protected void StoreDbNode(SqlServerDatabaseNode dbnode) { TypeService tsvc = new TypeService(); if (dbnode.NodeIdentity == 0) { NodeService nsvc = new NodeService(); AttributeService attsvc = new AttributeService(); NodeType dbtype = tsvc.GetNodeType("Database", true); Node existing = nsvc.GetByName(dbnode.Name); if (existing == null) { existing = new Node { name = dbnode.Name, description = "SQL Server Database", type = dbtype }; int dbnodeid = nsvc.AddNode(existing); dbnode.NodeIdentity = dbnodeid; if (dbnode.Metadata != null) { foreach (NodeAttribute natt in dbnode.Metadata) { AttributeType atype = tsvc.GetAttributeType(natt.type.name, true); natt.nodeId = dbnodeid; natt.type = atype; attsvc.AddNodeAttribute(natt); } } } else { dbnode.NodeIdentity = existing.id; } } //If the identities are set, add membership setting if (dbnode.NodeIdentity != 0 && serverStructure.ServerNode.NodeIdentity != 0) { MembershipType mtype = tsvc.GetMembershipType("Database", true); MembershipService msvc = new MembershipService(); msvc.AddNodeMembership(serverStructure.ServerNode.NodeIdentity, dbnode.NodeIdentity, mtype.typeId); } }
protected void StoreServerNode() { DataSourceNodeBase srvrNode = serverStructure.ServerNode; NodeService nsvc = new NodeService(); TypeService tsvc = new TypeService(); AttributeService attsvc = new AttributeService(); Node existing = nsvc.GetByName(srvrNode.Name); if (existing == null) { //doesn't exist--add it existing = new Node { name = srvrNode.Name }; NodeType srvrType = tsvc.GetNodeType("SQL Server", true); existing.type = srvrType; int srvrId = nsvc.AddNode(existing); existing.id = srvrId; } else { srvrNode.NodeIdentity = existing.id; } if (srvrNode.Metadata != null) { foreach (NodeAttribute natt in srvrNode.Metadata) { try { AttributeType atype = tsvc.GetAttributeType(natt.type.name, true); natt.nodeId = existing.id; natt.type = atype; attsvc.AddNodeAttribute(natt); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } }
protected void StoreNodes(List <DataSourceNodeBase> nlist, SqlServerDatabaseNode databaseNode) { NodeService nsvc = new NodeService(); TypeService tsvc = new TypeService(); AttributeService attsvc = new AttributeService(); MembershipService msvc = new MembershipService(); foreach (DataSourceNodeBase dbnode in nlist) { string memtypename = null; //if there is a non-zero id value, it's already been stored/pulled. if (dbnode.NodeIdentity == 0) { Node existnode = nsvc.GetByName(dbnode.Name); if (existnode == null) { //hasn't been added yet--create one Type nclasstype = dbnode.GetType(); string ntypename = null; switch (nclasstype.FullName) { case "SystemMap.Models.Transform.db.sqlserver.SqlServerInstanceNode": ntypename = "SQL Server"; memtypename = null; break; case "SystemMap.Models.Transform.db.sqlserver.SqlServerDatabaseNode": ntypename = EnumParser.GetValueName(DbClasses.Database); memtypename = null; break; case "SystemMap.Models.Transform.db.sqlserver.SqlServerTableNode": ntypename = EnumParser.GetValueName(DbClasses.Table); memtypename = ntypename; break; case "SystemMap.Models.Transform.db.sqlserver.SqlServerViewNode": ntypename = EnumParser.GetValueName(DbClasses.View); memtypename = ntypename; break; case "SystemMap.Models.Transform.db.sqlserver.SqlServerProcedureNode": ntypename = EnumParser.GetValueName(DbProcesses.StoredProcedue); memtypename = ntypename; break; case "SystemMap.Models.Transform.db.sqlserver.SqlServerFunctionNode": ntypename = EnumParser.GetValueName(DbProcesses.Function); memtypename = ntypename; break; case "SystemMap.Models.Transform.db.GenericDataSourceNode": ntypename = "External Reference"; memtypename = null; break; default: ntypename = "General"; memtypename = null; break; } NodeType ntype = tsvc.GetNodeType(ntypename, true); existnode = new Node { name = dbnode.Name, description = ntypename, type = ntype }; try { int nid = nsvc.AddNode(existnode); dbnode.NodeIdentity = nid; if (dbnode.Metadata != null) { foreach (NodeAttribute natt in dbnode.Metadata) { try { AttributeType atype = tsvc.GetAttributeType(natt.type.name, true); natt.nodeId = dbnode.NodeIdentity; natt.type = atype; attsvc.AddNodeAttribute(natt); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } else { dbnode.NodeIdentity = existnode.id; } } if (memtypename != null) { MembershipType mtype = tsvc.GetMembershipType(memtypename, true); if (mtype != null && databaseNode.NodeIdentity != 0 && dbnode.NodeIdentity != 0) { try { msvc.AddNodeMembership(databaseNode.NodeIdentity, dbnode.NodeIdentity, mtype.typeId); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } } }