public SearchResult <SOWDTO> Search(SOWSearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "TglMulai"; filter.SortDir = "desc"; } SOWQuery sowQuery = new SOWQuery(this.Db); var filteredRecords = sowQuery.GetQuery() .Where(sow => sow.SOWName.Contains(filter.Keyword) || sow.BTSName.Contains(filter.Keyword) ); var displayedRecords = filteredRecords. SortBy(filter.SortName, filter.SortDir) .Skip(filter.Skip) .Take(filter.PageSize) .ToList(); var searchResult = new SearchResult <SOWDTO>(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = sowQuery.GetTotalRecords(); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; return(searchResult); }
public SOWListModel Get(SOWSearchFilter searchFilter) { SOWListFormData formData = new SOWListFormData(); SearchResult <SOWDTO> searchResult = sowQuery.Search(searchFilter); return(new SOWListModel() { FormData = formData, SearchResult = searchResult }); }
public IHttpActionResult Search([FromUri] SOWSearchFilter filter) { ThrowIfUserHasNoRole(readRole); if (filter == null) { throw new KairosException("Missing search filter parameter"); } using (var sowQuery = new SOWQuery(Db)) { var data = sowQuery.Search(filter); return(Ok(new SuccessResponse(data))); } }