public void TestInitialize() { userService = new UserService(); SqlConnection connection = null; password = Md5Util.EncryptStringWithMD5("123"); try { string sqlCreateuser = "******" + password + "','male','2016-12-18 20:10:10.223','2016-12-18 20:10:10.223','2016-12-18 20:10:10.223',4,0,'1812312656','*****@*****.**'); select @@IDENTITY as 'id'"; Console.WriteLine(sqlCreateuser); connection = DBUtil.GetSqlConnection(); SqlCommand sqlCommand = connection.CreateCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = sqlCreateuser; SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { userId = (int)reader[0]; } } finally { DBUtil.ColseSqlConnection(connection); } }
private void DoLblSubmitOnClick(object sender, EventArgs e) { string password = this.txtPassword.Text.Trim(); string confirmPassword = this.txtPasswordConfirm.Text.Trim(); if (password.Length == 0 || confirmPassword.Length == 0) { showFlashMsg(Constants.TipInputPassword); return; } if (!password.Equals(confirmPassword)) { showFlashMsg(Constants.TipInputSamePassword); return; } new UserService.UserServiceClient().ModifyPassword(SessionUtil.User.Id, Md5Util.EncryptStringWithMD5(password)); this.pnlTipWindow.Visible = true; }
private void DoBtnLoginOnClick(object sender, EventArgs e) { bool isLegalData = ValidationLoginTxtBox(); if (isLegalData) { try { UserService.UserServiceClient userService = new UserService.UserServiceClient(); User user = userService.VerifyUserLogin(txtUserName.Text.Trim(), Md5Util.EncryptStringWithMD5(txtPassword.Text.Trim())); if (user != null) { SessionUtil.User = user; this.DialogResult = DialogResult.OK; } else { this.ShowTipMsg(Constants.PasswordIncorrect); } } catch (FaultException <DBException> faultDbException) { this.ShowTipMsg(faultDbException.Message); } catch (FaultException <ServiceException> faultServiceException) { this.ShowTipMsg(faultServiceException.Detail.getMsg()); } catch (CommunicationException communicationException) { this.ShowTipMsg(Constants.CannotConnServer); } catch (TimeoutException timeoutException) { this.ShowTipMsg(Constants.NetworkTimeout); } } }
private void DoBtnLoginOnClick(object sender, EventArgs e) { bool isLegalData = ValidationLoginTxtBox(); if (isLegalData) { UserService.UserServiceClient userService = new UserService.UserServiceClient(); try { bool result = userService.verifyUserLogin(txtUserName.Text.Trim(), Md5Util.EncryptStringWithMD5(txtPassword.Text.Trim())); if (result) { this.DialogResult = DialogResult.OK; } else { this.ShowTipMsg(Constants.PasswordIncorrect); } } catch (FaultException faultException) { this.ShowTipMsg(faultException.Message); Console.WriteLine(faultException.Message); } } }