public List <Food> GetByName(string name)
{
using (FoodDBEntities fd = new FoodDBEntities())
{
return(fd.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper())).ToList());
}
}
public Food GetFoodById(int id)
{
using (FoodDBEntities fd = new FoodDBEntities())
{
return(fd.Foods.FirstOrDefault(f => f.ID == id));
}
}
public List <Food> GetAll()
{
using (FoodDBEntities fd = new FoodDBEntities())
{
return(fd.Foods.ToList());
}
}
public void AddFood(Food f)
{
using (FoodDBEntities fd = new FoodDBEntities())
{
fd.Foods.Add(f);
fd.SaveChanges();
}
}
public List <Food> BiggetThanCalories(int calories)
{
List <Food> foods = new List <Food>();
using (FoodDBEntities fd = new FoodDBEntities())
{
return(foods = fd.Foods.Where(f => f.Calories > calories).ToList());
}
}
public void Delete(int id)
{
using (FoodDBEntities fd = new FoodDBEntities())
{
Food food = fd.Foods.FirstOrDefault(f => f.ID == id);
fd.Foods.Remove(food);
fd.SaveChanges();
}
}
public List <Food> GetAllBySearch(int maxCalories, string name, int minGrade, int minCalories)
{
List <Food> foods = new List <Food>();
using (FoodDBEntities fd = new FoodDBEntities())
{
foods = fd.Foods.Where(f => f.Grade > minGrade &&
f.Calories > minCalories && f.Calories < maxCalories &&
(f.Name == "" || f.Name.ToUpper().Contains(name.ToUpper()))).ToList();
}
return(foods);
}
public void UpdateFood(Food f)
{
Food food = new Food();
using (FoodDBEntities fd = new FoodDBEntities())
{
food = fd.Foods.FirstOrDefault(fo => fo.ID == f.ID);
food.Calories = f.Calories;
food.Grade = f.Grade;
food.Ingridients = f.Ingridients;
food.Name = f.Name;
fd.SaveChanges();
}
}
