protected void insert_gurdian() { try { using (databaseDataContext dbcon = new databaseDataContext()) { //without date of birth gurdian reg_gurdian = new gurdian { name = name.Text, username = username.Text, password = password.Text, gender = gender.SelectedItem.ToString(), id = int.Parse(id.Text), // dob=dob_g.Value, family_member = int.Parse(family.Text), month_sal = int.Parse(salary.Text) }; dbcon.gurdians.InsertOnSubmit(reg_gurdian); dbcon.SubmitChanges(); } MessageBox.Show("registration complete"); Form1 fm1 = new Form1(); this.Hide(); fm1.Show(); } catch (Exception e) { MessageBox.Show(e.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); } }
//my login method. any login is approved. private void login() { gurdian g = new gurdian(); databaseDataContext dbcon = new databaseDataContext(); string s = textBox2.Text; g = dbcon.gurdians.SingleOrDefault(x => x.username == s); if (textBox3.Text == g.password) { this.Hide(); admin ad = new admin(g.id); ad.Show(); gid = g.id; //dt.setGID(g.id); // MessageBox.Show("GID set to "+gid); } else { MessageBox.Show("wrong username or password"); } }
private void checkoldpass(object sender, EventArgs e) { databaseDataContext db = new databaseDataContext(); gurdian g = new gurdian(); // Form1 f = new Form1(); // MessageBox.Show("gid is"+gid); string op = textBoxOldPass.Text; try { g = db.gurdians.SingleOrDefault(x => x.id == gid); if (op == g.password) { textBoxNewPass.Show(); textBoxConfirmPass.Show(); button5.Show(); } else { MessageBox.Show("wrong password"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void change_pass(object sender, EventArgs e) { databaseDataContext db = new databaseDataContext(); gurdian g = new gurdian(); try { g = db.gurdians.SingleOrDefault(x => x.id == gid); if (textBoxNewPass.Text == textBoxConfirmPass.Text) { g.password = textBoxConfirmPass.Text; //g.password. db.SubmitChanges(); MessageBox.Show("Password change successfully!"); } else { MessageBox.Show("Passwords didn't match"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }