private void LoadFoodByCategorie(FoodCategory categorie) { using (var db = new DbManager.ApplicationDbContext()) { var query = db.FoodProducts.Where(x => x.MiCategory == categorie.ToString()); FoodProductsCollection.Clear(); foreach (var item in query) { FoodProductsCollection.Add(item); } } }
private void LoadTodayMenuFromDB() { //CreateTestMenuItem(); using (var db = new DbManager.ApplicationDbContext()) { var todayMenu = db.DailyMenus.FirstOrDefault(x => x.DmDate.Date == DateTime.Today.Date); if (todayMenu == null) { return; } var query = db.FoodProducts.Where(x => todayMenu.DmItems.Contains(x.MiId.ToString())); FoodProductsCollection.Clear(); foreach (var item in query) { FoodProductsCollection.Add(item); } } }