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); }