public List <Models.Automation.Test_Run> GetTestRun(Guid ID)
{
List <Models.Automation.Test_Run> list = new List <Models.Automation.Test_Run>();
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"select * from automation.runs 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 = new Models.Automation.Test_Run
{
idnum = new Guid(Convert.ToString(DR["row_idnum"])),
testset_idnum = new Guid(Convert.ToString(DR["testset_idnum"])),
id = Convert.ToInt32(DR["id"]),
notes = Convert.ToString(DR["notes"]),
Status = Convert.ToInt32(DR["status"])
};
list.Add(item);
}
return(list);
}
public Guid Maintain_TestRun(Models.Automation.Test_Run item, string username)
{
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"SELECT automation.maintain_run(@v_IdNum, @v_testset_idnum, @v_ID, @v_notes, @q_username, @v_status);", con);
cmd.Parameters.Add("@v_IdNum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.idnum;
cmd.Parameters.Add("@v_testset_idnum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.testset_idnum;
cmd.Parameters.Add("@v_ID", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.id;
cmd.Parameters.Add("@v_notes", NpgsqlTypes.NpgsqlDbType.Text).Value = item.notes ?? "";
cmd.Parameters.Add("@q_username", NpgsqlTypes.NpgsqlDbType.Text).Value = username;
cmd.Parameters.Add("@v_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"]));
return(IDNUM);
}
