private void addmemexp(object sender, EventArgs e)
{
databaseDataContext db = new databaseDataContext();
cost_table c = new cost_table();
databaseDataContext db1 = new databaseDataContext();
// member m = new member();
balance b = new balance();
try {
c.cost_title = textBox3.Text;
c.cost_amount = Int32.Parse(textBox4.Text);
// m = db1.members.SingleOrDefault(x=>x.username==mid);
// string s = f.gid.ToString();
c.username = mid;
c.date = dateTimePicker1.Value;
db.cost_tables.InsertOnSubmit(c);
db.SubmitChanges();
b = db1.balances.SingleOrDefault(x => x.membername == mid);
b.amount = b.amount - Int32.Parse(textBox4.Text);
db1.SubmitChanges();
MessageBox.Show("expense added");
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void addexpense(object sender, EventArgs e)
{
databaseDataContext db = new databaseDataContext();
cost_table c = new cost_table();
databaseDataContext db1 = new databaseDataContext();
gurdian g = new gurdian();
budget_setting bs = new budget_setting();
try
{
// Form1 f = new Form1();
// MessageBox.Show(dateTimePicker1.Value.Month.ToString());
bs = db1.budget_settings.SingleOrDefault(x => x.year == dateTimePicker1.Value.Year && x.month == convertdate(dateTimePicker1.Value.Month.ToString()));
bs.max = bs.max + Int32.Parse(textBoxCostAmount.Text);
c.cost_title = textBoxCostTitle.Text;
c.cost_amount = Int32.Parse(textBoxCostAmount.Text);
g = db1.gurdians.SingleOrDefault(x => x.id == gid);
// string s = f.gid.ToString();
c.username = g.username;
c.date = dateTimePicker1.Value;
db.cost_tables.InsertOnSubmit(c);
db1.SubmitChanges();
db.SubmitChanges();
MessageBox.Show("expense added");
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
