// GET: Report for BorrowedBookForNow public ActionResult BorrowedBookForNow(string sortBy) { //for sorting ViewBag.SortByTitleParameter = string.IsNullOrEmpty(sortBy) ? "Book desc" : ""; 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"; var result = _context.BorrowedBookForNow().ToList(); if (result == null) { return(HttpNotFound()); } //return Json(new { data = result }, JsonRequestBehavior.AllowGet); // for sorting switch (sortBy) { case "Book desc": result = _context.BorrowedBookForNow().OrderByDescending(b => b.Title).ToList(); break; case "First Name desc": result = _context.BorrowedBookForNow().OrderByDescending(b => b.First_Name).ToList(); break; case "First Name": result = _context.BorrowedBookForNow().OrderBy(b => b.First_Name).ToList(); break; case "Last Name desc": result = _context.BorrowedBookForNow().OrderByDescending(b => b.Last_Name).ToList(); break; case "Last Name": result = _context.BorrowedBookForNow().OrderBy(b => b.Last_Name).ToList(); break; case "Year desc": result = _context.BorrowedBookForNow().OrderByDescending(b => b.Year).ToList(); break; case "Year": result = _context.BorrowedBookForNow().OrderBy(b => b.Year).ToList(); break; case "Left Quantity desc": result = _context.BorrowedBookForNow().OrderByDescending(b => b.Left_Quantity).ToList(); break; case "Left Quantity": result = _context.BorrowedBookForNow().OrderBy(b => b.Left_Quantity).ToList(); break; default: result = _context.BorrowedBookForNow().OrderBy(b => b.Title).ToList(); break; } return(View(result)); }