private void button1_Click(object sender, EventArgs e)
{
//log out button acion event
DoctorsForm df = new DoctorsForm();
this.Hide();
df.ShowDialog();
}
private void button1_Click_1(object sender, EventArgs e)
{
// new evene of login button
if (cartagory == "Admin")
{
try
{
//MessageBox.Show("Executing Admin Login code");
String driver = "datasource=localhost;port=3306;username=root;password=root";
MySqlConnection con = new MySqlConnection(driver);
MySqlCommand cmd = new MySqlCommand("select * from hospital.admintable where AdminLoginId='" + this.txt_name.Text + "' and AdminPassword='******' ;", con);
MySqlDataReader reader;
con.Open();
reader = cmd.ExecuteReader();
int c = 0;
while (reader.Read())
{
c++;
}
con.Close();
if (c == 1)
{
//successfully authenicated now transfer to corresponding frame
AdminForm af = new AdminForm();
this.Hide();
af.ShowDialog();
}
else
{
MessageBox.Show("Mismatch in Id and password");
}
}
catch (Exception ex)
{
MessageBox.Show("Error in database connection" + ex.ToString());
}
}
else if (cartagory == "Doctor")
{
try
{
MessageBox.Show("Executing Doctor code");
String driver = "datasource=localhost;port=3306;username=root;password=root";
MySqlConnection con = new MySqlConnection(driver);
MySqlCommand cmd = new MySqlCommand("select * from hospital.doctortable where DoctorId='" + this.txt_name.Text + "' and Password='******'", con);
MySqlDataReader reader;
con.Open();
reader = cmd.ExecuteReader();
int c = 0;
while (reader.Read()) c++;
con.Close();
if (c == 1)
{
//successfully authenicated now transfer to corresponding frame
DoctorsForm df = new DoctorsForm();
this.Hide();
df.ShowDialog();
}
else
{
MessageBox.Show("Mismatch in Id and password");
}
}
catch (Exception eex)
{
MessageBox.Show("Error in database connection" + eex.ToString());
}
}
else
{
MessageBox.Show("Choose a cartagory");
}