/// <summary>
/// For Bereichs Datum
/// </summary>
/// <param name="ersteDatum"></param>
/// <param name="zweiteDatum"></param>
/// <param name="category"></param>
/// <returns></returns>
internal async static Task <ObservableCollection <ListBalance> > GetBalanceListeAsync(DateTime ersteDatum, DateTime zweiteDatum, string category)
{
ObservableCollection <ListBalance> balances = new ObservableCollection <ListBalance>();
var cost = new List <Store.DataBase.DataBaseEF.Cost>();
var income = new List <Store.DataBase.DataBaseEF.Income>();
using (var dataBase = new Store.DataBase.DataBaseEF.DataBaseFile())
{
if (category == CategoryNamenIncomen.Salary.ToString() || category == CategoryNamenIncomen.OtherIncomes.ToString())
{
income = await
(from nameIncome in dataBase.Incomes
where nameIncome.DateOfIncome.Date >= ersteDatum && nameIncome.DateOfIncome.Date <= zweiteDatum && nameIncome.CategoryOfIncome == category
select nameIncome).ToListAsync();
}
else
{
cost = await
(from nameCost in dataBase.Costs
where nameCost.DateOfCost.Date >= ersteDatum && nameCost.DateOfCost.Date <= zweiteDatum && nameCost.CategoryOfCost == category
select nameCost).ToListAsync();
}
}
if (category == CategoryNamenIncomen.Salary.ToString() || category == CategoryNamenIncomen.OtherIncomes.ToString())
{
foreach (var item in income)
{
ListBalance listBalance = new ListBalance();
listBalance = await GetNewIncomesBalanceAsync(item.IncomeId);
balances.Add(listBalance);
}
}
else
{
foreach (var item in cost)
{
ListBalance listBalance = new ListBalance();
listBalance = await GetNewCostsBalanceAsync(item.CostId);
balances.Add(listBalance);
}
}
return(balances);
}
internal async static Task <ObservableCollection <ListBalance> > GetBalanceListeAsync(CategoryCostIncomen category, int monat, int year)
{
ObservableCollection <ListBalance> balances = new ObservableCollection <ListBalance>();
ListBalance listBalance = new ListBalance();
var cost = new List <Store.DataBase.DataBaseEF.Cost>();
var income = new List <Store.DataBase.DataBaseEF.Income>();
//var optionsBuilder = new DbContextOptionsBuilder<Store.DataBase.DataBaseEF.DataBaseFile>();
//optionsBuilder.UseSqlite("Filename=Balance.db");
//using (var dataBase = new Store.DataBase.DataBaseEF.DataBaseFile(optionsBuilder.Options))
if (category == CategoryCostIncomen.Cost)
{
using (var dataBase = new Store.DataBase.DataBaseEF.DataBaseFile())
{
cost = await
(from nameCost in dataBase.Costs
where nameCost.DateOfCost.Month == monat && nameCost.DateOfCost.Year == year
select nameCost).ToListAsync();
}
foreach (var item in cost)
{
listBalance = await GetNewCostsBalanceAsync(item.CostId);
balances.Add(listBalance);
}
}
else
{
using (var dataBase = new Store.DataBase.DataBaseEF.DataBaseFile())
{
income = await
(from nameIncome in dataBase.Incomes
where nameIncome.DateOfIncome.Month == monat && nameIncome.DateOfIncome.Year == year
select nameIncome).ToListAsync();
}
foreach (var item in income)
{
listBalance = await GetNewIncomesBalanceAsync(item.IncomeId);
balances.Add(listBalance);
}
}
return(balances);
}
/// <summary>
/// For CalendarPage Get all Liste Incomes and Costs
/// </summary>
/// <param name="datum"></param>
/// <returns></returns>
public async static Task <ObservableCollection <ListBalance> > GetBalanceListeAsync(DateTime datum)
{
ObservableCollection <ListBalance> balances = new ObservableCollection <ListBalance>();
var cost = new List <Store.DataBase.DataBaseEF.Cost>();
var income = new List <Store.DataBase.DataBaseEF.Income>();
//var optionsBuilder = new DbContextOptionsBuilder<Store.DataBase.DataBaseEF.DataBaseFile>();
//optionsBuilder.UseSqlite("Filename=Balance.db");
//using (var dataBase = new Store.DataBase.DataBaseEF.DataBaseFile(optionsBuilder.Options))
using (var dataBase = new Store.DataBase.DataBaseEF.DataBaseFile())
{
cost = await
(from nameCost in dataBase.Costs
where nameCost.DateOfCost.Date == datum.Date
select nameCost).ToListAsync();
income = await
(from nameIncome in dataBase.Incomes
where nameIncome.DateOfIncome.Date == datum.Date
select nameIncome).ToListAsync();
}
foreach (var item in cost)
{
ListBalance listBalance = new ListBalance();
listBalance = await GetNewCostsBalanceAsync(item.CostId);
balances.Add(listBalance);
}
foreach (var item in income)
{
ListBalance listBalance = new ListBalance();
listBalance = await GetNewIncomesBalanceAsync(item.IncomeId);
balances.Add(listBalance);
}
return(balances);
}
