public async Task <PagedList <ServiceViewModel> > Handle(ServicePagedListRequest request, CancellationToken cancellationToken) { var services = await _cacheManager.GetAndSetAsync("list_services", 30, async() => { return(await this.db.Services .Where(x => !x.IsDeleted) .ToListAsync()); }); var list = services.Where(x => (string.IsNullOrEmpty(request.Query)) || (x.Name.Contains(request.Query))) .Where(x => (string.IsNullOrEmpty(request.Vehicle)) || (x.Station.Vehicle.ToLower().Equals(request.Vehicle.ToLower()))) .Select(x => new ServiceViewModel(x)).ToList(); if (request.IsDistinct) { list = list.GroupBy(x => x.Name).Select(g => g.First()).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 = "Name"; } var viewModelType = typeof(ServiceViewModel); 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 <ServiceViewModel>(list, request.Offset ?? CommonConstants.Config.DEFAULT_SKIP, request.Limit ?? CommonConstants.Config.DEFAULT_TAKE)); }
public async Task <PagedList <ServiceViewModel> > Get([FromQuery] ServicePagedListRequest request, CancellationToken cancellationToken) { return(await this.mediator.Send(request, cancellationToken)); }