public void Login()
{
Int64 pp;
string pass;
pp = Convert.ToInt64(F.fursanpp.Text);
pass = F.fursanpass.Text;
MessageBox.Show(Convert.ToString(pp));
if (F.fursanpp.Text != "" && F.fursanpass.Text != "" && F.fursanpp.Text.Length == 7)
{
string query1 = "select ppnumber,pass from fursan where ppnumber = '" + pp + "' and pass = '******'";
SqlDataAdapter adapter = new SqlDataAdapter(query1, connec);
connec.Open();
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Log In successful", "Log IN", MessageBoxButtons.OK, MessageBoxIcon.Information);
Fursan f = new Fursan();
f.check = 1;
F.Hide();
}
else
{
MessageBox.Show("Incorrect Passport Number or password", "Log In", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Incorrect Passport Number or password", "Log In", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (F.fursanpp.Text.Length != 7)
{
MessageBox.Show("Please enter passport number of 7 digits", "Log In", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
connec.Close();
}
