public async Task <CategorySummaryModel> Handle(GetCategorySummaryQuery request, CancellationToken cancellationToken)
{
categoryOverviewItems = new List <CategoryOverviewItem>();
paymentLastTwelveMonths = await contextAdapter.Context
.Payments
.Include(x => x.Category)
.Where(x => x.Date.Date >= DateTime.Today.AddMonths(-12))
.Where(x => x.Type != PaymentType.Transfer)
.ToListAsync(cancellationToken);
List <Payment> paymentsInTimeRange = await contextAdapter.Context
.Payments
.Include(x => x.Category)
.Where(x => x.Date.Date >= request.StartDate.Date &&
x.Date.Date <= request.EndDate.Date)
.Where(x => x.Type != PaymentType.Transfer)
.ToListAsync(cancellationToken);
foreach (Category category in paymentsInTimeRange.Where(x => x.Category != null).Select(x => x.Category !).Distinct())
{
CreateOverviewItem(paymentsInTimeRange, category);
}
AddEntryForPaymentsWithoutCategory(paymentsInTimeRange);
CalculatePercentage(categoryOverviewItems);
StatisticUtilities.RoundStatisticItems(categoryOverviewItems);
return(new CategorySummaryModel(Convert.ToDecimal(categoryOverviewItems.Where(x => x.Value > 0).Sum(x => x.Value)),
Convert.ToDecimal(categoryOverviewItems.Where(x => x.Value < 0).Sum(x => x.Value)),
categoryOverviewItems.Where(x => Math.Abs(x.Value) > 0.1m).OrderBy(x => x.Value).ToList()));
}
public async Task <CategorySummaryModel> Handle(GetCategorySummaryQuery request, CancellationToken cancellationToken)
{
categoryOverviewItems = new List <CategoryOverviewItem>();
paymentLastTwelveMonths = await contextAdapter.Context
.Payments
.Include(x => x.Category)
.Where(x => x.Date.Date >= DateTime.Today.AddMonths(NUMBERS_OF_MONTHS_TO_LOAD))
.WithoutTransfers()
.ToListAsync(cancellationToken);
List <Payment> paymentsInTimeRange = await contextAdapter.Context
.Payments
.Include(x => x.Category)
.HasDateLargerEqualsThan(request.StartDate.Date)
.HasDateSmallerEqualsThan(request.EndDate.Date)
.Where(x => x.Type != PaymentType.Transfer)
.ToListAsync(cancellationToken);
foreach (Category category in paymentsInTimeRange.Where(x => x.Category != null).Select(x => x.Category !).Distinct())
{
CreateOverviewItem(paymentsInTimeRange, category);
}
AddEntryForPaymentsWithoutCategory(paymentsInTimeRange);
CalculatePercentage(categoryOverviewItems);
StatisticUtilities.RoundStatisticItems(categoryOverviewItems);
return(new CategorySummaryModel(Convert.ToDecimal(paymentsInTimeRange.Where(x => x.Type == PaymentType.Income).Sum(x => x.Amount)),
Convert.ToDecimal(paymentsInTimeRange.Where(x => x.Type == PaymentType.Expense).Sum(x => x.Amount)),
categoryOverviewItems.Where(x => Math.Abs(x.Value) > DECIMAL_DELTA).OrderBy(x => x.Value).ToList()));
}