private void btnLogIn_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(this.txtUserName.Text)) { UserNameErrorProvider.SetError(txtUserName, "Username empty!"); txtUserName.Focus(); } else if (string.IsNullOrWhiteSpace(this.txtPassword.Text)) { PasswordErrorProvider.SetError(txtPassword, "Password empty!"); txtPassword.Focus(); } else { UserNameErrorProvider.Clear(); PasswordErrorProvider.Clear(); try { clsUtility.ExecuteSQLQuery(" SELECT * FROM Users WHERE UserName = '******' AND Password = '******' "); if (clsUtility.sqlDT.Rows.Count > 0) { clsUtility.UserID = clsUtility.sqlDT.Rows[0]["USER_ID"].ToString(); clsUtility.UserName = clsUtility.sqlDT.Rows[0]["UserName"].ToString(); clsUtility.UsersPrivilege = clsUtility.sqlDT.Rows[0]["Privilege"].ToString(); if (chkRememberMe.Checked) { Properties.Settings.Default.App_UserName = txtUserName.Text; Properties.Settings.Default.App_UserPassword = txtPassword.Text; } else { Properties.Settings.Default.App_UserName = null; Properties.Settings.Default.App_UserPassword = null; } Properties.Settings.Default.App_UserRemember = chkRememberMe.Checked; Properties.Settings.Default.Save(); frmMDIParent frmMDIParent = new frmMDIParent(); frmMDIParent.Show(); this.Hide(); } else { lblWaring.Visible = true; lblWaring.Text = "No such user."; } } catch (Exception) { lblWaring.Visible = true; lblWaring.Text = "Error executing sql statement."; } } }
private void ChangePasswordButton_Click(object sender, EventArgs e) { User user = new User() { UserName = UserNameTextBox.Text.Trim(), Password = OriginalPasswordTextBox.Text.Trim() }; Response response = new Response(); if (string.IsNullOrEmpty(UserNameTextBox.Text.Trim())) { UserNameTextBox.Focus(); UserNameErrorProvider.SetError(UserNameTextBox, "UserName can't be vacant!"); } else { UserNameErrorProvider.SetError(UserNameTextBox, ""); if (string.IsNullOrEmpty(OriginalPasswordTextBox.Text.Trim())) { OriginalPasswordTextBox.Focus(); OriginalPasswordErrorProvider.SetError(OriginalPasswordTextBox, "OriginalPassword can't be vacant!"); } else { OriginalPasswordErrorProvider.SetError(OriginalPasswordTextBox, ""); if (string.IsNullOrEmpty(NewPasswordTextBox.Text.Trim())) { NewPasswordTextBox.Focus(); NewPasswordErrorProvider.SetError(NewPasswordTextBox, "NewPassword can't be vacant!"); } else { NewPasswordErrorProvider.SetError(NewPasswordTextBox, ""); if (string.IsNullOrEmpty(ConfirmPasswordTextBox.Text.Trim())) { ConfirmPasswordTextBox.Focus(); ConfirmPasswordErrorProvider.SetError(ConfirmPasswordTextBox, "ConfirmPassword can't be vacant!"); } else { try { response = new UserService().Authentication(user); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (string.IsNullOrEmpty(response.Message)) { if (NewPasswordTextBox.Text.Trim() != OriginalPasswordTextBox.Text.Trim()) { if (ConfirmPasswordTextBox.Text.Trim() == NewPasswordTextBox.Text.Trim()) { try { user.UserId = new UserService().GetUserIdByUserName(user.UserName); user.Password = ConfirmPasswordTextBox.Text.Trim(); response = new UserService().ChangePassword(user); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (response.IsFailed) { MessageBox.Show("Changing password fails", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); UserNameTextBox.Focus(); UserNameTextBox.Text = string.Empty; OriginalPasswordTextBox.Text = string.Empty; NewPasswordTextBox.Text = string.Empty; ConfirmPasswordTextBox.Text = string.Empty; } else { MessageBox.Show("Changing password succeeds", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { MessageBox.Show("Please repeat new password again.", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); NewPasswordTextBox.Text = string.Empty; ConfirmPasswordTextBox.Text = string.Empty; } } else { MessageBox.Show("New password and current password are same.", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); NewPasswordTextBox.Text = string.Empty; ConfirmPasswordTextBox.Text = string.Empty; } } else { MessageBox.Show(response.Message, "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); UserNameTextBox.Focus(); UserNameTextBox.Text = string.Empty; OriginalPasswordTextBox.Text = string.Empty; NewPasswordTextBox.Text = string.Empty; ConfirmPasswordTextBox.Text = string.Empty; } } } } } }
/// <summary> /// Excute user login validation /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LoginButton_Click(object sender, EventArgs e) { User user = new User() { UserName = UserNameTextBox.Text.Trim(), Password = PasswordTextBox.Text.Trim() }; Response response = new Response(); if (string.IsNullOrEmpty(UserNameTextBox.Text.Trim())) { UserNameTextBox.Focus(); UserNameErrorProvider.SetError(UserNameTextBox, "UserName can't be vacant!"); } else { UserNameErrorProvider.SetError(UserNameTextBox, ""); if (string.IsNullOrEmpty(PasswordTextBox.Text.Trim())) { PasswordTextBox.Focus(); PasswordErrorProvider.SetError(PasswordTextBox, "Password can't be vacant!"); } else { PasswordErrorProvider.SetError(PasswordTextBox, ""); if (string.IsNullOrEmpty(IdentifyingCodeTextBox.Text.Trim())) { IdentifyingCodeTextBox.Focus(); IdentifyingCodeErrorProvider.SetError(IdentifyingCodeTextBox, "IdentifyingCode can't be vacant!"); } else { try { response = new UserService().Authentication(user); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (string.IsNullOrEmpty(response.Message)) { if (IdentifyingCodeTextBox.Text.Trim() == identifyingCode || IdentifyingCodeTextBox.Text.Trim().ToLowerInvariant() == identifyingCode.ToLowerInvariant() || IdentifyingCodeTextBox.Text.Trim().ToUpperInvariant() == identifyingCode.ToUpperInvariant()) { Form f = Application.OpenForms["StaffList"]; if (f == null) { f = new StaffList(); f.Show(); this.Hide(); } else { f.Show(); this.Hide(); } } else { MessageBox.Show("Identifying code do not match!", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show(response.Message, "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearInformation(); Bind(); } } } } }