// 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));
}