Changeset 389 for trunk/sources/HeuristicLab.CEDMA.DB/Database.cs

Timestamp:

07/22/08 14:06:42 (16 years ago)

Author:

gkronber

Message:

worked on #188

File:

• trunk/sources/HeuristicLab.CEDMA.DB/Database.cs (modified) (5 diffs)

trunk/sources/HeuristicLab.CEDMA.DB/Database.cs

@@ -432 +432 @@
     }
 
-    public ICollection<RunEntry> GetRuns() {
+    public ICollection<RunEntry> GetRuns(long agentId) {
       List<RunEntry> runs = new List<RunEntry>();
       rwLock.EnterReadLock();
@@ -439 +439 @@
           cnn.Open();
           using(DbCommand c = cnn.CreateCommand()) {
-            c.CommandText = "Select Id, AgentId, CreationTime, StartTime, FinishedTime, Status, Rawdata from Run";
+            c.CommandText = "Select Id, AgentId, CreationTime, Status, Rawdata from Run where AgentId=@AgentId";
+            DbParameter agentParameter = c.CreateParameter();
+            agentParameter.ParameterName = "@AgentId";
+            agentParameter.Value = agentId;
+            c.Parameters.Add(agentParameter);
+
             using(DbDataReader r = c.ExecuteReader()) {
               while(r.Read()) {
@@ -446 +451 @@
                 run.AgentId = r.GetInt32(1);
                 run.CreationTime = r.GetDateTime(2);
-                run.StartTime = r.GetDateTime(3);
-                run.FinishedTime = r.GetDateTime(4);
-                run.Status = (ProcessStatus)Enum.Parse(typeof(ProcessStatus), r.GetString(5));
-                run.RawData = (byte[])r.GetValue(6);
+                run.Status = (ProcessStatus)Enum.Parse(typeof(ProcessStatus), r.GetString(3));
+                run.RawData = (byte[])r.GetValue(4);
                 runs.Add(run);
               }
@@ -468 +471 @@
           cnn.Open();
           using(DbCommand c = cnn.CreateCommand()) {
-            c.CommandText = "Select Id, AgentId, CreationTime, StartTime, FinishedTime, Status, Rawdata from Run where Status=@Status";
+            c.CommandText = "Select Id, AgentId, CreationTime, Status, Rawdata from Run where Status=@Status";
             DbParameter statusParameter = c.CreateParameter();
             statusParameter.ParameterName = "@Status";
@@ -480 +483 @@
                 run.AgentId = r.GetInt32(1);
                 run.CreationTime = r.GetDateTime(2);
-                run.StartTime = r.IsDBNull(3) ? null : new Nullable<DateTime>(r.GetDateTime(3));
-                run.FinishedTime = r.IsDBNull(4) ? null : new Nullable<DateTime>(r.GetDateTime(4));
-                run.Status = (ProcessStatus)Enum.Parse(typeof(ProcessStatus), r.GetString(5));
-                run.RawData = (byte[])r.GetValue(6);
+                run.Status = (ProcessStatus)Enum.Parse(typeof(ProcessStatus), r.GetString(3));
+                run.RawData = (byte[])r.GetValue(4);
                 runs.Add(run);
               }