private static decimal GetPaymentAmountForSum(Payment payment, GetAccountProgressionQuery request)
{
return(payment.Type switch
{
PaymentType.Expense => - payment.Amount,
PaymentType.Income => payment.Amount,
PaymentType.Transfer => payment.ChargedAccount.Id == request.AccountId
? -payment.Amount
: payment.Amount,
_ => 0,
});
public async Task <List <StatisticEntry> > Handle(GetAccountProgressionQuery request, CancellationToken cancellationToken)
{
List <Payment>?payments = await contextAdapter.Context
.Payments
.Include(x => x.Category)
.Include(x => x.ChargedAccount)
.HasAccountId(request.AccountId)
.HasDateLargerEqualsThan(request.StartDate.Date)
.HasDateSmallerEqualsThan(request.EndDate.Date)
.ToListAsync(cancellationToken);
var returnList = new List <StatisticEntry>();
foreach (var group in payments.GroupBy(x => new { x.Date.Month, x.Date.Year }))
{
var statisticEntry = new StatisticEntry(group.Sum(x => GetPaymentAmountForSum(x, request)), $"{group.Key.Month:d2} {group.Key.Year:d4}");
statisticEntry.ValueLabel = statisticEntry.Value.ToString("c", CultureHelper.CurrentCulture);
statisticEntry.Color = statisticEntry.Value >= 0 ? BLUE_HEX_CODE : RED_HEX_CODE;
returnList.Add(statisticEntry);
}
return(returnList);
}