public ActivitiesSearchResult GetDataByFilter(ActivitiesSearchFilter filter) { if (string.IsNullOrEmpty(filter.SortName)) { filter.SortName = "User_FK"; } ActivitiesQuery activitiesQuery = new ActivitiesQuery(this.Db); var filteredRecords = activitiesQuery.GetQuery(filter.User_FK) //.Where(activities => // activities.Aktifitas.Contains(filter.Keyword) // ) .AsQueryable(); if (filter.Bulan != 0) { filteredRecords = filteredRecords.Where(x => x.Tanggal.Value.Month == filter.Bulan); } var displayedRecords = filteredRecords. SortBy(filter.SortName, filter.SortDir) .Skip(filter.Skip) .Take(filter.PageSize) .ToList(); var searchResult = new ActivitiesSearchResult(filter); searchResult.Filter = filter; searchResult.Count.TotalRecords = activitiesQuery.GetTotalRecords(filter.User_FK); searchResult.Count.TotalFiltered = filteredRecords.Count(); searchResult.Count.TotalDisplayed = displayedRecords.Count(); searchResult.Records = displayedRecords; searchResult.User = new UserQuery(Db).GetByPrimaryKey(filter.User_FK); return(searchResult); }
public ActivitiesSearchResult(ActivitiesSearchFilter filter) : base(filter) { }