public void saveProduct(Product Pro) { cmd.CommandText = "INSERT INTO product(name, quantity, price)" + " values(@name, @quantity, @price)"; cmd.Parameters.AddWithValue("@name", Pro.getName()); cmd.Parameters.AddWithValue("@quantity", Pro.getQuantity()); cmd.Parameters.AddWithValue("@price", Pro.getPrice()); cmd.ExecuteNonQuery(); conn.Close(); }
public void updateProduct(Product Pro) { cmd.CommandText = " UPDATE product SET name = @name, quantity = @quantity, " + " price = @price " + " where id = @id "; cmd.Parameters.AddWithValue("@name", Pro.getName()); cmd.Parameters.AddWithValue("@quantity", Pro.getQuantity()); cmd.Parameters.AddWithValue("@price", Pro.getPrice()); cmd.Parameters.AddWithValue("@id", Pro.getId()); cmd.ExecuteNonQuery(); conn.Close(); }