private static void Update(MSMOA.Operator operatorX, SQLInformation.Data.ApplicationDataSet.JSOperatorsRow dataRow)
{
try
{
operatorX.UpdateDataSet(dataRow);
UpdateDatabaseWithSnapShot(dataRow, "");
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 6);
UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
}
}
private static SQLInformation.Data.ApplicationDataSet.JSOperatorsRow Add(MSMOA.Operator operatorX, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow)
{
SQLInformation.Data.ApplicationDataSet.JSOperatorsRow dataRow = null;
try
{
dataRow = Common.ApplicationDataSet.JSOperators.NewJSOperatorsRow();
dataRow.ID = Guid.NewGuid();
dataRow.JobServer_ID = jobServerRow.ID;
dataRow.Name_JSOperator = operatorX.Name;
dataRow.CategoryName = operatorX.CategoryName;
dataRow.EmailAddress = operatorX.EmailAddress;
dataRow.Enabled = operatorX.Enabled;
dataRow.ID_Operator = operatorX.ID;
dataRow.LastEmailDate = operatorX.LastEmailDate;
dataRow.LastNetSendDate = operatorX.LastNetSendDate;
dataRow.LastPagerDate = operatorX.LastPagerDate;
dataRow.NetSendAddress = operatorX.NetSendAddress;
dataRow.PagerAddress = operatorX.PagerAddress;
dataRow.PagerDays = operatorX.PagerDays.ToString();
// TODO(crhodes): Is there a better datatype/
dataRow.SaturdayPagerEndTime = operatorX.SaturdayPagerEndTime.ToString();
dataRow.SaturdayPagerStartTime = operatorX.SaturdayPagerStartTime.ToString();
dataRow.SundayPagerEndTime = operatorX.SaturdayPagerEndTime.ToString();
dataRow.SundayPagerStartTime = operatorX.SaturdayPagerStartTime.ToString();
dataRow.WeekdayPagerEndTime = operatorX.WeekdayPagerEndTime.ToString();
dataRow.WeekdayPagerStartTime = operatorX.WeekdayPagerStartTime.ToString();
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = "";
Common.ApplicationDataSet.JSOperators.AddJSOperatorsRow(dataRow);
Common.ApplicationDataSet.JSOperatorsTA.Update(Common.ApplicationDataSet.JSOperators);
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 5);
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
}
return(dataRow);
}
private static SQLInformation.Data.ApplicationDataSet.JSOperatorsRow GetInfoFromSMO(MSMOA.Operator operatorX, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow)
{
#if TRACE
long startTicks = VNC.AppLog.Trace4(string.Format("Enter ({0})", operatorX.Name), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif
SQLInformation.Data.ApplicationDataSet.JSOperatorsRow dataRow = null;
try
{
var dbs = from db in Common.ApplicationDataSet.JSOperators
where db.JobServer_ID == jobServerRow.ID
select db;
var dbs2 = from db2 in dbs
where db2.Name_JSOperator == operatorX.Name
select db2;
if (dbs2.Count() > 0)
{
dataRow = dbs2.First();
Update(operatorX, dataRow);
}
else
{
dataRow = Add(operatorX, jobServerRow);
}
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
}
#if TRACE
VNC.AppLog.Trace4("Exit", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 4, startTicks);
#endif
return(dataRow);
}
