public string SaveUserPasswordConfirm(forgetPassword _UserPassConfirm)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[6];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_UserPassConfirm.EmailAddr) ? new SqlParameter("@EmailAddr", DBNull.Value) : new SqlParameter("@EmailAddr", _UserPassConfirm.EmailAddr);
Parameters[2] = String.IsNullOrEmpty(_UserPassConfirm.password) ? new SqlParameter("@Pw", DBNull.Value) : new SqlParameter("@Pw", _UserPassConfirm.password);
Parameters[3] = String.IsNullOrEmpty(_UserPassConfirm.secureCd) ? new SqlParameter("@SecureCd", DBNull.Value) : new SqlParameter("@SecureCd", _UserPassConfirm.secureCd);
Parameters[4] = String.IsNullOrEmpty(_UserPassConfirm.IpAddr) ? new SqlParameter("@IPAddr", DBNull.Value) : new SqlParameter("@IPAddr", _UserPassConfirm.IpAddr);
Parameters[5] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[5].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebUserAccessPwMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToString(Cmd.Parameters["@RETURN_VALUE"].Value);
return(Result);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task ForgetPassword_ShouldReturnSuccess_WhenPasswordValidforusername()
{
//Arrange
forgetPassword ObjforgetPassword = new forgetPassword();
ObjforgetPassword.LogID = "monica";
ObjforgetPassword.LogInDetail = "Username";
ObjforgetPassword.Password = "******";
ForgetPasswordResponse objRes = new ForgetPasswordResponse();
objRes.LogID = "monica";
objRes.ResponseMessage = "Password Changed Successfully";
string queryString = "";
queryString = "sp_LoginUpdate @LoginId,@LoginDetail,@Password,@MessageStatus Out";
_eventDBMock.Setup(x => x.ExecuteAsyncSql(It.IsAny <SqlParameter[]>(), queryString, 3)).ReturnsAsync("Password Changed Successfully");
//Act
var customer = await _eventBookingRepository.ForgetPasswordDB(ObjforgetPassword);
//Assert
Assert.Equal(objRes.ResponseMessage, customer);
}
/// <summary>
/// 重置密码
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool forgetPassword(forgetPassword request)
{
using (var db = DbFactory.Open())
{
var info = db.Single <UserInfo>(x => x.UserName == request.UserName);
if (info == null)
{
throw new Exception("用户不存在");
}
var success = db.UpdateOnly(new UserInfo {
PassWord = DESHelper.DESEncrypt(request.Password)
},
onlyFields: x => x.PassWord,
where : x => x.Id == info.Id) == 1;
if (success)
{
var logInfo = new LogInfo();
logInfo.UserName = request.UserName;
logInfo.tm = DateTime.Now;
logInfo.adcd = info.adcd;
var log = new operateLog();
log.operateMsg = "重置密码成功";
log.operateTime = DateTime.Now;
log.userName = request.UserName;
logInfo.Operation = JsonTools.ObjectToJson(log);
logInfo.RealName = info.RealName;
logInfo.OperationType = GrassrootsFloodCtrlEnums.OperationTypeEnums.更新;
db.Insert(logInfo);
}
return(success);
}
}
public async Task <OperationResponse <object> > forgotPassword(forgetPassword forgetPasswordObj)
{
OperationResponse <object> or = new OperationResponse <object>();
try
{
var apiKey = "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";
var client = new SendGridClient(apiKey);
var tempPass = GenerateRandomPassword();
var msg = new SendGridMessage()
{
From = new EmailAddress("*****@*****.**", "Gelany"),
Subject = "New Password",
// PlainTextContent = "Hello, Email!",
HtmlContent = "<strong> this is New password! </strong>" + "<h1>" + tempPass.ToString() + "</h1>"
};
msg.AddTo(new EmailAddress(forgetPasswordObj.Email, forgetPasswordObj.Email.Split('@')[0].ToString()));
or.HasErrors = false;
or.StatusCode = "200";
or.Data = "true";
var response = await client.SendEmailAsync(msg);
}
catch (Exception ex)
{
or.Message = ex.Message;
or.HasErrors = true;
}
return(or);
}
void Awake()
{
var AM = AssetDatabase.LoadAssetAtPath <GameObject> (AccountManagerPath);
Manager = AM.GetComponent <RegisterSystem> ();
ManagerForget = AM.GetComponent <forgetPassword> ();
ManagerLogin = AM.GetComponent <LoginSystem> ();
ManagerReset = AM.GetComponent <ResetPassword> ();
ManagerActive = AM.GetComponent <ActiveAccount> ();
}
public async Task <string> ForgetPasswordDB(forgetPassword ObjforgetPassword)
{
string ResponseMessage = "";
try
{
var param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@LoginId",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 200,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjforgetPassword.LogID)?String.Empty:ObjforgetPassword.LogID
},
new SqlParameter()
{
ParameterName = "@LoginDetail",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 200,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjforgetPassword.LogInDetail)?String.Empty:ObjforgetPassword.LogInDetail.ToUpper()
},
new SqlParameter()
{
ParameterName = "@Password",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjforgetPassword.Password)?String.Empty:ObjforgetPassword.Password
},
new SqlParameter()
{
ParameterName = "@MessageStatus",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Output
}
};
string queryString = "";
queryString = "sp_LoginUpdate @LoginId,@LoginDetail,@Password,@MessageStatus Out";
ResponseMessage = await _IDBLayercs.ExecuteAsyncSql(param, queryString, 3);
//var _Context = new AuthenticationContext();
//int affectedRows = await _Context.Database.ExecuteSqlRawAsync("sp_LoginUpdate @LoginId,@LoginDetail,@Password,@MessageStatus Out", param);
//ResponseMessage = Convert.ToString(param[3].Value);
}
catch (Exception ex)
{
ResponseMessage = ex.Message.ToString();
}
return(ResponseMessage);
}
public async Task ForgetPassword_ShouldReturnSuccess_WhenPasswordValidforusername()
{
//Arrange
forgetPassword ObjforgetPassword = new forgetPassword();
ObjforgetPassword.LogID = "monica";
ObjforgetPassword.LogInDetail = "Username";
ObjforgetPassword.Password = "******";
ForgetPasswordResponse objRes = new ForgetPasswordResponse();
objRes.LogID = "monica";
objRes.ResponseMessage = "Password Changed Successfully";
_eventBookingService.Setup(x => x.ForgetPassword(ObjforgetPassword)).ReturnsAsync(objRes);
//Act
var customer = await _EventBookingController.ForgetPassword(ObjforgetPassword);
//Assert
Assert.NotNull(customer);
}
public async Task <ForgetPasswordResponse> ForgetPassword(forgetPassword ObjforgetPassword)
{
ForgetPasswordResponse objForgetPasswordResponse = new ForgetPasswordResponse();
if (string.IsNullOrEmpty(ObjforgetPassword.LogInDetail))
{
objForgetPasswordResponse.ResponseMessage = "Please Select whether the Login ID is UserName/Email ID/ Phone Num";
objForgetPasswordResponse.LogID = ObjforgetPassword.LogID;
return(objForgetPasswordResponse);
}
if (string.IsNullOrEmpty(ObjforgetPassword.LogID))
{
objForgetPasswordResponse.ResponseMessage = "Please enter UserName/Email ID/ Phone Num";
objForgetPasswordResponse.LogID = ObjforgetPassword.LogID;
return(objForgetPasswordResponse);
}
if (string.IsNullOrEmpty(ObjforgetPassword.Password))
{
objForgetPasswordResponse.ResponseMessage = "Please enter Password";
objForgetPasswordResponse.LogID = ObjforgetPassword.LogID;
return(objForgetPasswordResponse);
}
if (ObjforgetPassword.LogInDetail.ToUpper() != "EMAIL" && ObjforgetPassword.LogInDetail.ToUpper() != "USERNAME" && ObjforgetPassword.LogInDetail.ToUpper() != "PHONENUM")
{
objForgetPasswordResponse.ResponseMessage = "Login Method is invalid, Please Try again!!!";
objForgetPasswordResponse.LogID = ObjforgetPassword.LogID;
return(objForgetPasswordResponse);
}
string ResponseMessage = await _eventBookingRepository.ForgetPasswordDB(ObjforgetPassword);
objForgetPasswordResponse.ResponseMessage = ResponseMessage;
objForgetPasswordResponse.LogID = ObjforgetPassword.LogID;
return(objForgetPasswordResponse);
}
public async Task ForgetPassword_ShouldReturnInvalidMessage_IFPasswordnotentered()
{
//Arrange
forgetPassword Obj = new forgetPassword();
Obj.LogID = "monica";
Obj.LogInDetail = "username";
Obj.Password = "";
ForgetPasswordResponse objRes = new ForgetPasswordResponse();
objRes.LogID = "monica";
objRes.ResponseMessage = "Please enter Password";
//_eventRepoMock.Setup(x => x.LogInDB(Obj)).ReturnsAsync("Login Success");
//Act
var customer = await _EventBookingService.ForgetPassword(Obj);
//Assert
Assert.Equal(objRes.LogID, customer.LogID);
Assert.Equal(objRes.ResponseMessage, customer.ResponseMessage);
}
public async Task ForgetPassword_ShouldReturnInvalidMessage_IFLogINDetailnotvalid()
{
//Arrange
forgetPassword Obj = new forgetPassword();
Obj.LogID = "monica";
Obj.LogInDetail = "dfg";
Obj.Password = "******";
ForgetPasswordResponse objRes = new ForgetPasswordResponse();
objRes.LogID = "monica";
objRes.ResponseMessage = "Login Method is invalid, Please Try again!!!";
//_eventRepoMock.Setup(x => x.LogInDB(Obj)).ReturnsAsync("Login Success");
//Act
var customer = await _EventBookingService.ForgetPassword(Obj);
//Assert
Assert.Equal(objRes.LogID, customer.LogID);
Assert.Equal(objRes.ResponseMessage, customer.ResponseMessage);
}
public async Task ForgetPassword_ShouldReturnInvalidMessage_IFLogINDetailnotpresent()
{
//Arrange
forgetPassword Obj = new forgetPassword();
Obj.LogID = "monica";
Obj.LogInDetail = "";
Obj.Password = "******";
ForgetPasswordResponse objRes = new ForgetPasswordResponse();
objRes.LogID = "monica";
objRes.ResponseMessage = "Please Select whether the Login ID is UserName/Email ID/ Phone Num";
//_eventRepoMock.Setup(x => x.LogInDB(Obj)).ReturnsAsync("Login Success");
//Act
var customer = await _EventBookingService.ForgetPassword(Obj);
//Assert
Assert.Equal(objRes.LogID, customer.LogID);
Assert.Equal(objRes.ResponseMessage, customer.ResponseMessage);
}
public async Task ForgetPassword_ShouldReturnSuccess_WhenPasswordInValidforusername()
{
//Arrange
forgetPassword Obj = new forgetPassword();
Obj.LogID = "monic";
Obj.LogInDetail = "Username";
Obj.Password = "******";
ForgetPasswordResponse objRes = new ForgetPasswordResponse();
objRes.LogID = "monic";
objRes.ResponseMessage = "Invalid UserName";
_eventRepoMock.Setup(x => x.ForgetPasswordDB(Obj)).ReturnsAsync("Invalid UserName");
//Act
var customer = await _EventBookingService.ForgetPassword(Obj);
//Assert
Assert.Equal(objRes.LogID, customer.LogID);
Assert.Equal(objRes.ResponseMessage, customer.ResponseMessage);
}
void OnGUI()
{
if (_window != null)
{
GUI.contentColor = Color.red; // Apply Red color to Button
GUILayout.Label("PHP Source Folder & Secure Key", EditorStyles.boldLabel);
URL = EditorGUILayout.TextField("Folder URL", URL);
Key = EditorGUILayout.TextField("Secure Key", Key);
GUILayout.Label("First Step : Before Login", EditorStyles.boldLabel);
GUILayout.Label(MSG);
AccountManager = (GameObject)EditorGUILayout.ObjectField("Account Manager:", AccountManager, typeof(GameObject), true);
if (GUILayout.Button("Configure ! STEP 1") && AccountManager != null)
{
LoginManager = AccountManager.GetComponent <LoginSystem> ();
RegisterManager = AccountManager.GetComponent <RegisterSystem> ();
ForgetManager = AccountManager.GetComponent <forgetPassword> ();
ResetManager = AccountManager.GetComponent <ResetPassword> ();
ActiveManager = AccountManager.GetComponent <ActiveAccount> ();
// AccountM = Manager.GetComponent<AccountSystem>();
PlayerPrefs.SetString("registerURL", URL + "/register.php");
PlayerPrefs.SetString("LoginUrl", URL + "/login.php");
ManagerLogin.LoginUrl = URL + "/login.php";
LoginManager.LoginUrl = URL + "/login.php";
ManagerLogin.SecureKey = Key;
ManagerLogin.checkBannedUrl = URL + "/checkbanned.php";
ManagerLogin.checkBannedUrl = URL + "/checkbanned.php";
Manager.securePassword = Key;
Manager.checkBannedUrl = URL + "/checkbanned.php";
Manager.RegisterUrl = URL + "/register.php";
RegisterManager.checkBannedUrl = URL + "/checkbanned.php";
ManagerForget.UrlSendCode = URL + "/sendcode.php";
ForgetManager.UrlSendCode = URL + "/sendcode.php";
ManagerForget.securePassword = Key;
ManagerReset.ResetUrl = URL + "/resetpassword.php";
ResetManager.ResetUrl = URL + "/resetpassword.php";
ManagerReset.securePassword = Key;
ManagerActive.activeURL = URL + "/activeaccount.php";
ManagerActive.resendURL = URL + "/resendactive.php";
ManagerActive.securePassword = Key;
ActiveManager.activeURL = URL + "/activeaccount.php";
ActiveManager.resendURL = URL + "/resendactive.php";
PlayerPrefs.SetString("UrlSendCode", URL + "/sendcode.php");
PlayerPrefs.SetString("ResetUrl", URL + "/resetpassword.php");
PlayerPrefs.SetString("UpdateURL", URL + "/update.php");
PlayerPrefs.SetString("RefreshURL", URL + "/refresh.php");
PlayerPrefs.SetString("ActiveAccountURL", URL + "/activeaccount.php");
PlayerPrefs.SetString("CheckBanned", URL + "/checkbanned.php");
PlayerPrefs.SetString("ResendActive", URL + "/resendactive.php");
_window.Close();
success_window = (gaseditor)EditorWindow.GetWindow(typeof(gaseditor), true, "Done !");
//Manager.registerURL = "ololo";
//Manager.oo = ":";
EditorUtility.SetDirty(AccountManager);
AssetDatabase.Refresh();
}
GUILayout.Label("Second Step: After Login", EditorStyles.boldLabel);
GUILayout.Label(MSG2);
MAS = (GameObject)EditorGUILayout.ObjectField("Manager GameObject:", MAS, typeof(GameObject), true);
if (GUILayout.Button("Configure ! STEP 2") && MAS != null)
{
AccountM = MAS.GetComponent <AccountSystem>();
AccountM.UpdateURL = URL + "/update.php";
AccountM.RefreshURL = URL + "/refresh.php";
AccountM.securePassword = Key;
//ManagerLogin.LoginUrl = URL + "/login.php";
// ManagerLogin.checkBannedUrl = URL + "/checkbanned.php";
//Manager.registerURL = URL + "/register.php";
//Manager.checkBannedUrl = URL + "/checkbanned.php";
// ManagerForget.UrlSendCode = URL + "/sendcode.php";
// ManagerReset.ResetUrl = URL + "/resetpassword.php";
// ManagerActive.activeURL = URL + "/activeaccount.php";
// ManagerActive.resendURL = URL + "/resendactive.php";
PlayerPrefs.SetString("UpdateURL", URL + "/update.php");
PlayerPrefs.SetString("RefreshURL", URL + "/refresh.php");
_window.Close();
success_window2 = (gaseditor)EditorWindow.GetWindow(typeof(gaseditor), true, "Done !");
//Manager.registerURL = "ololo";
//Manager.oo = ":";
EditorUtility.SetDirty(MAS);
AssetDatabase.Refresh();
}
if (AccountManager == null)
{
//GUI.contentColor = Color.red;
MSG = "Please Attach Account Manager !";
}
else
{
MSG = "Good !";
}
if (MAS == null)
{
GUI.contentColor = Color.red;
MSG2 = "Please Attach Manager !";
}
else
{
MSG2 = "Good !";
}
}
if (success_window != null)
{
GUILayout.Label("We Got These :", EditorStyles.boldLabel);
GUILayout.Label("Register URL : " + PlayerPrefs.GetString("registerURL"));
GUILayout.Label("Login URL : " + PlayerPrefs.GetString("LoginUrl"));
GUILayout.Label("Send URL : " + PlayerPrefs.GetString("UrlSendCode"));
GUILayout.Label("Reset URL : " + PlayerPrefs.GetString("ResetUrl"));
GUILayout.Label("Active Account URL : " + PlayerPrefs.GetString("ActiveAccountURL"));
GUILayout.Label("Check Banned URL : " + PlayerPrefs.GetString("CheckBanned"));
GUILayout.Label("Resend Active URL : " + PlayerPrefs.GetString("ResendActive"));
if (GUILayout.Button("Seems Good !"))
{
success_window.Close();
}
if (GUILayout.Button("Nope ! , Re-Setup"))
{
success_window.Close();
_window = (gaseditor)EditorWindow.GetWindow(typeof(gaseditor), true, "GAS Database Setup");
}
}
if (success_window2 != null)
{
GUILayout.Label("We Got These :", EditorStyles.boldLabel);
GUILayout.Label("Update URL : " + PlayerPrefs.GetString("UpdateURL"));
GUILayout.Label("Refresh URL : " + PlayerPrefs.GetString("RefreshURL"));
if (GUILayout.Button("Seems Good !"))
{
success_window2.Close();
}
if (GUILayout.Button("Nope ! , Re-Setup"))
{
success_window2.Close();
_window = (gaseditor)EditorWindow.GetWindow(typeof(gaseditor), true, "GAS Database Setup");
}
}
}
public async Task <IActionResult> ForgetPassword(forgetPassword ObjforgetPassword)
{
var bookEntities = await _eventBookingService.ForgetPassword(ObjforgetPassword);
return(Ok(bookEntities));
}
public async Task <IActionResult> forgotPassword([FromBody] forgetPassword Email)
{
var result = await _accountService.forgotPassword(Email);
return(resultWithStatus(result));
}
/// <summary>
/// 重置密码
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool Post(forgetPassword request)
{
return(SysManager.forgetPassword(request));
}
