public List <Models.Automation.Test_Run_Notes> GetRunNote(Guid ID)
{
List <Models.Automation.Test_Run_Notes> list = new List <Models.Automation.Test_Run_Notes>();
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"select * from automation.runnotes 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_Notes item = new Models.Automation.Test_Run_Notes
{
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"])),
id = Convert.ToInt32(DR["id"]),
notes = Convert.ToString(DR["notes"]),
method_name = Convert.ToString(DR["method_name"]),
Status = Convert.ToInt32(DR["status"])
};
list.Add(item);
}
return(list);
}
public Guid Maintain_RunNotes(Models.Automation.Test_Run_Notes item, string username)
{
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"SELECT automation.maintain_runnote(@IdNum, @run_IdNum, @testset_idnum,@test_IdNum, @ID,@method_name, @notes, @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("@ID", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.id;
cmd.Parameters.Add("@method_name", NpgsqlTypes.NpgsqlDbType.Text).Value = item.method_name ?? "";
cmd.Parameters.Add("@notes", NpgsqlTypes.NpgsqlDbType.Text).Value = item.notes ?? "";
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_runnote"]));
return(IDNUM);
}
