// // GET: /Case/ public ViewResult Index(int page = 1, string sort = "CaseTitle", string sortDir = "ASC") { // Clear search keyword for case Session["CaseKeyword"] = ""; int totalRows = 0; int pageSize = 10; List <Case> cases = new List <Case>(); totalRows = db.Cases.Count(); cases = (db.Cases.OrderBy(m => m.CaseDescription).Skip((page - 1) * pageSize).Take(pageSize)).ToList(); PruneLongDescriptions(cases); PagedCases pCases = new PagedCases(cases, pageSize, page, totalRows); return(View(pCases)); }
public ViewResult Search(int page = 1, string keyword = "") { string savedKeyword = (string)Session["CaseKeyword"]; if (!String.IsNullOrEmpty(savedKeyword)) { keyword = savedKeyword; } int totalRows = 0; int pageSize = 10; List <Case> cases = new List <Case>(); if (keyword == "") { totalRows = db.Cases.Count(); cases = (db.Cases.OrderBy(m => m.ID).Skip((page - 1) * pageSize).Take(pageSize)).ToList(); } else { totalRows = db.Cases .Where(m => m.CaseTitle.Contains(keyword) || m.CaseDescription.Contains(keyword)) .Count(); cases = (db.Cases .Where(m => m.CaseTitle.Contains(keyword) || m.CaseDescription.Contains(keyword)) .OrderBy(m => m.ID) .Skip((page - 1) * pageSize) .Take(pageSize)).ToList(); } Session["keyword"] = keyword; PruneLongDescriptions(cases); PagedCases pCases = new PagedCases(cases, pageSize, page, totalRows); return(View(pCases)); }