public List <Food> GetAllFoodsByName(string name) { using (FoodDBEntities foodEntites = new FoodDBEntities()) { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper())).ToList()); } }
public List <Food> GetAllFoodsByMinCalories(int Calories) { using (FoodDBEntities foodEntites = new FoodDBEntities()) { return(foodEntites.Foods.Where(f => f.Calories > Calories).ToList()); } }
public Food GetFoodById(int id) { using (FoodDBEntities foodEntites = new FoodDBEntities()) { return(foodEntites.Foods.FirstOrDefault(f => f.ID == id)); } }
public List <Food> GetAllFoods() { using (FoodDBEntities foodEntites = new FoodDBEntities()) { return(foodEntites.Foods.ToList()); } }
public void AddFood(Food food) { using (FoodDBEntities foodEntites = new FoodDBEntities()) { foodEntites.Foods.Add(food); foodEntites.SaveChanges(); } }
public Food DeleteFood(int id) { Food foodForRemove; using (FoodDBEntities foodEntites = new FoodDBEntities()) { foodForRemove = foodEntites.Foods.FirstOrDefault(f => f.ID == id); foodEntites.Foods.Remove(foodForRemove); foodEntites.SaveChanges(); } return(foodForRemove); }
public Food UpdateFood(int id, Food food) { Food foodForUpdate = new Food(); using (FoodDBEntities foodEntites = new FoodDBEntities()) { foodForUpdate = foodEntites.Foods.FirstOrDefault(f => f.ID == id); foodForUpdate.Name = food.Name; foodForUpdate.Calories = food.Calories; foodForUpdate.Ingridients = food.Ingridients; foodForUpdate.Grade = food.Grade; foodEntites.SaveChanges(); } return(foodForUpdate); }
public List <Food> GetAllFoodsByFilter(string name, int mincal, int maxcal, int grade) { using (FoodDBEntities foodEntites = new FoodDBEntities()) { if (name != "") { if (mincal != 0) { if (maxcal != 0 && grade == 0) // Name, Mincal, Maxcal. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories > mincal && f.Calories < maxcal).ToList()); } if (maxcal == 0 && grade != 0) // Name, Mincal, Grade. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories > mincal && f.Grade == grade).ToList()); } if (maxcal == 0 && grade == 0) // Name, Mincal. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories > mincal).ToList()); } if (maxcal != 0 && grade != 0) // All Filters. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories > mincal && f.Calories < maxcal && f.Grade == grade).ToList()); } } if (maxcal != 0) { if (grade != 0) // Name, Maxcal, Grade. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories < maxcal && f.Grade == grade).ToList()); } if (grade == 0) // Name, Maxcal. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories < maxcal).ToList()); } } if (grade != 0) // Name, Grade. { return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Grade == grade).ToList()); } // Only Name. return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper())).ToList()); } if (mincal != 0) { if (maxcal != 0) { if (grade != 0) // Mincal, Maxcal, Grade. { return(foodEntites.Foods.Where(f => f.Calories > mincal && f.Calories < maxcal && f.Grade == grade).ToList()); } // Mincal, Maxcal. return(foodEntites.Foods.Where(f => f.Calories > mincal && f.Calories < maxcal).ToList()); } if (grade != 0) // Mincal, Grade. { return(foodEntites.Foods.Where(f => f.Calories > mincal && f.Grade == grade).ToList()); } // Only Mincal. return(foodEntites.Foods.Where(f => f.Calories > mincal).ToList()); } if (maxcal != 0) { if (grade != 0) // Maxcal, Grade. { return(foodEntites.Foods.Where(f => f.Calories < maxcal && f.Grade == grade).ToList()); } // Only Maxcal. return(foodEntites.Foods.Where(f => f.Calories < maxcal).ToList()); } if (grade != 0) // Only Grade. { return(foodEntites.Foods.Where(f => f.Grade == grade).ToList()); } // All Filters. return(foodEntites.Foods.Where(f => f.Name.ToUpper().Contains(name.ToUpper()) && f.Calories > mincal && f.Calories < maxcal && f.Grade == grade).ToList()); } }