private void Previous_button_Click(object sender, EventArgs e)
{
Donar_Profile dp = new Donar_Profile();
this.Hide();
dp.Show();
}
private void Donar_login_button_Click(object sender, EventArgs e)
{
string useremail = User_email_textbox.Text;
string userpassword = User_password_textBox.Text;
if (useremail.Equals(""))
{
MessageBox.Show("please enter your Email.");
}
else if (userpassword.Equals(""))
{
MessageBox.Show("please enter your Password.");
}
else
{
string query = "select * from Donars where Email = '" + useremail + "' AND Password = '******'";
objDBAccess.readDatathroughAdapter(query, dtUsers);
if (dtUsers.Rows.Count == 1)
{
id = dtUsers.Rows[0]["ID"].ToString();
name = dtUsers.Rows[0]["Name"].ToString();
email = dtUsers.Rows[0]["Email"].ToString();
password = dtUsers.Rows[0]["Password"].ToString();
phn_num = dtUsers.Rows[0]["Phone_number"].ToString();
dob = dtUsers.Rows[0]["Date_of_Birthday"].ToString();
age = dtUsers.Rows[0]["Age"].ToString();
occupation = dtUsers.Rows[0]["Occupation"].ToString();
gender = dtUsers.Rows[0]["Gender"].ToString();
address = dtUsers.Rows[0]["Address"].ToString();
fake_name = dtUsers.Rows[0]["Fake_name"].ToString();
current_balance = dtUsers.Rows[0]["Current_Balance"].ToString();
total_donated_amount = dtUsers.Rows[0]["Total_donated_amount"].ToString();
//MessageBox.Show("login Successfully");
objDBAccess.closeConn();
Donar_Profile hf = new Donar_Profile();
this.Hide();
hf.Show();
}
else
{
query = "select * from Receivers where Email = '" + useremail + "' AND Password = '******'";
objDBAccess.readDatathroughAdapter(query, dtUsers);
if (dtUsers.Rows.Count == 1)
{
id = dtUsers.Rows[0]["ID"].ToString();
name = dtUsers.Rows[0]["Name"].ToString();
email = dtUsers.Rows[0]["Email"].ToString();
password = dtUsers.Rows[0]["Password"].ToString();
phn_num = dtUsers.Rows[0]["Phone_number"].ToString();
dob = dtUsers.Rows[0]["Date_of_Birth"].ToString();
age = dtUsers.Rows[0]["Age"].ToString();
occupation = dtUsers.Rows[0]["Occupation"].ToString();
gender = dtUsers.Rows[0]["Gender"].ToString();
present_address = dtUsers.Rows[0]["Present_address"].ToString();
permanent_address = dtUsers.Rows[0]["Permanent_address"].ToString();
nid = dtUsers.Rows[0]["NID"].ToString();
marital_status = dtUsers.Rows[0]["Marital_status"].ToString();
religion = dtUsers.Rows[0]["Religion"].ToString();
reference_person_name = dtUsers.Rows[0]["Reference_person_name"].ToString();
reference_person_phn_number = dtUsers.Rows[0]["Reference_person_phone_number"].ToString();
organization_type = dtUsers.Rows[0]["Organization_type"].ToString();
//MessageBox.Show("login Successfully");
objDBAccess.closeConn();
Receiver_Profile_form rpf = new Receiver_Profile_form();
this.Hide();
rpf.Show();
}
else
{
MessageBox.Show("Invalid information. Provide correct email and password");
}
}
}
}
