// GET: AutoOrder public ActionResult AutoReorder() { ReorderListSet(); DefaultReorder reorder = _context.ReorderQuantity.FirstOrDefault(u => u.DefaultReorderID == 1); List <BookOrder> autobookorders = _context.BookOrders.Include(o => o.Book).Where(b => b.InReorderList == true).ToList(); foreach (BookOrder bo in autobookorders) { if (bo.Status == Status.Delivered) { bo.InReorderList = false; _context.Update(bo); } } _context.SaveChanges(); List <BookOrder> updatedautoorders = _context.BookOrders.Include(o => o.Book).Where(b => b.InReorderList == true).ToList(); ViewBag.ReorderID = reorder.DefaultReorderID; return(View(updatedautoorders)); }
public async Task <IActionResult> Edit(int id, [Bind("DefaultReorderID,DefaultQuantity")] DefaultReorder defaultReorder) { if (id != defaultReorder.DefaultReorderID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(defaultReorder); SetDefaultQuantity(); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DefaultReorderExists(defaultReorder.DefaultReorderID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("AutoReorder", "BookOrder")); } return(View(defaultReorder)); }
public IActionResult ChangeDefault(int DefaultValue) { DefaultReorder reorder = _context.ReorderQuantity.FirstOrDefault(u => u.DefaultReorderID == 1); reorder.DefaultQuantity = DefaultValue; //TempData["quantity"] = DefaultValue; return(RedirectToAction("AutoRorder")); }
//POST : BookOrder/Create public IActionResult CreateAuto() { AppUser user = _context.Users.FirstOrDefault(u => u.UserName == User.Identity.Name); DefaultReorder reorder = _context.ReorderQuantity.FirstOrDefault(u => u.DefaultReorderID == 1); List <Book> ReorderBooks = GetReorderBooks(); //list of orders List <BookOrder> bookorders = new List <BookOrder>(); //list of book orders in database List <BookOrder> boalreadyindb = _context.BookOrders.ToList(); //list of books we already have book orders for List <Book> titlesbookorder = new List <Book>(); foreach (BookOrder bookorder in boalreadyindb) { titlesbookorder.Add(bookorder.Book); } //list of order details foreach (Book b in ReorderBooks) { bool alreadyExist = titlesbookorder.Contains(b); //if book doesnt have order if (alreadyExist == false) { //create orders BookOrder bo = new BookOrder(); bo.AppUser = user; bo.ReorderQuantity = reorder; bo.Book = b; bo.Quantity = bo.ReorderQuantity.DefaultQuantity; bo.Price = b.SupplierPrice; bo.InReorderList = true; bookorders.Add(bo); _context.BookOrders.Add(bo); } } _context.SaveChanges(); return(RedirectToAction("AutoReorder")); }
public void SetDefaultQuantity() { DefaultReorder reorder = _context.ReorderQuantity.FirstOrDefault(u => u.DefaultReorderID == 1); List <BookOrder> autobookorders = _context.BookOrders.Include(o => o.Book).Where(b => b.InReorderList == true).ToList(); foreach (BookOrder bo in autobookorders) { if (bo.ReorderQuantity == reorder) { bo.Quantity = bo.ReorderQuantity.DefaultQuantity; bo.Quantity = reorder.DefaultQuantity; _context.Update(bo); } } _context.SaveChanges(); }