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 "";
}
