//POST:Book/Returned
public async Task <IActionResult> Returned(int bookId, int orderId)
{
var order = await _context.Orders.FindAsync(orderId);
var borrowedBook = await _context.BorrowedBooks.Where(b => b.OrderID == orderId).FirstAsync();
var book = await _context.Books.FindAsync(bookId);
var user = await _context.Users.FindAsync(order.UserID);
user.BooksHeld--;
order.ReturnedOn = DateTime.Now;
order.Status = "completed";
book.Borrowed = false;
// this just "tells the database what needs to be done but doesn't do anythign"
_context.Update(order);
_context.Update(book);
_context.Update(user);
_context.Remove(borrowedBook);
//this does the trick
await _context.SaveChangesAsync();
return(RedirectToAction("Transactions", "Order"));
}
public IActionResult RemoveBook(long id, long userid)
{
_context.Remove(_context.Books.Single(a => a.Id == id));
_context.SaveChanges();
return(Redirect("/Home/MyBookshelf"));
}