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