private void button1_Click(object sender, EventArgs e)
{
username = textBox1.Text;
CONNECT conn = new CONNECT();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
String query = "SELECT * FROM `user` WHERE `username`=@usn AND `password`=@pass AND `role`=@role";
command.CommandText = query;
command.Connection = conn.getConnection();
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBox1.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBox2.Text;
try
{
command.Parameters.Add("@role", MySqlDbType.VarChar).Value = comboBox1.SelectedItem.ToString();
}
catch { }
adapter.SelectCommand = command;
adapter.Fill(table);
//if the username and the password exist or match
if (table.Rows.Count > 0)
{
MessageBox.Show("You are logged in as " + comboBox1.SelectedItem.ToString());
if (comboBox1.SelectedIndex == 0)
{
this.Hide();
Admin admin = new Admin();
admin.Show();
}
else if (comboBox1.SelectedIndex == 1)
{
this.Hide();
Staff staff = new Staff();
staff.Show();
}
else
{
this.Hide();
Trainer trainer = new Trainer();
trainer.Show();
}
}
else
{
if (textBox1.Text.Trim().Equals(""))
{
MessageBox.Show("Please enter Username!", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBox2.Text.Trim().Equals(""))
{
MessageBox.Show("Please enter Password!", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (comboBox1.SelectedItem == null)
{
MessageBox.Show("Please select a role to login", "Empty Role", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("No username or password matches for this role", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
username = textBox1.Text;
CONNECT conn = new CONNECT();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
String query = "SELECT * FROM `user` WHERE `username`=@usn AND `password`=@pass";
command.CommandText = query;
command.Connection = conn.getConnection();
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBox1.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBox2.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
//if the username and the password exist or match
if (table.Rows.Count > 0)
{
foreach (DataRow dr in table.Rows)
{
if (dr["role"].ToString() == "Admin")
{
MessageBox.Show("You are logged in as Admin");
this.Hide();
Admin adminPanel = new Admin();
adminPanel.Show();
}
else if (dr["role"].ToString() == "Staff")
{
MessageBox.Show("You are logged in as Staff");
this.Hide();
Staff staffPanel = new Staff();
staffPanel.Show();
}
else if (dr["role"].ToString() == "Trainer")
{
MessageBox.Show("You are logged in as Trainer");
this.Hide();
Trainer trainerPanel = new Trainer();
trainerPanel.Show();
}
else
{
MessageBox.Show("This username or password doesnt exists!", "Wrong username or password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/*
* MessageBox.Show("You are logged in as " + comboBox1.SelectedItem.ToString());
* if (comboBox1.SelectedIndex == 0)
* {
* this.Hide();
* Admin admin = new Admin();
* admin.Show();
* }
* else if (comboBox1.SelectedIndex == 1)
* {
* this.Hide();
* Staff staff = new Staff();
* staff.Show();
* }
* else
* {
* this.Hide();
* Trainer trainer = new Trainer();
* trainer.Show();
* }*/
else
{
if (textBox1.Text.Trim().Equals(""))
{
MessageBox.Show("Please enter Username!", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBox2.Text.Trim().Equals(""))
{
MessageBox.Show("Please enter Password!", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("This username or password doesnt exists!", "Wrong username or password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}