private void CreateAddedItemsTreeNodes(
ICollection <EntityStoreSchemaFilterEntry> tableEntries,
ICollection <EntityStoreSchemaFilterEntry> viewEntries,
ICollection <EntityStoreSchemaFilterEntry> storedProcEntries,
SortedDictionary <DatabaseObject, int> existingTables,
SortedDictionary <DatabaseObject, int> existingViews,
SortedDictionary <DatabaseObject, int> existingStoredProcs,
string storageEntityContainerName)
{
var newTables = NotPreviouslyExistingNodes(tableEntries, storageEntityContainerName, existingTables);
var newViews = NotPreviouslyExistingNodes(viewEntries, storageEntityContainerName, existingViews);
var newSprocs = NotPreviouslyExistingNodes(storedProcEntries, storageEntityContainerName, existingStoredProcs);
var addedTablesNode = DatabaseObjectTreeView.CreateRootNodeAndDescendents(
newTables, Resources.SelectTablesPage_TablesNode, DatabaseObjectTreeView.TreeViewImage.DbTablesImage,
DatabaseObjectTreeView.TreeViewImage.TableImage);
var addedViewsNode = DatabaseObjectTreeView.CreateRootNodeAndDescendents(
newViews, Resources.SelectTablesPage_ViewsNode, DatabaseObjectTreeView.TreeViewImage.DbViewsImage,
DatabaseObjectTreeView.TreeViewImage.ViewImage);
var addedSprocsNode = DatabaseObjectTreeView.CreateRootNodeAndDescendents(
newSprocs, Resources.SelectTablesPage_StoredProceduresNode, DatabaseObjectTreeView.TreeViewImage.DbStoreProcsImage,
DatabaseObjectTreeView.TreeViewImage.StoreProcImage);
AddTreeView.TreeViewControl.Nodes.Add(addedTablesNode);
AddTreeView.TreeViewControl.Nodes.Add(addedViewsNode);
AddTreeView.TreeViewControl.Nodes.Add(addedSprocsNode);
// if there are _new_ Sproc entries then enable the Create Function Imports box and by default set to checked
if (newSprocs.Count > 0)
{
chkCreateFunctionImports.Enabled = true;
chkCreateFunctionImports.Checked = true;
}
}
private void CreateTreeForNewModel(
ICollection <EntityStoreSchemaFilterEntry> tableEntries,
ICollection <EntityStoreSchemaFilterEntry> viewEntries, ICollection <EntityStoreSchemaFilterEntry> sprocEntries)
{
databaseObjectTreeView.TreeViewControl.Nodes.Add(
DatabaseObjectTreeView.CreateRootNodeAndDescendents(
tableEntries, ModelWizard.Properties.Resources.SelectTablesPage_TablesNode,
DatabaseObjectTreeView.TreeViewImage.DbTablesImage, DatabaseObjectTreeView.TreeViewImage.TableImage));
databaseObjectTreeView.TreeViewControl.Nodes.Add(
DatabaseObjectTreeView.CreateRootNodeAndDescendents(
viewEntries, ModelWizard.Properties.Resources.SelectTablesPage_ViewsNode,
DatabaseObjectTreeView.TreeViewImage.DbViewsImage, DatabaseObjectTreeView.TreeViewImage.ViewImage));
databaseObjectTreeView.TreeViewControl.Nodes.Add(
DatabaseObjectTreeView.CreateRootNodeAndDescendents(
sprocEntries, ModelWizard.Properties.Resources.SelectTablesPage_StoredProceduresNode,
DatabaseObjectTreeView.TreeViewImage.DbStoreProcsImage, DatabaseObjectTreeView.TreeViewImage.StoreProcImage));
}
private void CreateRefreshedAndDeletedItemsTreeNodes(
SortedDictionary <DatabaseObject, int> existingTables,
SortedDictionary <DatabaseObject, int> existingViews,
SortedDictionary <DatabaseObject, int> existingStoredProcs,
Dictionary <DatabaseObject, EntityStoreSchemaFilterEntry> tablesFromDB,
Dictionary <DatabaseObject, EntityStoreSchemaFilterEntry> viewsFromDB,
Dictionary <DatabaseObject, EntityStoreSchemaFilterEntry> storedProcsFromDB)
{
// setup top-level Tables, Views and Sprocs nodes for RefreshTree
var refreshedTablesNode =
DatabaseObjectTreeView.CreateTreeNode(
Resources.SelectTablesPage_TablesNode, false, null, Resources.SelectTablesPage_TablesNode,
DatabaseObjectTreeView.TreeViewImage.DbTablesImage, Resources.SelectTablesPage_TablesNode);
var refreshedViewsNode =
DatabaseObjectTreeView.CreateTreeNode(
Resources.SelectTablesPage_ViewsNode, false, null, Resources.SelectTablesPage_ViewsNode,
DatabaseObjectTreeView.TreeViewImage.DbViewsImage, Resources.SelectTablesPage_ViewsNode);
var refreshedSprocsNode =
DatabaseObjectTreeView.CreateTreeNode(
Resources.SelectTablesPage_StoredProceduresNode, false, null, Resources.SelectTablesPage_StoredProceduresNode,
DatabaseObjectTreeView.TreeViewImage.DbStoreProcsImage, Resources.SelectTablesPage_StoredProceduresNode);
RefreshTreeView.TreeViewControl.Nodes.Add(refreshedTablesNode);
RefreshTreeView.TreeViewControl.Nodes.Add(refreshedViewsNode);
RefreshTreeView.TreeViewControl.Nodes.Add(refreshedSprocsNode);
// setup top-level Tables, Views and Sprocs nodes for DeleteTree
var deletedTablesNode =
DatabaseObjectTreeView.CreateTreeNode(
Resources.SelectTablesPage_TablesNode, false, null, Resources.SelectTablesPage_TablesNode,
DatabaseObjectTreeView.TreeViewImage.DbTablesImage, Resources.SelectTablesPage_TablesNode);
var deletedViewsNode =
DatabaseObjectTreeView.CreateTreeNode(
Resources.SelectTablesPage_ViewsNode, false, null, Resources.SelectTablesPage_ViewsNode,
DatabaseObjectTreeView.TreeViewImage.DbViewsImage, Resources.SelectTablesPage_ViewsNode);
var deletedSprocsNode =
DatabaseObjectTreeView.CreateTreeNode(
Resources.SelectTablesPage_StoredProceduresNode, false, null, Resources.SelectTablesPage_StoredProceduresNode,
DatabaseObjectTreeView.TreeViewImage.DbStoreProcsImage, Resources.SelectTablesPage_StoredProceduresNode);
DeleteTreeView.TreeViewControl.Nodes.Add(deletedTablesNode);
DeleteTreeView.TreeViewControl.Nodes.Add(deletedViewsNode);
DeleteTreeView.TreeViewControl.Nodes.Add(deletedSprocsNode);
// any entry in existingTables which also exists in tablesFromDB is about to be refreshed
// otherwise its about to be deleted
foreach (var table in existingTables.Keys)
{
if (tablesFromDB.ContainsKey(table))
{
DatabaseObjectTreeView.EnsureSchemaAndLeafNode(
refreshedTablesNode, table, DatabaseObjectTreeView.TreeViewImage.TableImage, tablesFromDB[table]);
}
else
{
DatabaseObjectTreeView.EnsureSchemaAndLeafNode(
deletedTablesNode, table, DatabaseObjectTreeView.TreeViewImage.TableImage, null);
}
}
// any entry in existingViews which also exists in viewsFromDB is about to be refreshed
// otherwise its about to be deleted
foreach (var view in existingViews.Keys)
{
if (viewsFromDB.ContainsKey(view))
{
DatabaseObjectTreeView.EnsureSchemaAndLeafNode(
refreshedViewsNode, view, DatabaseObjectTreeView.TreeViewImage.ViewImage, viewsFromDB[view]);
}
else
{
DatabaseObjectTreeView.EnsureSchemaAndLeafNode(
deletedViewsNode, view, DatabaseObjectTreeView.TreeViewImage.ViewImage, null);
}
}
// similarly any entry in existingStoredProcNames which also exists in storedProcsFromDB is about to be refreshed
foreach (var storedProc in existingStoredProcs.Keys)
{
if (storedProcsFromDB.ContainsKey(storedProc))
{
DatabaseObjectTreeView.EnsureSchemaAndLeafNode(
refreshedSprocsNode, storedProc, DatabaseObjectTreeView.TreeViewImage.StoreProcImage, storedProcsFromDB[storedProc]);
}
else
{
DatabaseObjectTreeView.EnsureSchemaAndLeafNode(
deletedSprocsNode, storedProc, DatabaseObjectTreeView.TreeViewImage.StoreProcImage, null);
}
}
}