private void LoadMoneyList() { ExpenseManagementEntities DBE = new ExpenseManagementEntities(); List <MoneyForSavings> LstIncome = DBE.MoneyForSavings.ToList(); lstIncome.DataSource = LstIncome.Select(i => new { ID = i.IDSaving, Month = i.Month, Income = i.MoneyFSaving }).ToList(); }
private void LoadL() { ExpenseManagementEntities DBE = new ExpenseManagementEntities(); SpendMoney Money = new SpendMoney(); lstSatistics.DataSource = DBE.SpendMoney.ToList(); }
private void Expenses_Load(object sender, EventArgs e) { ExpenseManagementEntities DBE = new ExpenseManagementEntities(); int m = DTPDate.Value.Month; List <Money> List = DBE.Money.Where(i => i.Month == m).ToList(); Menu MN = new Menu(); txtTotal.Text = "Total:" + (MN.MAvailable() - MN.MoSpend() - MN.MFSaving()); }
public int MoSpend() { int MS; ExpenseManagementEntities DBE = new ExpenseManagementEntities(); List <SpendMoney> MoneySpend = DBE.SpendMoney.Where(i => i.Date.Month == month).ToList(); MS = int.Parse(MoneySpend.Select(i => new { Sum = i.Money }).Sum(i => i.Sum).ToString()); return(MS); }
private void btnSeach_Click(object sender, EventArgs e) { try { ExpenseManagementEntities DBE = new ExpenseManagementEntities(); int month = int.Parse(cbbMonth.Text); List <SpendMoney> SpendM = DBE.SpendMoney.Where(i => i.Date.Month == month).ToList(); lstSatistics.DataSource = SpendM.ToList(); } catch { MessageBox.Show("You should select a month!"); } }
public int MFSaving() { int MFS; ExpenseManagementEntities DBE = new ExpenseManagementEntities(); List <MoneyForSavings> MoneySaving = DBE.MoneyForSavings.Where(i => i.Month == month).ToList(); try { MFS = MoneySaving.Select(i => i.MoneyFSaving).First(); } catch { MFS = 0; } return(MFS); }
public int MAvailable() { int MA; ExpenseManagementEntities DBE = new ExpenseManagementEntities(); List <Money> MoneyA = DBE.Money.Where(i => i.Month == month).ToList(); try { MA = MoneyA.Select(i => i.Money1).First(); } catch { MA = 0; } return(MA); }
private void btnDelete_Click(object sender, EventArgs e) { if (lstIncome.SelectedRows.Count == 1) { var row = lstIncome.SelectedRows[0]; var cell = row.Cells["ID"]; DateTime ID = (DateTime)cell.Value; ExpenseManagementEntities db = new ExpenseManagementEntities(); MoneyForSavings Money = db.MoneyForSavings.Single(st => st.IDSaving == ID); db.MoneyForSavings.DeleteObject(Money); db.SaveChanges(); this.LoadMoneyList(); } else { MessageBox.Show("You should select a month!"); } }
private void btnSave_Click(object sender, EventArgs e) { Menu MN = new Menu(); try { int money = int.Parse(txtMoney.Text); int MoneyTotal = MN.MAvailable() - MN.MoSpend() - MN.MFSaving(); if ((MoneyTotal - money) < 0 || (MoneyTotal - money) <= MN.MFSaving()) { MessageBox.Show("Out of money"); } else { try { DateTime Date = DateTime.Now; string Name = txtName.Text; DateTime datepick = DTPDate.Value; ExpenseManagementEntities DBE = new ExpenseManagementEntities(); SpendMoney SpendMoney = new SpendMoney(); Money Money = new Money(); SpendMoney.IDExpense = Date; SpendMoney.Name = Name; SpendMoney.Date = datepick; SpendMoney.Money = money; DBE.SpendMoney.AddObject(SpendMoney); DBE.SaveChanges(); MessageBox.Show("Add sucesscesful"); this.Close(); } catch { MessageBox.Show("Invalid Input"); } } } catch { MessageBox.Show("Invalid Input"); } }
public EditIncome(DateTime ID) { InitializeComponent(); EME = new ExpenseManagementEntities(); IC = EME.MoneyForSavings.Single(i => i.IDSaving == ID); }