public void saveIngredient(Ingredient Ing)
{
cmd.CommandText = "INSERT INTO ingredient(name, quantity, price, status)" +
" values(@name, @quantity, @price, @status)";
cmd.Parameters.AddWithValue("@name", Ing.getName());
cmd.Parameters.AddWithValue("@quantity", Ing.getQuantity());
cmd.Parameters.AddWithValue("@price", Ing.getPrice());
cmd.Parameters.AddWithValue("@status", Ing.getStatus());
cmd.ExecuteNonQuery();
conn.Close();
}
public void updateIngredient(Ingredient Ing)
{
cmd.CommandText = " UPDATE ingredient SET name = @name, quantity = @quantity, " +
" price= @price , status = @status " +
" where id = @id ";
cmd.Parameters.AddWithValue("@name", Ing.getName());
cmd.Parameters.AddWithValue("@quantity", Ing.getQuantity());
cmd.Parameters.AddWithValue("@price", Ing.getPrice());
cmd.Parameters.AddWithValue("@status", Ing.getStatus());
cmd.Parameters.AddWithValue("@id", Ing.getId());
cmd.ExecuteNonQuery();
conn.Close();
}