/// <summary> /// Checking if super admin exist by email /// and password /// </summary> /// <param name="email"></param> /// <param name="isDelete"></param> /// <returns></returns> public FinocartMaster CheckSuperAdmin(string email, string password) { RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext); FinocartMaster finocartMaster = objFinocartMaster.SelectAll().Where(x => x.EmailId == email && x.Password == password).FirstOrDefault(); return(finocartMaster); }
/// <summary> /// Checking if super admin exist by email /// </summary> /// <param name="email"></param> /// <param name="isDelete"></param> /// <returns></returns> public FinocartMaster CheckSuperAdminByEmail(string email, bool isDelete) { RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext); FinocartMaster finocartMaster = objFinocartMaster.SelectAll().Where(x => x.EmailId == email && x.IsDelete == isDelete).FirstOrDefault(); return(finocartMaster); }
/// <summary> /// Validate login /// </summary> /// <param name="EmailId"></param> /// <param name="Password"></param> /// <returns></returns> public FinocartMaster ValidateLogin(string EmailId, string Password) { RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext); ICollection <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(SQLHelper.SqlInputParam("@EmailId", EmailId, System.Data.SqlDbType.VarChar)); parameters.Add(SQLHelper.SqlInputParam("@Password", Password, System.Data.SqlDbType.VarChar)); var data = objFinocartMaster.ExecWithStoreProcedure("proc_CheckSuperAdminLogin @EmailId, @Password", parameters.ToArray()); FinocartMaster SuperAdmin = data.SingleOrDefault(); return(SuperAdmin); }
public ActionResult SendForgetPasswordMail(ForgetPasswordModel objForgetPassword) { string ActionName = this.ControllerContext.RouteData.Values["action"].ToString(); string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); Int32? UserID = HttpContext.Session.GetInt32("UserID"); string ErrorMessage = string.Empty; var RoleName = ""; FinocartMaster objDatawithSP1 = null; Company objDatawithSP2 = null; User objDatawithSP3 = null; IEnumerable <User> objDatawithSP = _CommonRepository.CheckUserPassword(); IEnumerable <User> objDatawithSP4 = _CommonRepository.CheckUserPassword(); try { var Name = ""; string ID = ""; string randomPassword = _CommonRepository.GeneratePassword(); // string EncryptToken = SecurityHelperService.Encrypt(Token); string EmailID = objForgetPassword.EmailID.Trim(); var data = Encoding.UTF8.GetBytes(objForgetPassword.RoleName); RoleName = Convert.ToBase64String(data); if (objForgetPassword.RoleName == "MasterAdmin") { //IEnumerable<Company> objDatawithSP = _CommonRepository.CheckAdminPassword(); //objDatawithSP = objDatawithSP.Where(x => x.Contact_email == EmailID && x.IsDelete == false); objDatawithSP2 = _CommonRepository.CheckAdminByEmailExists(EmailID); if (objDatawithSP2 != null && (!objDatawithSP2.IsDelete || objDatawithSP2.LoginAttempt == 3)) { Name = objDatawithSP2.Company_name; ID = Convert.ToString(objDatawithSP2.CompanyID); } } if (objForgetPassword.RoleName == "InternalUser") { //IEnumerable<User> objDatawithSP = _CommonRepository.CheckUserPassword(); //objDatawithSP = objDatawithSP.Where(x => x.Email == EmailID && x.IsDelete == true); objDatawithSP3 = _CommonRepository.CheckUserByEmail(EmailID, true); if (objDatawithSP3 != null) { Name = objDatawithSP3.Name; ID = Convert.ToString(objDatawithSP3.UserID); } } if (objForgetPassword.RoleName == "Vendor") { objDatawithSP = objDatawithSP.Where(x => x.Email == EmailID); if (objDatawithSP.Any()) { Name = objDatawithSP.ElementAt(0).Name; ID = Convert.ToString(objDatawithSP.ElementAt(0).UserID); } } if (objForgetPassword.RoleName == "Anchor Company") { objDatawithSP4 = objDatawithSP.Where(x => x.Email == EmailID && x.IsDelete == false); if (objDatawithSP4.Any()) { Name = objDatawithSP4.ElementAt(0).Name; ID = Convert.ToString(objDatawithSP4.ElementAt(0).UserID); } } if (objForgetPassword.RoleName == "SuperAdmin") { objDatawithSP1 = _CommonRepository.CheckSuperAdminByEmail(EmailID, false); if (objDatawithSP1 != null) { Name = objDatawithSP1.Name; ID = Convert.ToString(objDatawithSP1.ID); } } if (Name != "") { string Token = ID + "~" + objForgetPassword.RoleName + "~" + DateTime.Now; string EncryptToken = SecurityHelperService.Encrypt(Token); // var Result = _CommonRepository.UpdatePassword(Password, EmailID, objForgetPassword.RoleName); // if (Result > 0) //{ IEnumerable <GetForgetPasswordMailTemplate> lstAwaitedInvVendorsView = _lookUpRepository.getForgetPasswordMailTemplate(); string path = lstAwaitedInvVendorsView.ElementAt(0).Template; string EMAIL_TOKEN_PAYMENT_LINK = "##$$LOGIN_LINK$$##"; //string paymentLink ="http://*****:*****@@User@@", Name); body = body.Replace("@@ProjectName@@", "Finocart"); body = body.Replace(EMAIL_TOKEN_PAYMENT_LINK, paymentLink); body = body.Replace("http://dotnet.brainvire.com/Finocart/Account/AdminLogin", paymentLink); body = body.Replace("@@Password@@", randomPassword); IEnumerable <LookupDetails> lookupDetails = _lookUpRepository.getLookupDetailByKey("SMTPInfo"); _CommonRepository.SendEmail(lookupDetails, emailToAddress, subject, body, true); TempData["MailSuccess"] = "Mail sent successfully"; // } } else { TempData["WrongMail"] = "Email ID is not valid"; } } catch (Exception ex) { TempData["FailureMessage"] = "We are sorry, something went wrong. Please try again later"; var st = new StackTrace(ex, true); var frame = st.GetFrame(0); int ErrorLine = frame.GetFileLineNumber(); var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID); return(RedirectToAction("ErrorPage", "Common")); } return(RedirectToAction("ForgetPassword", "Account", new { Role = RoleName })); }
public IActionResult ValidateSuperAdminLogOn(string EmailID, string Password, string IsRemember) { //EmailID = "*****@*****.**"; if (!ReCaptchaPassed( Request.Form["g-recaptcha-response"], // that's how you get it from the Request object _configuration.GetSection("GoogleReCaptcha:SecretKey").Value )) { TempData["InvalidCredential"] = "Captcha verification failed."; return(RedirectToAction("SuperAdminLogin", "Account")); } string ActionName = this.ControllerContext.RouteData.Values["action"].ToString(); string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); Int32? UserLoginID = HttpContext.Session.GetInt32("UserID"); string ErrorMessage = string.Empty; try { Password = SecurityHelperService.Encrypt(Password); FinocartMaster objDatawithSP = _SuperAdminRepository.ValidateLogin(EmailID, Password); HttpContext.Session.SetString("Role", "SuperAdmin"); CookieOptions option = new CookieOptions(); option.Expires = DateTime.Now.AddDays(2); Response.Cookies.Append("RoleAccess", "SuperAdmin", option); if (objDatawithSP == null) { TempData["InvalidCredential"] = "Enter valid credential"; return(RedirectToAction("SuperAdminLogin", "Account")); } else { var UserID = objDatawithSP.ID; var UserName = objDatawithSP.Name; HttpContext.Session.SetInt32("UserID", UserID); HttpContext.Session.SetString("LoginName", UserName); HttpContext.Session.SetString("JWToken", GenerateJWTToken(UserName)); if (IsRemember == "1") { SetCookie(UserID.ToString(), UserName, "SuperAdmin"); Response.Cookies.Append("EmailID", EmailID, option); } var Res = _CommonRepository.AuditTrailLog("Login", "Super Admin Login", UserID, 0); if (objDatawithSP.IsTemporaryPassword == false) { TempData["Role"] = "SuperAdmin"; return(RedirectToAction("SuperAdminDashBoard", "AnchorCompany")); } else { var data = Encoding.UTF8.GetBytes("SuperAdmin"); var Role = Convert.ToBase64String(data); HttpContext.Session.SetString("Email", objDatawithSP.EmailId); return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role })); } } } catch (Exception ex) { var st = new StackTrace(ex, true); var frame = st.GetFrame(0); int ErrorLine = frame.GetFileLineNumber(); var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserLoginID); return(RedirectToAction("ErrorPage", "Common")); } }
public IActionResult updateNewPassword(ChangePasswordModel changePassword) { string ActionName = this.ControllerContext.RouteData.Values["action"].ToString(); string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); Int32? UserID = HttpContext.Session.GetInt32("UserID"); string ErrorMessage = string.Empty; var lstEmailIDofBank = _companyRepository.GetAnchorEmail(Convert.ToString(changePassword.UserId)); changePassword.Email = lstEmailIDofBank.ElementAt(0).Contact_email; try { var Result = ""; var Actions = ""; changePassword.NewPassword = SecurityHelperService.Encrypt(changePassword.NewPassword); changePassword.OldPassword = SecurityHelperService.Encrypt(changePassword.OldPassword); var data = Encoding.UTF8.GetBytes(changePassword.Role); var Role = Convert.ToBase64String(data); if (HttpContext.Session.GetInt32("UserID") != null) { if (changePassword.Role == "InternalUser") { Actions = "UserLogin"; User objDatawithSP = _empRepository.CheckUser(changePassword.Email, changePassword.OldPassword); if (objDatawithSP != null) { Result = objDatawithSP.Password; } } if (changePassword.Role == "MasterAdmin") { Actions = "AdminLogin"; Company objDatawithSP = _empRepository.CheckAdmin(changePassword.Email, changePassword.OldPassword); if (objDatawithSP != null) { Result = objDatawithSP.Password; } } if (changePassword.Role == "SuperAdmin") { Actions = "SuperAdminLogin"; FinocartMaster objDatawithSP = _empRepository.CheckSuperAdmin(changePassword.Email, changePassword.OldPassword); if (objDatawithSP != null) { Result = objDatawithSP.Password; } } if (Result != "") { var Data = _empRepository.UpdateNewPassword(changePassword); } else { TempData["WrongPassword"] = "******"; return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role })); } if (Result != "") { string emailToAddress = lstEmailIDofBank.ElementAt(0).Contact_email; string AnchorName = lstEmailIDofBank.ElementAt(0).Contact_Name; string BankName = HttpContext.Session.GetString("LoginName"); string Template = string.Empty; int Id = 1; IEnumerable <GetChangePasswordMailTemplate> lstAwaitedInvVendorsView = _companyRepository.GetChangePasswordMailTemplate(Template); string path = lstAwaitedInvVendorsView.ElementAt(0).Template; //string path = ""; string subject = "Change Password"; string body = path; body = body.Replace("@@User@@", AnchorName); body = body.Replace("@@BankName@@", BankName); body = body.Replace("@@mentiondateandtime", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")); IEnumerable <LookupDetails> lookupDetails = _lookUpRepository.getLookupDetailByKey("SMTPInfo"); _CommonRepository.SendEmail(lookupDetails, emailToAddress, subject, body, true); } return(RedirectToAction(Actions, "Account")); } else { return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role })); } } catch (Exception ex) { var st = new StackTrace(ex, true); var frame = st.GetFrame(0); int ErrorLine = frame.GetFileLineNumber(); var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID); return(RedirectToAction("ErrorPage", "Common")); } }
public IActionResult setChangePassword(ChangePasswordModel objChangePassword) { string ActionName = this.ControllerContext.RouteData.Values["action"].ToString(); string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); Int32? UserID = HttpContext.Session.GetInt32("UserID"); string ErrorMessage = string.Empty; try { //string pw = SecurityHelperService.Decrypt("ueNl4Gl98pKy3m0G6CaqBsi6jSC58DX8"); var Result = ""; var Actions = ""; objChangePassword.NewPassword = SecurityHelperService.Encrypt(objChangePassword.NewPassword); objChangePassword.OldPassword = SecurityHelperService.Encrypt(objChangePassword.OldPassword); var data = Encoding.UTF8.GetBytes(objChangePassword.Role); var Role = Convert.ToBase64String(data); if (HttpContext.Session.GetInt32("UserID") != null) { if (objChangePassword.Role == "InternalUser") { Actions = "UserLogin"; //IEnumerable<User> objDatawithSP = _empRepository.CheckUserPassword(); //objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && x.Email == objChangePassword.Email); User objDatawithSP = _empRepository.CheckUser(objChangePassword.Email, objChangePassword.OldPassword); if (objDatawithSP != null) { Result = objDatawithSP.Password; } } if (objChangePassword.Role == "MasterAdmin") { Actions = "AdminLogin"; //IEnumerable<Company> objDatawithSP = _empRepository.CheckAdminPassword(); ////objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && (x.Email == objChangePassword.Email || x.PANNumber == objChangePassword.Email)); //objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && x.Pan_number == objChangePassword.Email); Company objDatawithSP = _empRepository.CheckAdmin(objChangePassword.Email, objChangePassword.OldPassword); if (objDatawithSP != null) { Result = objDatawithSP.Password; } } if (objChangePassword.Role == "SuperAdmin") { Actions = "SuperAdminLogin"; //IEnumerable<FinocartMaster> objDatawithSP = _empRepository.CheckSuperAdminPassword(); //objDatawithSP = objDatawithSP.Where(x => x.Password == objChangePassword.OldPassword && x.EmailId == objChangePassword.Email); FinocartMaster objDatawithSP = _empRepository.CheckSuperAdmin(objChangePassword.Email, objChangePassword.OldPassword); if (objDatawithSP != null) { Result = objDatawithSP.Password; } } if (Result != "") { var Data = _empRepository.UpdateNewPassword(objChangePassword); return(RedirectToAction(Actions, "Account")); } else { TempData["WrongPassword"] = "******"; return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role })); } } else { return(RedirectToAction("ChangePassword", "Common", new { RoleName = Role })); } } catch (Exception ex) { var st = new StackTrace(ex, true); var frame = st.GetFrame(0); int ErrorLine = frame.GetFileLineNumber(); var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID); return(RedirectToAction("ErrorPage", "Common")); } }