How to get values from multiple xml nodes

Hi my Code masters,

I need your help again please, i have this XML file below

<LaboratoryReport>
<VisitID>103079VisitID>
<VisitDate>2015-06-23VisitDate>
<ARTStatusCode>AARTStatusCode>
<LaboratoryOrderAndResult>
<OrderedTestDate>2015-06-23OrderedTestDate>
<LaboratoryResultedTest>
<Code>11Code>
<CodeDescTxt>CD4CodeDescTxt>
LaboratoryResultedTest>
<LaboratoryResult>
<AnswerNumeric>
<Value1>420Value1>
AnswerNumeric>
LaboratoryResult>
<ResultedTestDate>2015-07-08ResultedTestDate>
LaboratoryOrderAndResult>
<LaboratoryOrderAndResult>
<OrderedTestDate>2015-06-23OrderedTestDate>
<LaboratoryResultedTest>
<Code>46Code>
<CodeDescTxt>HIV Rapid TestCodeDescTxt>
LaboratoryResultedTest>
<LaboratoryResult>
<AnswerNumeric>
<Value1>1Value1>
AnswerNumeric>
LaboratoryResult>
<ResultedTestDate>2015-07-08ResultedTestDate>
LaboratoryOrderAndResult>
LaboratoryReport>
<LaboratoryReport>
<VisitID>107337VisitID>
<VisitDate>2016-05-24VisitDate>
<ARTStatusCode>AARTStatusCode>
<LaboratoryOrderAndResult>
<OrderedTestDate>2016-05-24OrderedTestDate>
<LaboratoryResultedTest>
<Code>80Code>
<CodeDescTxt>Viral LoadCodeDescTxt>
LaboratoryResultedTest>
<LaboratoryResult>
<AnswerNumeric>
<Value1>18732Value1>
AnswerNumeric>
LaboratoryResult>
<ResultedTestDate>2016-07-23ResultedTestDate>
LaboratoryOrderAndResult>
LaboratoryReport>

i want to check if any of the element contain LaboratoryReport and LaboratoryResultedTest it should count the element that have it value equal to CD4.

this should also happend for any element that have it value equal to Viral Load

the code is working well for CD4 but it is not counting for Viral Load since the CD4 is the first element group.

my code is shown bellow :

string directoryPath = Server.MapPath(string.Format("~/{0}/", "XML"));
string[] filePaths = Directory.GetFiles(directoryPath, "*.xml"); //, SearchOption.AllDirectories
string fileContent = "";
/*=========================================
* this section is to initialise the Excel header and
* the workbook in turn the worksheet
* */
ExcelPackage ps = new ExcelPackage();
ps.Workbook.Worksheets.Add("EMR-NDR");
ExcelWorksheet ws = ps.Workbook.Worksheets[1];
object missValue = System.Reflection.Missing.Value;
ps.Workbook.Properties.Author = "Abraham Oaltubosun";
ps.Workbook.Properties.Title = "EMR-NDR Data Extraction Analytics";
ExcelRange ChartRange = ws.Cells["A1:D1"];
ws.Cells[1, 1].Value = "Fil Names";
ws.Cells[1, 2].Value = "HIV Encounter";
ws.Cells[1, 3].Value = "CD4";
ws.Cells[1, 4].Value = "Viral Load";
ws.Cells[1, 5].Value = "ART Regimen";
int t = 2;
foreach (string file in filePaths)
{
// Log Message read started
fileContent = File.ReadAllText(file).Trim();
if (fileContent.Length > 0)
{
XDocument xd = XDocument.Parse(fileContent);
XmlDocument xxd = new XmlDocument();
xxd.Load(file);
int RegimenCounter = 0;
int RegimenCounter1 = 0;
int LaboratoryCounter=0;
int ViralLoadCounter = 0;
string result = "";
HIVEnCounter = xxd.SelectNodes("/Container/IndividualReport/Condition/Encounters/HIVEncounter").Count;
string result2 = xd.Element("Container").Element("IndividualReport").Element("Condition").ToString();
if (result2.Contains("Regimen"))
{
result = xd.Element("Container").Element("IndividualReport").Element("Condition").Element("Regimen").Element("PrescribedRegimenTypeCode").Value;
}
if (!string.IsNullOrEmpty(result))
{
if (result == "ART")
{
RegimenCounter1 = xxd.SelectNodes("/Container/IndividualReport/Condition/Regimen/PrescribedRegimenTypeCode[. = \"ART\"]").Count;
}
}
string result3 = xd.Element("Container").Element("IndividualReport").Element("Condition").ToString();
if (result3.Contains("LaboratoryReport") && result3.Contains("LaboratoryResultedTest"))
{
result = xd.Element("Container").Element("IndividualReport").Element("Condition").Element("LaboratoryReport").Element("LaboratoryOrderAndResult").Element("LaboratoryResultedTest").Element("CodeDescTxt").Value;
}
if (!string.IsNullOrEmpty(result))
{
if (result == "CD4")
{
LaboratoryCounter = xxd.SelectNodes("/Container/IndividualReport/Condition/LaboratoryReport/LaboratoryOrderAndResult/LaboratoryResultedTest/CodeDescTxt[. =\"CD4\"]").Count;
}
}
string resultVL = xd.Element("Container").Element("IndividualReport").Element("Condition").ToString();
if (resultVL.Contains("LaboratoryReport") && resultVL.Contains("LaboratoryResultedTest"))
{
resultVL = xd.Element("Container").Element("IndividualReport").Element("Condition").Element("LaboratoryReport").Element("LaboratoryOrderAndResult").Element("LaboratoryResultedTest").Element("CodeDescTxt").Value;
}
if (!string.IsNullOrEmpty(resultVL))
{
if (resultVL == "Viral Load")
{
ViralLoadCounter = xxd.SelectNodes("/Container/IndividualReport/Condition/LaboratoryReport/LaboratoryOrderAndResult/LaboratoryResultedTest/CodeDescTxt[. =\"Viral Load\"]").Count;
}
}
ws.Cells[t, 1].Value = file;
ws.Cells[t, 2].Value = HIVEnCounter;
ws.Cells[t, 3].Value = LaboratoryCounter;
ws.Cells[t, 4].Value = ViralLoadCounter;
ws.Cells[t, 5].Value = RegimenCounter1;
t = t + 1;
}
else
{
// Log error File is blank
}
}

please i need your help

Thank you all

DataTable.ReadXml Method (String)

The above said method will make your work easy,

Sample Code:

private static void DemonstrateReadWriteXMLDocumentWithString()
{
DataTable table = CreateTestTable("XmlDemo");
PrintValues(table, "Original table");
string fileName = "C:\\TestData.xml";
table.WriteXml(fileName, XmlWriteMode.WriteSchema);
DataTable newTable = new DataTable();
newTable.ReadXml(fileName);
// Print out values in the table.
PrintValues(newTable, "New table");
}
private static DataTable CreateTestTable(string tableName)
{
// Create a test DataTable with two columns and a few rows.
DataTable table = new DataTable(tableName);
DataColumn column = new DataColumn("id", typeof(System.Int32));
column.AutoIncrement = true;
table.Columns.Add(column);
column = new DataColumn("item", typeof(System.String));
table.Columns.Add(column);
// Add ten rows.
DataRow row;
for (int i = 0; i <= 9; i++)
{
row = table.NewRow();
row["item"] = "item " + i;
table.Rows.Add(row);
}
table.AcceptChanges();
return table;
}
private static void PrintValues(DataTable table, string label)
{
Console.WriteLine(label);
foreach (DataRow row in table.Rows)
{
foreach (DataColumn column in table.Columns)
{
Console.Write("\t{0}", row[column]);
}
Console.WriteLine();
}
}

Mark as answer, if helpful.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abraham Olatubosun9y ago
Thank you all for the solution tips, i and my team appreciate your effort and kind heart you showed us during our though time line.

We actually solve the specific challenges that we asked question.

thank you ance again
0
Bhuvanesh Mohankumar9y ago
DataTable.ReadXml Method (String)
The above said method will make your work easy,

Sample Code:
private static void DemonstrateReadWriteXMLDocumentWithString()
{
    DataTable table = CreateTestTable("XmlDemo");
    PrintValues(table, "Original table");

    string fileName = "C:\\TestData.xml";
    table.WriteXml(fileName, XmlWriteMode.WriteSchema);

    DataTable newTable = new DataTable();
    newTable.ReadXml(fileName);

    // Print out values in the table.
    PrintValues(newTable, "New table");
}

private static DataTable CreateTestTable(string tableName)
{
    // Create a test DataTable with two columns and a few rows.
    DataTable table = new DataTable(tableName);
    DataColumn column = new DataColumn("id", typeof(System.Int32));
    column.AutoIncrement = true;
    table.Columns.Add(column);

    column = new DataColumn("item", typeof(System.String));
    table.Columns.Add(column);

    // Add ten rows.
    DataRow row;
    for (int i = 0; i <= 9; i++)
    {
        row = table.NewRow();
        row["item"] = "item " + i;
        table.Rows.Add(row);
    }

    table.AcceptChanges();
    return table;
}

private static void PrintValues(DataTable table, string label)
{
    Console.WriteLine(label);
    foreach (DataRow row in table.Rows)
    {
        foreach (DataColumn column in table.Columns)
        {
            Console.Write("\t{0}", row[column]);
        }
        Console.WriteLine();
    }
}
Mark as answer, if helpful.
0