//Update a food (exist)
public static void UpdateFood(int id, Food food)
{
string updatecmd = "update tbFoods set fnameUs='" + food.enName + "', fnameVn='" + food.vnName + "', price=" + food.Price + ", '" + food.descibe + "', '" + food.making + "', '" + food.category + "', '" + food.area + "', '" + food.picPath + "' where Id= " + id + "";
int rows = FoodDataHeplers.ExecutedUID(updatecmd);
}
//Delete api/VnFoods
public static void DeleteFood(int id)
{
string deletecmd = "delete from tbFoods where Id=" + id + "";
int rows = FoodDataHeplers.ExecutedUID(deletecmd);
}
//Insert a new food
public static void InsertNewFood(Food food)
{
string insertcmd = "insert into tbFoods values ('" + food.enName + "', '" + food.vnName + "', " + food.Price + ", '" + food.descibe + "', '" + food.making + "', '" + food.category + "', '" + food.area + "', '" + food.picPath + "')";
int rows = FoodDataHeplers.ExecutedUID(insertcmd);
}