private string SaveMobileOTP(MobileOTPDetail mobileOTP) { using (var dbContextTransaction = _dbContext.Database.BeginTransaction()) { try { _MobileOTPDetail.Add(mobileOTP); _dbContext.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } return ""; }
private string UpdateMobileOTP(MobileOTPDetail mobileOTP) { using (var dbContextTransaction = _dbContext.Database.BeginTransaction()) { try { //_MobileOTPDetail.Attach(mobileOTP); //_dbContext.Entry(mobileOTP).State = EntityState.Added; //_dbContext.Commit(); // dbContextTransaction.Commit(); _MobileOTPDetail.Attach(mobileOTP); var entry = _dbContext.Entry(mobileOTP); entry.Property(e => e.OTP).IsModified = true; entry.Property(e => e.CreatedDate).IsModified = true; _dbContext.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } return ""; }
public string GenerateMobileOTP(MobileOTPDetail mobileOTP) { try { var mobiledata = _dbContext.MobileOTPDetails.Where(c => c.MobileNo == mobileOTP.MobileNo).Select(d => d.MobileNo).FirstOrDefault(); if (mobiledata == null) { SaveMobileOTP(mobileOTP); } else { UpdateMobileOTP(mobileOTP); } } catch (Exception) { return ""; throw; } return ""; }