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