private void btnQuit_Click(object sender, EventArgs e)
{
FrmDashboard das = new FrmDashboard();
das.Visible = true;
this.Close();
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (txtEmailAdress.Text == "")
{
MessageBox.Show("Ensure all fields are filled", "MESS Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEmailAdress.Focus();
}
else if (txtPassword.Text == "")
{
MessageBox.Show("Ensure all fields are filled", "MESS Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassword.Focus();
}
else
{
try
{
conn connect = new conn();
string query = "SELECT * FROM officer WHERE Email_Address='" + txtEmailAdress.Text.ToString() + "' AND Passsword='" + txtPassword.Text.ToString() + "' AND Status=1";
//open connection
if (connect.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connect.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
if (dataReader.Read())
{
/*MessageBox.Show("Login successful");
* Dashboard das = new Dashboard();*/
FrmDashboard das = new FrmDashboard();
das.Visible = true;
this.Hide();
}
else
{
txtEmailAdress.Text = "";
txtPassword.Text = "";
txtEmailAdress.Focus();
MessageBox.Show("password/username mismatch!");
}
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
}
}