private void Button1_Click(object sender, EventArgs e)
{
try
{
int RowsAffected = 0;
if ((txtUserName.Text.Trim().Length == 0))
{
MessageBox.Show("Please enter user name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserName.Focus();
return;
}
if ((txtOldPassword.Text.Trim().Length == 0))
{
MessageBox.Show("Please enter old password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtOldPassword.Focus();
return;
}
if ((txtNewPassword.Text.Trim().Length == 0))
{
MessageBox.Show("Please enter new password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNewPassword.Focus();
return;
}
if ((txtConfirmPassword.Text.Trim().Length == 0))
{
MessageBox.Show("Please confirm new password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtConfirmPassword.Focus();
return;
}
if ((txtNewPassword.TextLength < 5))
{
MessageBox.Show("The New Password Should be of Atleast 5 Characters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNewPassword.Text = "";
txtConfirmPassword.Text = "";
txtNewPassword.Focus();
return;
}
else if ((txtNewPassword.Text != txtConfirmPassword.Text))
{
MessageBox.Show("Password do not match", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNewPassword.Text = "";
txtOldPassword.Text = "";
txtConfirmPassword.Text = "";
txtOldPassword.Focus();
return;
}
else if ((txtOldPassword.Text == txtNewPassword.Text))
{
MessageBox.Show("Password is same..Re-enter new password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNewPassword.Text = "";
txtConfirmPassword.Text = "";
txtNewPassword.Focus();
return;
}
con = new SqlConnection(cs.DBConn);
con.Open();
string co = "Update Registration set Password = '******'where UserName='******' and Password = '******'";
cmd = new SqlCommand(co);
cmd.Connection = con;
RowsAffected = cmd.ExecuteNonQuery();
if ((RowsAffected > 0))
{
MessageBox.Show("Successfully changed", "Password", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
txtUserName.Text = "";
txtNewPassword.Text = "";
txtOldPassword.Text = "";
txtConfirmPassword.Text = "";
frmLogin LoginForm1 = new frmLogin();
LoginForm1.Show();
LoginForm1.txtUserName.Text = "";
LoginForm1.txtPassword.Text = "";
LoginForm1.ProgressBar1.Visible = false;
LoginForm1.txtUserName.Focus();
}
else
{
MessageBox.Show("invalid user name or password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserName.Text = "";
txtNewPassword.Text = "";
txtOldPassword.Text = "";
txtConfirmPassword.Text = "";
txtUserName.Focus();
}
if ((con.State == ConnectionState.Open))
{
con.Close();
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}