public ActionResult ResetPasswordForUser(string Password) { UserLoginInformation loggedinUser = (UserLoginInformation)LoginController.ActiveUser; Encryption eny = new Encryption(); string EncrptPassword = eny.EncryptString(Password); loggedinUser.Password = EncrptPassword; _context.Entry(loggedinUser).State = EntityState.Modified; _context.SaveChanges(); UserRegitrationForInitialLogin IntialLogin = _context.UserRegitrationForInitialLogins.SingleOrDefault(In => In.USERID.Equals(loggedinUser.USERID)); IntialLogin.IsInitialLogin = false; _context.Entry(IntialLogin).State = EntityState.Modified; _context.SaveChanges(); return(Json(new { result = "Redirect", url = Url.Action("List", "UserDatatables") })); }
public ActionResult LoginCredentials(UserLoginInformation obj) { Encryption eny = new Encryption(); string EncrptPassword = eny.EncryptString(obj.Password); var user = _context.UserLoginInformations.FirstOrDefault(x => x.EmailId.ToLower().Equals(obj.EmailId.ToLower()) && x.Password.ToLower().Equals(EncrptPassword.ToLower()) && x.IsActive == true && x.Status == 1); if (user != null) { if (!user.IsSuperAdmin) { if (!user.IsOrganisationAdmin) { if (!user.IsFacilityAdmin) { TempData["errormsg"] = "You are not authorised to login, Please contact Administrator"; return(RedirectToAction("Login", "Login")); } } } ActiveUser = user; UserRegitrationForInitialLogin IntialLogin = _context.UserRegitrationForInitialLogins.FirstOrDefault(L => L.USERID.Equals(user.USERID)); if (IntialLogin != null) { if (IntialLogin.IsInitialLogin) { return(RedirectToAction("ResetPassword", "Login")); } else { return(RedirectToAction("List", "UserDatatables")); } } else { return(RedirectToAction("List", "UserDatatables")); } } TempData["errormsg"] = "Please Enter Correct Username And Password"; return(RedirectToAction("Login", "Login")); }
public string UpdateUser(UserLoginInformation ulinfo) { try { var loggedinUser = LoginController.ActiveUser; ulinfo.ModifiedById = loggedinUser.USERID.ToString(); if (ulinfo.USERID == 0) { ulinfo.CreatedById = loggedinUser.USERID.ToString(); ulinfo.CreatedDate = DateTime.Now; ulinfo.Status = 1; //insert record status if (ulinfo.IsActive) { ulinfo.UserIsActive = true; } try { using (var transactionScope = new TransactionScope()) { try { using (var db = new kryptoEntities1()) // Context object { db.UserLoginInformations.Add(ulinfo); db.SaveChanges(); if (ulinfo.USERID > 0) { if (ulinfo.IsActive) { ulinfo.ActivatedDate = DateTime.Now; db.Entry(ulinfo).State = EntityState.Modified; db.SaveChanges(); var useracive = new UserActivate { CreatedById = loggedinUser.USERID.ToString(), Date = DateTime.Now, USERID = ulinfo.USERID, IsActive = ulinfo.IsActive, Status = 1 }; db.UserActivates.Add(useracive); db.SaveChanges(); } } var otherFacilityIds = ulinfo.OtherFacilityIds; if (ulinfo.USERID > 0 && (otherFacilityIds != null && otherFacilityIds.Length > 0)) { foreach (var eachid in otherFacilityIds) { var facilityid = int.Parse(eachid); db.UserFacilities.Add(new UserFacility { FacilityId = facilityid, USERID = ulinfo.USERID, Status = 1, CreatedById = loggedinUser.USERID.ToString(), CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ModifiedById = loggedinUser.USERID.ToString() }); } db.SaveChanges(); } if (ulinfo.USERID > 0) { var initiallogin = new UserRegitrationForInitialLogin { USERID = ulinfo.USERID, Createdate = DateTime.Now, IsInitialLogin = true, IsTermsAccepted = false, IsSecQuestEnabled = false, IsMpinCreated = false, IsPasswordUpdated = false, Status = 1, CreatedById = loggedinUser.USERID.ToString(), ModifiedById = loggedinUser.USERID.ToString() }; initiallogin.ModifiedDate = initiallogin.Createdate; db.UserRegitrationForInitialLogins.Add(initiallogin); db.SaveChanges(); } } transactionScope.Complete(); // transaction complete } catch (Exception ee) { return("FAIL"); } } } catch (Exception exception) { return("FAIL"); } } else { try { using (var transactionScope = new TransactionScope()) { try { using (var db = new kryptoEntities1()) { ulinfo.ModifiedDate = DateTime.Now; var prevobj = _context.UserLoginInformations.Find(ulinfo.USERID); if (prevobj.IsActive != ulinfo.IsActive) { var activate = new UserActivate { IsActive = !prevobj.IsActive, CreatedById = loggedinUser.USERID.ToString() }; if (ulinfo.IsActive) { ulinfo.ActivatedDate = DateTime.Now; activate.Date = ulinfo.ActivatedDate; } else { ulinfo.DeactivatedDate = DateTime.Now; activate.Date = ulinfo.DeactivatedDate; } activate.USERID = prevobj.USERID; db.UserActivates.Add(activate); } ulinfo.UserIsActive = ulinfo.IsActive; ulinfo = Updateobject(ulinfo.USERID, ulinfo); db.Entry(ulinfo).State = EntityState.Modified; db.SaveChanges(); var otherFacilityIdsAsints = ulinfo.GetOtherFacilityIdsAsints(); var facilityIdsInUserFacilityList = ulinfo.GetFacilityIdsInUserFacilityList(); var toAdd = ExcludedRight(facilityIdsInUserFacilityList, otherFacilityIdsAsints); var toDelete = ExcludedLeft(facilityIdsInUserFacilityList, otherFacilityIdsAsints); foreach (var @id in toAdd) { db.UserFacilities.Add(new UserFacility { FacilityId = @id, USERID = ulinfo.USERID, Status = 1, CreatedById = loggedinUser.USERID.ToString(), CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ModifiedById = loggedinUser.USERID.ToString() }); } foreach ( var existingUserFacility in toDelete.Select( id => db.UserFacilities.SingleOrDefault( x => x.FacilityId.Value.Equals(id) && x.USERID.Equals(ulinfo.USERID)))) { db.UserFacilities.Remove(existingUserFacility); } db.SaveChanges(); if (ulinfo.IsActive == false) { RemoveUser(ulinfo.USERID); } } transactionScope.Complete(); } catch (Exception ee) { return("FAIL"); } } } catch (Exception exception) { return("FAIL"); } } if (ulinfo.USERID > 0 && ulinfo.IsActive) { OtpSent(ulinfo, loggedinUser.USERID); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return("FAIL"); } return("SUCESS"); }
public string ResetPswd(int selecteduser) { var user = _context.UserLoginInformations.Single(x => x.USERID.Equals(selecteduser)); var info = new KPTY_USER_FORGOT_PASS_OTP_REQ_TBL(); var intialLogin = new UserRegitrationForInitialLogin(); Session["OTPCount"] = 0; var otp = GenerateOTP(4); try { var loggedinUser = LoginController.ActiveUser; info.USERID = user.USERID; info.ModifiedById = loggedinUser.USERID.ToString(); info.CreatedById = loggedinUser.USERID.ToString(); info.CREATED_DATE = DateTime.Now; info.ModifiedDate = DateTime.Now; info.STATUS = 1; info.OTPVAL = otp; try { using (var transactionScope = new TransactionScope()) { try { using (var db = new kryptoEntities1()) // Context object { db.Database.ExecuteSqlCommand( "delete from KPTY_USER_FORGOT_PASS_OTP_REQ_TBL where UserId = {0}", selecteduser); db.KPTY_USER_FORGOT_PASS_OTP_REQ_TBL.Add(info); db.UserRegitrationForInitialLogins.Remove( db.UserRegitrationForInitialLogins.SingleOrDefault(u => u.USERID == selecteduser)); intialLogin.IsInitialLogin = true; intialLogin.IsTermsAccepted = false; intialLogin.IsSecQuestEnabled = false; intialLogin.IsPasswordUpdated = false; intialLogin.IsMpinCreated = false; intialLogin.Notes = null; intialLogin.Status = 1; intialLogin.ModifiedById = loggedinUser.USERID.ToString(); intialLogin.ModifiedDate = DateTime.Now; intialLogin.USERID = selecteduser; intialLogin.Createdate = DateTime.Now; intialLogin.CreatedById = loggedinUser.USERID.ToString(); db.UserRegitrationForInitialLogins.Add(intialLogin); db.SaveChanges(); db.Database.ExecuteSqlCommand("delete from KPTY_USER_SECQURITY_QUEST_ANS where UserId = {0}", selecteduser); Encryption eny = new Encryption(); string EncrptPassword = eny.EncryptString(otp.ToString()); user.Password = EncrptPassword; user.ModifiedById = loggedinUser.USERID.ToString(); user.ModifiedDate = DateTime.Now; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } transactionScope.Complete(); // transaction complete var recemail = user.EmailId; if (!SendOTPMail(otp, recemail, user.FirstName)) { return("Invalid Email"); } } catch (Exception ee) { return("FAIL"); } } } catch (Exception exception) { return("FAIL"); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return("FAIL"); } return("SUCESS"); }
public string ResetPswd(int selecteduser) { UserLoginInformation user = _context.UserLoginInformations.SingleOrDefault(x => x.USERID.Equals(selecteduser)); KPTY_USER_FORGOT_PASS_OTP_REQ_TBL info = new KPTY_USER_FORGOT_PASS_OTP_REQ_TBL(); UserRegitrationForInitialLogin IntialLogin = new UserRegitrationForInitialLogin(); Session["OTPCount"] = 0; var OTP = GenerateOTP(4); try { UserLoginInformation loggedinUser = (UserLoginInformation)LoginController.ActiveUser; //ResetOTPStatus(loggedinUser.USERID); info.USERID = user.USERID; info.ModifiedById = loggedinUser.USERID.ToString(); info.CreatedById = loggedinUser.USERID.ToString(); info.CREATED_DATE = DateTime.Now; info.ModifiedDate = DateTime.Now; info.STATUS = 1; info.OTPVAL = OTP; try { using (TransactionScope transactionScope = new TransactionScope()) { try { using (kryptoEntities1 db = new kryptoEntities1()) // Context object { db.Database.ExecuteSqlCommand("delete from KPTY_USER_FORGOT_PASS_OTP_REQ_TBL where UserId = {0}", selecteduser); db.KPTY_USER_FORGOT_PASS_OTP_REQ_TBL.Add(info); db.SaveChanges(); db.Database.ExecuteSqlCommand("delete from UserRegitrationForInitialLogin where UserId = {0}", selecteduser); IntialLogin.IsInitialLogin = true; IntialLogin.IsTermsAccepted = false; IntialLogin.IsSecQuestEnabled = false; IntialLogin.IsPasswordUpdated = false; IntialLogin.IsMpinCreated = false; IntialLogin.Notes = null; IntialLogin.Status = 1; IntialLogin.ModifiedById = loggedinUser.USERID.ToString(); IntialLogin.ModifiedDate = DateTime.Now; IntialLogin.USERID = selecteduser; IntialLogin.Createdate = DateTime.Now; IntialLogin.CreatedById = loggedinUser.USERID.ToString(); db.UserRegitrationForInitialLogins.Add(IntialLogin); db.SaveChanges(); } transactionScope.Complete(); // transaction complete var recemail = user.EmailId; var msg = "Dear User,\n\n Your request to process the reset password is successful and your new OTP generated is " + OTP + " . Please use it to login again. \n This is system generated message please do not reply."; bool x1 = SendEmail("Your Password has been reset", msg, recemail, user.FirstName); if (!x1) { return("Invalid Email"); } } catch (Exception ee) { return("FAIL"); } } } catch (Exception exception) { return("FAIL"); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return("FAIL"); } return("SUCESS"); }