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