public List <Models.TestCase.Test_step> GetTestSteps(Guid Test_ID)
{
List <Models.TestCase.Test_step> list = new List <Models.TestCase.Test_step>();
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"select * from qadata.test_steps where test_idnum = @Test_ID order by step_number;", con);
cmd.Parameters.Add("@Test_ID", NpgsqlTypes.NpgsqlDbType.Uuid).Value = Test_ID;
da = new NpgsqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
foreach (DataRow DR in ds.Tables[0].Rows)
{
Models.TestCase.Test_step item = new Models.TestCase.Test_step();
item.Expected_result = Convert.ToString(DR["expected_reult"]);
item.Id = new Guid(Convert.ToString(DR["row_idnum"]));
item.Status = Convert.ToInt32(DR["status"]);
item.Step = Convert.ToString(DR["step"]);
item.Step_num = Convert.ToInt32(DR["step_number"]);
item.Test_case_id = new Guid(Convert.ToString(DR["test_idnum"]));
list.Add(item);
}
return(list);
}
public Guid Maintain_TestCase_Step(Models.TestCase.Test_step item, string username)
{
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"SELECT qadata.maintain_testcase_step(@v_row_idnum, @v_test_idnum, @v_step, @v_expected_result, @v_step_num, @q_username, @v_status);", con);
cmd.Parameters.Add("@v_row_idnum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.Id;
cmd.Parameters.Add("@v_test_idnum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.Test_case_id;
cmd.Parameters.Add("@v_step", NpgsqlTypes.NpgsqlDbType.Text).Value = item.Step ?? "";
cmd.Parameters.Add("@v_expected_result", NpgsqlTypes.NpgsqlDbType.Text).Value = item.Expected_result ?? "";
cmd.Parameters.Add("@v_step_num", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.Step_num;
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_testcase_step"]));
return(IDNUM);
}
