public void UpdatePRSErrorMonitorTable(DateTime dateTime, int prsUnavailableErrors, int prsTimeoutErrors) { tbPRSErrorMonitor _prsErrorMonitorRow = new tbPRSErrorMonitor(); _prsErrorMonitorRow.DateTime = dateTime; _prsErrorMonitorRow.PRSUnavailableErrors = prsUnavailableErrors; _prsErrorMonitorRow.PRSTimeoutErrors = prsTimeoutErrors; _reportingEntityContext.tbPRSErrorMonitor.AddObject(_prsErrorMonitorRow); _reportingEntityContext.SaveChanges(); }
public static tbPRSErrorMonitor AddTableRow(DateTime dateTime, int numPrsUnavailableErrors, int numPrsTimeoutErrors) { tbPRSErrorMonitor row = new tbPRSErrorMonitor { DateTime = dateTime, PRSUnavailableErrors = numPrsUnavailableErrors, PRSTimeoutErrors = numPrsTimeoutErrors }; return row; }
public static tbPRSErrorMonitor AddTableRow() { tbPRSErrorMonitor row = new tbPRSErrorMonitor { DateTime = DateTime.Now, PRSUnavailableErrors = 0, PRSTimeoutErrors = 0 }; return row; }
public CheckPrsErrorLevels(IRepository repository, IConfigFileHelper configFileHelper, ILogger log) { _repository = repository; _configFileHelper = configFileHelper; _log = log; _prsUnavailableErrorLimit = _configFileHelper.PrsUnavailableErrorLimit; _prsTimeoutErrorLimit = _configFileHelper.PrsTimeoutErrorLimit; _prsTotalErrorLimit = _configFileHelper.PrsTotalErrorLimit; // If check is to be run every minute, just grab the latest row from tbPrsErrorMonitor if (_configFileHelper.PrsErrorCheckFrequency == 1) { tbPRSErrorMonitor _resultsFromLatestPrsCheck = _repository.RetrieveLatestRowFromPrsErrorMonitorTable(); _numberOfPrsUnavailableErrors = _resultsFromLatestPrsCheck.PRSUnavailableErrors; _numberOfPrsTimeoutErrors = _resultsFromLatestPrsCheck.PRSTimeoutErrors; _totalNumberOfPrsErrors = _numberOfPrsUnavailableErrors + _numberOfPrsTimeoutErrors; } else // Grab all the rows created since check was last ran { // Been thinking about changing this to retrieive all records more recent than the lastTimeCheckWasRan // value in the config file as its more accurate and probably the same speed.....? IList <tbPRSErrorMonitor> _prsErrorDetailsSinceLastCheck = _repository.RetrieveRowsFromPrsErrorMonitorTableForTimeSpecified(_configFileHelper.PrsErrorCheckFrequency); foreach (var tableRow in _prsErrorDetailsSinceLastCheck) { _numberOfPrsUnavailableErrors += tableRow.PRSUnavailableErrors; _numberOfPrsTimeoutErrors += tableRow.PRSTimeoutErrors; } _totalNumberOfPrsErrors = _numberOfPrsUnavailableErrors + _numberOfPrsTimeoutErrors; } // Update the config file with the time check was run _configFileHelper.UpdateTimeLastPrsErrorCheckWasRun(); }