private static IQueryable<Transactions> GetSpending(DateTime startDate, DateTime endDate,
CategoryTypesEnum categoryType, PersonalFinanceContainer context)
{
var transactions = context.Transactions
.Include(table => table.Category)
//.Include(table => table.Category.CategoryType)
.Include(table => table.Partner);
return from transaction in transactions
where (transaction.Category.CategoryTypesId == (int)categoryType) &&
(transaction.Date >= startDate && transaction.Date <= endDate)
select transaction;
}
private static IQueryable<CategorySummary> GetCategoriesSummaryItems(DateTime startDate,
CategoryTypesEnum assetType, PersonalFinanceContainer context)
{
return from category in context.Categories.Include(item => item.Items)
where category.CategoryTypesId == (int)assetType &&
category.Items.Count() > 0 &&
category.Items.Any(item => item.DateAcquired >= startDate)
select new CategorySummary
{
Id = category.Id,
Name = category.Name,
Total = category.Items.Sum(item => item.Value)
};
}
private static IQueryable<PersonalFinance.Models.Item> GetOwnedItems(DateTime startDate, DateTime endDate,
CategoryTypesEnum assetType, PersonalFinanceContainer context)
{
return from asset in context.Items.Include(item => item.Category)
where (asset.Category.CategoryType.Id == (int)assetType && (asset.DateAcquired >= startDate) && asset.DateAcquired <= endDate)
orderby asset.DateAcquired
select asset;
}
private static IQueryable<CategorySummary> GetCategoriesSummary(DateTime startDate, DateTime endDate,
CategoryTypesEnum categoryType, PersonalFinanceContainer context)
{
return from category in context.Categories.Include(table => table.Transactions)
where category.CategoryTypesId == (int)categoryType &&
category.Transactions.Count() > 0 &&
category.Transactions.Any(transaction => transaction.Date >= startDate && transaction.Date <= endDate)
select new CategorySummary
{
Id = category.Id,
Name = category.Name,
Total = category.Transactions.Sum(tran => tran.Amount)
};
}
