public AttributeTag getAttributeTagByGUID(string GUID)
{
AttributeTag attributeTag = null;
string getAttributes = @"select elementid from t_attributetag
where ea_guid like '" + GUID + "'";
XmlDocument xmlElementIDs = this.SQLQuery(getAttributes);
XmlNode elementNode = xmlElementIDs.SelectSingleNode("//elementid");
if (elementNode != null)
{
int objectID;
if (int.TryParse(elementNode.InnerText, out objectID))
{
Attribute owner = this.getAttributeByID(objectID);
if (owner != null)
{
foreach (TaggedValue taggedValue in owner.taggedValues)
{
if (taggedValue.ea_guid.Equals(GUID, StringComparison.InvariantCultureIgnoreCase))
{
attributeTag = taggedValue as AttributeTag;
}
}
}
}
}
return(attributeTag);
}
public List <AttributeTag> getAttributeTagsWithValue(string value)
{
List <AttributeTag> attributeTags = new List <AttributeTag>();
string sqlFindGUIDS = @"select ea_guid from t_attributetag
where value like '" + value + "'";
// get the nodes with the name "ea_guid"
XmlDocument xmlTagGUIDs = this.SQLQuery(sqlFindGUIDS);
XmlNodeList tagGUIDNodes = xmlTagGUIDs.SelectNodes("//ea_guid");
foreach (XmlNode guidNode in tagGUIDNodes)
{
AttributeTag attributeTag = this.getAttributeTagByGUID(guidNode.InnerText);
if (attributeTag != null)
{
attributeTags.Add(attributeTag);
}
}
return(attributeTags);
}