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