public Food GetByName(string name)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
Food food = foodDBEntities.Foods.FirstOrDefault(f => f.Name.ToUpper().Contains(name.ToUpper()));
return food;
}
}
public List<Food> GetByMinCal(int minCal)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
List<Food> foods = (from f in foodDBEntities.Foods where f.Calories > minCal select f).ToList();
return foods;
}
}
public void Add(Food food)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
foodDBEntities.Foods.Add(food);
foodDBEntities.SaveChanges();
}
}
public List<Food> GetAll()
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
List<Food> foods = foodDBEntities.Foods.ToList();
return foods;
}
}
public void Remove(int id)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
Food food = foodDBEntities.Foods.ToList().Find(f => f.ID == id);
foodDBEntities.Foods.Remove(food);
foodDBEntities.SaveChanges();
}
}
public Food GetByID(int id)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
Food food = foodDBEntities.Foods.ToList().Find(f => f.ID == id) as Food;
return food;
}
}
public void Update(Food food)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
Food currentFood = foodDBEntities.Foods.SingleOrDefault(f => f.ID == food.ID);
if (currentFood != null)
{
currentFood.Name = food.Name;
currentFood.Ingridients = food.Ingridients;
currentFood.Calories = food.Calories;
currentFood.Grade = food.Grade;
}
foodDBEntities.SaveChanges();
}
}
public List<Food> GetByCategories(string name, int grade, int minCal, int maxCal)
{
using (FoodDBEntities foodDBEntities = new FoodDBEntities())
{
List<Food> foods = foodDBEntities.Foods.ToList();
List<Food> filteredOutFoods = new List<Food>();
foreach(Food food in foods)
{
if (!String.IsNullOrEmpty(name))
{
if (!food.Name.ToUpper().Contains(name.ToUpper()))
filteredOutFoods.Add(food);
}
if (grade != 0)
{
if (food.Grade != grade)
filteredOutFoods.Add(food);
}
if (minCal != 0)
{
if (food.Calories < minCal)
filteredOutFoods.Add(food);
}
if (maxCal != 0)
{
if (food.Calories > maxCal)
filteredOutFoods.Add(food);
}
}
foreach (Food food in filteredOutFoods)
{
foods.Remove(food);
}
return foods;
}
}
