public List <Food> GetByFilter(string name = "", int maxcal = 0, int mincal = 0, string ingridients = "", int grade = 0) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { if (name == "" && mincal == 0 && maxcal == 0 && ingridients == "" && grade != 0) { return(foodDBEntities.Foods.Where(m => m.Grade == grade).ToList()); } if (name == "" && mincal == 0 && maxcal == 0 && ingridients != "" && grade == 0) { return(foodDBEntities.Foods.Where(m => m.Ingridients.ToUpper().Contains(ingridients.ToUpper())).ToList()); } if (name == "" && mincal == 0 && maxcal != 0 && ingridients == "" && grade == 0) { return(foodDBEntities.Foods.Where(m => m.Calories <= maxcal).ToList()); } if (name == "" && mincal != 0 && maxcal == 0 && ingridients == "" && grade == 0) { return(foodDBEntities.Foods.Where(m => m.Calories >= mincal).ToList()); } if (name != "" && mincal == 0 && maxcal == 0 && ingridients == "" && grade == 0) { return(foodDBEntities.Foods.Where(m => m.Name.ToUpper().Contains(name.ToUpper())).ToList()); } if (name == "" && mincal != 0 && maxcal != 0 && ingridients == "" && grade == 0) { return(foodDBEntities.Foods.Where(m => m.Calories >= mincal && m.Calories <= maxcal).ToList()); } return(foodDBEntities.Foods.Where(m => m.Name.ToUpper().Contains(name.ToUpper()) || (ingridients != "" && m.Ingridients.ToUpper().Contains(ingridients.ToUpper())) || m.Grade == grade || (mincal > 0 && maxcal == 0 && m.Calories >= mincal) || (mincal == 0 && maxcal > 0 && m.Calories <= maxcal) || (mincal > 0 && maxcal > 0 && m.Calories >= mincal && m.Calories <= maxcal)).ToList()); } }
public void AddFood(Food food) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { foodDBEntities.Foods.Add(food); foodDBEntities.SaveChanges(); } }
public Food GetfoodById(int id) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { Food food = foodDBEntities.Foods.FirstOrDefault(f => f.ID == id); return(food); } }
public List <Food> GetFoodBiggerthanCal(int mincal) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { List <Food> foods = foodDBEntities.Foods.Where(m => m.Calories > mincal).ToList(); return(foods); } }
public List <Food> GetByFoodName(string name) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { List <Food> results = foodDBEntities.Foods.Where(m => m.Name.ToUpper() == name.ToUpper()).ToList(); return(results); } }
public List <Food> GetAllFoods() { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { List <Food> foods = (from f in foodDBEntities.Foods select f).ToList(); return(foods); } }
public void DeleteFood(int id) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { Food result = foodDBEntities.Foods.FirstOrDefault(f => f.ID == id); if (result != null) { foodDBEntities.Foods.Remove(result); } foodDBEntities.SaveChanges(); } }
public void UpdateFood(int id, Food food) { using (FoodDBEntities foodDBEntities = new FoodDBEntities()) { Food result = foodDBEntities.Foods.FirstOrDefault(f => f.ID == id); if (result != null) { result.Name = food.Name; result.Ingridients = food.Ingridients; result.Calories = food.Calories; foodDBEntities.SaveChanges(); } } }