public List<Operation>getOperationsByQuery(string SQLQuery)
{
// get the nodes with the name "OperationID"
XmlDocument xmlOperationIDs = this.SQLQuery(SQLQuery);
XmlNodeList operationIDNodes = xmlOperationIDs.SelectNodes(formatXPath("//OperationID"));
List<Operation> operations = new List<Operation>();
foreach( XmlNode operationIDNode in operationIDNodes )
{
int operationID;
if (int.TryParse(operationIDNode.InnerText,out operationID))
{
Operation operation = this.getOperationByID(operationID) as Operation;
if (operation != null)
{
operations.Add(operation);
}
}
}
return operations;
}