public async Task <SupplierGetPagedListResponse> GetPagedListAsync( Guid accountId, SupplierGetPagedListRequest request, CancellationToken ct) { var suppliers = await _storage.Suppliers .AsNoTracking() .Include(x => x.AttributeLinks) .Where(x => x.AccountId == accountId && (request.Name.IsEmpty() || EF.Functions.ILike(x.Name, $"{request.Name}%")) && (request.Phone.IsEmpty() || x.Phone == request.Phone) && (request.Email.IsEmpty() || x.Email == request.Email) && (!request.IsDeleted.HasValue || x.IsDeleted == request.IsDeleted) && (!request.MinCreateDate.HasValue || x.CreateDateTime >= request.MinCreateDate) && (!request.MaxCreateDate.HasValue || x.CreateDateTime <= request.MaxCreateDate) && (!request.MinModifyDate.HasValue || x.ModifyDateTime >= request.MinModifyDate) && (!request.MaxModifyDate.HasValue || x.ModifyDateTime <= request.MaxModifyDate)) .ToListAsync(ct); return(new SupplierGetPagedListResponse { TotalCount = suppliers .Count(x => x.FilterByAdditional(request)), LastModifyDateTime = suppliers .Max(x => x.ModifyDateTime), Suppliers = suppliers .Where(x => x.FilterByAdditional(request)) .AsQueryable() .SortBy(request.SortBy, request.OrderBy) .Skip(request.Offset) .Take(request.Limit) .ToList() }); }
public async Task WhenGetPagedList_ThenSuccess() { var headers = await _defaultRequestHeadersService.GetAsync(); var attribute = await _create.SupplierAttribute.BuildAsync(); var value = "Test".WithGuid(); await Task.WhenAll( _create.Supplier .WithAttributeLink(attribute.Id, value) .BuildAsync(), _create.Supplier .WithAttributeLink(attribute.Id, value) .BuildAsync()); var filterAttributes = new Dictionary <Guid, string> { { attribute.Id, value } }; var request = new SupplierGetPagedListRequest { Attributes = filterAttributes }; var response = await _suppliersClient.GetPagedListAsync(request, headers); var results = response.Suppliers .Skip(1) .Zip(response.Suppliers, (previous, current) => current.CreateDateTime >= previous.CreateDateTime); Assert.NotEmpty(response.Suppliers); Assert.All(results, Assert.True); }
public Task <SupplierGetPagedListResponse> GetPagedListAsync( SupplierGetPagedListRequest request, Dictionary <string, string> headers = default, CancellationToken ct = default) { return(_factory.PostAsync <SupplierGetPagedListResponse>( _host + "/Suppliers/v1/GetPagedList", null, request, headers, ct)); }
public static bool FilterByAdditional(this Supplier supplier, SupplierGetPagedListRequest request) { return((request.CreateUserIds == null || !request.CreateUserIds.Any() || request.CreateUserIds.Any(x => CreateUserIdsPredicate(supplier, x))) && (request.Attributes == null || !request.Attributes.Any() || (request.AllAttributes is false ? request.Attributes.Any(x => AttributePredicate(supplier, x)) : request.Attributes.All(x => AttributePredicate(supplier, x))))); }
public async Task <ActionResult <SupplierGetPagedListResponse> > GetPagedList( SupplierGetPagedListRequest request, CancellationToken ct = default) { var response = await _suppliersService.GetPagedListAsync(_userContext.AccountId, request, ct); return(ReturnIfAllowed( response, Roles.Suppliers, response.Suppliers.Select(x => x.AccountId))); }