// Delete method: public static string DeleteProduct(ProductXML prod) { string msg = string.Empty; string query = $"DELETE Products WHERE Id = {prod.Id}"; using (conn = new SqlConnection(ConnectionString)) { conn.Open(); using (cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Title", prod.Title); cmd.Parameters.AddWithValue("@Country", prod.Country); cmd.Parameters.AddWithValue("@Price", prod.Price); int result = cmd.ExecuteNonQuery(); if (result == 1) { msg = "Product was Delete successfully"; } else { msg = "Product was NOT Delete.. Something went wrong..."; } } } return(msg); }
// Add method: public static string AddProduct(ProductXML prod) { string msg = string.Empty; string query = "INSERT INTO Products(Title, Country, Price) VALUES(@Title, @Country, @Price)"; using (conn = new SqlConnection(ConnectionString)) { conn.Open(); using (cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Title", prod.Title); cmd.Parameters.AddWithValue("@Country", prod.Country); cmd.Parameters.AddWithValue("@Price", prod.Price); int result = cmd.ExecuteNonQuery(); if (result == 1) { msg = "Product was added successfully"; } else { msg = "Product was NOT added. Please try it again"; } } } return(msg); }