public IActionResult AddEditBook(long?id, BookViewModel model) { try { if (ModelState.IsValid) { bool isNew = !id.HasValue; Book book = isNew ? new Book { AddedDate = DateTime.UtcNow } : context.Set <Book>().SingleOrDefault(s => s.Id == id.Value); book.Name = model.Name; book.ISBN = model.ISBN; book.Author = model.Author; book.Publisher = model.Publisher; if (isNew) { context.Add(book); } context.SaveChanges(); } } catch (Exception ex) { throw ex; } return(RedirectToAction("Index")); }
public async Task <IActionResult> Create([Bind("Id,Name,Img,Price,Weight,Description,RoastLevel,Taste,RoastDate")] Coffee coffee) { if (ModelState.IsValid) { _context.Add(coffee); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(coffee)); }
public async Task <IActionResult> Create([Bind("ID,Name,Customer,TimeOrdered")] Order order) { if (ModelState.IsValid) { _context.Add(order); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(order)); }
public async Task <IActionResult> Create([Bind("Id,NamaKopi,AsalKopi,JenisKopi,DeskripsiKopi")] Coffee coffee) { if (ModelState.IsValid) { _context.Add(coffee); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(coffee)); }
public async Task <IActionResult> Create([Bind("ID,Name,Customer,TimeOrdered")] Order order, string Name) { var coffeebean = (from c in _context.Ingredients where c.Name == "CoffeeBean" select c.Unit).FirstOrDefault(); var sugar = (from c in _context.Ingredients where c.Name == "Sugar" select c.Unit).FirstOrDefault(); var milk = (from c in _context.Ingredients where c.Name == "Milk" select c.Unit).FirstOrDefault(); var bagcoffee = (from c in _context.Ingredients where c.Name == "CoffeeBean" select c.Container).FirstOrDefault(); var packsugar = (from c in _context.Ingredients where c.Name == "Sugar" select c.Container).FirstOrDefault(); var cartonmilk = (from c in _context.Ingredients where c.Name == "Milk" select c.Container).FirstOrDefault(); switch (Name) { case "Double Americano": if (coffeebean >= 3) { coffeebean = coffeebean - 3; _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + coffeebean + " WHERE ID = 1"); _context.SaveChanges(); } else { return(RedirectToAction(nameof(Index)).WithWarning("Order has failed due to insufficient unit of ingredient")); } break; case "Sweet Latte": if (coffeebean >= 2 & sugar >= 5 & milk >= 3) { coffeebean = coffeebean - 2; sugar = sugar - 5; milk = milk - 3; _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + coffeebean + " WHERE ID = 1"); _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + sugar + " WHERE ID = 2"); _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + milk + " WHERE ID = 3"); _context.SaveChanges(); } else { return(RedirectToAction(nameof(Index)).WithWarning("Order has failed due to insufficient unit of ingredient")); } break; case "Flat White": if (coffeebean >= 2 & sugar >= 1 & milk >= 4) { coffeebean = coffeebean - 2; sugar = sugar - 1; milk = milk - 4; _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + coffeebean + " WHERE ID = 1"); _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + sugar + " WHERE ID = 2"); _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Unit = " + milk + " WHERE ID = 3"); _context.SaveChanges(); } else { return(RedirectToAction(nameof(Index)).WithWarning("Order has failed due to insufficient unit of ingredient")); } break; default: break; } var beanhigh = bagcoffee * 15; var beanlow = (bagcoffee - 1) * 15; var sugarhigh = packsugar * 15; var sugarlow = (packsugar - 1) * 15; var milkhigh = cartonmilk * 15; var milklow = (cartonmilk - 1) * 15; if (!(coffeebean > beanlow && coffeebean <= beanhigh)) { bagcoffee--; _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Container = " + bagcoffee + " WHERE ID = 1"); _context.SaveChanges(); } if (!(sugar > sugarlow && sugar <= sugarhigh)) { packsugar--; _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Container = " + packsugar + " WHERE ID = 2"); _context.SaveChanges(); } if (!(milk > milklow && milk <= milkhigh)) { cartonmilk--; _context.Database.ExecuteSqlCommand("UPDATE dbo.Ingredient SET Container = " + cartonmilk + " WHERE ID = 3"); _context.SaveChanges(); } if (ModelState.IsValid) { _context.Add(order); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index)).WithSuccess("Order has been successfully submitted")); } return(View(order)); }