public List <Models.TestSet.Test_Set> GetTestSet(Guid ID)
{
List <Models.TestSet.Test_Set> list = new List <Models.TestSet.Test_Set>();
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"select * from qadata.ref_testset where row_idnumber = @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.TestSet.Test_Set item = new Models.TestSet.Test_Set
{
Id = new Guid(Convert.ToString(DR["row_idnumber"])),
Title = Convert.ToString(DR["testset_title"]),
Description = Convert.ToString(DR["testset_description"]),
testset_id = Convert.ToInt32(DR["testset_id"]),
Status = Convert.ToInt32(DR["status"])
};
list.Add(item);
}
return(list);
}
public List <Models.TestSet.Test_Set> GetTestSet(string Query, string DataTpe, string EqualsWhat)
{
List <Models.TestSet.Test_Set> list = new List <Models.TestSet.Test_Set>();
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@Query, con);
if (DataTpe == "Uuid")
{
cmd.Parameters.Add("@EqualsWhat", NpgsqlTypes.NpgsqlDbType.Uuid).Value = new Guid(EqualsWhat);
}
else if (DataTpe == "Varchar")
{
cmd.Parameters.Add("@EqualsWhat", NpgsqlTypes.NpgsqlDbType.Varchar).Value = EqualsWhat;
}
else if (DataTpe == "Int")
{
cmd.Parameters.Add("@EqualsWhat", NpgsqlTypes.NpgsqlDbType.Integer).Value = EqualsWhat;
}
da = new NpgsqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
foreach (DataRow DR in ds.Tables[0].Rows)
{
Models.TestSet.Test_Set item = new Models.TestSet.Test_Set
{
Id = new Guid(Convert.ToString(DR["row_idnumber"])),
Title = Convert.ToString(DR["testset_title"]),
Description = Convert.ToString(DR["testset_description"]),
testset_id = Convert.ToInt32(DR["testset_id"]),
Status = Convert.ToInt32(DR["status"])
};
list.Add(item);
}
return(list);
}
public Guid Maintain_TestSet(Models.TestSet.Test_Set item, string username)
{
con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin);
cmd = new NpgsqlCommand(@"SELECT qadata.maintain_testset( @v_Id, @v_Title, @v_Description, @v_testset_id, @q_username, @v_status);", con);
cmd.Parameters.Add("@v_Id", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.Id;
cmd.Parameters.Add("@v_Title", NpgsqlTypes.NpgsqlDbType.Text).Value = item.Title ?? "";
cmd.Parameters.Add("@v_Description", NpgsqlTypes.NpgsqlDbType.Text).Value = item.Description ?? "";
cmd.Parameters.Add("@v_testset_id", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.testset_id;
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_testset"]));
return(IDNUM);
}
