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))));
}
