public SearchResult <SOWStatusDTO> GetDataByFilter(SOWStatusSearchFilter filter)
{
if (string.IsNullOrEmpty(filter.SortName))
{
filter.SortName = "SOWStatus_PK";
}
SOWStatusQuery sowStatusQuery = new SOWStatusQuery(this.Db);
var filteredRecords =
sowStatusQuery.GetQuery()
.Where(sowStatus =>
sowStatus.Title.Contains(filter.Keyword));
var displayedRecords = filteredRecords.
SortBy(filter.SortName, filter.SortDir)
.Skip(filter.Skip)
.Take(filter.PageSize)
.ToList();
var searchResult = new SearchResult <SOWStatusDTO>(filter);
searchResult.Filter = filter;
searchResult.Count.TotalRecords = sowStatusQuery.GetTotalRecords();
searchResult.Count.TotalFiltered = filteredRecords.Count();
searchResult.Count.TotalDisplayed = displayedRecords.Count();
searchResult.Records = displayedRecords;
return(searchResult);
}
public SOWStatusListModel Get(SOWStatusSearchFilter searchFilter)
{
SOWStatusListFormData formData = new SOWStatusListFormData();
SearchResult <SOWStatusDTO> searchResult = sowStatusSearch.GetDataByFilter(searchFilter);
return(new SOWStatusListModel()
{
FormData = formData,
SearchResult = searchResult
});
}
