public Documentation AddNodeDoc(Documentation nd) { Documentation retval = null; using (SystemMapEntities db = new SystemMapEntities()) { node_docs ndoc = new node_docs { name = nd.name, doctypeid = nd.docTypeId, descr = nd.description, docurl = nd.url, nodeid = nd.componentId }; db.node_docs.Add(ndoc); db.SaveChanges(); retval = new Documentation { documentationId = ndoc.node_docid, name = ndoc.name, description = ndoc.descr, url = ndoc.docurl, docTypeId = ndoc.doctypeid, documentType = new DocType { typeId = ndoc.doctypeid, name = ndoc.doc_type.typename, description = ndoc.doc_type.descr, iconUrl = ndoc.doc_type.iconurl } }; } return(retval); }
/// <summary> /// Get the type associated with the given information. If typeadd is true, then add those values to the node types if not found. /// </summary> /// <param name="typeid">identifier of the node type</param> /// <param name="typename">Name for the node type</param> /// <param name="typeadd">default is false. If not found add the typename to the nodetypes.</param> /// <returns></returns> public NodeType GetNodeType(string typename, bool typeadd = false) { NodeType ntype = null; using (SystemMapEntities db = new SystemMapEntities()) { ntype = db.nodetypes .Where(nt => nt.name == typename) .Select(nt => new NodeType { typeId = nt.typeid, name = nt.name, description = nt.descr, iconUrl = nt.iconurl }) .SingleOrDefault(); if (ntype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename)) { //Go ahead and add it nodetype addtype = new nodetype { name = typename }; db.nodetypes.Add(addtype); db.SaveChanges(); ntype = new NodeType { name = typename, typeId = addtype.typeid }; } } return(ntype); }
public Documentation AddProcessDoc(Documentation pdoc) { Documentation retval = null; using (SystemMapEntities db = new SystemMapEntities()) { process_docs ndoc = new process_docs { name = pdoc.name, doctypeid = pdoc.docTypeId, descr = pdoc.description, docurl = pdoc.url, processid = pdoc.componentId }; db.process_docs.Add(ndoc); db.SaveChanges(); retval = new Documentation { documentationId = ndoc.process_docid, name = ndoc.name, description = ndoc.descr, url = ndoc.docurl, docTypeId = ndoc.doctypeid, documentType = new DocType { typeId = ndoc.doctypeid, name = ndoc.doc_type.typename, description = ndoc.doc_type.descr, iconUrl = ndoc.doc_type.iconurl } }; } return(retval); }
/// <summary> /// Add a new edge given the Connector model /// </summary> /// <param name="conn">Connector model containing edge information</param> /// <returns>identity value of the new edge record; otherwise, -1.</returns> public int AddEdge(Edge conn, bool typeadd = false) { int retval = -1; if (conn.type == null) { throw new Exception("Edge type data required"); } TypeService tsvc = new TypeService(); EdgeType etype = tsvc.GetEdgeType(conn.type.name, typeadd); using (SystemMapEntities db = new SystemMapEntities()) { //check that an existing edge (u, v, name) is not already there) edge curredge = db.edges.Where(e => e.from_node == conn.fromNodeId && e.to_node == conn.toNodeId && e.name == conn.name).FirstOrDefault(); if (curredge == null) { curredge = new edge { name = conn.name, edgetypeid = etype.typeId, descr = conn.description, from_node = conn.fromNodeId, to_node = conn.toNodeId }; db.edges.Add(curredge); db.SaveChanges(); } retval = curredge.edgeid; } return(retval); }
public DocType GetDocType(string typename, bool typeadd = false) { DocType dtype = null; using (SystemMapEntities db = new SystemMapEntities()) { dtype = db.doc_type .Where(dt => dt.typename == typename) .Select(dt => new DocType { typeId = dt.doctypeid, name = dt.typename, description = dt.descr, iconUrl = dt.iconurl }) .SingleOrDefault(); if (dtype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename)) { doc_type natype = new doc_type { typename = typename }; db.doc_type.Add(natype); db.SaveChanges(); dtype = new DocType { typeId = natype.doctypeid, name = typename }; } } return(dtype); }
public NodeAttribute AddNodeAttribute(NodeAttribute natt) { NodeAttribute retval = null; using (SystemMapEntities db = new SystemMapEntities()) { node_attributes nrec = new node_attributes { nodeid = natt.nodeId, name = natt.name, descr = natt.description, attrtypeid = natt.type.typeId }; db.node_attributes.Add(nrec); db.SaveChanges(); retval = new NodeAttribute { id = nrec.attributeid, name = nrec.name, description = nrec.descr }; retval.type = new TypeService().GetAttributeType(nrec.attrtypeid); } return(retval); }
public EdgeType GetEdgeType(string typename, bool typeadd = false) { EdgeType etype = null; using (SystemMapEntities db = new SystemMapEntities()) { etype = db.edgetypes .Where(et => et.name == typename) .Select(et => new EdgeType { typeId = et.edgetypeid, name = et.name, description = et.descr, iconUrl = et.iconurl }) .SingleOrDefault(); if (etype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename)) { edgetype netype = new edgetype { name = typename }; db.edgetypes.Add(netype); db.SaveChanges(); etype = new EdgeType { name = typename, typeId = netype.edgetypeid }; } } return(etype); }
public MembershipType GetMembershipType(string typename, bool typeadd = false) { MembershipType mtype = null; using (SystemMapEntities db = new SystemMapEntities()) { mtype = db.membership_types .Where(mt => mt.typename == typename) .Select(mt => new MembershipType { typeId = mt.memtypeid, name = mt.typename, description = mt.descr, iconUrl = mt.iconurl }) .SingleOrDefault(); if (mtype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename)) { membership_types natype = new membership_types { typename = typename }; db.membership_types.Add(natype); db.SaveChanges(); mtype = new MembershipType { typeId = natype.memtypeid, name = typename }; } } return(mtype); }
public AttributeType GetAttributeType(string typename, bool typeadd = false) { AttributeType atype = null; using (SystemMapEntities db = new SystemMapEntities()) { atype = db.attribute_types .Where(at => at.name == typename) .Select(at => new AttributeType { typeId = at.attrtypeid, name = at.name, description = at.descr, iconUrl = at.iconurl }) .SingleOrDefault(); if (atype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename)) { attribute_types natype = new attribute_types { name = typename }; db.attribute_types.Add(natype); db.SaveChanges(); atype = new AttributeType { typeId = natype.attrtypeid, name = typename }; } } return(atype); }
public void DeleteNode(int nodeid) { using (SystemMapEntities db = new SystemMapEntities()) { node delnode = db.nodes.Where(n => n.nodeid == nodeid).Single(); db.nodes.Remove(delnode); db.SaveChanges(); } }
public void UpdateNode(Node unode) { using (SystemMapEntities db = new SystemMapEntities()) { node update = db.nodes.Where(n => n.nodeid == unode.id).SingleOrDefault(); update.name = unode.name; update.descr = unode.description; update.typeid = unode.type.typeId; db.SaveChanges(); } }
public void DeleteAttributeType(int atypeid) { using (SystemMapEntities db = new SystemMapEntities()) { attribute_types delrec = db.attribute_types.Where(at => at.attrtypeid == atypeid).SingleOrDefault(); if (delrec != null) { db.attribute_types.Remove(delrec); db.SaveChanges(); } } }
public void DeleteNodeDoc(int nodedocid) { using (SystemMapEntities db = new SystemMapEntities()) { node_docs delrec = db.node_docs.Where(d => d.node_docid == nodedocid).SingleOrDefault(); if (delrec != null) { db.node_docs.Remove(delrec); db.SaveChanges(); } } }
public void DeleteProcessDoc(int pdocid) { using (SystemMapEntities db = new SystemMapEntities()) { process_docs delrec = db.process_docs.Where(d => d.process_docid == pdocid).SingleOrDefault(); if (delrec != null) { db.process_docs.Remove(delrec); db.SaveChanges(); } } }
public void DeleteAttribute(int nattid) { using (SystemMapEntities db = new SystemMapEntities()) { node_attributes del = db.node_attributes.Where(na => na.attributeid == nattid).SingleOrDefault(); if (del != null) { db.node_attributes.Remove(del); db.SaveChanges(); } } }
/// <summary> /// Remove the given edge from the system /// </summary> /// <param name="edgeid"></param> public void RemoveEdge(int edgeid) { using (SystemMapEntities db = new SystemMapEntities()) { edge deledge = db.edges.Where(e => e.edgeid == edgeid).SingleOrDefault(); if (deledge != null) { db.edges.Remove(deledge); db.SaveChanges(); } } }
public void UpdateNodeMembershipType(int containerId, int memid, int mtypeid) { using (SystemMapEntities db = new SystemMapEntities()) { node_membership nm = db.node_membership.Where(m => m.groupnode_id == containerId && m.membernode_id == memid).FirstOrDefault(); if (nm != null) { nm.memtypeid = mtypeid; db.SaveChanges(); } } }
public void DeleteEdgeAttribute(int eattid) { using (SystemMapEntities db = new SystemMapEntities()) { edge_attributes delrec = db.edge_attributes .Where(ea => ea.attributeid == eattid) .SingleOrDefault(); if (delrec != null) { db.edge_attributes.Remove(delrec); db.SaveChanges(); } } }
public void AddNodeMembership(int containerId, int memid, int mtypeid) { using (SystemMapEntities db = new SystemMapEntities()) { int ecount = db.node_membership.Where(nm => nm.groupnode_id == containerId && nm.membernode_id == memid).Count(); if (ecount == 0) { node_membership nm = new node_membership { groupnode_id = containerId, membernode_id = memid, memtypeid = mtypeid }; db.node_membership.Add(nm); db.SaveChanges(); } } }
public void UpdateNodeDoc(Documentation udata) { using (SystemMapEntities db = new SystemMapEntities()) { node_docs urec = db.node_docs.Where(d => d.node_docid == udata.documentationId).SingleOrDefault(); if (urec != null) { urec.name = udata.name; urec.descr = udata.description; urec.docurl = udata.url; urec.doctypeid = udata.docTypeId; db.SaveChanges(); } } }
public void UpdateNodeAttribute(NodeAttribute udata) { using (SystemMapEntities db = new SystemMapEntities()) { node_attributes urec = db.node_attributes .Where(na => na.attributeid == udata.id) .SingleOrDefault(); if (urec != null) { urec.name = udata.name; urec.descr = udata.description; urec.attrtypeid = udata.type.typeId; db.SaveChanges(); } } }
/// <summary> /// Update edge information /// </summary> /// <param name="conn">Connector model containing the updated information</param> public void UpdateEdge(Edge conn) { using (SystemMapEntities db = new SystemMapEntities()) { edge uedge = db.edges.Where(e => e.edgeid == conn.id).SingleOrDefault(); if (uedge != null) { uedge.name = conn.name; uedge.descr = conn.description; uedge.edgetypeid = conn.type.typeId; uedge.from_node = conn.fromNodeId; uedge.to_node = conn.toNodeId; db.SaveChanges(); } } }
public void UpdateEdgeType(EdgeType udata) { using (SystemMapEntities db = new SystemMapEntities()) { edgetype utype = db.edgetypes .Where(et => et.edgetypeid == udata.typeId) .SingleOrDefault(); if (utype != null) { utype.name = udata.name; utype.descr = udata.description; utype.iconurl = udata.iconUrl; db.SaveChanges(); } } }
public void UpdateDocType(DocType udata) { using (SystemMapEntities db = new SystemMapEntities()) { doc_type utype = db.doc_type .Where(dt => dt.doctypeid == udata.typeId) .SingleOrDefault(); if (utype != null) { utype.typename = udata.name; utype.descr = udata.description; utype.iconurl = udata.iconUrl; db.SaveChanges(); } } }
public void UpdateAttributeType(AttributeType udata) { using (SystemMapEntities db = new SystemMapEntities()) { attribute_types utype = db.attribute_types .Where(at => at.attrtypeid == udata.typeId) .SingleOrDefault(); if (utype != null) { utype.name = udata.name; utype.descr = udata.description; utype.iconurl = udata.iconUrl; db.SaveChanges(); } } }
public void UpdateMembershipType(MembershipType udata) { using (SystemMapEntities db = new SystemMapEntities()) { membership_types utype = db.membership_types .Where(mt => mt.memtypeid == udata.typeId) .SingleOrDefault(); if (utype != null) { utype.typename = udata.name; utype.descr = udata.description; utype.iconurl = udata.iconUrl; db.SaveChanges(); } } }
public void UpdateAttribute(NodeAttribute natt) { using (SystemMapEntities db = new SystemMapEntities()) { node_attributes urecord = db.node_attributes .Where(na => na.attributeid == natt.id) .SingleOrDefault(); if (urecord != null) { urecord.name = natt.name; urecord.descr = natt.description; urecord.attrtypeid = natt.type.typeId; urecord.nodeid = natt.nodeId; db.SaveChanges(); } } }
public int AddAttribute(NodeAttribute natt) { int retval = -1; using (SystemMapEntities db = new SystemMapEntities()) { node_attributes ndata = new node_attributes { name = natt.name, descr = natt.description, nodeid = natt.nodeId, attrtypeid = natt.type.typeId }; db.node_attributes.Add(ndata); db.SaveChanges(); retval = ndata.attributeid; } return(retval); }
public int AddNode(Node nnode, bool typeadd = false) { int retval = -1; //Check for typeval--if not exists (and typeadd == false) throw exception; if (nnode.type == null) { throw new Exception("Node type data required"); } TypeService typesvc = new TypeService(); NodeType ntype = typesvc.GetNodeType(nnode.type.name, typeadd); using (SystemMapEntities db = new SystemMapEntities()) { node addnode = new node { name = nnode.name, descr = nnode.description, typeid = ntype.typeId }; db.nodes.Add(addnode); db.SaveChanges(); retval = addnode.nodeid; } return(retval); }
public EdgeAttribute AddEdgeAttribute(EdgeAttribute eatt) { EdgeAttribute retval = null; using (SystemMapEntities db = new SystemMapEntities()) { edge_attributes erec = new edge_attributes { name = eatt.name, descr = eatt.description, attrtypeid = eatt.type.typeId }; db.edge_attributes.Add(erec); db.SaveChanges(); retval = new EdgeAttribute { id = erec.attributeid, name = erec.name, description = erec.descr }; retval.type = new TypeService().GetAttributeType(erec.attrtypeid); } return(retval); }