public SearchResult <AuthParamDTO> GetDataByFilter(AuthParamSearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "AuthParam_PK"; } AuthParamQuery authParamQuery = new AuthParamQuery(this.Db); var filteredRecords = authParamQuery.GetQuery() .Where(authParam => authParam.Title.Contains(filter.Keyword) || authParam.Description.Contains(filter.Keyword)); var displayedRecords = filteredRecords. SortBy(filter.SortName, filter.SortDir) .Skip(filter.Skip) .Take(filter.PageSize) .ToList(); var searchResult = new SearchResult <AuthParamDTO>(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = authParamQuery.GetTotalRecords(); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; return(searchResult); }
public AuthParamListModel Get(AuthParamSearchFilter searchFilter) { AuthParamListFormData formData = new AuthParamListFormData(); SearchResult <AuthParamDTO> searchResult = authParamSearch.GetDataByFilter(searchFilter); return(new AuthParamListModel() { FormData = formData, SearchResult = searchResult }); }
public IHttpActionResult Search([FromUri] AuthParamSearchFilter filter) { ThrowIfUserHasNoRole(readRole); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var authParamSearch = new AuthParamSearch(Db)) { var data = authParamSearch.GetDataByFilter(filter); return(Ok(new SuccessResponse(data))); } }
public IHttpActionResult Search([FromUri] AuthParamSearchFilter filter) { string accessType = "AuthParam_ViewAll"; ThrowIfUserCannotAccess(accessType); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var authParamSearch = new AuthParamSearch(Db)) { var data = authParamSearch.GetDataByFilter(filter); return(Ok(new SuccessResponse(data))); } }