private async Task <List <Transaction> > GetTransactions(GetAssetsTotalQuery request, Guid[] assetIds, CancellationToken cancellationToken)
{
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 => assetIds.Contains(t.AssetId));
}
}
return(await query
.Include(t => t.Currency)
.ToListAsync(cancellationToken)
.ConfigureAwait(false));
}
private async Task <IEnumerable <Asset> > GetAsseets(GetAssetsTotalQuery request, CancellationToken cancellationToken)
{
var query = _assetRepository.GetAll();
if (request.Filter != null)
{
if (request.Filter.AssetId.HasValue)
{
query = query.Where(t => t.Id == request.Filter.AssetId.Value);
}
if (request.Filter.GroupId.HasValue)
{
query = query.Where(t => t.GroupId == request.Filter.GroupId.Value);
}
}
return(await query.Include(a => a.Group)
.ToListAsync(cancellationToken)
.ConfigureAwait(false));
}
protected override async ValueTask <IResult <IEnumerable <AssetTotalModel> > > HandleImpl(GetAssetsTotalQuery request, CancellationToken cancellationToken)
{
var result = new List <AssetTotalModel>();
var assets = await GetAsseets(request, cancellationToken)
.ConfigureAwait(false);
var transactions = await GetTransactions(request, assets.Select(a => a.Id).ToArray(), cancellationToken)
.ConfigureAwait(false);
var currency = await _currencyRepository.GetById(request.CurrencyId, cancellationToken)
.ConfigureAwait(false);
foreach (var group in transactions.GroupBy(t => t.AssetId))
{
if (cancellationToken.IsCancellationRequested)
{
return(await FromCancellationToken(cancellationToken));
}
var asset = assets.FirstOrDefault(a => a.Id == group.Key);
if (asset == null)
{
continue;
}
decimal total = 0m;
foreach (var transaction in group)
{
var price = transaction.Amount * transaction.Rate;
total += transaction.CurrencyId != request.CurrencyId
? await Exchange(transaction.Currency.Code, currency.Code, price, cancellationToken)
.ConfigureAwait(false)
: price;
}
var rate = await _forexService.GetPriceOf(asset.Code, currency.Code, cancellationToken)
.ConfigureAwait(false);
var amount = group.Sum(t => t.Amount);
decimal?totalNow = rate.IsSuccess ? amount * rate.Value.Rate : null;
var model = new AssetTotalModel
{
Id = asset.Id,
Code = asset.Code,
GroupId = asset.GroupId,
Icon = asset.Icon,
Name = asset.Name,
Order = asset.Order,
Symbol = asset.Symbol,
SumAmount = amount,
Total = total,
TotalNow = totalNow,
Increase = totalNow.HasValue ? CalculateProcent(total, totalNow.Value) : 0
};
if (asset.Group != null)
{
model.Group = _mapper.Map <Group, GroupModel>(asset.Group);
}
result.Add(model);
}
return(result.AsResult());
}
protected override string GenerateKey(GetAssetsTotalQuery request) => $"{base.GenerateKey(request)}.{request.CurrencyId}.{request.Filter}";
