public void UpdateSingleVersion(SQLAutoDocLib.BLL.Version oVersion)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("update [Version] set")
.AppendFormat(" ScanComplete='{0}',", oVersion.ScanComplete)
.AppendFormat(" ChangesFound='{0}',", DBHelper.BoolToBit(oVersion.ChangesFound))
.AppendFormat(" Change_Date_Time='{0}',", oVersion.ChangeDateTime)
.AppendFormat(" Change_UID='{0}'", oVersion.ChangeUID)
.AppendLine(" where")
.AppendFormat(" DBID='{0}'", oVersion.DBID)
.AppendFormat(" and VersionID='{0}'", oVersion.VersionID);
base.ExecuteNonQuery(sSQL.ToString());
}
public void AddSingleVersion(SQLAutoDocLib.BLL.Version oVersion)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("insert into [Version] (")
.AppendLine(" DBID,")
.AppendLine(" VersionID,")
.AppendLine(" ScanStart,")
.AppendLine(" ChangesFound,")
.AppendLine(" Change_Date_Time,")
.AppendLine(" Change_UID) values (")
.AppendFormat("'{0}',", oVersion.DBID)
.AppendFormat("'{0}',", oVersion.VersionID)
.AppendFormat("'{0}',", oVersion.ScanStart)
.AppendFormat("'{0}',", DBHelper.BoolToBit(oVersion.ChangesFound))
.AppendFormat("'{0}',", oVersion.ChangeDateTime)
.AppendFormat("'{0}')", oVersion.ChangeUID);
base.ExecuteNonQuery(sSQL.ToString());
}
public void Scan()
{
bool ChangesFound = false;
ScanDatabaseBegin(DateTime.Now);
//create version record
SQLAutoDocLib.BLL.Version oVersion = new SQLAutoDocLib.BLL.Version(m_DBID);
//Scan beginning
oVersion.ScanStart = DateTime.Now.ToString();
oVersion.Save();
//scan all functions
ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.FUNCTIONNODE, DateTime.Now);
ScanAllFunctions oFunctionScanner = new ScanAllFunctions(m_DBID, oVersion.VersionID);
oFunctionScanner.ScanBegin += new ScanAllFunctions.ScanObjectBegin(ScanObjectBegin_Handler);
oFunctionScanner.ScanChanged += new ScanAllFunctions.ScanObjectChanged(ScanObjectChanged_Handler);
oFunctionScanner.ScanNotFound += new ScanAllFunctions.ScanObjectNotFound(ScanObjectNotFound_Handler);
oFunctionScanner.ScanDeleted += new ScanAllFunctions.ScanObjectDeleted(ScanObjectDeleted_Handler);
oFunctionScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oFunctionScanner.Scan(m_ConnectionString);
oFunctionScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oFunctionScanner.ScanDeleted += new ScanAllFunctions.ScanObjectDeleted(ScanObjectDeleted_Handler);
oFunctionScanner.ScanNotFound -= new ScanAllFunctions.ScanObjectNotFound(ScanObjectNotFound_Handler);
oFunctionScanner.ScanChanged -= new ScanAllFunctions.ScanObjectChanged(ScanObjectChanged_Handler);
oFunctionScanner.ScanBegin -= new ScanAllFunctions.ScanObjectBegin(ScanObjectBegin_Handler);
ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.FUNCTIONNODE, DateTime.Now);
if (oFunctionScanner.ChangesFound)
{
ChangesFound = true;
}
//scan all procedures
ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.PROCEDURENODE, DateTime.Now);
ScanAllProcedures oProcedureScanner = new ScanAllProcedures(m_DBID, oVersion.VersionID);
oProcedureScanner.ScanBegin += new ScanAllProcedures.ScanObjectBegin(ScanObjectBegin_Handler);
oProcedureScanner.ScanChanged += new ScanAllProcedures.ScanObjectChanged(ScanObjectChanged_Handler);
oProcedureScanner.ScanNotFound += new ScanAllProcedures.ScanObjectNotFound(ScanObjectNotFound_Handler);
oProcedureScanner.ScanDeleted += new ScanAllProcedures.ScanObjectDeleted(ScanObjectDeleted_Handler);
oProcedureScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oProcedureScanner.Scan(m_ConnectionString);
oProcedureScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oProcedureScanner.ScanDeleted += new ScanAllProcedures.ScanObjectDeleted(ScanObjectDeleted_Handler);
oProcedureScanner.ScanNotFound -= new ScanAllProcedures.ScanObjectNotFound(ScanObjectNotFound_Handler);
oProcedureScanner.ScanChanged -= new ScanAllProcedures.ScanObjectChanged(ScanObjectChanged_Handler);
oProcedureScanner.ScanBegin -= new ScanAllProcedures.ScanObjectBegin(ScanObjectBegin_Handler);
ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.PROCEDURENODE, DateTime.Now);
if (oProcedureScanner.ChangesFound)
{
ChangesFound = true;
}
//scan all tables
ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.TABLENODE, DateTime.Now);
ScanAllTables oTableScanner = new ScanAllTables(m_DBID, oVersion.VersionID);
oTableScanner.ScanBegin += new ScanAllTables.ScanObjectBegin(ScanObjectBegin_Handler);
oTableScanner.ScanChanged += new ScanAllTables.ScanObjectChanged(ScanObjectChanged_Handler);
oTableScanner.ScanNotFound += new ScanAllTables.ScanObjectNotFound(ScanObjectNotFound_Handler);
oTableScanner.ScanDeleted += new ScanAllTables.ScanObjectDeleted(ScanObjectDeleted_Handler);
oTableScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oTableScanner.Scan(m_ConnectionString);
oTableScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oTableScanner.ScanDeleted -= new ScanAllTables.ScanObjectDeleted(ScanObjectDeleted_Handler);
oTableScanner.ScanNotFound -= new ScanAllTables.ScanObjectNotFound(ScanObjectNotFound_Handler);
oTableScanner.ScanChanged -= new ScanAllTables.ScanObjectChanged(ScanObjectChanged_Handler);
oTableScanner.ScanBegin -= new ScanAllTables.ScanObjectBegin(ScanObjectBegin_Handler);
ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.TABLENODE, DateTime.Now);
if (oTableScanner.ChangesFound)
{
ChangesFound = true;
}
//scan all triggers
ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.TRIGGERNODE, DateTime.Now);
ScanAllTriggers oTriggerScanner = new ScanAllTriggers(m_DBID, oVersion.VersionID);
oTriggerScanner.ScanBegin += new ScanAllTriggers.ScanObjectBegin(ScanObjectBegin_Handler);
oTriggerScanner.ScanChanged += new ScanAllTriggers.ScanObjectChanged(ScanObjectChanged_Handler);
oTriggerScanner.ScanNotFound += new ScanAllTriggers.ScanObjectNotFound(ScanObjectNotFound_Handler);
oTriggerScanner.ScanDeleted += new ScanAllTriggers.ScanObjectDeleted(ScanObjectDeleted_Handler);
oTriggerScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oTriggerScanner.Scan(m_ConnectionString);
oTriggerScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oTriggerScanner.ScanDeleted += new ScanAllTriggers.ScanObjectDeleted(ScanObjectDeleted_Handler);
oTriggerScanner.ScanNotFound -= new ScanAllTriggers.ScanObjectNotFound(ScanObjectNotFound_Handler);
oTriggerScanner.ScanChanged -= new ScanAllTriggers.ScanObjectChanged(ScanObjectChanged_Handler);
oTriggerScanner.ScanBegin -= new ScanAllTriggers.ScanObjectBegin(ScanObjectBegin_Handler);
ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.TRIGGERNODE, DateTime.Now);
if (oTriggerScanner.ChangesFound)
{
ChangesFound = true;
}
//scan all views
ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.VIEWNODE, DateTime.Now);
ScanAllViews oViewScanner = new ScanAllViews(m_DBID, oVersion.VersionID);
oViewScanner.ScanBegin += new ScanAllViews.ScanObjectBegin(ScanObjectBegin_Handler);
oViewScanner.ScanChanged += new ScanAllViews.ScanObjectChanged(ScanObjectChanged_Handler);
oViewScanner.ScanNotFound += new ScanAllViews.ScanObjectNotFound(ScanObjectNotFound_Handler);
oViewScanner.ScanDeleted += new ScanAllViews.ScanObjectDeleted(ScanObjectDeleted_Handler);
oViewScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oViewScanner.Scan(m_ConnectionString);
oViewScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler);
oViewScanner.ScanDeleted += new ScanAllViews.ScanObjectDeleted(ScanObjectDeleted_Handler);
oViewScanner.ScanNotFound -= new ScanAllViews.ScanObjectNotFound(ScanObjectNotFound_Handler);
oViewScanner.ScanChanged -= new ScanAllViews.ScanObjectChanged(ScanObjectChanged_Handler);
oViewScanner.ScanBegin -= new ScanAllViews.ScanObjectBegin(ScanObjectBegin_Handler);
ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.VIEWNODE, DateTime.Now);
if (oViewScanner.ChangesFound)
{
ChangesFound = true;
}
//Scan complete
oVersion.ScanComplete = DateTime.Now.ToString();
oVersion.ChangesFound = ChangesFound;
oVersion.Save();
ScanDatabaseEnd(DateTime.Now);
}
