public async Task <IActionResult> Test(int?id, bool selectedCourse) { var viewModel = new RentalInventoryData(); viewModel.Inventory = from i in _context.Inventory .Include(i => i.Rental) .Include(i => i.Location) where i.RentalID == null select i; var rental = await _context.Rental .Include(r => r.User) .AsNoTracking() .SingleOrDefaultAsync(m => m.RentalID == id); if (id == null) { return(NotFound()); } ViewData["RentalName"] = rental.RentalName; ViewData["RentalReturn"] = rental.RentalReturnDate; ViewData["RentalCheckout"] = rental.RentalCheckoutDate; ViewData["RentalNotes"] = rental.RentalNotes; var rentalID = rental.RentalID; return(View(viewModel)); }
public async Task <IActionResult> TestPost(int?id, bool selectedCourse) { if (id == null) { return(NotFound()); } var viewModel = new RentalInventoryData(); viewModel.Inventory = from i in _context.Inventory .Include(i => i.Rental) .Include(i => i.Location) where i.RentalID == null select i; foreach (var x in viewModel.Inventory) { if (selectedCourse == true) { _context.Database.ExecuteSqlCommand("UPDATE Inventory SET RentalID={0} WHERE InventoryID={1}", id, x.InventoryID); } } return(RedirectToAction("Details/" + id)); }