public static void UpdateDataSet(this MSMO.DataFile dataFile, Data.ApplicationDataSet.DBDataFilesRow dataFileRow)
{
try
{
//instanceRow.ServiceName = server.ServiceName;
}
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 Update(MSMO.DataFile dataFile, SQLInformation.Data.ApplicationDataSet.DBDataFilesRow dataRow)
{
try
{
dataFile.UpdateDataSet(dataRow);
UpdateDatabaseWithSnapShot(dataRow, "");
// Add add the Snapshot
SMO.Helper.TakeDBDataFileSnapShot(dataRow);
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11);
UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
}
}
/// <summary>
/// Initializes a new instance of the DataFile class.
/// </summary>
public DataFile(SMO.DataFile dataFile)
{
try { AvailableSpace = dataFile.AvailableSpace.ToString(); } catch (Exception) { AvailableSpace = "Not Available"; }
try { FileName = dataFile.FileName.ToString(); } catch (Exception) { FileName = "Not Available"; }
try { Growth = dataFile.Growth.ToString(); } catch (Exception) { Growth = "Not Available"; }
try { GrowthType = dataFile.GrowthType.ToString(); } catch (Exception) { GrowthType = "Not Available"; }
try { ID = dataFile.ID.ToString(); } catch (Exception) { ID = "Not Available"; }
try { IsOffline = dataFile.IsOffline.ToString(); } catch (Exception) { IsOffline = "Not Available"; }
try { IsPrimaryFile = dataFile.IsPrimaryFile.ToString(); } catch (Exception) { IsPrimaryFile = "Not Available"; }
try { IsReadOnly = dataFile.IsReadOnly.ToString(); } catch (Exception) { IsReadOnly = "Not Available"; }
try { IsReadOnlyMedia = dataFile.IsReadOnlyMedia.ToString(); } catch (Exception) { IsReadOnlyMedia = "Not Available"; }
try { IsSparse = dataFile.IsSparse.ToString(); } catch (Exception) { IsSparse = "Not Available"; }
//try { IsTouched = dataFile.IsTouched.ToString(); } catch(Exception) { IsTouched = "Not Available"; }
try { MaxSize = dataFile.MaxSize.ToString(); } catch (Exception) { MaxSize = "Not Available"; }
try { Name = dataFile.Name.ToString(); } catch (Exception) { Name = "Not Available"; }
try { NumberOfDiskReads = dataFile.NumberOfDiskReads.ToString(); } catch (Exception) { NumberOfDiskReads = "Not Available"; }
try { NumberOfDiskWrites = dataFile.NumberOfDiskWrites.ToString(); } catch (Exception) { NumberOfDiskWrites = "Not Available"; }
try { Size = dataFile.Size.ToString(); } catch (Exception) { Size = "Not Available"; }
try { State = dataFile.State.ToString(); } catch (Exception) { State = "Not Available"; }
try { UsedSpace = dataFile.UsedSpace.ToString(); } catch (Exception) { UsedSpace = "Not Available"; }
try { VolumeFreeSpace = dataFile.VolumeFreeSpace.ToString(); } catch (Exception) { VolumeFreeSpace = "Not Available"; }
}
private static SQLInformation.Data.ApplicationDataSet.DBDataFilesRow Add(Guid fileGroupID, MSMO.DataFile dataFile, Guid databaseID)
{
SQLInformation.Data.ApplicationDataSet.DBDataFilesRow dataRow = null;
try
{
dataRow = Common.ApplicationDataSet.DBDataFiles.NewDBDataFilesRow();
dataRow.ID = Guid.NewGuid();
dataRow.FileGroup_ID = fileGroupID;
dataRow.Database_ID = databaseID;
dataRow.ID_DataFile = dataFile.ID;
dataRow.Name_DataFile = dataFile.Name;
dataRow.AvailableSpace = dataFile.AvailableSpace;
// try
// {
// dataRow.BytesReadFromDisk = (int)dataFile.BytesReadFromDisk; // TODO(crhodes)
// }
// catch (Exception ex)
// {
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 5);
//#endif
// dataRow.BytesReadFromDisk = -1;
// }
// try
// {
// dataRow.BytesWrittenToDisk = (int)dataFile.BytesWrittenToDisk; // TODO(crhodes)
// }
// catch (Exception ex)
// {
// dataRow.BytesWrittenToDisk = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 6);
//#endif
// }
dataRow.FileName = dataFile.FileName;
dataRow.Growth = (int)dataFile.Growth; // TODO(crhodes)
dataRow.GrowthType = dataFile.GrowthType.ToString();
dataRow.ID_DataFile = dataFile.ID;
dataRow.IsPrimaryFile = dataFile.IsPrimaryFile;
dataRow.MaxSize = dataFile.MaxSize;
// try
// {
// dataRow.NumberOfDiskReads = (int)dataFile.NumberOfDiskReads; // TODO(crhodes)
// }
// catch (Exception ex)
// {
// dataRow.NumberOfDiskReads = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7);
//#endif
// }
// try
// {
// dataRow.NumberOfDiskWrites = (int)dataFile.NumberOfDiskWrites; // TODO(crhodes)
// }
// catch (Exception ex)
// {
// dataRow.NumberOfDiskWrites = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 8);
//#endif
// }
dataRow.Size = dataFile.Size;
dataRow.UsedSpace = dataFile.UsedSpace;
try
{
dataRow.VolumeFreeSpace = dataFile.VolumeFreeSpace;
}
catch (Exception ex)
{
dataRow.VolumeFreeSpace = dataFile.VolumeFreeSpace;
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 9);
#endif
}
dataRow.SnapShotDate = DateTime.Now;
dataRow.SnapShotError = "";
Common.ApplicationDataSet.DBDataFiles.AddDBDataFilesRow(dataRow);
Common.ApplicationDataSet.DBDataFilesTA.Update(Common.ApplicationDataSet.DBDataFiles);
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
// 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.DBDataFilesRow GetInfoFromSMO(Guid fileGroupID, string fileGroupName, MSMO.DataFile dataFile, Guid databaseID)
{
#if TRACE
long startTicks = VNC.AppLog.Trace4("Enter", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif
SQLInformation.Data.ApplicationDataSet.DBDataFilesRow dataRow = null;
try
{
var dbs = from tb in Common.ApplicationDataSet.DBDataFiles
where tb.FileGroup_ID == fileGroupID
select tb;
var dbs2 = from db2 in dbs
where db2.Name_DataFile == dataFile.Name
select db2;
if (dbs2.Count() > 0)
{
dataRow = dbs2.First();
Update(dataFile, dataRow);
}
else
{
dataRow = Add(fileGroupID, dataFile, databaseID);
}
}
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);
}
public static void UpdateDataSet(this MSMO.DataFile dataFile, Data.ApplicationDataSet.DBDataFilesRow dataRow)
{
try
{
try
{
dataRow.AvailableSpace = dataFile.AvailableSpace;
}
catch (Exception ex)
{
dataRow.AvailableSpace = -1;
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 12);
#endif
}
// try
// {
// dataRow.BytesReadFromDisk = dataFile.BytesReadFromDisk;
// }
// catch (Exception ex)
// {
// dataRow.BytesReadFromDisk = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 13);
//#endif
// }
// try
// {
// dataRow.BytesWrittenToDisk = dataFile.BytesWrittenToDisk;
// }
// catch (Exception ex)
// {
// dataRow.BytesWrittenToDisk = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 14);
//#endif
// }
dataRow.MaxSize = dataFile.MaxSize;
// try
// {
// dataRow.NumberOfDiskReads = dataFile.NumberOfDiskReads;
// }
// catch (Exception ex)
// {
// dataRow.NumberOfDiskReads = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 15);
//#endif
// }
// try
// {
// dataRow.NumberOfDiskWrites = dataFile.NumberOfDiskWrites;
// }
// catch (Exception ex)
// {
// dataRow.NumberOfDiskWrites = -1;
//#if TRACE
// VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 16);
//#endif
// }
dataRow.Size = dataFile.Size;
dataRow.UsedSpace = dataFile.UsedSpace;
try
{
dataRow.VolumeFreeSpace = dataFile.VolumeFreeSpace;
}
catch (Exception ex)
{
dataRow.VolumeFreeSpace = -1;
#if TRACE
VNC.AppLog.Debug(ex.ToString(), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 17);
#endif
}
}
catch (Exception ex)
{
VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 12);
// TODO(crhodes):
// Wrap anything above that throws an exception that we want to ignore,
// e.g. property not available because of SQL Edition.
}
}
