private void LoadData() { using (var db = new ExpenseManager()) { expenses = db.GetSomeItems(startDate, endDate, selectedCatName); } }
private void Spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e) { var mySpinner = (Spinner)sender; string selectedCatName = string.Format("{0}", mySpinner.GetItemAtPosition(e.Position)); using (var db = new ExpenseManager()) { catSum = db.GetSomeItems(startDate, endDate, selectedCatName) .Sum(a => a.Amount); } catTV.Text = catSum.ToString(); }
private void CountBalance() { double bills; double expenses; float balance; DateTime today = DateTime.Today; DateTime startDate = new DateTime(today.Year, today.Month, 1); DateTime endDate = startDate.AddMonths(1).AddDays(-1); int daysOfMonth = endDate.Day; int dayOfMonth = today.Day; using (var db = new ExpenseManager()) { bills = db.GetSomeItems(startDate, endDate, "Rachunki").Sum(a => a.Amount); expenses = db.GetItemsByDates(startDate, endDate) .Where(a => a.CategoryId != 1) .Sum(a => a.Amount); } balance = (((monthLimit - (float)bills - estBills) / daysOfMonth) * dayOfMonth) - (float)expenses; if (balance > 0) { textBalance.Text = balance.ToString(); textPlusMinus.Text = " zł do przodu."; } else if (balance == 0) { textBalance.Text = ""; textPlusMinus.Text = "na zero"; } else { balance = Math.Abs(balance); textBalance.Text = balance.ToString(); textPlusMinus.Text = " zł do tyłu."; } }