public OperationTag getOperationTagByGUID(string GUID)
{
OperationTag operationTag = null;
string getOperations = @"select elementid from t_operationtag
where ea_guid like '" + GUID + "'";
XmlDocument xmlElementIDs = this.SQLQuery(getOperations);
XmlNode elementNode = xmlElementIDs.SelectSingleNode("//elementid");
if (elementNode != null)
{
int objectID;
if (int.TryParse(elementNode.InnerText, out objectID))
{
Operation owner = this.getOperationByID(objectID) as Operation;
if (owner != null)
{
foreach (TaggedValue taggedValue in owner.taggedValues)
{
if (taggedValue.ea_guid.Equals(GUID, StringComparison.InvariantCultureIgnoreCase))
{
operationTag = taggedValue as OperationTag;
}
}
}
}
}
return(operationTag);
}
public List <OperationTag> getOperationTagsWithValue(string value)
{
List <OperationTag> operationTags = new List <OperationTag>();
string sqlFindGUIDS = @"select ea_guid from t_operationtag
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)
{
OperationTag operationTag = this.getOperationTagByGUID(guidNode.InnerText);
if (operationTag != null)
{
operationTags.Add(operationTag);
}
}
return(operationTags);
}