public void saveSupplier(Supplier sup)
{
cmd.CommandText = "INSERT INTO supplier(name, address, email, phone, birthday, ingredient_id)" +
" values(@name, @address, @email, @phone, @birthday, @ingredient_id)";
cmd.Parameters.AddWithValue("@name", sup.getName());
cmd.Parameters.AddWithValue("@address", sup.getAddress());
cmd.Parameters.AddWithValue("@email", sup.getEmail());
cmd.Parameters.AddWithValue("@phone", sup.getPhone());
cmd.Parameters.AddWithValue("@birthday", sup.getBirthday());
cmd.Parameters.AddWithValue("@ingredient_id", sup.getIngredientid());
cmd.ExecuteNonQuery();
conn.Close();
}
public void updateSupplier(Supplier sup)
{
cmd.CommandText = " UPDATE supplier SET name = @name, address=@address, " +
" email = @email, phone = @phone, birthday=@birthday, ingredient_id = @ingredient_id " +
" where id = @id ";
cmd.Parameters.AddWithValue("@name", sup.getName());
cmd.Parameters.AddWithValue("@address", sup.getAddress());
cmd.Parameters.AddWithValue("@email", sup.getEmail());
cmd.Parameters.AddWithValue("@phone", sup.getPhone());
cmd.Parameters.AddWithValue("@birthday", sup.getBirthday());
cmd.Parameters.AddWithValue("@ingredient_id", sup.getIngredientid());
cmd.Parameters.AddWithValue("@id", sup.getId());
cmd.ExecuteNonQuery();
conn.Close();
}