public SearchResult <SOWAssignDTO> GetDataByFilter(SOWAssignSearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "SOWAssign_PK"; } SOWAssignQuery sowAssignQuery = new SOWAssignQuery(this.Db); var filteredRecords = sowAssignQuery.GetQuery() .Where(sowAssign => sowAssign.SOWName.Contains(filter.Keyword) || sowAssign.UserName.Contains(filter.Keyword) || sowAssign.KategoriJabatanTitle.Contains(filter.Keyword) ); var displayedRecords = filteredRecords. SortBy(filter.SortName, filter.SortDir) .Skip(filter.Skip) .Take(filter.PageSize) .ToList(); var searchResult = new SearchResult <SOWAssignDTO>(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = sowAssignQuery.GetTotalRecords(); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; return(searchResult); }
public SOWAssignListModel Get(SOWAssignSearchFilter searchFilter) { SOWAssignListFormData formData = new SOWAssignListFormData(); SearchResult <SOWAssignDTO> searchResult = sowAssignSearch.GetDataByFilter(searchFilter); return(new SOWAssignListModel() { FormData = formData, SearchResult = searchResult }); }