private static void UpdateDatabaseWithSnapShot(Data.ApplicationDataSet.DatabaseInfoRow dataRow, string snapShotError)
{
try
{
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = snapShotError;
Common.ApplicationDataSet.DatabaseInfoTA.Update(Common.ApplicationDataSet.DatabaseInfo);
}
catch (Exception ex)
{
string errorMessage = string.Format("DatabaseInfoRow.ID:{0} - ex:{1} ex.Inner:{2}", dataRow.ID, ex, ex.InnerException);
VNC.AppLog.Error(errorMessage, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 0);
}
}
public static void UpdateDataSet(this MSMO.Database database, Data.ApplicationDataSet.DatabaseInfoRow dataRow)
{
try
{
dataRow.IndexSpaceUsage = database.IndexSpaceUsage;
dataRow.DataSpaceUsage = database.DataSpaceUsage;
dataRow.Size = database.Size;
dataRow.SpaceAvailable = database.SpaceAvailable;
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1);
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
}
}
public static void UpdateDataSet(this MSMO.Database database, Data.ApplicationDataSet.DatabaseInfoRow databaseRow)
{
try
{
databaseRow.IndexSpaceUsage = database.IndexSpaceUsage;
databaseRow.DataSpaceUsage = database.DataSpaceUsage;
databaseRow.Size = database.Size;
databaseRow.SpaceAvailable = database.SpaceAvailable;
}
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;
}
}
public static void TakeDatabaseSnapShot(SQLInformation.Data.ApplicationDataSet.DatabasesRow databaseRow)
{
#if TRACE
long startTicks = VNC.AppLog.Trace4("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 0);
#endif
Data.ApplicationDataSet.DatabaseInfoRow databaseInfoRow = null;
try
{
databaseInfoRow = Common.ApplicationDataSet.DatabaseInfo.NewDatabaseInfoRow();
databaseInfoRow.SnapShotDate = databaseRow.SnapShotDate;
databaseInfoRow.SnapShotError = databaseRow.SnapShotError;
databaseInfoRow.Database_ID = databaseRow.ID;
databaseInfoRow.Name_Database = databaseRow.Name_Database;
databaseInfoRow.Instance_ID = databaseRow.Instance_ID;
databaseInfoRow.Name_Instance = databaseRow.Name_Instance;
databaseInfoRow.IndexSpaceUsage = databaseRow.IndexSpaceUsage;
databaseInfoRow.DataSpaceUsage = databaseRow.DataSpaceUsage;
databaseInfoRow.Size = databaseRow.Size;
databaseInfoRow.SpaceAvailable = databaseRow.SpaceAvailable;
Common.ApplicationDataSet.DatabaseInfo.AddDatabaseInfoRow(databaseInfoRow);
Common.ApplicationDataSet.DatabaseInfoTA.Update(Common.ApplicationDataSet.DatabaseInfo);
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
databaseInfoRow.SnapShotDate = DateTime.Now;
databaseInfoRow.SnapShotError = ex.ToString().Substring(0, 256);
Common.ApplicationDataSet.DatabaseInfoTA.Update(Common.ApplicationDataSet.DatabaseInfo);
}
#if TRACE
VNC.AppLog.Trace4("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3, startTicks);
#endif
}
