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]; } }