public async Task <PagedList <StationDetailViewModel> > Handle(StationPagedListRequest request, CancellationToken cancellationToken)
{
var stations = await _cacheManager.GetAndSetAsync("list_stations", 60, async() =>
{
return(await this.db.Stations
.Where(x => !x.IsDeleted)
.Include(x => x.User)
.Include(x => x.Services)
.ToListAsync());
});
var list = stations.Where(x => (string.IsNullOrEmpty(request.Query)) || (x.Name.Contains(request.Query)))
.Where(x => (string.IsNullOrEmpty(request.Vehicle)) || (x.Vehicle.ToLower().Equals(request.Vehicle.ToLower())))
.Where(x => (!request.HasAmbulatory) || (x.HasAmbulatory))
.Where(x => (string.IsNullOrEmpty(request.ServiceName)) || (x.Services.FirstOrDefault(x => x.Name.ToLower().Contains(request.ServiceName.ToLower()))) != null)
.Select(x => new StationDetailViewModel(x))
.ToList();
var viewModelProperties = this.GetAllPropertyNameOfViewModel();
var sortPropertyName = !string.IsNullOrEmpty(request.SortName) ? request.SortName.ToLower() : string.Empty;
var matchedPropertyName = viewModelProperties.FirstOrDefault(x => x == sortPropertyName);
if (string.IsNullOrEmpty(matchedPropertyName))
{
matchedPropertyName = "CreatedOn";
}
var viewModelType = typeof(StationDetailViewModel);
var sortProperty = viewModelType.GetProperty(matchedPropertyName);
list = request.IsDesc ? list.OrderByDescending(x => sortProperty.GetValue(x, null)).ToList() : list.OrderBy(x => sortProperty.GetValue(x, null)).ToList();
return(new PagedList <StationDetailViewModel>(list, request.Offset ?? CommonConstants.Config.DEFAULT_SKIP, request.Limit ?? CommonConstants.Config.DEFAULT_TAKE));
}
public async Task <PagedList <StationDetailViewModel> > GetAsync([FromQuery] StationPagedListRequest request, CancellationToken cancellationToken)
{
return(await this.mediator.Send(request, cancellationToken));
}
