public async Task <PagedList <CategoryViewBaseModel> > Handle(CategoryPagedListRequest request, CancellationToken cancellationToken) { var list = await this.db.Categories .Where(x => !x.IsDeleted) .Where(x => (string.IsNullOrEmpty(request.Query)) || (x.Name.Contains(request.Query))) .Select(x => new CategoryViewBaseModel(x)).ToListAsync(); 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(CategoryViewBaseModel); 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 <CategoryViewBaseModel>(list, request.Offset ?? CommonConstants.Config.DEFAULT_SKIP, request.Limit ?? CommonConstants.Config.DEFAULT_TAKE)); }
public async Task <PagedList <CategoryViewBaseModel> > GetAsync([FromQuery] CategoryPagedListRequest request, CancellationToken cancellationToken) { return(await this.mediator.Send(request, cancellationToken)); }