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