public AsetHistoriSearchResult GetDataByFilter(AsetHistoriSearchFilter filter)
{
if (string.IsNullOrEmpty(filter.SortName))
{
filter.SortName = "AsetHistori_PK";
}
AsetHistoriQuery asetHistoriQuery = new AsetHistoriQuery(this.Db);
var filteredRecords =
asetHistoriQuery.GetQuery()
.Where(asetHistori =>
asetHistori.User_FK == filter.User_FK &&
(asetHistori.UserFullName.Contains(filter.Keyword) ||
asetHistori.AsetID.Contains(filter.Keyword) ||
asetHistori.AsetName.Contains(filter.Keyword) ||
asetHistori.Description.Contains(filter.Keyword)
));
var displayedRecords = filteredRecords.
SortBy(filter.SortName, filter.SortDir)
.Skip(filter.Skip)
.Take(filter.PageSize)
.ToList();
var searchResult = new AsetHistoriSearchResult(filter);
searchResult.Filter = filter;
searchResult.Count.TotalRecords = asetHistoriQuery.GetTotalRecords();
searchResult.Count.TotalFiltered = filteredRecords.Count();
searchResult.Count.TotalDisplayed = displayedRecords.Count();
searchResult.Records = displayedRecords;
searchResult.User = new UserQuery(Db).GetByUserDetailFK(filter.User_FK);
return(searchResult);
}
public AsetHistoriSearchResult(AsetHistoriSearchFilter filter) : base(filter)
{
}
