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