private void RefreshStoredProcedure(ObjectExplorerNode selectedNode, int indexOfNodeToReplace)
{
if (selectedNode.Data is StoredProcedure storedProcedure)
{
storedProcedure.Refresh();
_objectExplorerDataSource.DataSource[indexOfNodeToReplace] = ObjectExplorerNodeFactory.CreateStoredProcedureNode(
selectedNode.Id, selectedNode.ParentId,
storedProcedure);
}
}
private void RefreshFunction(ObjectExplorerNode selectedNode, int indexOfNodeToReplace)
{
if (selectedNode.Data is UserDefinedFunction function)
{
function.Refresh();
_objectExplorerDataSource.DataSource[indexOfNodeToReplace] = ObjectExplorerNodeFactory.CreateFunctionNode(
selectedNode.Id, selectedNode.ParentId,
function);
}
}
private void RefreshColumn(ObjectExplorerNode selectedNode, int indexOfNodeToReplace)
{
if (selectedNode.Data is Column column)
{
column.Refresh();
_objectExplorerDataSource.DataSource[indexOfNodeToReplace] = ObjectExplorerNodeFactory.CreateColumnNode(selectedNode.Id,
selectedNode.ParentId,
column);
}
}
public void GenerateInstances()
{
foreach (var instance in App.Connection.CurrentConnections.Select(x => x.Instance).ToList())
{
if (InstanceAlreadyInDataSource(instance))
{
continue;
}
var serverInstance = App.Connection.GetServerAtInstanceName(instance);
DataSource.Add(ObjectExplorerNodeFactory.CreateServerNode(GetNewNodeId(), serverInstance));
}
}
private void CreateSystemDatabaseNodes(ObjectExplorerNode model)
{
if (!(model.Data is Server server))
{
return;
}
foreach (Database db in server.Databases)
{
if (systemDatabaseNames.Contains(db.Name)) //TODO - This is probably not the most elegant way to handle this...
{
DataSource.Add(ObjectExplorerNodeFactory.CreateDatabaseNode(GetNewNodeId(), model.Id, db));
}
}
}
private void CreateFolderNodesForDatabase(ObjectExplorerNode model)
{
if (!(model.Data is Database))
{
return;
}
DataSource.Add(ObjectExplorerNodeFactory.CreateFolderNode(GetNewNodeId(), GlobalStrings.FolderTypes.TableFolder,
model));
DataSource.Add(ObjectExplorerNodeFactory.CreateFolderNode(GetNewNodeId(), GlobalStrings.FolderTypes.ViewFolder,
model));
DataSource.Add(ObjectExplorerNodeFactory.CreateFolderNode(GetNewNodeId(),
GlobalStrings.FolderTypes.StoreProcedureFolder, model));
DataSource.Add(ObjectExplorerNodeFactory.CreateFolderNode(GetNewNodeId(),
GlobalStrings.FolderTypes.FunctionsFolder, model));
}
private void CreateColumnNodes(ObjectExplorerNode model)
{
if (!(model.Data is Table table))
{
return;
}
if (table.Columns.Count <= 0)
{
CreateEmptyNode(model);
return;
}
foreach (Column column in table.Columns)
{
DataSource.Add(ObjectExplorerNodeFactory.CreateColumnNode(GetNewNodeId(), model.Id, column));
}
}
private void CreateFunctionNodes(ObjectExplorerNode model)
{
if (!(model.Data is Database database))
{
return;
}
if ((database.UserDefinedFunctions.Count <= 0))
{
CreateEmptyNode(model);
return;
}
foreach (UserDefinedFunction function in database.UserDefinedFunctions)
{
DataSource.Add(ObjectExplorerNodeFactory.CreateFunctionNode(GetNewNodeId(), model.Id, function));
}
}
private void CreateSystemStoredProcedureNodes(ObjectExplorerNode model)
{
if (!(model.Data is Database database))
{
return;
}
if ((database.StoredProcedures.Count <= 0))
{
CreateEmptyNode(model);
return;
}
foreach (StoredProcedure storedProcedure in database.StoredProcedures.Cast <StoredProcedure>().Where(r => r.IsSystemObject))
{
DataSource.Add(ObjectExplorerNodeFactory.CreateStoredProcedureNode(GetNewNodeId(), model.Id, storedProcedure));
}
}
private void CreateViewNodes(ObjectExplorerNode model)
{
if (!(model.Data is Database database))
{
return;
}
if ((database.Views.Count <= 0))
{
CreateEmptyNode(model);
return;
}
foreach (View view in database.Views)
{
DataSource.Add(ObjectExplorerNodeFactory.CreateViewNode(GetNewNodeId(), model.Id, view));
}
}
private void CreateTableNodes(ObjectExplorerNode model)
{
if (!(model.Data is Database database))
{
return;
}
if (database.Tables.Count <= 0)
{
CreateEmptyNode(model);
return;
}
foreach (Table table in database.Tables)
{
DataSource.Add(ObjectExplorerNodeFactory.CreateTableNode(GetNewNodeId(), model.Id, table));
}
}
private void CreateUserDatabaseNodes(ObjectExplorerNode model)
{
if (!(model.Data is Server server))
{
return;
}
if (server.Databases.Count <= 0)
{
CreateEmptyNode(model);
return;
}
DataSource.Add(ObjectExplorerNodeFactory.CreateFolderNode(GetNewNodeId(), GlobalStrings.FolderTypes.SystemDatabaseFolder, model));
foreach (Database db in server.Databases) //TODO - This is probably not the most elegant way to handle this...
{
if (!systemDatabaseNames.Contains(db.Name))
{
DataSource.Add(ObjectExplorerNodeFactory.CreateDatabaseNode(GetNewNodeId(), model.Id, db));
}
}
}
private void CreateStoredProcedureNodes(ObjectExplorerNode model)
{
if (!(model.Data is Database database))
{
return;
}
if ((database.StoredProcedures.Count <= 0))
{
CreateEmptyNode(model);
return;
}
DataSource.Add(ObjectExplorerNodeFactory.CreateFolderNode(GetNewNodeId(), GlobalStrings.FolderTypes.SystemStoredProcedureFolder, model));
var nonSystemStoredProcedures = database.StoredProcedures.Cast <StoredProcedure>()
.Where(r => r.IsSystemObject == false).ToList();
foreach (var storedProcedure in nonSystemStoredProcedures)
{
DataSource.Add(ObjectExplorerNodeFactory.CreateStoredProcedureNode(GetNewNodeId(), model.Id, storedProcedure));
}
}
public void CreateEmptyNode(ObjectExplorerNode model)
{
DataSource.Add(ObjectExplorerNodeFactory.CreateNothingNode(GetNewNodeId(), model));
}
