private async Task <List <Transaction> > GetTransactions(GetGroupTotalQuery request, Guid[] groupIds, CancellationToken cancellationToken = default)
{
var query = _transactionRepository.GetAll();
if (request.Filter != null)
{
if (request.Filter.From.HasValue)
{
query = query.Where(t => t.CreatedAt >= request.Filter.From.Value);
}
if (request.Filter.To.HasValue)
{
query = query.Where(t => t.CreatedAt <= request.Filter.To.Value);
}
if (request.Filter.AssetId.HasValue)
{
query = query.Where(t => t.AssetId == request.Filter.AssetId.Value);
}
if (request.Filter.GroupId.HasValue)
{
query = query.Where(t => t.Asset.GroupId == request.Filter.GroupId.Value);
}
else
{
query = query.Where(t => groupIds.Contains(t.Asset.GroupId));
}
}
return(await query.Include(t => t.Currency)
.Include(t => t.Asset)
.ToListAsync(cancellationToken)
.ConfigureAwait(false));
}
private async Task <IEnumerable <Group> > GetGroups(GetGroupTotalQuery request, CancellationToken cancellationToken)
{
var query = _groupRepository.GetAll();
if (request.Filter != null)
{
if (request.Filter.AssetId.HasValue)
{
query = query.Where(t => t.Assets.Select(a => a.Id).Contains(request.Filter.AssetId.Value));
}
if (request.Filter.GroupId.HasValue)
{
query = query.Where(t => t.Id == request.Filter.GroupId.Value);
}
}
return(await query
.ToListAsync(cancellationToken)
.ConfigureAwait(false));
}
protected override async ValueTask <IResult <IEnumerable <GroupTotalModel> > > HandleImpl(GetGroupTotalQuery request, CancellationToken cancellationToken)
{
var result = new List <GroupTotalModel>();
var currency = await _currencyRepository.GetById(request.CurrencyId, cancellationToken)
.ConfigureAwait(false);
var groups = await GetGroups(request, cancellationToken)
.ConfigureAwait(false);
var transactions = await GetTransactions(request, groups.Select(g => g.Id).ToArray(), cancellationToken)
.ConfigureAwait(false);
foreach (var transGroup in transactions.GroupBy(t => t.Asset.GroupId))
{
if (cancellationToken.IsCancellationRequested)
{
return(await FromCancellationToken(cancellationToken));
}
var group = groups.FirstOrDefault(a => a.Id == transGroup.Key);
if (group == null)
{
continue;
}
decimal total = 0m;
decimal totalNow = 0m;
foreach (var transaction in transGroup)
{
var price = transaction.Amount * transaction.Rate;
total += transaction.CurrencyId != request.CurrencyId
? await Exchange(transaction.Currency.Code, currency.Code, price, cancellationToken)
.ConfigureAwait(false)
: price;
}
foreach (var tranAsseet in transGroup.GroupBy(t => t.AssetId))
{
var asset = tranAsseet.First().Asset;
var rate = await _forexService.GetPriceOf(asset.Code, currency.Code, cancellationToken)
.ConfigureAwait(false);
totalNow += rate.IsSuccess ? tranAsseet.Sum(t => t.Amount) * rate.Value.Rate : 0;
}
var amount = transGroup.Sum(t => t.Amount);
var model = new GroupTotalModel
{
Id = group.Id,
Code = group.Code,
Name = group.Name,
SumAmount = amount,
Total = total,
TotalNow = totalNow != 0 ? totalNow : null,
Increase = CalculateProcent(total, totalNow)
};
result.Add(model);
}
return(result.AsResult());
}
protected override string GenerateKey(GetGroupTotalQuery request) => $"{base.GenerateKey(request)}.{request.CurrencyId}.{request.Filter}";