private void metroButton1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtUsername.Text)) { MetroFramework.MetroMessageBox.Show(this, "Please enter your username.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUsername.Focus(); return; } try { using (CARRENTALEntities3 db = new CARRENTALEntities3()) { var query = from u in db.Users where u.UserName == txtUsername.Text && u.Password == txtPassword.Text select u; if (query.SingleOrDefault() != null) { txtUsername.Clear(); txtPassword.Clear(); this.Hide(); Dashboard dash = new Dashboard(); dash.ShowDialog(); } else { MetroFramework.MetroMessageBox.Show(this, "Your user name or password is incorrrect.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void metroButton1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(oldpassword.Text) || string.IsNullOrEmpty(newpassword.Text)) { newpassword.Focus(); oldpassword.Focus(); return; } SqlConnection con = new SqlConnection("Server=BLESSINGS-PC\\SQLEXPRESS;Database=CARRENTAL;Integrated Security=true"); try { DialogResult DR = MessageBox.Show("Are You Sure You want to change password ?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (DR == DialogResult.Yes) { try { using (CARRENTALEntities3 db = new CARRENTALEntities3()) { var query = from u in db.Users where u.UserName == "admin" && u.Password == oldpassword.Text select u; if (query.SingleOrDefault() != null) { con.Open(); SqlCommand command = new SqlCommand("sp_changepassword", con); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@UserName", SqlDbType.VarChar, 25).Value = "admin"; command.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = newpassword.Text; command.ExecuteNonQuery(); con.Close(); MessageBox.Show("Password changed"); oldpassword.Clear(); newpassword.Clear(); } else { MetroFramework.MetroMessageBox.Show(this, "Error Password not changed.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception) { MetroFramework.MetroMessageBox.Show(this, "Your user name or password is incorrrect.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }