public SearchResult <SOWTrackResultDTO> GetDataByFilter(SOWTrackResultSearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "SOWTrackResult_PK"; } var filteredRecords = GetQuery(); var displayedRecords = filteredRecords. SortBy(filter.SortName, filter.SortDir) .Skip(filter.Skip) .Take(filter.PageSize) .ToList(); var searchResult = new SearchResult <SOWTrackResultDTO>(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = GetTotalRecords(); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; return(searchResult); }
public SOWTrackResultListModel Get(SOWTrackResultSearchFilter searchFilter) { SOWTrackResultListFormData formData = new SOWTrackResultListFormData(); SearchResult <SOWTrackResultDTO> searchResult = sowTrackResultQuery.GetDataByFilter(searchFilter); return(new SOWTrackResultListModel() { FormData = formData, SearchResult = searchResult }); }
public IHttpActionResult Search([FromUri] SOWTrackResultSearchFilter filter) { //string accessType = "SOWTrackResult_ViewAll"; //ThrowIfUserHasNoRole(accessType); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var sowTrackResultQuery = new SOWTrackResultQuery(Db)) { var data = sowTrackResultQuery.GetDataByFilter(filter); return(Ok(new SuccessResponse(data))); } }