public void AddLoginAuditDetails(string userId, string status, string failureReason)
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
LoginAuditDetails newRecord = new LoginAuditDetails();
newRecord.UserId = userId;
newRecord.LoginDate = (status == "Failed") ? (DateTime?)null : DateTime.UtcNow;
newRecord.Status = status;
newRecord.FailureReason = failureReason;
_dbContext.LoginAuditDetails.Add(newRecord);
_dbContext.SaveChanges();
}
}
public int DeleteLoginAuditDetails(string userId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
LoginAuditDetails loginAuditDetails = _dbContext.LoginAuditDetails.Find(userId);
_dbContext.LoginAuditDetails.Remove(loginAuditDetails);
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public LoginAuditDetails GetLoginAuditDetails(string userId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
LoginAuditDetails loginAuditDetails = (from loginDetails in _dbContext.LoginAuditDetails
where loginDetails.UserId == userId
select loginDetails).FirstOrDefault();
return(loginAuditDetails);
}
}
catch
{
throw;
}
}
