private async Task setDbErrorMessage(DrinkCategory dbValues, DrinkCategory clientValues, RestaurantContext context) { if (dbValues.Name != clientValues.Name) { ModelState.AddModelError("DrinkCategory.Name", $"Current value: { dbValues.Name}"); } if (dbValues.MinProductionCost != clientValues.MinProductionCost) { ModelState.AddModelError("DrinkCategory.MinProductionCost", $"Current value: {dbValues.MinProductionCost:c}"); } if (dbValues.Alcoholic != clientValues.Alcoholic) { ModelState.AddModelError("DrinkCategory.Alcoholic", $"Current value: {dbValues.Alcoholic}"); } if (dbValues.CompanyID != clientValues.CompanyID) { Company dbCompany = await _context.Companies .FindAsync(dbValues.CompanyID); ModelState.AddModelError("DrinkCategory.CompanyID", $"Current value: {dbCompany?.Name}"); } ModelState.AddModelError(string.Empty, "The record you attempted to edit was modifed by another user after you. " + "The edit operation was canceled and the current values in the database " + "have been displayed. If you still want to edit this record, click " + "the Save button again."); }
public async Task <IActionResult> Edit(int id, [Bind("ID,Name")] DrinkCategory drinkCategory) { if (id != drinkCategory.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(drinkCategory); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DrinkCategoryExists(drinkCategory.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(drinkCategory)); }
// GET: DrinkCategories/Edit/5 public IActionResult Edit(int?id) { if (id == null) { return(NotFound()); } var drinkCategory = new DrinkCategory(); if (id.Value == -1) { drinkCategory.Drinks = _drinkRepository.NewDrinks.ToList(); ViewBag.IsNewList = true; } else { drinkCategory = _categoryRepository.GetDrinkCategoryById(id.Value); if (drinkCategory == null) { return(NotFound()); } ViewBag.IsNewList = false; } ViewBag.Parents = _categoryRepository.Categories.Where(c => c.Id != id && c.ParentId != id); ViewBag.CatTypes = _categoryRepository.CategorieTypes; return(View(drinkCategory)); }
public IActionResult Edit(int id, DrinkCategory drinkCategory, string activetab = "") { if (id != drinkCategory.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _categoryRepository.UpdateDrinkCategory(drinkCategory); } catch (DbUpdateConcurrencyException) { if (!_categoryRepository.DrinkCategoryExists(drinkCategory.Id)) { return(NotFound()); } else { throw; } } return(new RedirectResult(Url.Action("Edit", new { id }) + activetab)); } ViewBag.Parents = _categoryRepository.Categories.Where(c => c.Id != id && c.ParentId != id); ViewBag.CatTypes = _categoryRepository.CategorieTypes; return(View(drinkCategory)); }
//DrinkCategory #region public static DrinkCategoryDto MappingDto(this DrinkCategory drinkCategory) { return(new DrinkCategoryDto { Id = drinkCategory.Id, Title = drinkCategory.Title }); }
public ActionResult DeleteConfirmed(int id) { DrinkCategory drinkCategory = db.DrinkCategories.Find(id); db.DrinkCategories.Remove(drinkCategory); db.SaveChanges(); return(RedirectToAction("Index")); }
public void AddDrinkCategory(DrinkCategory drinkCategory) { if (drinkCategory.Photos != null) { drinkCategory.Photos = drinkCategory.Photos.Where(p => !p.IsDeleted).ToList(); } _appDbContext.DrinkCategories.Add(drinkCategory); _appDbContext.SaveChanges(); }
public ActionResult Edit([Bind(Include = "idCategoryDrink,name")] DrinkCategory drinkCategory) { if (ModelState.IsValid) { db.Entry(drinkCategory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(drinkCategory)); }
//private void LoadPizzaPage() //{ // var currentMainPage = (Application.Current.MainPage as MasterDetailPage); // currentMainPage.Detail = new NavigationPage(new PizzaPage()); // Application.Current.MainPage = currentMainPage; //} private void LoadPreviousDrinkSelections(DrinkCategory categoryDisplayed) { //Get drink Order items and load to current screen category. //Will load to DrinkDisplayDictionary with key of categoryDisplayed. var currentOrder = OrderManager.Instance.OrderInProgress; foreach (var orderItem in currentOrder.OrderItems) { if (orderItem is Drink) { var drinkAlreadyOnTempOrder = (Drink)orderItem; //Save items to Dictionary that is on the current order. var drinkKey = Tuple.Create <DrinkType, DrinkSize>(drinkAlreadyOnTempOrder.DrinkType, drinkAlreadyOnTempOrder.DrinkSize); if (DrinksOnTempOrderDictionary.ContainsKey(drinkKey)) { DrinksOnTempOrderDictionary[drinkKey] = drinkAlreadyOnTempOrder; } else { DrinksOnTempOrderDictionary.Add(drinkKey, drinkAlreadyOnTempOrder); } //if drink on current order is in category displayed, then we'll want //to show what the order already has. if (drinkAlreadyOnTempOrder.DrinkCategory == categoryDisplayed) { if (!DrinkDisplayDictionary.ContainsKey(categoryDisplayed)) { LoadDrinkCategoryForDisplay(categoryDisplayed); } //Populate current drink items displayed with item count of //drinks already on the order. var drinksDisplayed = DrinkDisplayDictionary[categoryDisplayed]; foreach (var drinkDisplayItem in drinksDisplayed) { foreach (var drink in drinkDisplayItem.RowDrinks) { if (drink.DrinkType == drinkAlreadyOnTempOrder.DrinkType && drink.DrinkSize == drinkAlreadyOnTempOrder.DrinkSize) { drink.ItemCount = drinkAlreadyOnTempOrder.ItemCount; } } //if (saveDrinkTypeToScrollTo == drinkDisplayItem.Drink.DrinkType) //{ // drinkDisplayIndexToScrollTo = drinkDisplayItem.DrinkDisplayItemIndex; //} } } } } }
private IActionResult HandleDeletedDrinkCategory() { var deletedDrinkCategory = new DrinkCategory(); // ModelStat contains the posted data because of the deletion error // and will overide the Drink Category instance values when displaying page() ModelState.AddModelError(string.Empty, "Unable to save. The drink category was deleted by another user."); CompanyNameSL = new SelectList(_context.Companies, "ID", "Name", DrinkCategory.CompanyID); return(Page()); }
public async Task <IActionResult> Create([Bind("ID,Name")] DrinkCategory drinkCategory) { if (ModelState.IsValid) { _context.Add(drinkCategory); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(drinkCategory)); }
private void LoadDrinkCategoryForDisplay(DrinkCategory newDrinkCategory) { List <DrinkDisplayRow> rows = new List <DrinkDisplayRow>(); try { if (DrinkDisplayDictionary.ContainsKey(newDrinkCategory)) { rows = DrinkDisplayDictionary[newDrinkCategory]; } else { List <Drink> drinksForDisplay = MenuDrinks.GetDrinksList(newDrinkCategory); if (newDrinkCategory == DrinkCategory.DraftBeer) { var pints = new List <Drink>(); var pitchers = new List <Drink>(); foreach (var drink in drinksForDisplay) { if (drink.DrinkSize == DrinkSize.Pint) { pints.Add(drink); } else { pitchers.Add(drink); } } rows = GetDrinkDisplayRows(pints); rows.AddRange(GetDrinkDisplayRows(pitchers)); } else { rows = GetDrinkDisplayRows(drinksForDisplay); } DrinkDisplayDictionary.Add(newDrinkCategory, rows); } if (newDrinkCategory == DrinkCategory.DraftBeer) { DrinksGroups = new ObservableCollection <DrinksGroup>(ConvertBeerRowsToGroups(rows)); } else { DrinkDisplayItems = new ObservableCollection <DrinkDisplayRow>(rows); } } catch (Exception ex) { var error = ex.InnerException; throw; } }
public IActionResult Create(DrinkCategory drinkCategory) { if (ModelState.IsValid) { _categoryRepository.AddDrinkCategory(drinkCategory); return(RedirectToAction(nameof(Index))); } ViewBag.Parents = _categoryRepository.Categories; ViewBag.CatTypes = _categoryRepository.CategorieTypes; return(View(drinkCategory)); }
public static List <Drink> GetDrinksList(DrinkCategory drinkCategory) { switch (drinkCategory) { case DrinkCategory.SoftDrink: if (SoftDrinks == null || SoftDrinks.Count <= 0) { CreateSoftDrinks(); } return(SoftDrinks); case DrinkCategory.DraftBeer: if (DraftBeers == null || DraftBeers.Count <= 0) { CreateDraftBeers(); } return(DraftBeers); case DrinkCategory.BottledBeer: if (BottledBeers == null || BottledBeers.Count <= 0) { CreateBottledBeers(); } return(BottledBeers); case DrinkCategory.GlassWine: if (GlassWines == null || GlassWines.Count <= 0) { CreateGlassWines(); } return(GlassWines); case DrinkCategory.BottleWine: if (BottleWines == null || BottleWines.Count <= 0) { CreateBottleWines(); } return(BottleWines); //case DrinkCategory.HouseWine: // if (HouseWines == null || HouseWines.Count <= 0) // { // CreateHouseWines(); // } // return HouseWines; //case DrinkCategory.HotDrink: // if (HotDrinks == null || HotDrinks.Count <= 0) // { // CreateHotDrinks(); // } // return HotDrinks; } return(new List <Drink>()); }
// GET: DrinkCategories/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DrinkCategory drinkCategory = db.DrinkCategories.Find(id); if (drinkCategory == null) { return(HttpNotFound()); } return(View(drinkCategory)); }
public IViewComponentResult Invoke(DrinkCategory cat) { var isMobileTablet = _device.Type == DeviceType.Mobile || _device.Type == DeviceType.Tablet; var isOpen = DateTime.Now.TimeOfDay > TimeSpan.FromHours(8) && DateTime.Now.TimeOfDay < TimeSpan.FromHours(17); var drinks = cat.Id == 0 ? _drinkRepository.PreferredDrinks.ToList() : cat.Id == -1 ? _drinkRepository.NewDrinks.ToList(): _drinkRepository.DrinksByCategory(cat.Id).ToList(); var notifyPopup = _notifyPopupRepository.GetActiveNotifyPopup(); ViewData["IsOpen"] = isOpen; ViewData["NotifyPopup"] = notifyPopup; ViewData["isMobileTablet"] = isMobileTablet; ViewData["cat"] = cat; return(View(drinks)); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } DrinkCategory = await _context.DrinkCategories .Include(d => d.CompanyHead).FirstOrDefaultAsync(m => m.DrinkCategoryID == id); if (DrinkCategory == null) { return(NotFound()); } return(Page()); }
public ActionResult Create([Bind(Include = "idCategoryDrink,name")] DrinkCategory drinkCategory) { int idcare = Convert.ToInt32(Request["idCategoryDrink"]); var ds = db.DrinkCategories.Where(x => x.idCategoryDrink == idcare); if (ds.Count() > 0) { ModelState.AddModelError("", "Mã danh mục đã tồn tại"); } if (ModelState.IsValid) { db.DrinkCategories.Add(drinkCategory); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(drinkCategory)); }
// To protect from overposting attacks, enable the specific properties you want to bind to, for // more details, see https://aka.ms/RazorPagesCRUD. public async Task<IActionResult> OnPostAsync(string[] selectedCategories) { var newDrink = new Drink(); if(selectedCategories != null) { newDrink.DrinkCategories = new List<DrinkCategory>(); foreach(var cat in selectedCategories) { var catToAdd = new DrinkCategory { CategoryID = int.Parse(cat) }; newDrink.DrinkCategories.Add(catToAdd); } } if(await TryUpdateModelAsync<Drink>(newDrink,"Drink",i => i.Name, i => i.Company, i => i.Price, i => i.ExpiringDate, i => i.StoreID)){ _context.Drink.Add(newDrink); await _context.SaveChangesAsync(); return RedirectToPage("./Index"); } PopulateAssignedCategoryData(_context, newDrink); return Page(); }
public void UpdateDrinkCategory(DrinkCategory drinkCategory) { if (drinkCategory.Photos != null) { foreach (var photoModel in drinkCategory.Photos) { if (photoModel.Id != 0) { var photo = _appDbContext.DrinkCategoryPhotos.Find(photoModel.Id); _appDbContext.Entry(photo).State = EntityState.Detached; //deleted if (photoModel.IsDeleted) { _appDbContext.DrinkCategoryPhotos.Remove(photo); } else { photo.IsPrimary = photoModel.IsPrimary; _appDbContext.Update(photo); } } else { if (!photoModel.IsDeleted) { photoModel.DrinkCategoryId = drinkCategory.Id; _appDbContext.DrinkCategoryPhotos.Add(photoModel); } } } } _appDbContext.Entry(drinkCategory).State = EntityState.Modified; _appDbContext.Update(drinkCategory); _appDbContext.SaveChanges(); }
public void OnDrinksSelected(DrinkCategory newDrinkCategory) { try { if (IsDrinkSelectedForEdit) { List <Drink> drinksForDisplay = MenuDrinks.GetDrinksList(newDrinkCategory); for (int i = 0; i < drinksForDisplay.Count; i++) { if (drinksForDisplay[i].DrinkType == drinkSelectedForEditDrinkType && drinksForDisplay[i].DrinkSize == drinkSelectedForEditDrinkSize) { if (newDrinkCategory == DrinkCategory.DraftBeer) { if (i < 5) { DrinkForEditIndex = (int)Math.Floor(i / 3M); } else { switch (i) { case 5: case 6: case 7: DrinkForEditIndex = 2; break; case 8: DrinkForEditIndex = 3; break; } } } else { DrinkForEditIndex = (int)Math.Floor(i / 3M); } break; } } } else { ScrollToTopOfList?.Invoke(this, EventArgs.Empty); } //Load new drinks onto page. LoadDrinkCategoryForDisplay(newDrinkCategory); } catch (Exception ex) { var error = ex.InnerException; throw; } //In case we've already added drinks to this order and are returning to that //drink category, we want to show what was added previously. LoadPreviousDrinkSelections(newDrinkCategory); switch (newDrinkCategory) { case DrinkCategory.SoftDrink: SoftDrinksSelected = true; BottledBeerSelected = false; DraftBeerSelected = false; GlassWineSelected = false; BottleWineSelected = false; break; case DrinkCategory.DraftBeer: DraftBeerSelected = true; SoftDrinksSelected = false; BottledBeerSelected = false; GlassWineSelected = false; BottleWineSelected = false; break; case DrinkCategory.BottledBeer: BottledBeerSelected = true; SoftDrinksSelected = false; DraftBeerSelected = false; GlassWineSelected = false; BottleWineSelected = false; break; case DrinkCategory.GlassWine: GlassWineSelected = true; SoftDrinksSelected = false; BottledBeerSelected = false; DraftBeerSelected = false; BottleWineSelected = false; break; case DrinkCategory.BottleWine: BottleWineSelected = true; SoftDrinksSelected = false; BottledBeerSelected = false; DraftBeerSelected = false; GlassWineSelected = false; break; } currentDrinkCategorySelected = newDrinkCategory; }
public static void Initialize(RestaurantContext context) { //context.Database.EnsureDeleted(); // makes sure the database starts fresh by deleting any old databases // Migrations added -- 01/27/2020 -- // context.Database.EnsureCreated(); // creates new database if there isn't one already. // Looks for any Food // Change conditional to check for all models if (context.Foods.Any()) { return; //DB has been seeded aka has foods } //Initialize Foods var foods = new Food[] { new Food { Name = "Taco", ExpirationDate = DateTime.Parse("2020-01-25"), Quantity = 20 }, new Food { Name = "Burger", ExpirationDate = DateTime.Parse("2020-02-01"), Quantity = 30 }, new Food { Name = "Sandwich", ExpirationDate = DateTime.Parse("2020-01-01"), Quantity = 50 }, new Food { Name = "Ramen", ExpirationDate = DateTime.Parse("2020-03-05"), Quantity = 100 }, new Food { Name = "Pizza", ExpirationDate = DateTime.Parse("2020-04-01"), Quantity = 25 }, new Food { Name = "Hot Dog", ExpirationDate = DateTime.Parse("2020-12-31"), Quantity = 15 } }; foreach (Food f in foods) { context.Foods.Add(f); } context.SaveChanges(); //Initialize Beverage Companies var companys = new Company[] { new Company { Name = "Coca-Cola", FoundedDate = DateTime.Parse("1920-01-15") }, new Company { Name = "Nestle", FoundedDate = DateTime.Parse("1845-05-24") }, new Company { Name = "Heineken", FoundedDate = DateTime.Parse("1953-03-24") } }; foreach (Company c in companys) { context.Companies.Add(c); } context.SaveChanges(); //Initialize Drink Categories var drinkCats = new DrinkCategory[] { //Single will look for 1 instance, it throws an exception if 0 or more than 1 is found. new DrinkCategory { Name = "Soft Drink", MinProductionCost = 1000.00m, Alcoholic = "no", CompanyID = companys.Single(c => c.Name == "Coca-Cola").CompanyID }, new DrinkCategory { Name = "Bottled Water", MinProductionCost = 2020.20m, Alcoholic = "no", CompanyID = companys.Single(c => c.Name == "Nestle").CompanyID }, new DrinkCategory { Name = "Beer", MinProductionCost = 150.00m, Alcoholic = "yes", CompanyID = companys.Single(c => c.Name == "Heineken").CompanyID } }; foreach (DrinkCategory d in drinkCats) { context.DrinkCategories.Add(d); } context.SaveChanges(); //Initialize Drinks var drinks = new Drink[] { new Drink { DrinkID = 1001, Name = "Coke", Size = 20.0, DrinkCategoryID = drinkCats.Single(d => d.Name == "Soft Drink").DrinkCategoryID }, new Drink { DrinkID = 1002, Name = "Water", Size = 32.0, DrinkCategoryID = drinkCats.Single(d => d.Name == "Bottled Water").DrinkCategoryID }, new Drink { DrinkID = 1003, Name = "Sprite", Size = 16.0, DrinkCategoryID = drinkCats.Single(d => d.Name == "Soft Drink").DrinkCategoryID }, new Drink { DrinkID = 1004, Name = "Lager", Size = 12.0, DrinkCategoryID = drinkCats.Single(d => d.Name == "Beer").DrinkCategoryID } }; foreach (Drink d in drinks) { context.Drinks.Add(d); } context.SaveChanges(); //Initalize CompanyHQs var companyHQs = new CompanyHQ[] { new CompanyHQ { CompanyID = companys.Single(c => c.Name == "Coca-Cola").CompanyID, Location = "Atlanta, Georgia" }, new CompanyHQ { CompanyID = companys.Single(c => c.Name == "Nestle").CompanyID, Location = "Vevey, Switzerland" }, new CompanyHQ { CompanyID = companys.Single(c => c.Name == "Heineken").CompanyID, Location = "Amsterdam, Netherlands" } }; foreach (CompanyHQ c in companyHQs) { context.CompanyHQs.Add(c); } context.SaveChanges(); //Initialize CompanyAssignments var drinkAssigns = new DrinkAssignment[] { new DrinkAssignment { DrinkID = drinks.Single(d => d.Name == "Coke").DrinkID, CompanyID = companys.Single(c => c.Name == "Coca-Cola").CompanyID }, new DrinkAssignment { DrinkID = drinks.Single(d => d.Name == "Water").DrinkID, CompanyID = companys.Single(c => c.Name == "Nestle").CompanyID }, new DrinkAssignment { DrinkID = drinks.Single(d => d.Name == "Sprite").DrinkID, CompanyID = companys.Single(c => c.Name == "Coca-Cola").CompanyID }, new DrinkAssignment { DrinkID = drinks.Single(d => d.Name == "Lager").DrinkID, CompanyID = companys.Single(c => c.Name == "Heineken").CompanyID } }; foreach (DrinkAssignment d in drinkAssigns) { context.DrinkAssignments.Add(d); } context.SaveChanges(); //Initialize Menus var menus = new Menu[] { new Menu { FoodID = foods.Single(f => f.Name == "Taco").FoodID, DrinkID = drinks.Single(d => d.Name == "Sprite").DrinkID, HealthGrade = HealthGrade.F }, new Menu { FoodID = foods.Single(f => f.Name == "Pizza").FoodID, DrinkID = drinks.Single(d => d.Name == "Water").DrinkID, HealthGrade = HealthGrade.C }, new Menu { FoodID = foods.Single(f => f.Name == "Burger").FoodID, DrinkID = drinks.Single(d => d.Name == "Water").DrinkID, HealthGrade = HealthGrade.D }, new Menu { FoodID = foods.Single(f => f.Name == "Hot Dog").FoodID, DrinkID = drinks.Single(d => d.Name == "Lager").DrinkID, HealthGrade = HealthGrade.B }, new Menu { FoodID = foods.Single(f => f.Name == "Ramen").FoodID, DrinkID = drinks.Single(d => d.Name == "Water").DrinkID, HealthGrade = HealthGrade.A }, new Menu { FoodID = foods.Single(f => f.Name == "Sandwich").FoodID, DrinkID = drinks.Single(d => d.Name == "Lager").DrinkID, HealthGrade = HealthGrade.D } }; foreach (Menu m in menus) { // var menuInDatabase = context.Menus.Where( f => f.Food.FoodID == m.FoodID && f.Drink.DrinkID == m.DrinkID).SingleOrDefault(); if (menuInDatabase == null) { context.Menus.Add(m); } } context.SaveChanges(); }
public static void MappingDrinkCategory(this DrinkCategoryDto drinkCategoryDto, DrinkCategory drinkCategory) { drinkCategory.Id = drinkCategoryDto.Id; drinkCategory.Title = drinkCategoryDto.Title; }