//Get all Foods public static List <Food> AllFood() { List <Food> foodlist = new List <Food>(); DataSet dts = FoodDataHeplers.ExecutedSelect("tbFoods"); for (int i = 0; i < dts.Tables["tbFoods"].Rows.Count; i++) { foodlist.Add(new Food(dts.Tables[0].Rows[i][1].ToString(), dts.Tables[0].Rows[i][2].ToString(), Convert.ToInt16(dts.Tables[0].Rows[i][3].ToString()), dts.Tables[0].Rows[i][4].ToString(), dts.Tables[0].Rows[i][5].ToString(), dts.Tables[0].Rows[i][6].ToString(), dts.Tables[0].Rows[i][7].ToString(), dts.Tables[0].Rows[i][8].ToString() )); } return(foodlist); }
//Delete api/VnFoods public static void DeleteFood(int id) { string deletecmd = "delete from tbFoods where Id=" + id + ""; int rows = FoodDataHeplers.ExecutedUID(deletecmd); }
//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); }
//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); }