public async Task <StockBalanceGetPagedListResponse> GetPagedListAsync( Guid accountId, StockBalanceGetPagedListRequest request, CancellationToken ct) { var balances = await _storage.StockBalances .AsNoTracking() .Include(x => x.Room) .Where(x => x.AccountId == accountId && (!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 StockBalanceGetPagedListResponse { TotalCount = balances .Count(x => x.FilterByAdditional(request)), LastModifyDateTime = balances .Max(x => x.ModifyDateTime), Balances = balances .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 room = await _create.StockRoom.BuildAsync(); var productStatus = await _create.ProductStatus.BuildAsync(); var product = await _create.Product .WithStatusId(productStatus.Id) .BuildAsync(); await Task.WhenAll( _create.StockBalance .WithRoomId(room.Id) .WithProductId(product.Id) .WithCount(1) .BuildAsync(), _create.StockBalance .WithRoomId(room.Id) .WithProductId(product.Id) .WithCount(1) .BuildAsync()); var request = new StockBalanceGetPagedListRequest(); var response = await _stockBalancesClient.GetPagedListAsync(request, headers); var results = response.Balances .Skip(1) .Zip(response.Balances, (previous, current) => current.CreateDateTime >= previous.CreateDateTime); Assert.NotEmpty(response.Balances); Assert.All(results, Assert.True); }
public Task <StockBalanceGetPagedListResponse> GetPagedListAsync( StockBalanceGetPagedListRequest request, Dictionary <string, string> headers = default, CancellationToken ct = default) { return(_factory.PostAsync <StockBalanceGetPagedListResponse>( _host + "/Stock/Balances/v1/GetPagedList", null, request, headers, ct)); }
public async Task <ActionResult <StockBalanceGetPagedListResponse> > GetPagedList( StockBalanceGetPagedListRequest request, CancellationToken ct = default) { var response = await _stockBalancesService.GetPagedListAsync(_userContext.AccountId, request, ct); return(ReturnIfAllowed(response, Roles.Stock, response.Balances.Select(x => x.AccountId))); }
public static bool FilterByAdditional(this StockBalance balance, StockBalanceGetPagedListRequest request) { return((request.CreateUserIds == null || !request.CreateUserIds.Any() || request.CreateUserIds.Any(x => CreateUserIdsPredicate(balance, x))) && (request.RoomIds == null || !request.RoomIds.Any() || request.RoomIds.Any(x => RoomIdsPredicate(balance, x))) && (request.ProductIds == null || !request.ProductIds.Any() || request.ProductIds.Any(x => ProductIdsPredicate(balance, x)))); }