public void Update()
{
AGENT.DBDescriptionAgent_Factory oDescriptionFactory = new AGENT.DBDescriptionAgent_Factory(DBID: m_DBID);
DescriptionUpdateBegin(DateTime.Now);
TypeDescriptionUpdate(UTIL.Constants.FUNCTIONNODE.ToString(), DateTime.Now);
using (SQLAutoDocLib.BLL.Function_Factory oFunction_Factory = new SQLAutoDocLib.BLL.Function_Factory())
foreach (BLL.Function oFunction in oFunction_Factory.ListAllFunctionsInDatabase(DBID: m_DBID))
{
oDescriptionFactory.UpdateFunctionDescription(
Name: oFunction.Name,
Description: oFunction.Description);
}
TypeDescriptionUpdate(UTIL.Constants.PROCEDURENODE.ToString(), DateTime.Now);
using (SQLAutoDocLib.BLL.Procedure_Factory oProcedure_Factory = new SQLAutoDocLib.BLL.Procedure_Factory())
foreach (BLL.Procedure oProcedure in oProcedure_Factory.ListAllProceduresInDatabase(DBID:m_DBID))
{
oDescriptionFactory.UpdateProcedureDescription(
Name: oProcedure.Name,
Description: oProcedure.Description);
}
TypeDescriptionUpdate(UTIL.Constants.TABLENODE.ToString(), DateTime.Now);
using (SQLAutoDocLib.BLL.Table_Factory oTable_Factory = new SQLAutoDocLib.BLL.Table_Factory())
foreach (BLL.Table oTable in oTable_Factory.ListAllTablesInDatabase(DBID:m_DBID))
{
oDescriptionFactory.UpdateTableDescription(
Name: oTable.Name,
Description: oTable.Description);
}
TypeDescriptionUpdate(UTIL.Constants.VIEWNODE.ToString(), DateTime.Now);
using (SQLAutoDocLib.BLL.View_Factory oView_Factory = new SQLAutoDocLib.BLL.View_Factory())
foreach (BLL.View oView in oView_Factory.ListAllViewsInDatabase(DBID:m_DBID))
{
oDescriptionFactory.UpdateViewDescription(
Name: oView.Name,
Description: oView.Description);
}
/*
* Can't update trigger descriptions at this time...
* SQLAutoDocLib.BLL.Trigger_Factory oTrigger_Factory = new SQLAutoDocLib.BLL.Trigger_Factory();
* oFunction_Factory.UpdateExtendedDescriptions(DBID: m_DBID);
* Application.DoEvents();
* */
DescriptionUpdateEnd(DateTime.Now);
}
public static void ShowViewDetail(
System.Windows.Forms.Form oParent,
Guid DBID,
string VersionID,
string ViewName)
{
SQLAutoDocLib.BLL.View_Factory oFactory = new SQLAutoDocLib.BLL.View_Factory();
SQLAutoDocLib.BLL.View oView = oFactory.GetViewByName(DBID: DBID, ViewName: ViewName, VersionID: VersionID);
StringReader oReader = new StringReader(oView.Configuration);
XPathDocument oMyDoc = new XPathDocument(oReader);
XslCompiledTransform oProcessor = new XslCompiledTransform();
string sXSL = GetResourceTextFile(oParent, "SQLAutoDoc.xsl.view.xsl");
oProcessor.Load(XmlReader.Create(new StringReader(sXSL)));
StringBuilder oBuffer = new StringBuilder();
StringWriter oSWriter = new StringWriter(oBuffer);
oProcessor.Transform(
XmlReader.Create(new StringReader(oView.Configuration)),
null,
oSWriter);
SetFormFields(
oParent: oParent,
VersionID: VersionID,
Name: ViewName,
Desc: oView.Description,
FirstDate: oView.FindFirstVersion,
LastDate: oView.FindLastVersion,
HTML: oSWriter.ToString());
oSWriter.Flush();
oSWriter.Dispose();
Application.DoEvents();
}
private void InitTree(string VersionID)
{
string sCurrentVersion = CurrentVersion();
ClearTree();
if (VersionID.Length > 0)
{
try
{
TreeNode oDatabase = GetNodeByKey(tvwObject.Nodes, SQLAutoDocLib.UTIL.Constants.DATABASENODE);
//Add tables
SQLAutoDocLib.BLL.Table_Factory oTableFactory = new SQLAutoDocLib.BLL.Table_Factory();
List <SQLAutoDocLib.BLL.Table> oTableList = oTableFactory.ListAllTablesInDatabase(
DBID: m_DBID,
VersionID: sCurrentVersion,
ChangedOnly: false);
TreeNode oTablesNode = GetNodeByKey(oDatabase.Nodes, SQLAutoDocLib.UTIL.Constants.TABLENODE);
foreach (SQLAutoDocLib.BLL.Table oTable in oTableList)
{
if (chkShowChangesOnly.Checked == false || oTable.ChangedInLastScan == true)
{
TreeNode oTableNode = oTablesNode.Nodes.Add(oTable.Name, oTable.Name, imageIndex: (int)ImageKeys.table);
oTableNode.SelectedImageIndex = (int)ImageKeys.table_go;
if (oTable.ChangedInLastScan == true)
{
if (oTable.CurrentlyExists == false)
{
oTableNode.ImageIndex = (int)ImageKeys.table_delete;
oTableNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
else
{
oTableNode.ImageIndex = (int)ImageKeys.table_edit;
oTableNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
}
}
}
//Add views
SQLAutoDocLib.BLL.View_Factory oViewFactory = new SQLAutoDocLib.BLL.View_Factory();
List <SQLAutoDocLib.BLL.View> oViewList = oViewFactory.ListAllViewsInDatabase(
DBID: m_DBID,
VersionID: sCurrentVersion,
ChangedOnly: false);
TreeNode oViewsNode = GetNodeByKey(oDatabase.Nodes, SQLAutoDocLib.UTIL.Constants.VIEWNODE);
foreach (SQLAutoDocLib.BLL.View oView in oViewList)
{
if (chkShowChangesOnly.Checked == false || oView.ChangedInLastScan == true)
{
TreeNode oViewNode = oViewsNode.Nodes.Add(oView.Name, oView.Name, imageIndex: (int)ImageKeys.table);
oViewNode.SelectedImageIndex = (int)ImageKeys.table_go;
if (oView.ChangedInLastScan == true)
{
if (oView.CurrentlyExists == false)
{
oViewNode.ImageIndex = (int)ImageKeys.table_delete;
oViewNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
else
{
oViewNode.ImageIndex = (int)ImageKeys.table_edit;
oViewNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
}
}
}
//Add procs
SQLAutoDocLib.BLL.Procedure_Factory oProcFactory = new SQLAutoDocLib.BLL.Procedure_Factory();
List <SQLAutoDocLib.BLL.Procedure> oProcList = oProcFactory.ListAllProceduresInDatabase(
DBID: m_DBID,
VersionID: sCurrentVersion,
ChangedOnly: false);
TreeNode oProcsNode = GetNodeByKey(oDatabase.Nodes, SQLAutoDocLib.UTIL.Constants.PROCEDURENODE);
foreach (SQLAutoDocLib.BLL.Procedure oProc in oProcList)
{
if (chkShowChangesOnly.Checked == false || oProc.ChangedInLastScan == true)
{
TreeNode oProcNode = oProcsNode.Nodes.Add(oProc.Name, oProc.Name, imageIndex: (int)ImageKeys.table);
oProcNode.SelectedImageIndex = (int)ImageKeys.table_go;
if (oProc.ChangedInLastScan == true)
{
if (oProc.CurrentlyExists == false)
{
oProcNode.ImageIndex = (int)ImageKeys.table_delete;
oProcNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
else
{
oProcNode.ImageIndex = (int)ImageKeys.table_edit;
oProcNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
}
}
}
//Add functions
SQLAutoDocLib.BLL.Function_Factory oFunctionFactory = new SQLAutoDocLib.BLL.Function_Factory();
List <SQLAutoDocLib.BLL.Function> oFunctionList = oFunctionFactory.ListAllFunctionsInDatabase(
DBID: m_DBID,
VersionID: sCurrentVersion,
ChangedOnly: false);
TreeNode oFunctionsNode = GetNodeByKey(oDatabase.Nodes, SQLAutoDocLib.UTIL.Constants.FUNCTIONNODE);
foreach (SQLAutoDocLib.BLL.Function oFunction in oFunctionList)
{
if (chkShowChangesOnly.Checked == false || oFunction.ChangedInLastScan == true)
{
TreeNode oFunctionNode = oFunctionsNode.Nodes.Add(oFunction.Name, oFunction.Name, imageIndex: (int)ImageKeys.table);
oFunctionsNode.SelectedImageIndex = (int)ImageKeys.table_go;
if (oFunction.ChangedInLastScan == true)
{
if (oFunction.CurrentlyExists == false)
{
oFunctionsNode.ImageIndex = (int)ImageKeys.table_delete;
oFunctionsNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
else
{
oFunctionsNode.ImageIndex = (int)ImageKeys.table_edit;
oFunctionNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
}
}
}
//Add triggers
SQLAutoDocLib.BLL.Trigger_Factory oTriggerFactory = new SQLAutoDocLib.BLL.Trigger_Factory();
List <SQLAutoDocLib.BLL.Trigger> oTriggerList = oTriggerFactory.ListAllTriggersInDatabase(
DBID: m_DBID,
VersionID: sCurrentVersion,
ChangedOnly: false);
TreeNode oTriggersNode = GetNodeByKey(oDatabase.Nodes, SQLAutoDocLib.UTIL.Constants.TRIGGERNODE);
foreach (SQLAutoDocLib.BLL.Trigger oTrigger in oTriggerList)
{
if (chkShowChangesOnly.Checked == false || oTrigger.ChangedInLastScan == true)
{
TreeNode oTriggerNode = oTriggersNode.Nodes.Add(oTrigger.Name, oTrigger.Name, imageIndex: (int)ImageKeys.table);
oTriggersNode.SelectedImageIndex = (int)ImageKeys.table_go;
if (oTrigger.ChangedInLastScan == true)
{
if (oTrigger.CurrentlyExists == false)
{
oTriggersNode.ImageIndex = (int)ImageKeys.table_delete;
oTriggersNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
else
{
oTriggersNode.ImageIndex = (int)ImageKeys.table_edit;
oTriggersNode.Parent.ImageIndex = (int)ImageKeys.table_edit;
}
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
private void ShowDesc()
{
string VersionID = cmbVersion.SelectedValue.ToString();
TreeNode CurrentNode = tvwObject.SelectedNode;
if (CurrentNode.Parent != null)
{
if (CurrentNode.Parent.Name == SQLAutoDocLib.UTIL.Constants.TABLENODE)
{
SQLAutoDocLib.BLL.Table_Factory oFactory = new SQLAutoDocLib.BLL.Table_Factory();
SQLAutoDocLib.BLL.Table oTable = oFactory.GetTableByName(DBID: m_DBID, TableName: CurrentNode.Name, VersionID: VersionID);
frmDesc oForm = new frmDesc(
ObjectName: CurrentNode.Name,
ObjectDesc: oTable.Description,
ObjectType: SQLAutoDocLib.UTIL.ObjectType.Table);
if (oForm.ShowDialog() == DialogResult.OK)
{
oTable.Load();
oTable.Description = oForm.Desc;
oTable.Save();
txtDesc.Text = oForm.Desc;
}
}
else if (CurrentNode.Parent.Name == SQLAutoDocLib.UTIL.Constants.VIEWNODE)
{
SQLAutoDocLib.BLL.View_Factory oFactory = new SQLAutoDocLib.BLL.View_Factory();
SQLAutoDocLib.BLL.View oView = oFactory.GetViewByName(DBID: m_DBID, ViewName: CurrentNode.Name, VersionID: VersionID);
frmDesc oForm = new frmDesc(
ObjectName: CurrentNode.Name,
ObjectDesc: oView.Description,
ObjectType: SQLAutoDocLib.UTIL.ObjectType.View);
if (oForm.ShowDialog() == DialogResult.OK)
{
oView.Load();
oView.Description = oForm.Desc;
oView.Save();
txtDesc.Text = oForm.Desc;
}
}
else if (CurrentNode.Parent.Name == SQLAutoDocLib.UTIL.Constants.TRIGGERNODE)
{
SQLAutoDocLib.BLL.Trigger_Factory oFactory = new SQLAutoDocLib.BLL.Trigger_Factory();
SQLAutoDocLib.BLL.Trigger oTrigger = oFactory.GetTriggerByName(DBID: m_DBID, TriggerName: CurrentNode.Name, VersionID: VersionID);
frmDesc oForm = new frmDesc(
ObjectName: CurrentNode.Name,
ObjectDesc: oTrigger.Description,
ObjectType: SQLAutoDocLib.UTIL.ObjectType.Trigger);
if (oForm.ShowDialog() == DialogResult.OK)
{
oTrigger.Load();
oTrigger.Description = oForm.Desc;
oTrigger.Save();
txtDesc.Text = oForm.Desc;
}
}
else if (CurrentNode.Parent.Name == SQLAutoDocLib.UTIL.Constants.PROCEDURENODE)
{
SQLAutoDocLib.BLL.Procedure_Factory oFactory = new SQLAutoDocLib.BLL.Procedure_Factory();
SQLAutoDocLib.BLL.Procedure oProcedure = oFactory.GetProcedureByName(DBID: m_DBID, ProcedureName: CurrentNode.Name, VersionID: VersionID);
frmDesc oForm = new frmDesc(
ObjectName: CurrentNode.Name,
ObjectDesc: oProcedure.Description,
ObjectType: SQLAutoDocLib.UTIL.ObjectType.Procedure);
if (oForm.ShowDialog() == DialogResult.OK)
{
oProcedure.Load();
oProcedure.Description = oForm.Desc;
oProcedure.Save();
txtDesc.Text = oForm.Desc;
}
}
else if (CurrentNode.Parent.Name == SQLAutoDocLib.UTIL.Constants.FUNCTIONNODE)
{
SQLAutoDocLib.BLL.Function_Factory oFactory = new SQLAutoDocLib.BLL.Function_Factory();
SQLAutoDocLib.BLL.Function oFunction = oFactory.GetFunctionByName(DBID: m_DBID, FunctionName: CurrentNode.Name, VersionID: VersionID);
frmDesc oForm = new frmDesc(
ObjectName: CurrentNode.Name,
ObjectDesc: oFunction.Description,
ObjectType: SQLAutoDocLib.UTIL.ObjectType.Function);
if (oForm.ShowDialog() == DialogResult.OK)
{
oFunction.Load();
oFunction.Description = oForm.Desc;
oFunction.Save();
txtDesc.Text = oForm.Desc;
}
}
}
}
public void ShowVersion()
{
this.Show();
this.TopMost = true;
this.UseWaitCursor = true;
lblVersion.Text = m_Version;
//Add tables
SQLAutoDocLib.BLL.Table_Factory oTableFactory = new SQLAutoDocLib.BLL.Table_Factory();
List <SQLAutoDocLib.BLL.Table> oTableList = oTableFactory.ListAllTablesInDatabase(m_DBID, m_Version, ChangedOnly: true);
foreach (SQLAutoDocLib.BLL.Table oTable in oTableList)
{
ListViewItem oItem = new ListViewItem(text: oTable.Name);
oItem.Tag = oTable;
oItem.Group = lvwDifferences.Groups[0];
lvwDifferences.Items.Add(oItem);
}
//Add views
SQLAutoDocLib.BLL.View_Factory oViewFactory = new SQLAutoDocLib.BLL.View_Factory();
List <SQLAutoDocLib.BLL.View> oViewList = oViewFactory.ListAllViewsInDatabase(m_DBID, m_Version, ChangedOnly: true);
foreach (SQLAutoDocLib.BLL.View oView in oViewList)
{
ListViewItem oItem = new ListViewItem(text: oView.Name);
oItem.Tag = oView;
oItem.Group = lvwDifferences.Groups[1];
lvwDifferences.Items.Add(oItem);
}
//Add procs
SQLAutoDocLib.BLL.Procedure_Factory oProcFactory = new SQLAutoDocLib.BLL.Procedure_Factory();
List <SQLAutoDocLib.BLL.Procedure> oProcList = oProcFactory.ListAllProceduresInDatabase(m_DBID, m_Version, ChangedOnly: true);
foreach (SQLAutoDocLib.BLL.Procedure oProc in oProcList)
{
ListViewItem oItem = new ListViewItem(text: oProc.Name);
oItem.Tag = oProc;
oItem.Group = lvwDifferences.Groups[2];
lvwDifferences.Items.Add(oItem);
}
//Add functions
SQLAutoDocLib.BLL.Function_Factory oFunctionFactory = new SQLAutoDocLib.BLL.Function_Factory();
List <SQLAutoDocLib.BLL.Function> oFunctionList = oFunctionFactory.ListAllFunctionsInDatabase(m_DBID, m_Version, ChangedOnly: true);
foreach (SQLAutoDocLib.BLL.Function oFunction in oFunctionList)
{
ListViewItem oItem = new ListViewItem(text: oFunction.Name);
oItem.Tag = oFunction;
oItem.Group = lvwDifferences.Groups[3];
lvwDifferences.Items.Add(oItem);
}
//Add triggers
SQLAutoDocLib.BLL.Trigger_Factory oTriggerFactory = new SQLAutoDocLib.BLL.Trigger_Factory();
List <SQLAutoDocLib.BLL.Trigger> oTriggerList = oTriggerFactory.ListAllTriggersInDatabase(m_DBID, m_Version, ChangedOnly: true);
foreach (SQLAutoDocLib.BLL.Trigger oTrigger in oTriggerList)
{
ListViewItem oItem = new ListViewItem(text: oTrigger.Name);
oItem.Tag = oTrigger;
oItem.Group = lvwDifferences.Groups[4];
lvwDifferences.Items.Add(oItem);
}
this.UseWaitCursor = false;
}
private void SaveScript(string sFileName)
{
using (StreamWriter oSW = new StreamWriter(path: sFileName, append: false))
{
oSW.WriteLine("/* VERSION: " + m_Version + " */");
foreach (ListViewItem oItem in lvwDifferences.Items)
{
if (oItem.Checked == true)
{
object oValue = oItem.Tag;
string sTypeName = oValue.GetType().ToString();
if (oValue.GetType() == typeof(SQLAutoDocLib.BLL.Table))
{
//This is a table
SQLAutoDocLib.BLL.Table oTable = (SQLAutoDocLib.BLL.Table)oValue;
if (oTable.CurrentlyExists == true)
{
oSW.WriteLine("/* ALTER */");
}
else
{
oSW.WriteLine("/* CREATE */");
}
SQLAutoDocLib.BLL.Table_Factory oFactory = new SQLAutoDocLib.BLL.Table_Factory();
oSW.WriteLine(oFactory.Reconstitute(oTable));
}
else if (oValue.GetType() == typeof(SQLAutoDocLib.BLL.View))
{
//This is a view
SQLAutoDocLib.BLL.View oView = (SQLAutoDocLib.BLL.View)oValue;
SQLAutoDocLib.BLL.View_Factory oFactory = new SQLAutoDocLib.BLL.View_Factory();
oSW.WriteLine(oFactory.Reconstitute(oView));
}
else if (oValue.GetType() == typeof(SQLAutoDocLib.BLL.Function))
{
//This is a function
SQLAutoDocLib.BLL.Function oFunction = (SQLAutoDocLib.BLL.Function)oValue;
SQLAutoDocLib.BLL.Function_Factory oFactory = new SQLAutoDocLib.BLL.Function_Factory();
oSW.WriteLine(oFactory.Reconstitute(oFunction));
}
else if (oValue.GetType() == typeof(SQLAutoDocLib.BLL.Procedure))
{
//This is a procedure
SQLAutoDocLib.BLL.Procedure oProcedure = (SQLAutoDocLib.BLL.Procedure)oValue;
SQLAutoDocLib.BLL.Procedure_Factory oFactory = new SQLAutoDocLib.BLL.Procedure_Factory();
oSW.WriteLine(oFactory.Reconstitute(oProcedure));
}
else if (oValue.GetType() == typeof(SQLAutoDocLib.BLL.Trigger))
{
//This is a trigger
SQLAutoDocLib.BLL.Trigger oTrigger = (SQLAutoDocLib.BLL.Trigger)oValue;
SQLAutoDocLib.BLL.Trigger_Factory oFactory = new SQLAutoDocLib.BLL.Trigger_Factory();
oSW.WriteLine(oFactory.Reconstitute(oTrigger));
}
}
}
}
}
