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);
txtUserName.Text = "";
txtNewPassword.Text = "";
txtOldPassword.Text = "";
txtConfirmPassword.Text = "";
frmLogin LoginForm1 = new frmLogin();
this.Dispose();
LoginForm1.ShowDialog();
LoginForm1.txt1UserName.Text = "";
LoginForm1.txt1Password.Text = "";
LoginForm1.ProgressBar1.Visible = false;
LoginForm1.txt1UserName.Focus();
this.Visible = true;
}
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);
}
}
private void userButton_Click(object sender, EventArgs e)
{
if (userNameTextBox.Text == "")
{
MessageBox.Show("Please enter user name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
userNameTextBox.Focus();
return;
}
if (passwordTextBox.Text == "")
{
MessageBox.Show("Please Type Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
passwordTextBox.Focus();
return;
}
if (nameTextBox.Text == "")
{
MessageBox.Show("Please Type your Full Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
nameTextBox.Focus();
return;
}
if (designationTextBox.Text == "")
{
MessageBox.Show("Please Type your designation", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
designationTextBox.Focus();
return;
}
if (departmentTextBox.Text == "")
{
MessageBox.Show("Please Type your Department", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
departmentTextBox.Focus();
return;
}
int us = 0;
UserManager aManager = new UserManager();
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "Select Username from Registration where Username='******'";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("This User Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Reset();
userNameTextBox.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
User nUser = new User
{
UserName = userNameTextBox.Text,
Password = passwordTextBox.Text,
UserType = txtUserComboBox.Text,
Name = nameTextBox.Text,
Email = emailTextBox.Text,
Designation = designationTextBox.Text,
Department = departmentTextBox.Text,
ContactNo = contactNoTextBox.Text
};
us = aManager.SaveUser(nUser);
MessageBox.Show("Successfully User Created.", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
userButton.Enabled = false;
Reset();
frmLogin lg = new frmLogin();
this.Visible = false;
lg.ShowDialog();
this.Visible = true;
}
catch (FormatException formatException)
{
MessageBox.Show("Please Enter Input in Correct Format", formatException.Message);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}