public void DeleteCategoryByName(string category) { int catid = reader.GetCategoryID(category); DeleteProductByCategory(catid); MySqlConnection conn = new MySqlConnection(ConnStr); using (conn) { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "DELETE FROM categories WHERE name = @category"; cmd.Parameters.AddWithValue("category", category); cmd.ExecuteNonQuery(); } }
public void AddProduct(string name, decimal price, string category) { MySqlConnection conn = new MySqlConnection(ConnStr); int categoryID = reader.GetCategoryID(category); using (conn) { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO products (Name, Price, CategoryID) VALUES(@name, @price, @categoryID);"; cmd.Parameters.AddWithValue("name", name); cmd.Parameters.AddWithValue("price", price); cmd.Parameters.AddWithValue("categoryID", categoryID); cmd.ExecuteNonQuery(); } }