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