// 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);
}