CODEWITHSUNDEEP
c#xml
Kasinatha Durai Avudaiyappan
Kasinatha Durai Avudaiyappan

Reputation: 21

Change XML element value in c#

My C# code:

XDocument doc = XDocument.Load(filename); 
IEnumerable<XElement> collection = 
    doc.Elements("BCIRequest").Elements("Card").Elements("SelectedPIN");

My XML document:

<?xml version="1.0" encoding="utf-8"?>
 <BCIRequest Version="2.0"
        xmlns="urn:xxxxxx:bci:request">
  <Header>
<SenderCode>XX99</SenderCode>
<SenderID>9999</SenderID>
<SequenceNumber>123</SequenceNumber>
<CardGroupCount>2</CardGroupCount>
<CardCount>4</CardCount>
<BlockCount>2</BlockCount>
 </Header>
      <!--card groups (must precede cards and blocks)-->
       <CardGroup RequestID="1">
        <CustomerNumber>XX01234567</CustomerNumber>
        <CardGroupName Emboss="true">GROUP ONE</CardGroupName>
  </CardGroup>

  <CardGroup RequestID="2"
            RequestRef="87416CB7-DAEF-483A-BD08-1A885531D958">
   <CustomerNumber>XX12345678</CustomerNumber>
<CardGroupName Emboss="false">GROUP TWO</CardGroupName>
 </CardGroup>
  <Card RequestID="3">
<CustomerNumber>XX01234567</CustomerNumber>
<DriverCard>
  <Driver Emboss="true">MARGE SIMPSON</Driver>
</DriverCard>
<CardTypeID>10</CardTypeID>
<PurchaseCategoryID>11</PurchaseCategoryID>
<Reissue>false</Reissue>
<GeneratedPIN/>
<OdoPrompt>false</OdoPrompt>
<CRNPrompt>false</CRNPrompt>
 </Card>
  <Card RequestID="4">
<CustomerNumber>XX12345678</CustomerNumber>
<VehicleCard>
  <VRN Emboss="true">KYI 830</VRN>
</VehicleCard>
<CardTypeID>10</CardTypeID>
<PurchaseCategoryID>11</PurchaseCategoryID>
<Reissue>false</Reissue>
<SelectedPIN>0123</SelectedPIN>
<OdoPrompt>false</OdoPrompt>
<CRNPrompt>false</CRNPrompt>
  </Card>
  <Card RequestID="5">
<CustomerNumber>XX01234567</CustomerNumber>
<BearerCard>
  <Bearer Emboss="true">OPEN XXXXXX</Bearer>
</BearerCard>
<CardTypeID>10</CardTypeID>
<PurchaseCategoryID>11</PurchaseCategoryID>
<Reissue>false</Reissue>
<FleetPIN/>
<OdoPrompt>false</OdoPrompt>
<CRNPrompt>false</CRNPrompt>
  </Card>
   <Block RequestID="6">
<CustomerNumber>XX01234567</CustomerNumber>
<PAN>7002999999999999991</PAN>
  </Block>
  <Card RequestID="7"
    RequestRef="956EA6C5-7D7E-4622-94D0-38CAD9FCC8DF">
<CustomerNumber>XX01234567</CustomerNumber>
<DriverCard>
  <Driver Emboss="true">HOMER SIMPSON</Driver>
  <VRN Emboss="true">795 DVI</VRN>
</DriverCard>
<EmbossText>SPRINGFIELD POWER</EmbossText>
<CardTypeID>10</CardTypeID>
<TokenTypeID>20</TokenTypeID>
<PurchaseCategoryID>30</PurchaseCategoryID>
<ExpiryDate>2018-12</ExpiryDate>
<Reissue>true</Reissue>
<SelectedPIN>0123</SelectedPIN>
<OdoPrompt>true</OdoPrompt>
<CRNPrompt>true</CRNPrompt>
<!--address with optional fields specified-->
<CardDeliveryAddress OneTimeUse="false">
  <ContactName>M xxxx</ContactName>
  <ContactTitle>Mr</ContactTitle>
  <CompanyName>Sxxxx</CompanyName>
  <Line1>Sector 22-F</Line1>
  <Line2>Springfield Power Plant</Line2>
  <Line3>xxx Road</Line3>
  <City>xxxx</City>
  <Zipcode>xxxx</Zipcode>
  <CountryCode>xxx</CountryCode>
</CardDeliveryAddress>
<!--address with only required fields-->
<PINDeliveryAddress OneTimeUse="true">
  <Line1>xxxx</Line1>
  <City>xxx</City>
  <Zipcode>xxxx</Zipcode>
  <CountryCode>xxxx</CountryCode>
</PINDeliveryAddress>
<Limits>
  <Value Transaction="unlimited" Daily="200" Weekly="unlimited" Monthly="400"/>
  <Volume Transaction="100" Daily="unlimited" Weekly="unlimited" Monthly="unlimited"/>
  <Transactions Daily="unlimited" Weekly="unlimited" Monthly="unlimited"/>
  <Day Monday="true" Tuesday="true" Wednesday="true" Thursday="true" Friday="true" Saturday="false" Sunday="false"/>
  <Time Start="unlimited" End="17:00:00"/>
</Limits>
<Products>
  <FuelProductRestrictionID>40</FuelProductRestrictionID>
  <NonFuelProductRestrictionID>51</NonFuelProductRestrictionID>
  <NonFuelProductRestrictionID>52</NonFuelProductRestrictionID>
  <NonFuelProductRestrictionID>53</NonFuelProductRestrictionID>
  <NonFuelProductRestrictionID>54</NonFuelProductRestrictionID>
  <NonFuelProductRestrictionID>55</NonFuelProductRestrictionID>
</Products>
  </Card>

  <Block RequestID="8"
     RequestRef="69A3E44D-DC10-4BEE-9249-1FC3C651BA0E">
<CustomerNumber>xxxxx</CustomerNumber>
<PAN>xxxxxx</PAN>
  </Block>
 </BCIRequest>

I need to update the element value in the above values. The old value is:

<SelectedPIN>0123</SelectedPIN>

And the new value should be: 

<SelectedPIN EncryptedPIN="TKDS" FormNumber="000793906306">****</SelectedPIN>

Can anyone can help me on this?
If I selected the BCIRequest element, it's returning a null value. I've tried many solutions but unable to get one working on this XML file.

Upvotes: 1

Views: 118

Answers (2)

user5930261
user5930261

Reputation:

The root node (BCIRequest) contains a namespace so you need to include that into your query. Something like this should work:

        XNamespace ns = "urn:xxxxxx:bci:request";
        IEnumerable<XElement> collection = doc.Elements(ns + "BCIRequest").Elements(ns + "Card").Elements(ns + "SelectedPIN");

Upvotes: 0

Hari Prasad
Hari Prasad

Reputation: 16956

There many ways an Xml can be be modified, I prefer XDocument

XDocument doc = XDocument.Parse(input);

foreach (var element in  doc.Descendants("SelectedPIN")) // filter if you want single element, in example I modifed for all elements.
{
    element.Add(new XAttribute("EncryptedPIN", "TKDS"));
    element.Add(new XAttribute("FormNumber", "000793906306"));
    element.Value = "xxxxx"; //new value
}

and finally you can save the document using

doc.Save();

Take a look at this Demo

Upvotes: 3

Related Questions