private static SQLInformation.Data.ApplicationDataSet.JSAlertsRow Add(MSMOA.Alert alert, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow) { SQLInformation.Data.ApplicationDataSet.JSAlertsRow dataRow = null; try { dataRow = Common.ApplicationDataSet.JSAlerts.NewJSAlertsRow(); dataRow.ID = Guid.NewGuid(); dataRow.JobServer_ID = jobServerRow.ID; dataRow.Name_JSAlert = alert.Name; dataRow.AlertType = alert.AlertType.ToString(); dataRow.CategoryName = alert.CategoryName; dataRow.CountResetDate = alert.CountResetDate; dataRow.DatabaseName = alert.DatabaseName; dataRow.IsEnabled = alert.IsEnabled; dataRow.JobID = alert.JobID; dataRow.JobName = alert.JobName; dataRow.LastOccurrenceDate = alert.LastOccurrenceDate; dataRow.LastResponseDate = alert.LastResponseDate; dataRow.NotificationMessage = alert.NotificationMessage; dataRow.OccurrenceCount = alert.OccurrenceCount; dataRow.Severity = alert.Severity; try { dataRow.WmiEventNamespace = alert.WmiEventNamespace; } catch (Exception ex) { #if TRACE VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 5); #endif dataRow.WmiEventNamespace = "<Exception>"; } try { dataRow.WmiEventQuery = alert.WmiEventQuery; } catch (Exception ex) { #if TRACE VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 6); #endif dataRow.WmiEventNamespace = "<Exception>"; } dataRow.SnapShotDate = DateTime.Now; dataRow.SnapShotError = ""; Common.ApplicationDataSet.JSAlerts_Add(dataRow); } catch (Exception ex) { ReportException(ex, dataRow, CLASS_BASE_ERRORNUMBER + 7); } return(dataRow); }
private static void Update(MSMOA.Alert alert, SQLInformation.Data.ApplicationDataSet.JSAlertsRow dataRow) { try { //dataRow.X = alert.X; dataRow.SnapShotDate = DateTime.Now; dataRow.SnapShotError = ""; Common.ApplicationDataSet.JSAlerts_Update(); } catch (Exception ex) { ReportException(ex, dataRow, CLASS_BASE_ERRORNUMBER + 8); } }
private static SQLInformation.Data.ApplicationDataSet.JSAlertsRow GetInfoFromSMO(MSMOA.Alert alert, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow) { #if TRACE long startTicks = VNC.AppLog.Trace4(string.Format("Enter ({0})", alert.Name), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); #endif SQLInformation.Data.ApplicationDataSet.JSAlertsRow dataRow = null; try { var dbs = from db in Common.ApplicationDataSet.JSAlerts where db.JobServer_ID == jobServerRow.ID select db; var dbs2 = from db2 in dbs where db2.Name_JSAlert == alert.Name select db2; if (dbs2.Count() > 0) { dataRow = dbs2.First(); Update(alert, dataRow); } else { dataRow = Add(alert, jobServerRow); } } catch (Exception ex) { ReportException(ex, dataRow, CLASS_BASE_ERRORNUMBER + 3); } #if TRACE VNC.AppLog.Trace4("Exit", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 4, startTicks); #endif return(dataRow); }