Xml Issue ?In C# console or windows forms

SUNIL GUTTA

Hi
This is very important assignment i tried tried getting struck dam dam ..
Experts just need to sort this issue plz .
Please check the attachment provided :) XML file attached
What is need is very simple :
In XML file there are
-
+
+
+
.
.
.
.
+
+
+

The thing i need is looks simple but i am feeling a bit complex ..
In the attachment file there is Entity Action Tag right Under that we have many tag key-value pairs .. In that what i need is when i input to text boxes or a method in console like "LONGNAME" & "CATEGEORYNAME" .. I need to get all the details of those inc those values in some manner like CATEGEORYNAME: APPAREL ... All key value pair under the matched Entities ACTION ..
Second Thing is When i dig even deeper like given "LONGNAME" & "CATEGEORYNAME" & also "NAME" which is under attributes I JUST NEED to get the value ...
Hope i made clear so everyone can understand .
Cheers
Have a nice day

8 Replies

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

SUNIL GUTTA12y ago
Humm yes :) its working mate .. .. You been so helpful :)

Yes you used link right :) Nice one .. ..

I just have some xml files with more attributes .. Will test it and any issues will get back to you .

Thank you so so much
Have a nice day
Vulpes12y ago
OK, I think I've finally got it :)

using System;
using System.Linq;
using System.Xml.Linq;

class Program
{
static void Main()
{
Console.Write("Enter LONGNAME value : ");
string lName = Console.ReadLine();
Console.Write("Enter CATEGORYNAME value : ");
string cName = Console.ReadLine();
Console.WriteLine();
XElement Data = XElement.Load("xmldata.xml");

//lName = "Auto_TS8_DELTAMODE_01"; //** uncomment for hard-code test
//cName = "Apparel"; // ** uncomment for hard-code test

var query = from el in Data.Element("Entities").Elements("Entity")
where el.Attribute("LongName").Value == lName
&& el.Attribute("CategoryName").Value == cName
select el;

if(query.Count() == 0)
{
Console.WriteLine("There are no nodes with those values");
return;
}

foreach(XElement el in query)
{
foreach(XAttribute at in el.Attributes())
{
Console.WriteLine("{0} : {1}", at.Name, at.Value);
}

Console.WriteLine();

foreach(XElement el2 in el.Element("Attributes").Elements("Attribute"))
{
XAttribute at1 = el2.Attribute("Name");
XAttribute at2 = el2.Attribute("LongName");
Console.WriteLine(" {0} : {1}", at1.Name, at1.Value);
Console.WriteLine(" {0} : {1}", at2.Name, at2.Value);
XCData xcd = (XCData)el2.Element("Values").Element("Value").FirstNode;
Console.WriteLine(" {0} : {1}", at2.Value.ToUpper(), xcd.Value.ToUpper());
Console.WriteLine();
}

Console.WriteLine();
}

Console.ReadKey();
}
}

The output is :

Id : 39
ExternalId : Auto_TS8_DELTAMODE_01
LongName : Auto_TS8_DELTAMODE_01
EntityTypeId : 21
EntityTypeName : product
ContainerId : 5
ContainerName : product Master
OrganizationName : river Works
CategoryId : 1
CategoryName : Apparel
CategoryLongName : Apparel
CategoryPath : Apparel
CategoryLongNamePath :
ParentEntityId : 1
ParentExternalId : Apparel
ParentExtensionEntityId : 0
ParentExtensionEntityExternalId :
ParentExtensionEntityContainerId : 0
ParentExtensionEntityContainerName :
ParentExtensionEntityCategoryId : 0
ParentExtensionEntityCategoryPath :
ParentExtensionEntityCategoryLongNamePath :
Locale : en_WW
Action : Add

Name : apply VAT
LongName : Apply VAT
APPLY VAT : FALSE

Name : status
LongName : Status
STATUS : NEW
SUNIL GUTTA12y ago
UNDER 1ST ENTITY ACTION

under 1st node : ----It means FALSE . so APPLY VAT: FALSE

under 2nd node : ----- output should be NEW . so Status : NEW

Like that it goes on for N number of entity action nodes under entity ...

Thank you for help .. ..
Vulpes12y ago
OK, I'm clear on the filtering point though I'm not clear on the other point as I don't see anything within the Value node which could tell us whether APPLY VAT is true or false.

For now I've hard-coded it to give the output you wanted:

using System;
using System.Linq;
using System.Xml.Linq;

class Program
{
static void Main()
{
Console.Write("Enter LONGNAME value : ");
string lName = Console.ReadLine();
Console.Write("Enter CATEGORYNAME value : ");
string cName = Console.ReadLine();
Console.WriteLine();
XElement Data = XElement.Load("xmldata.xml");

//lName = "Auto_TS8_DELTAMODE_01"; //** uncomment for hard-code test
//cName = "Apparel"; // ** uncomment for hard-code test

var query = from el in Data.Element("Entities").Elements("Entity")
where el.Attribute("LongName").Value == lName
&& el.Attribute("CategoryName").Value == cName
select el;

if(query.Count() == 0)
{
Console.WriteLine("There are no nodes with those values");
return;
}

foreach(XElement el in query)
{
foreach(XAttribute at in el.Attributes())
{
Console.WriteLine("{0} : {1}", at.Name, at.Value);
}

Console.WriteLine();

foreach(XElement el2 in el.Element("Attributes").Elements("Attribute"))
{
XAttribute at1 = el2.Attribute("Name");
XAttribute at2 = el2.Attribute("LongName");
if(at1.Value == "status" && at2.Value == "Status")
{
Console.WriteLine(" APPLY VAT: TRUE .");
}
else
{
Console.WriteLine(" {0} : {1}", at1.Name, at1.Value);
Console.WriteLine(" {0} : {1}", at2.Name, at2.Value);
}
}

Console.WriteLine();
}

Console.ReadKey();
}
}
SUNIL GUTTA12y ago
Humm ty vulpes .

Humm actually in your output u displayed the XML contents like key valued-pairs .. Humm yes i need just that but some what different ..

I need to provide the input like LONGNAME value , CATEGEORY NAME value ..

On combination of both I need to filter which ENTITY ACTION WE ARE DEALING ..

ex : If we give LONGNAME : Auto_TS8_DELTAMODE_01 & CategoryName : Apparel

The output should be like :
Id : 39
ExternalId : Auto_TS8_DELTAMODE_01
LongName : Auto_TS8_DELTAMODE_01
EntityTypeId : 21
EntityTypeName : product
ContainerId : 5
ContainerName : product Master
OrganizationName : river Works
CategoryId : 1
CategoryName : Apparel
CategoryLongName : Apparel
CategoryPath : Apparel
CategoryLongNamePath :
ParentEntityId : 1
ParentExternalId : Apparel
ParentExtensionEntityId : 0
ParentExtensionEntityExternalId :
ParentExtensionEntityContainerId : 0
ParentExtensionEntityContainerName :
ParentExtensionEntityCategoryId : 0
ParentExtensionEntityCategoryPath :
ParentExtensionEntityCategoryLongNamePath :
Locale : en_WW
Action : Add

Name : apply VAT
LongName : Apply VAT

Name : status ---------------------> ISSUE IS RIGHT HERE ..
LongName : Status --------------------->

IN THIS I NEED VALUE ...
-
-

APPLY VAT: TRUE .

So final out pit should look like :
The output should be like :
Id : 39
ExternalId : Auto_TS8_DELTAMODE_01
LongName : Auto_TS8_DELTAMODE_01
EntityTypeId : 21
EntityTypeName : product
ContainerId : 5
ContainerName : product Master
OrganizationName : river Works
CategoryId : 1
CategoryName : Apparel
CategoryLongName : Apparel
CategoryPath : Apparel
CategoryLongNamePath :
ParentEntityId : 1
ParentExternalId : Apparel
ParentExtensionEntityId : 0
ParentExtensionEntityExternalId :
ParentExtensionEntityContainerId : 0
ParentExtensionEntityContainerName :
ParentExtensionEntityCategoryId : 0
ParentExtensionEntityCategoryPath :
ParentExtensionEntityCategoryLongNamePath :
Locale : en_WW
Action : Add

Name : apply VAT
LongName : Apply VAT
APPLY VAT: TRUE .

I hope you understand . . . . .

Regards
Vulpes12y ago
TBH, I'm not 100% clear what's wanted but try this:

using System;
using System.Xml.Linq;

class Program
{
static void Main()
{
XElement Data = XElement.Load("xmldata.xml");
foreach(XElement el in Data.Element("Entities").Elements("Entity"))
{
foreach(XAttribute at in el.Attributes())
{
Console.WriteLine("{0} : {1}", at.Name, at.Value);
}

Console.WriteLine();

foreach(XElement el2 in el.Element("Attributes").Elements("Attribute"))
{
foreach(XAttribute at in el2.Attributes())
{
if (at.Name == "Name" || at.Name == "LongName" || at.Name == "CategoryName")
{
Console.WriteLine(" {0} : {1}", at.Name, at.Value);
}
}

Console.WriteLine();
}
}

Console.ReadKey();
}
}

The output is:

Id : 39
ExternalId : Auto_TS8_DELTAMODE_01
LongName : Auto_TS8_DELTAMODE_01
EntityTypeId : 21
EntityTypeName : product
ContainerId : 5
ContainerName : product Master
OrganizationName : river Works
CategoryId : 1
CategoryName : Apparel
CategoryLongName : Apparel
CategoryPath : Apparel
CategoryLongNamePath :
ParentEntityId : 1
ParentExternalId : Apparel
ParentExtensionEntityId : 0
ParentExtensionEntityExternalId :
ParentExtensionEntityContainerId : 0
ParentExtensionEntityContainerName :
ParentExtensionEntityCategoryId : 0
ParentExtensionEntityCategoryPath :
ParentExtensionEntityCategoryLongNamePath :
Locale : en_WW
Action : Add

Name : apply VAT
LongName : Apply VAT

Name : status
LongName : Status

Id : 45
ExternalId : Auto_TS8_DELTAMODE_02
LongName : Auto_TS8_DELTAMODE_02
EntityTypeId : 21
EntityTypeName : product
ContainerId : 5
ContainerName : product Master
OrganizationName : river Works
CategoryId : 1
CategoryName : Apparel
CategoryLongName : Apparel
CategoryPath : Apparel
CategoryLongNamePath :
ParentEntityId : 1
ParentExternalId : Apparel
ParentExtensionEntityId : 0
ParentExtensionEntityExternalId :
ParentExtensionEntityContainerId : 0
ParentExtensionEntityContainerName :
ParentExtensionEntityCategoryId : 0
ParentExtensionEntityCategoryPath :
ParentExtensionEntityCategoryLongNamePath :
Locale : en_WW
Action : Add

Name : apply VAT
LongName : Apply VAT

Name : status
LongName : Status
SUNIL GUTTA12y ago
First of all let me ty for reply and its been helpful .

But thing is need to display information in listbox or what ever in key-value pairs so ..so one ca neatly recognize whats present in which .

In the attachment i.e when typing longName i am getting wrong results ..

Actually i planned i.e keeping 2 textboxes so i can enter LONGNAME & CATEGORYNAME .. SO IT JUST acts as a composite key in sql server will only fetch data of all Attributes where the given textbox input matches ... Output should be in key valued pairs ..

Anyway as you said it definately a start i can hope on .. Ty for help .
Frogleg12y ago
Here's a start