public string ResetOtp(int selectedUser) { var loggedinUser = LoginController.ActiveUser; var user = _context.UserLoginInformations.Single(x => x.USERID.Equals(selectedUser)); var userOtp = new UserForgotMpinsOTP(); var number = GenerateOTP(11); try { using (var transactionScope = new TransactionScope()) { try { using (var db = new kryptoEntities1()) // Context object { userOtp.USERID = selectedUser; userOtp.OTPVAL = number; userOtp.STATUS = 2; userOtp.Notes = ""; userOtp.CREATED_DATE = DateTime.Now; userOtp.ModifiedDate = DateTime.Now; userOtp.CreatedById = loggedinUser.USERID.ToString(); userOtp.ModifiedById = loggedinUser.USERID.ToString(); db.Database.ExecuteSqlCommand("delete from UserForgotMpinsOTPS where UserId = {0}", selectedUser); db.UserForgotMpinsOTPS.Add(userOtp); db.SaveChanges(); } transactionScope.Complete(); bool x1 = SendOTPMail(number, user.EmailId, user.FirstName); if (!x1) { return("Invalid Email"); } } catch (Exception ee) { 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 ResetOtp(int selectedUser) { UserLoginInformation loggedinUser = (UserLoginInformation)LoginController.ActiveUser; UserLoginInformation user = _context.UserLoginInformations.SingleOrDefault(x => x.USERID.Equals(selectedUser)); UserForgotMpinsOTP UserOtp = new UserForgotMpinsOTP(); string Number = GenerateOTP(11); try { using (TransactionScope transactionScope = new TransactionScope()) { try { using (kryptoEntities1 db = new kryptoEntities1()) // Context object { UserOtp.USERID = selectedUser; UserOtp.OTPVAL = Number; UserOtp.STATUS = 1; UserOtp.Notes = ""; UserOtp.CREATED_DATE = DateTime.Now; UserOtp.ModifiedDate = DateTime.Now; UserOtp.CreatedById = loggedinUser.USERID.ToString(); UserOtp.ModifiedById = loggedinUser.USERID.ToString(); db.Database.ExecuteSqlCommand("delete from UserForgotMpinsOTPS where UserId = {0}", selectedUser); db.UserForgotMpinsOTPS.Add(UserOtp); db.SaveChanges(); } transactionScope.Complete(); var msg = "Dear User, \n\n Your request to process the reset OTP is successful and your new OTP generated is " + Number + " . \n\n This is system generated message please do not reply."; bool x1 = SendEmail("Your OTP has been reset", msg, user.EmailId, user.FirstName); if (!x1) { return("Invalid Email"); } } catch (Exception ee) { 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"); }