public bool create(int check_code, DB_objects.Attribute a) { SqlCommand comm = new SqlCommand("INSERT INTO check_attributes(type, language, value) VALUES(@type, @language, @value)", myConnection); comm.Parameters.Add("@type", a.type); comm.Parameters.Add("@language", a.language); comm.Parameters.Add("@value", a.value); comm.ExecuteNonQuery(); comm = new SqlCommand("SELECT attribute_code FROM check_attributes WHERE type LIKE @type AND language LIKE @language AND value LIKE @value ORDER BY attribute_code DESC", myConnection); comm.Parameters.Add("@type", a.type); comm.Parameters.Add("@language", a.language); comm.Parameters.Add("@value", a.value); SqlDataReader reader = comm.ExecuteReader(); int id = -1; reader.Read(); id = Int32.Parse(reader[0].ToString()); if (id == -1) { return(false); } reader.Close(); comm = new SqlCommand("INSERT INTO check_contains(attribute_code, check_code) VALUES(@attribute_code, @check_code)", myConnection); comm.Parameters.Add("@attribute_code", id); comm.Parameters.Add("@check_code", check_code); return(comm.ExecuteNonQuery() == 1); }
public List <DB_objects.Attribute> retrieve(int check_code) { List <DB_objects.Attribute> result = new List <DB_objects.Attribute>(); SqlCommand comm = new SqlCommand("SELECT attribute_code, type, language, value " + "FROM check_attributes " + "WHERE attribute_code IN (SELECT attribute_code " + "FROM check_contains " + "WHERE check_code=@check_code)", myConnection); comm.Parameters.Add("@check_code", check_code); SqlDataReader reader = comm.ExecuteReader(); DB_objects.Attribute a; while (reader.Read()) { a = new DB_objects.Attribute(); a.attribute_code = Int32.Parse(reader[0].ToString()); a.type = reader[1].ToString(); a.language = reader[2].ToString(); a.value = reader[3].ToString(); result.Add(a); } reader.Close(); return(result); }
public void delete(DB_objects.Attribute a) { SqlCommand comm = new SqlCommand("DELETE FROM operation_attributes WHERE attribute_code=@attribute_code", myConnection); comm.Parameters.Add("@attribute_code", a.attribute_code); comm.ExecuteNonQuery(); }
public bool update(DB_objects.Attribute a) { SqlCommand comm = new SqlCommand("UPDATE check_attributes SET type=@type, value=@value, language=@language WHERE attribute_code=@attribute_code", myConnection); comm.Parameters.Add("@type", a.type); comm.Parameters.Add("@value", a.value); comm.Parameters.Add("@language", a.language); comm.Parameters.Add("@attribute_code", a.attribute_code); return(comm.ExecuteNonQuery() == 1); }