// // GET: /Comments/ public ActionResult Index(int?gridNum, CommentsSearch frm) { ViewBag.GridNum = AppFunc.GetGridItemsCombo(gridNum); var query = cRepo.GetQuery(false); if (frm.DateFrom.HasValue) { query = query.Where(t => t.AddDate >= frm.DateFrom); } if (frm.DateTo.HasValue) { query = query.Where(t => t.AddDate <= frm.DateTo); } if (!string.IsNullOrWhiteSpace(frm.Search)) { query = query.Where(t => t.Comment.Contains(frm.Search)); } frm.CommentsQuery = query; return(View(frm)); }
// // GET: /Users/ public ActionResult Index(int?gridNum) { ViewBag.PageSize = gridNum ?? GlobVars.GridItems; ViewBag.GridNum = AppFunc.GetGridItemsCombo(gridNum); var query = uRepo.GetQuery(); return(View(query.OrderByDescending(t => t.UserId))); }
public ActionResult Index(int?gridNum, string search, bool isArchive = false) { ViewBag.GridNum = AppFunc.GetGridItemsCombo(gridNum); ViewBag.PageSize = gridNum ?? GlobVars.GridItems; var query = contRepo.GetQuery(isArchive); if (!string.IsNullOrWhiteSpace(search)) { query = query.Where(t => t.Email.Contains(search) || t.Phone.Contains(search) || t.Company.Contains(search) || t.FullName.Contains(search) || t.LastName.Contains(search)); } query = query.OrderBy(t => t.IsDone).ThenByDescending(t => t.ContactId); return(View(query)); }