public void acceptreq(object sender, EventArgs e) { databaseDataContext db3 = new databaseDataContext(); budget_setting bs = new budget_setting(); //DateTime dt = new DateTime(); databaseDataContext db = new databaseDataContext(); balance b = new balance(); request r = new request(); admin adm = new admin(gid); databaseDataContext db1 = new databaseDataContext(); try { string s = comboBox1.GetItemText(this.comboBox1.SelectedItem); int es = Int32.Parse(s); b = db.balances.SingleOrDefault(x => x.membername == textBox1.Text); b.amount = b.amount + es; db.SubmitChanges(); r = db1.requests.SingleOrDefault(x => x.amount == es); db1.requests.DeleteOnSubmit(r); db1.SubmitChanges(); //following 3 lines don't work //bs = db3.budget_settings.SingleOrDefault(x => x.guardian_id == gid && x.year==dateTimePicker1.Value.Month && x.month==adm.convertdate(dateTimePicker1.Value.Month.ToString())); //bs.max = bs.max + es; //db3.SubmitChanges(); MessageBox.Show("request accepted"); } 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); } }
private void set_budget(object sender, EventArgs e) { databaseDataContext db = new databaseDataContext(); budget_setting bs = new budget_setting(); databaseDataContext db1 = new databaseDataContext(); int s = Int32.Parse(comboBoxYear.GetItemText(this.comboBoxYear.SelectedItem)); string n = comboBoxMonth.GetItemText(this.comboBoxMonth.SelectedItem); budget_setting bs1 = new budget_setting(); try{ bs1 = db1.budget_settings.SingleOrDefault(x => x.year == s && x.month == n); if (bs1 == null) { bs.year = s; bs.month = n; bs.max = 0; bs.budget = Int32.Parse(textBoxBudget.Text); bs.guardian_id = gid; db.budget_settings.InsertOnSubmit(bs); db.SubmitChanges(); MessageBox.Show("budget set"); } else { MessageBox.Show("item already exist"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
protected void budget_set() { // Form1 f1 = new Form1(); //Null reference exception here databaseDataContext db = new databaseDataContext(); try { budget_setting b = new budget_setting(); b.year = int.Parse(comboBox1.SelectedItem.ToString()); b.month = comboBox2.SelectedItem.ToString(); b.max = 0; b.budget = int.Parse(textBoxBudget.Text); b.guardian_id = gid; // b.guardian_id = f1.gid; db.budget_settings.InsertOnSubmit(b); db.SubmitChanges(); MessageBox.Show("budget setting done!"); } catch (NullReferenceException ex) { MessageBox.Show(ex.Message); } /*try * { * using (databaseDataContext dbcon = new databaseDataContext()) * { * budget_setting bd=new budget_setting * { * year = int.Parse(comboBox1.SelectedItem.ToString()), * month = comboBox2.SelectedItem.ToString(), * budget = int.Parse(textBoxBudget.SelectedText), * max = int.Parse(textBoxMAX.SelectedText), * budget_id=int.Parse(textBoxBudgetId.SelectedText) * //month_id=tex * }; * dbcon.budget_settings.InsertOnSubmit(bd); * dbcon.SubmitChanges(); * * } * //label17.Text = "Successfullt Done!"; * * //MessageBox.Show("Done"); * } * catch (Exception ex) * { * MessageBox.Show(ex.Message); * * }*/ }
private void show_budget(object sender, EventArgs e) { databaseDataContext db = new databaseDataContext(); budget_setting bs = new budget_setting(); //budget_setting bs1 = new budget_setting(); try { int y = Int32.Parse(comboBox1.GetItemText(this.comboBox1.SelectedItem)); string m = comboBox2.GetItemText(this.comboBox2.SelectedItem); bs = db.budget_settings.SingleOrDefault(x => x.year == y && x.month == m); //bs = db.budget_settings.SingleOrDefault(x => x.month==m); textBoxAmountUsed.Text = bs.max.ToString(); textBoxAmountRemaining.Text = (bs.budget - bs.max).ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { databaseDataContext bd = new databaseDataContext(); balance b = new balance(); databaseDataContext bd1 = new databaseDataContext(); budget_setting bs = new budget_setting(); databaseDataContext bd2 = new databaseDataContext(); try { // b = bd.balances.SingleOrDefault(x => x.membername == comboBox1.GetItemText(this.comboBox1.SelectedItem)); int m = int.Parse(bd2.balances.Select(x => x.year).ToString()); string fs = bd2.balances.Select(x => x.month).ToString(); b.membername = comboBox1.SelectedItem.ToString(); b.amount = int.Parse(textBox1.Text); b.month = comboBox3.SelectedItem.ToString(); b.year = int.Parse(comboBox2.SelectedItem.ToString()); if (b.month == fs && b.year == m) { bd.balances.InsertOnSubmit(b); bd.SubmitChanges(); MessageBox.Show("balance added"); } else { MessageBox.Show("duplicate value!!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } try { bs = bd1.budget_settings.SingleOrDefault(x => x.month == b.month && x.year == b.year); bs.max = bs.max + b.amount; bd1.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }