public List <Models.TestLevels.TestStructures> GetTopStructures() { List <Models.TestLevels.TestStructures> list = new List <Models.TestLevels.TestStructures>(); con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin); cmd = new NpgsqlCommand(@"select * from qadata.ref_structure where parent_idnumber = '00000000-0000-0000-0000-000000000000' order by name;", con); da = new NpgsqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); foreach (DataRow DR in ds.Tables[0].Rows) { Models.TestLevels.TestStructures item = new Models.TestLevels.TestStructures(); item.id = new Guid(Convert.ToString(DR["row_idnumber"])); item.Name = Convert.ToString(DR["name"]); item.ShortName = Convert.ToString(DR["srtname"]); item.Parent_IDNumber = new Guid(Convert.ToString(DR["parent_idnumber"])); list.Add(item); } return(list); }
public Guid Maintain_Level(Models.TestLevels.TestStructures item, string username) { Guid record_IDNUM = new Guid(); con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin); cmd = new NpgsqlCommand(@"SELECT qadata.maintain_level(@idnum, @parent_idnumber, @name, @short_name, @loggedinas, @status);", con); cmd.Parameters.Add("@idnum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.id; cmd.Parameters.Add("@parent_idnumber", NpgsqlTypes.NpgsqlDbType.Uuid).Value = item.Parent_IDNumber; cmd.Parameters.Add("@name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = item.Name ?? ""; cmd.Parameters.Add("@short_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = item.ShortName ?? ""; cmd.Parameters.Add("@loggedinas", NpgsqlTypes.NpgsqlDbType.Varchar).Value = username; cmd.Parameters.Add("@status", NpgsqlTypes.NpgsqlDbType.Integer).Value = item.status; da = new NpgsqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); record_IDNUM = new Guid(Convert.ToString(ds.Tables[0].Rows[0]["maintain_level"])); return(record_IDNUM); }
public Models.TestLevels.TestStructures GetStructure(Guid ID_Number) { List <Models.TestLevels.TestStructures> list = new List <Models.TestLevels.TestStructures>(); con = new NpgsqlConnection(conFIG.ConnFor_PG_Admin); cmd = new NpgsqlCommand(@"select * from qadata.ref_structure where row_idnumber = @idnum limit 1;", con); cmd.Parameters.Add("@idnum", NpgsqlTypes.NpgsqlDbType.Uuid).Value = ID_Number; da = new NpgsqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); Models.TestLevels.TestStructures item = new Models.TestLevels.TestStructures(); foreach (DataRow DR in ds.Tables[0].Rows) { item.id = new Guid(Convert.ToString(DR["row_idnumber"])); item.Name = Convert.ToString(DR["name"]); item.ShortName = Convert.ToString(DR["srtname"]); item.Parent_IDNumber = new Guid(Convert.ToString(DR["parent_idnumber"])); } return(item); }