public static void UpdateDataSet(this MSMO.StoredProcedure storedProcedure, Data.ApplicationDataSet.DBStoredProceduresRow storedProcedureRow)
{
try
{
storedProcedureRow.Owner = storedProcedure.Owner;
storedProcedureRow.CreateDate = storedProcedure.CreateDate;
if (Data.Config.ADSLoad_DBStoredProcedureContent)
{
try
{
storedProcedureRow.MethodName = storedProcedure.MethodName;
}
catch (Exception ex)
{
PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1);
storedProcedureRow.MethodName = "<Exception>";
}
try
{
storedProcedureRow.TextHeader = storedProcedure.TextHeader;
}
catch (Exception ex)
{
PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1);
storedProcedureRow.TextHeader = "<Exception>";
}
try
{
storedProcedureRow.TextBody = storedProcedure.TextBody;
}
catch (Exception ex)
{
PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1);
storedProcedureRow.TextBody = "<Exception>";
}
}
try
{
storedProcedureRow.DateLastModified = storedProcedure.DateLastModified;
}
catch (Exception ex)
{
PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1);
}
}
catch (Exception ex)
{
// TODO(crhodes): Need to wrap anything above that throws an exception
// that we want to ignore, e.g. property not available because of
// SQL Edition.
PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
throw ex;
}
}
private static void UpdateDatabaseWithSnapShot(Data.ApplicationDataSet.DBStoredProceduresRow dataRow, string snapShotError)
{
try
{
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = snapShotError;
Common.ApplicationDataSet.DBStoredProceduresTA.Update(Common.ApplicationDataSet.DBStoredProcedures);
}
catch (Exception ex)
{
string errorMessage = string.Format("DBStoredProceduresRow.ID:{0} - ex:{1} ex.Inner:{2}", dataRow.ID, ex, ex.InnerException);
VNC.AppLog.Error(errorMessage, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7);
}
}
public static void UpdateDataSet(this MSMO.StoredProcedure storedProcedure, Data.ApplicationDataSet.DBStoredProceduresRow dataRow)
{
try
{
dataRow.Owner = storedProcedure.Owner;
dataRow.CreateDate = storedProcedure.CreateDate;
if (Data.Config.ADSLoad_DBStoredProcedureContent)
{
try
{
dataRow.MethodName = storedProcedure.MethodName;
}
catch (Exception ex)
{
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11);
#endif
dataRow.MethodName = "<Exception>";
}
try
{
dataRow.TextHeader = storedProcedure.TextHeader;
}
catch (Exception ex)
{
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 12);
#endif
dataRow.TextHeader = "<Exception>";
}
try
{
dataRow.TextBody = storedProcedure.TextBody;
}
catch (Exception ex)
{
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 13);
#endif
dataRow.TextBody = "<Exception>";
}
}
try
{
dataRow.DateLastModified = storedProcedure.DateLastModified;
}
catch (Exception ex)
{
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 14);
#endif
}
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 15);
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
}
}
