public async Task <StockRoomGetPagedListResponse> GetPagedListAsync(
Guid accountId,
StockRoomGetPagedListRequest request,
CancellationToken ct)
{
var rooms = _storage.StockRooms
.AsNoTracking()
.Where(x =>
x.AccountId == accountId &&
(request.Name.IsEmpty() || EF.Functions.ILike(x.Name, $"{request.Name}%")) &&
(!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));
return(new StockRoomGetPagedListResponse
{
TotalCount = await rooms
.CountAsync(ct),
LastModifyDateTime = await rooms
.MaxAsync(x => x != null?x.ModifyDateTime ?? x.CreateDateTime : (DateTime?)null, ct),
Rooms = await rooms
.SortBy(request.SortBy, request.OrderBy)
.Skip(request.Offset)
.Take(request.Limit)
.ToListAsync(ct)
});
}
public Task <StockRoomGetPagedListResponse> GetPagedListAsync(
StockRoomGetPagedListRequest request,
Dictionary <string, string> headers = default,
CancellationToken ct = default)
{
return(_factory.PostAsync <StockRoomGetPagedListResponse>(
_host + "/Stock/Rooms/v1/GetPagedList", null, request, headers, ct));
}
public async Task <ActionResult <StockRoomGetPagedListResponse> > GetPagedList(
StockRoomGetPagedListRequest request,
CancellationToken ct = default)
{
var response = await _stockRoomsService.GetPagedListAsync(_userContext.AccountId, request, ct);
return(ReturnIfAllowed(response, Roles.Orders, response.Rooms.Select(x => x.AccountId)));
}
public async Task WhenGetPagedList_ThenSuccess()
{
var headers = await _defaultRequestHeadersService.GetAsync();
var name = "Test".WithGuid();
await Task.WhenAll(
_create.StockRoom
.WithName(name)
.BuildAsync());
var request = new StockRoomGetPagedListRequest
{
Name = name
};
var response = await _stockRoomsClient.GetPagedListAsync(request, headers);
var results = response.Rooms
.Skip(1)
.Zip(response.Rooms, (previous, current) => current.CreateDateTime >= previous.CreateDateTime);
Assert.NotEmpty(response.Rooms);
Assert.All(results, Assert.True);
}
