private void Resetbtn_Click(object sender, EventArgs e)
{
DialogResult PasswordRest = MessageBox.Show("Are You Sure You Wish To Reset Your Password?", "Rest Password", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (PasswordRest == DialogResult.Yes)
{
MySqlConnection con = new MySqlConnection();
con.ConnectionString = LoginForm.constring;
MySqlDataAdapter dataadapter = new MySqlDataAdapter();
DataSet dataset = new DataSet();
con.Open();
MySqlCommand command = con.CreateCommand();
command.CommandText = "SELECT * FROM staff WHERE staff_username='******';";
dataadapter.SelectCommand = command;
dataadapter.Fill(dataset, "staff");
if (dataset.Tables["staff"].Rows.Count == 0)
{
MessageBox.Show("Inncorrect Email Address.");
}
else
{
DataRow dr = dataset.Tables["staff"].Rows[0];
if (Answer1txt.Text != dr[7].ToString())
{
MessageBox.Show("Mother's Maiden Name Is Incorrect.");
}
else if (Answer2txt.Text != dr[8].ToString())
{
MessageBox.Show("Favourite Instrument Is Incorrect.");
}
else
{
command.CommandText = "UPDATE staff SET staff_password='******' WHERE staff_username='******'";
command.ExecuteNonQuery();
con.Close();
MessageBox.Show("Your Password Has Been Reset To The Default Password Which Is 'password'.");
LoginForm loginform = new LoginForm();
loginform.Show();
this.Dispose(true);
}
}
}
}
private void Logoutbtn_Click(object sender, EventArgs e)
{
LoginForm Login = new LoginForm();
Login.Show();
this.Dispose(true);
}
private void Cancelbtn_Click(object sender, EventArgs e)
{
LoginForm LoginForm = new LoginForm();
LoginForm.Show();
this.Dispose(true);
}