private static List <CategoryProduct> get(string query, Dictionary <string, object> parameters) { CategoryProduct item = null; Connection cs = new Connection(); List <CategoryProduct> list = new List <CategoryProduct>(); MySqlDataReader reader = cs.Select(query, parameters); while (reader.Read()) { item = new CategoryProduct(); if (!reader.IsDBNull(reader.GetOrdinal("id"))) { item.id = reader.GetInt32(reader.GetOrdinal("id")); } if (!(reader["name"] == DBNull.Value)) { item.name = reader["name"].ToString().Trim(); } if (!(reader["description"] == DBNull.Value)) { item.description = reader["description"].ToString().Trim(); } list.Add(item); } cs.CloseConnection(); return(list); }
public static int Add(CategoryProduct m) { int t = 0; string query = @"INSERT INTO categoryProduct (name, description) " + "VALUES (@name, @description);"; Connection cs = new Connection(); Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("name", m.name); param.Add("description", m.description); try { t = cs.Insert(query, param); //si insertion reussit } catch (MySqlException e) { } cs.CloseConnection(); //si insertion echoue return(t); }