private void button1_Click(object sender, EventArgs e)
{
string myConnection = "datasource= localhost; port = 3306; username = root; password = animesh1!";
string q1 = "select * from userreg.registration where username = '******' and password= '******'; ";
string q2 = "select usertype from userreg.registration where username ='******' and password= '******'; ";
string q3 = "select idregistration from userreg.registration where username = '******' and password = '******'; ";
MySqlDataReader myReader;
using (MySqlConnection myConn = new MySqlConnection(myConnection))
{
myConn.Open();
using (MySqlCommand command1 = new MySqlCommand(q1, myConn))
{
try
{
myReader = command1.ExecuteReader();
int count = 0;
while (myReader.Read())
{
count = count + 1;
}
if (count == 1)
{
MessageBox.Show("Username and Password is correct");
}
else if (count > 1)
{
MessageBox.Show("Duplicate...Access Denied");
}
else
{
//string msg = count.ToString();
MessageBox.Show("Incorrect Username and Password");
}
myReader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
using (MySqlCommand command3 = new MySqlCommand(q3, myConn))
{
try
{
}
catch (Exception ex2)
{
MessageBox.Show(ex2.Message);
}
}
using (MySqlCommand command2 = new MySqlCommand(q2, myConn))
{
try
{
string x = Convert.ToString(command2.ExecuteScalar());
if (x == "Customer")
{
this.Hide();
customer f = new customer();
f.ShowDialog();
}
else if (x == "Hotel Staff")
{
this.Hide();
hotelstaff f = new hotelstaff();
f.ShowDialog();
}
else if (x == "Admin")
{
this.Hide();
admin f = new admin();
f.ShowDialog();
}
}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message);
}
}
}
}