private CustomNode GenerateServerNode()
{
int count = 0;
int totalCount = GetTotalCount();
CustomNode serverNode = new CustomNode(NodeType.Server, null, ConfigHandler.ServerName, NodeImage.ServerDatabase, 0);
NodeDataGenerator.GenerateDatabaseNode(serverNode, _databaseOperation.GetDatabaseName(), 0);
if (_objectsSelectorForm.IncludeObjectType(NodeType.Tables) || ((_fileFormat == "sql" || _fileFormat == "xls") && (_objectsSelectorForm.tableColumnsCheckBox.Checked || _objectsSelectorForm.tableKeysCheckBox.Checked || _objectsSelectorForm.tableConstraintsCheckBox.Checked || _objectsSelectorForm.tableTriggersCheckBox.Checked || _objectsSelectorForm.tableIndexesCheckBox.Checked)))
{
CustomNode tablesNode = (CustomNode)serverNode.Nodes[0].Nodes["Tables"];
NodeDataGenerator.GenerateTablesNode(tablesNode, _databaseOperation);
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableColumns))
{
ExportTableColumns(tablesNode, ++count, totalCount);
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableKeys))
{
ExportTableKeys(tablesNode, ++count, totalCount);
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableConstraints))
{
ExportTableConstraints(tablesNode, ++count, totalCount);
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableTriggers))
{
ExportTableTriggers(tablesNode, ++count, totalCount);
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableIndexes))
{
ExportTableIndexes(tablesNode, ++count, totalCount);
}
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.Views) || ((_fileFormat == "sql" || _fileFormat == "xls") && (_objectsSelectorForm.viewColumnsCheckBox.Checked || _objectsSelectorForm.viewTriggersCheckBox.Checked || _objectsSelectorForm.viewIndexesCheckBox.Checked)))
{
CustomNode viewsNode = (CustomNode)serverNode.Nodes[0].Nodes["Views"];
NodeDataGenerator.GenerateViewsNode(viewsNode, _databaseOperation);
if (_objectsSelectorForm.IncludeObjectType(NodeType.ViewColumns))
{
ExportViewColumns(viewsNode, ++count, totalCount);
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.ViewTriggers))
{
ExportViewTriggers(viewsNode, ++count, totalCount);
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.ViewIndexes))
{
ExportViewIndexes(viewsNode, ++count, totalCount);
}
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.StoredProcedures) || ((_fileFormat == "sql" || _fileFormat == "xls") && (_objectsSelectorForm.storedProcedureParametersCheckBox.Checked)))
{
CustomNode proceduresNode = (CustomNode)serverNode.Nodes[0].Nodes["Programmability"].Nodes["Stored Procedures"];
NodeDataGenerator.GenerateProceduresNode(proceduresNode, _databaseOperation);
if (_objectsSelectorForm.IncludeObjectType(NodeType.StoredProcedureParameters))
{
ExportStoredProcedureParameters(proceduresNode, ++count, totalCount);
}
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableValuedFunctions) || ((_fileFormat == "sql" || _fileFormat == "xls") && (_objectsSelectorForm.tableValuedFunctionParametersCheckBox.Checked)))
{
CustomNode tableValuedFunctionsNode = (CustomNode)serverNode.Nodes[0].Nodes["Programmability"].Nodes["Functions"].Nodes["Table-valued Functions"];
NodeDataGenerator.GenerateTableValuedFunctionsNode(tableValuedFunctionsNode, _databaseOperation);
if (_objectsSelectorForm.IncludeObjectType(NodeType.TableValuedFunctionParameters))
{
ExportTableValuedFunctionParameters(tableValuedFunctionsNode, ++count, totalCount);
}
}
if (_objectsSelectorForm.IncludeObjectType(NodeType.ScalarValuedFunctions) || ((_fileFormat == "sql" || _fileFormat == "xls") && (_objectsSelectorForm.scalarValuedFunctionParametersCheckBox.Checked)))
{
CustomNode scalarValuedFunctionsNode = (CustomNode)serverNode.Nodes[0].Nodes["Programmability"].Nodes["Functions"].Nodes["Scalar-valued Functions"];
NodeDataGenerator.GenerateScalarValuedFunctionsNode(scalarValuedFunctionsNode, _databaseOperation);
if (_objectsSelectorForm.IncludeObjectType(NodeType.ScalarValuedFunctionParameters))
{
ExportScalarValuedFunctionParameters(scalarValuedFunctionsNode, ++count, totalCount);
}
}
return(serverNode);
}
