// GET: Report for BorrowedAndReternedBooks public ActionResult BorrowedAndReternedBooks(ReportViewModel report, string borrowedAndReternedBooksDateFrom, string borrowedAndReternedBooksDateTo, string sortBy) { ViewBag.SortTitleParameter = sortBy == "Book" ? "Book_desc" : "Book"; ViewBag.SortByFirst_NameParameter = sortBy == "First Name" ? "First Name desc" : "First Name"; ViewBag.SortByLast_NameParameter = sortBy == "Last Name" ? "Last Name desc" : "Last Name"; ViewBag.SortByYearParameter = sortBy == "Year" ? "Year desc" : "Year"; ViewBag.SortByLeft_QuantityParameter = sortBy == "Left Quantity" ? "Left Quantity desc" : "Left Quantity"; if (!ModelState.IsValid) { return(View("Report")); } var result = _context.BorrowedAndReternedBooks(report.BorrowedAndReternedBooksDateFrom, report.BorrowedAndReternedBooksDateTo).ToList(); if (result == null) { return(HttpNotFound()); } switch (sortBy) { case "Book_desc": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderByDescending(b => b.Title).ToList(); break; case "Book": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderBy(b => b.Title).ToList(); break; case "First Name desc": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderByDescending(b => b.First_Name).ToList(); break; case "First Name": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderBy(b => b.First_Name).ToList(); break; case "Last Name desc": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderByDescending(b => b.Last_Name).ToList(); break; case "Last Name": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderBy(b => b.Last_Name).ToList(); break; case "Year desc": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderByDescending(b => b.Year).ToList(); break; case "Year": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderBy(b => b.Year).ToList(); break; case "Left Quantity desc": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderByDescending(b => b.Left_Quantity).ToList(); break; case "Left Quantity": result = _context.BorrowedAndReternedBooks(Convert.ToDateTime(borrowedAndReternedBooksDateFrom), Convert.ToDateTime(borrowedAndReternedBooksDateTo)).OrderBy(b => b.Left_Quantity).ToList(); break; } return(View(result)); }