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