/// <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); }