Urgent help required for reading xml file in C#

EDN Admin · Jun 8, 2012

I am unable to figure out how to parse an xml based on the following scenario. I am trying to parse a business rule, which is in xml format. Xml file has a grouping of "AND" and "OR" conditions. I need to maintain the hierachy and basically convert that
whole xml into a biztalk rule . I was able to achieve that by using a simple xml which has only one "AND" condition and create a biztalk rule. But now when i created a nested "AND" and "OR" conditions..i am not sure how to parse the innermost "AND" for
example and maintain the hierachy upwards..below is a sample xml

<?xml version="1.0" encoding="utf-8" ?> 
<rule name="TestRule2" priority="0" active="true 
<if> 
<and> 
<compare operator="equal 
<lhs> 
<function> 
<xmldocumentmember xmldocumentref="xml_31" type="string" sideeffects="false 
<fieldalias>AccountID</fieldalias> 
</xmldocumentmember> 
</function> 
</lhs> 
<rhs> 
<constant> 
<string>1234</string> 
</constant> 
</rhs> 
</compare> 
<compare operator="not equal 
<lhs> 
<function> 
<xmldocumentmember xmldocumentref="xml_31" type="string" sideeffects="false 
<fieldalias>CompanyID</fieldalias> 
</xmldocumentmember> 
</function> 
</lhs> 
<rhs> 
<constant> 
<string>1111</string> 
</constant> 
</rhs> 
</compare> 
<and> 
<compare operator="equal 
<lhs> 
<function> 
 
<xmldocumentmember xmldocumentref="xml_32" type="string" sideeffects="false 
<field>@*[local-name()=AccountID and namespace-uri()=]</field> 
<fieldalias>@AccountID</fieldalias> 
</xmldocumentmember> 
</function> 
</lhs> 
<rhs> 
<constant> 
<string>1234</string> 
</constant> 
</rhs> 
</compare> 
<or> 
<compare operator="equal 
<lhs> 
<function> 
 
<xmldocumentmember xmldocumentref="xml_33" type="string" sideeffects="false 
<field>.</field> 
<fieldalias>@AccountStatus</fieldalias> 
</xmldocumentmember> 
</function> 
</lhs> 
<rhs> 
<constant> 
<string>2121</string> 
</constant> 
</rhs> 
</compare> 
<compare operator="equal 
<lhs> 
<function> 
<xmldocumentmember xmldocumentref="xml_34" type="string" sideeffects="false 
<field>.</field> 
<fieldalias>@AccomodationCode</fieldalias> 
</xmldocumentmember> 
</function> 
</lhs> 
<rhs> 
<constant> 
<string>11</string> 
</constant> 
</rhs> 
</compare> 
</or> 
</and> 
</and> 
</if> 
</rule>

below is the code i wrte to get the parsing working if there was only one "AND" in the rule xml above. I am newbie to LINQ. Please suggest if you see any code issues.

select new 
{

//RHSFields
= items.Descendants("RHS")

};
LogicalExpressionCollection LogicalExprnCollection = new LogicalExpressionCollection(); 
XMLDocumentFieldBinding LHSFieldBinding = null; 
XMLDocumentFieldBinding RHSFieldBinding = null; 
foreach (var ANDCondition in LogicalANDConditions) 
{
foreach (var LogicalExprnStmt in ANDCondition.LogicalExprnXml) 
{
var predicate = LogicalExprnStmt.FirstAttribute.Value; 
var RHSVocabName = string.Empty; 
var LHSVocabName = string.Empty; 
Constant RHSConstant = null; 
var LHSFieldNode = LogicalExprnStmt.FirstNode.ToString(); 
var LHSField = LogicalExprnStmt.Elements("lhs"); 
var LHSFieldType = LHSFieldNode.Contains("function"); 
if (LHSFieldType == true) 
{ 
LHSVocabName = LHSField.Descendants("fieldalias").First().Value; 
LHSFieldBinding = RuleVocabDictionary[LHSVocabName]; 

 
} 
var RHSFieldNode = LogicalExprnStmt.LastNode.ToString(); 
var RHSField = LogicalExprnStmt.Elements("rhs"); 
var RHSFieldType = RHSFieldNode.Contains("function"); 
if (RHSFieldType == true) 
{ 
RHSVocabName = RHSField.Descendants("fieldalias").First().Value; 
RHSFieldBinding = RuleVocabDictionary[RHSVocabName]; 
} 
else 
{ 
RHSVocabName = RHSField.Descendants("constant").First().Value; 
RHSConstant = new Constant(RHSVocabName); 
var x = RHSConstant.VocabularyLink; 
}

 
switch (predicate) 
{ 
case "equal": 
{ 
if (!string.IsNullOrEmpty(RHSConstant.ToString())) 
LogicalExprnCollection.Add(new Equal(new UserFunction(LHSFieldBinding),
RHSConstant)); 
else 
LogicalExprnCollection.Add(new Equal(new UserFunction(LHSFieldBinding),
new UserFunction(RHSFieldBinding))); 
break; 
} 
case "not equal": 
{ 
if (!string.IsNullOrEmpty(RHSConstant.ToString())) 
LogicalExprnCollection.Add(new Equal(new UserFunction(LHSFieldBinding),
RHSConstant)); 
else 
LogicalExprnCollection.Add(new Equal(new UserFunction(LHSFieldBinding),
new UserFunction(RHSFieldBinding))); 
break;
}
} 
} 
}

Please guide me in the right direction to parse the xml and maintain the hierarchy/grouping to create the rule with AND/OR hierarchy in the same order as in the xml.Thank you.

 <a> <hr class="sig Dilip Bandi

View the full article

Urgent help required for reading xml file in C#

EDN Admin

Well-known member