public List <Models.Automation.Test_Run_Item> GetRunItem(Guid ID) { List <Models.Automation.Test_Run_Item> list = new List <Models.Automation.Test_Run_Item>(); con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin); cmd = new NpgsqlCommand(@"select * from automation.run_item where row_idnum = @ID;", con); cmd.Parameters.Add("@ID", NpgsqlTypes.NpgsqlDbType.Uuid).Value = ID; da = new NpgsqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); foreach (DataRow DR in ds.Tables[0].Rows) { Models.Automation.Test_Run_Item item = new Models.Automation.Test_Run_Item { idnum = new Guid(Convert.ToString(DR["row_idnum"])), run_idnum = new Guid(Convert.ToString(DR["run_idnum"])), testset_idnum = new Guid(Convert.ToString(DR["testset_idnum"])), test_idnum = new Guid(Convert.ToString(DR["test_idnum"])), item_number = Convert.ToInt32(DR["item_number"]), method_name = Convert.ToString(DR["method_name"]), Status = Convert.ToInt32(DR["status"]) }; list.Add(item); } return(list); }
public Guid Maintain_RunItem(Models.Automation.Test_Run_Item item, string username) { con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin); cmd = new NpgsqlCommand(@"SELECT automation.maintain_run_item(@IdNum, @run_IdNum, @testset_idnum,@test_IdNum, @item_number ,@method_name, @username, @status);", con); cmd.Parameters.Add("@IdNum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.idnum; cmd.Parameters.Add("@run_IdNum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.run_idnum; cmd.Parameters.Add("@testset_idnum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.testset_idnum; cmd.Parameters.Add("@test_IdNum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.test_idnum; cmd.Parameters.Add("@item_number", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.item_number; cmd.Parameters.Add("@method_name", NpgsqlTypes.NpgsqlDbType.Text).Value = item.method_name ?? ""; cmd.Parameters.Add("@username", NpgsqlTypes.NpgsqlDbType.Text).Value = username; cmd.Parameters.Add("@status", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.Status; da = new NpgsqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); Guid IDNUM = new Guid(Convert.ToString(ds.Tables[0].Rows[0]["maintain_run_item"])); return(IDNUM); }