public void AddToDB(Food food) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { foodDBEntities.Foods.Add(food); foodDBEntities.SaveChanges(); } }
public void RemoveFromDB(int id) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { Food result = foodDBEntities.Foods.SingleOrDefault(b => b.ID == id); if (result != null) { foodDBEntities.Foods.Remove(result); } foodDBEntities.SaveChanges(); } }
public void UpdateDB(Food food, int id) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { Food result = foodDBEntities.Foods.SingleOrDefault(b => b.ID == id); if (result != null) { result.Calories = food.Calories; result.Grade = food.Grade; result.Ingridients = food.Ingridients; result.Name = food.Name; foodDBEntities.SaveChanges(); } } }