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