public bool IsCheckExist(ForgotPassReset forgotPassResetModel) { try { int result = 0; using (var connection = this.GetConnection()) { string query; query = @"Select count(*) from " + dbUser + "application_user where username = '******' " + "and Employee_Id = '" + forgotPassResetModel.EmployeeId.Trim() + "' " + "and mobile_no = '" + forgotPassResetModel.MobileNo.Trim() + "' " + "and email_id= '" + forgotPassResetModel.OfficialEmail.Trim() + "'"; //var result = connection.QueryFirstOrDefault<dynamic>(query); result = connection.Query <int>(query).FirstOrDefault(); this.CloseConnection(connection); if (result > 0) { return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }
public object ResetPasswordForForgot([FromBody] ForgotPassReset model) { try { //var modelToChange = usersService.SingleOrDefault(model.Id, new ApplicationUser()); var modelToChange = usersService.SingleOrDefaultByCustomField(model.UserName, "username", new ApplicationUser()); modelToChange = generateSecuredCredentials(modelToChange); modelToChange.Pstatus = "N"; modelToChange = usersService.Update(modelToChange); Email objEmail = new Email(); objEmail.EMAIL = model.OfficialEmail; objEmail.TEMPLETE = "2"; //objEmail.DATA1 = "Password Reset"; objEmail.DATA1 = modelToChange.PlainPassword; //objEmail.DATA2 = "Your password for OKWallet Application User has been reset and password is " + modelToChange.PlainPassword; emailService.SendVeriCodeToEmail(objEmail); ApplicationUser prevModel = new ApplicationUser(); prevModel = modelToChange; prevModel.Pstatus = "L"; //Insert into audit trial audit and detail _auditTrailService.InsertUpdatedModelToAuditTrail(modelToChange, prevModel, model.UserName, 7, 4, "Application User", modelToChange.Username, "Password Reset Successfully!"); return(modelToChange); } catch (Exception ex) { return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString())); } }
public object SendVeriCodeToEmailAfterChecking([FromBody] ForgotPassReset forgotPassResetModel) { try { if (emailService.IsCheckExist(forgotPassResetModel)) { Email objEmail = new Email(); objEmail.EMAIL = forgotPassResetModel.OfficialEmail; objEmail.TEMPLETE = "1"; //objEmail.DATA1 = "Email Verification Code for OK Wallet Application User"; StringBuilderService stringBuilderService = new StringBuilderService(); int randromNumber = stringBuilderService.RandomNumber(1000, 9999); string md5Password = stringBuilderService.GenerateMD5Hash(randromNumber.ToString()); objEmail.DATA1 = randromNumber.ToString(); //objEmail.DATA2 = "Your email verification code for OK Wallet Application User is : " + randromNumber.ToString(); emailService.SendVeriCodeToEmail(objEmail); return(md5Password); } else { return(""); } } catch (Exception ex) { return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString())); } }
public bool IsCheckExist(ForgotPassReset forgotPassResetModel) { return(repo.IsCheckExist(forgotPassResetModel)); }