private TreeNode[] GetChildNodes(DbObjectTypes dbObjectType)
{
switch (dbObjectType)
{
case DbObjectTypes.Tables:
return(GetTables().Select(x =>
{
var folderNodes = new TreeNode(" " + x.Name,
new TreeNode[] {
new TreeNode("Columns", 1, 1, GetColumnsForTablesInTreeview(x)),
//new TreeNode("Keys", 1, 1)
});
folderNodes.ImageIndex = 3;
folderNodes.SelectedImageIndex = 3;
folderNodes.Tag = x;
return folderNodes;
}).ToArray());
case DbObjectTypes.Views:
return(GetViews().Select(x =>
{
var node = new TreeNode(" " + x.Name,
x.Columns.Select(y =>
{
var columnNode = new TreeNode(y.name);
columnNode.ImageIndex = 4;
columnNode.SelectedImageIndex = 4;
return columnNode;
}).ToArray());
node.ImageIndex = 3;
node.SelectedImageIndex = 3;
node.Tag = x;
return node;
}).ToArray());
case DbObjectTypes.StoredProcedures:
return(GetStoredProcedures().ToList().Select(x => new TreeNode(" " + x.Name)).ToArray());
case DbObjectTypes.TableValuedFunctions:
return(GetTableValuedFunctions().ToList().Select(x => new TreeNode(" " + x.Name)).ToArray());
default:
return(new TreeNode[0]);
}
}
public IEnumerable<TablesWithColumnsDto> GetDbObjects(DbObjectTypes dbObjectType)
{
switch(dbObjectType)
{
case DbObjectTypes.Tables:
return _retrieveDbObjectsRepository.GetTables();
case DbObjectTypes.StoredProcedures:
return _retrieveDbObjectsRepository.GetStoredProcedures();
case DbObjectTypes.Views:
return _retrieveDbObjectsRepository.GetViews();
case DbObjectTypes.TableValuedFunctions:
return _retrieveDbObjectsRepository.GetTableValuedFunctions();
default:
return new List<TablesWithColumnsDto>();
}
}
public IEnumerable <TablesWithColumnsDto> GetDbObjects(DbObjectTypes dbObjectType)
{
switch (dbObjectType)
{
case DbObjectTypes.Tables:
return(_retrieveDbObjectsRepository.GetTables());
case DbObjectTypes.StoredProcedures:
return(_retrieveDbObjectsRepository.GetStoredProcedures());
case DbObjectTypes.Views:
return(_retrieveDbObjectsRepository.GetViews());
case DbObjectTypes.TableValuedFunctions:
return(_retrieveDbObjectsRepository.GetTableValuedFunctions());
default:
return(new List <TablesWithColumnsDto>());
}
}
public static string GetDbObjectTypesDescription(this DbObjectTypes e)
{
switch (e)
{
case DbObjectTypes.Tables:
return("Tables");
case DbObjectTypes.Views:
return("Views");
case DbObjectTypes.StoredProcedures:
return("Stored Procedures");
case DbObjectTypes.TableValuedFunctions:
return("Table Valued Functions");
default:
return(string.Empty);
}
}
private TreeNode[] GetChildNodes(DbObjectTypes dbObjectType)
{
switch (dbObjectType)
{
case DbObjectTypes.Tables:
return GetTables().Select(x =>
{
var folderNodes = new TreeNode(" " + x.Name,
new TreeNode[] {
new TreeNode("Columns", 1, 1, GetColumnsForTablesInTreeview(x)),
//new TreeNode("Keys", 1, 1)
});
folderNodes.ImageIndex = 3;
folderNodes.SelectedImageIndex = 3;
folderNodes.Tag = x;
return folderNodes;
}).ToArray();
case DbObjectTypes.Views:
return GetViews().Select(x =>
{
var node = new TreeNode(" " + x.Name,
x.Columns.Select(y =>
{
var columnNode = new TreeNode(y.name);
columnNode.ImageIndex = 4;
columnNode.SelectedImageIndex = 4;
return columnNode;
}).ToArray());
node.ImageIndex = 3;
node.SelectedImageIndex = 3;
node.Tag = x;
return node;
}).ToArray();
case DbObjectTypes.StoredProcedures:
return GetStoredProcedures().ToList().Select(x => new TreeNode(" " + x.Name)).ToArray();
case DbObjectTypes.TableValuedFunctions:
return GetTableValuedFunctions().ToList().Select(x => new TreeNode(" " + x.Name)).ToArray();
default:
return new TreeNode[0];
}
}
