public ElementTag getElementTagByGUID(string GUID) { ElementTag elementTag = null; string getElementWrappers = @"select object_id from t_objectproperties where ea_guid like '" + GUID + "'"; XmlDocument xmlElementIDs = this.SQLQuery(getElementWrappers); XmlNode elementNode = xmlElementIDs.SelectSingleNode("//object_id"); if (elementNode != null) { int objectID; if (int.TryParse(elementNode.InnerText, out objectID)) { ElementWrapper owner = this.getElementWrapperByID(objectID); if (owner != null) { foreach (TaggedValue taggedValue in owner.taggedValues) { if (taggedValue.ea_guid.Equals(GUID, StringComparison.InvariantCultureIgnoreCase)) { elementTag = taggedValue as ElementTag; } } } } } return(elementTag); }
public HashSet <ElementTag> getElementTagsWithValue(string value) { HashSet <ElementTag> elementTags = new HashSet <ElementTag>(); string sqlFindGUIDS = @"select ea_guid from t_objectproperties where value like '" + value + "'"; // get the nodes with the name "ea_guid" XmlDocument xmlElementTagGUIDs = this.SQLQuery(sqlFindGUIDS); XmlNodeList tagGUIDNodes = xmlElementTagGUIDs.SelectNodes("//ea_guid"); foreach (XmlNode guidNode in tagGUIDNodes) { ElementTag elementTag = this.getElementTagByGUID(guidNode.InnerText); if (elementTag != null) { elementTags.Add(elementTag); } } return(elementTags); }