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

Timestamp:

07/22/08 23:29:18 (16 years ago)

Author:

gkronber

Message:

worked on very basic control to view the tree of agents/runs (ticket #188)

File:

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

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

@@ -298 +298 @@
           statusParameter.Value = status.ToString();
           c.Parameters.Add(statusParameter);
-
           SQLiteDataReader r = c.ExecuteReader();
           while(r.Read()) {
@@ -330 +329 @@
                 agent.Id = r.GetInt32(0);
                 agent.ParentAgentId = r.IsDBNull(1) ? null : new Nullable<long>(r.GetInt32(1));
-                agent.Name = r.GetString(2);
+                agent.Name = r.IsDBNull(2)?"-":r.GetString(2);
                 agent.Status = (ProcessStatus)Enum.Parse(typeof(ProcessStatus), r.GetString(3));
                 agent.ControllerAgent = r.GetBoolean(4);
@@ -353 +352 @@
           using(DbCommand c = cnn.CreateCommand()) {
             c.CommandText = "Select id, name, status, controllerAgent, rawdata from Agent where ParentAgentId=@ParentAgentId";
+            DbParameter parentParameter = c.CreateParameter();
+            parentParameter.ParameterName = "@ParentAgentId";
+            parentParameter.Value = parentAgentId;
+            c.Parameters.Add(parentParameter);
+
             using(DbDataReader r = c.ExecuteReader()) {
               while(r.Read()) {
@@ -358 +362 @@
                 agent.ParentAgentId = parentAgentId;
                 agent.Id = r.GetInt32(0);
-                agent.Name = r.GetString(1);
+                agent.Name = r.IsDBNull(1)?"-":r.GetString(1);
                 agent.Status = (ProcessStatus)Enum.Parse(typeof(ProcessStatus), r.GetString(2));
                 agent.ControllerAgent = r.GetBoolean(3);