public ParameterTag getParameterTagByGUID(string GUID) { ParameterTag parameterTag = null; string getParameters = @"select elementid from t_taggedvalue where propertyid like '" + GUID + "'"; XmlDocument xmlElementIDs = this.SQLQuery(getParameters); XmlNode elementNode = xmlElementIDs.SelectSingleNode("//elementid"); if (elementNode != null) { if (elementNode.InnerText.Length > 0) { Parameter owner = this.getParameterByGUID(elementNode.InnerText); if (owner != null) { foreach (TaggedValue taggedValue in owner.taggedValues) { if (taggedValue.ea_guid.Equals(GUID, StringComparison.InvariantCultureIgnoreCase)) { parameterTag = taggedValue as ParameterTag; } } } } } return(parameterTag); }
public List <ParameterTag> getParameterTagsWithValue(string value) { List <ParameterTag> parameterTags = new List <ParameterTag>(); string sqlFindGUIDS = @"select propertyid from t_taggedvalue where notes like '" + value + "'"; // get the nodes with the name "ea_guid" XmlDocument xmlTagGUIDs = this.SQLQuery(sqlFindGUIDS); XmlNodeList tagGUIDNodes = xmlTagGUIDs.SelectNodes("//propertyid"); foreach (XmlNode guidNode in tagGUIDNodes) { ParameterTag parameterTag = this.getParameterTagByGUID(guidNode.InnerText); if (parameterTag != null) { parameterTags.Add(parameterTag); } } return(parameterTags); }