public List <SRStatusEntity> SearchSrStatus(SRStatusSearchFilter searchFilter) { var q = (new SrStatusDataAccess(_context)).GetSrStatus(searchFilter.SRStatusId, searchFilter.SRStateId, null, null, searchFilter.Status, searchFilter.SRPageId); searchFilter.TotalRecords = q.Count(); int startPageIndex = (searchFilter.PageNo - 1) * searchFilter.PageSize; if (startPageIndex >= searchFilter.TotalRecords) { startPageIndex = 0; searchFilter.PageNo = 1; } switch (searchFilter.SortField) { case "SRStateName": q = searchFilter.SortOrder.ToUpper().Equals("ASC") ? q.OrderBy(x => x.SRState.SRStateName) : q.OrderByDescending(x => x.SRState.SRStateName); break; } return(q.Skip(startPageIndex).Take(searchFilter.PageSize).ToList()); }
public ActionResult Search(SRStatusSearchFilter searchFilter) { Logger.Info(_logMsg.Clear().SetPrefixMsg("SR Status List").ToInputLogString()); try { if (ModelState.IsValid) { SearchSRStatusModel model = new SearchSRStatusModel(); model.SearchFilter = searchFilter; if (searchFilter.Status == "all") { searchFilter.Status = null; } using (SrStatusFacade facade = new SrStatusFacade()) { model.SearchList = facade.SearchSrStatus(searchFilter); } ViewBag.PageSize = model.SearchFilter.PageSize; Logger.Info(_logMsg.Clear().SetPrefixMsg("Search SR Status").ToSuccessLogString()); return(PartialView("~/Views/Status/SearchList.cshtml", model)); } return(Json(new { Valid = false, Error = string.Empty, Errors = GetModelValidationErrors() })); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); Logger.Info(_logMsg.Clear().SetPrefixMsg("Search SR Status").Add("Error Message", ex.Message).ToFailLogString()); return(Error(new HandleErrorInfo(ex, ControllerContext.RouteData.Values["controller"].ToString(), ControllerContext.RouteData.Values["action"].ToString()))); } }