using System;

using System.Collections;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Text;

using System.Text.RegularExpressions;

using System.Xml;

using System.Xml.Linq;

public class Program

{

    public static void Main()

    {

        XElement xRecord= XElement.Parse(@"<record>

        <fields>

            <field name=""publish_GB"">

                <values>

                    <value>1</value>

                </values>

            </field>

            <field name=""id"">

                <values>

                    <value>108080</value>

                </values>

            </field>

            <field name=""name"">

                <values>

                    <value language=""en_GB"">Women's Timberland® Authentics Roll-Top Boot</value>

                </values>

            </field>

            <field name=""shortdescription"">

                <values>

                    <value language=""en_GB""></value>

                </values>

            </field>

            <field name=""longdescription"">

                <values>

                    <value language=""en_GB"">Time to be a little daring and dynamic in your choice of footwear. This premium nubuck leather women's boot is one plucky piece of footwear worth shouting about. Featuring all the best in Timberland® quality and comfort, you've got great grip underfoot, superb comfort with the Anti-Fatigue footbed, and a shaft made of sumptuous suede. Roll up or down as you wish. Down is the more adventurous option where you can show off the wacky watercolour print.</value>

                </values>

            </field>

            <field name=""sku"">

                <values>

                    <value>A14B7420</value>

                </values>

            </field>

            <field name=""CATEGORY"">

                <values>

                    <value language=""en_GB"">Footwear</value>

                </values>

            </field>

            <field name=""CATEGORY_TYPE"">

                <values>

                    <value language=""en_GB"">Boots</value>

                </values>

            </field>

            <field name=""COLOR"">

                <values>

                    <value language=""en_GB"">Vintage Indigo Nubuck With Watercolor Print</value>

                </values>

            </field>

            <field name=""COLOR_FAMILY"">

                <values>

                    <value language=""en_GB"">Blue</value>

                </values>

            </field>

            <field name=""DEPARTMENT"">

                <values>

                    <value language=""en_GB"">Ladies</value>

                </values>

            </field>

            <field name=""PRODUCT_GENDER"">

                <values>

                    <value language=""en_GB"">WOMEN</value>

                </values>

            </field>

            <field name=""PRODUCT_STYLE"">

                <values>

                    <value language=""en_GB"">Trainers</value>

                </values>

            </field>

            <field name=""SIZE_CONTEXT"">

                <values>

                    <value language=""en_GB"">WOMENS_FOOTWEAR</value>

                </values>

            </field>

            <field name=""prices"">

                <values>

                    <value currency=""GBP"">115.00000</value>

                </values>

            </field>

            <field name=""images"">

                <values>

                    <value>http://s7d2.scene7.com/is/image/TimberlandEU/A14B7420-hero?$PLP-IMAGE$</value>

                    <value>http://s7d2.scene7.com/is/image/TimberlandEU/A14B7420-hero?$PLP-SMALL-IMAGE$</value>

                    <value>http://images.timberland.com/is/image/TimberlandEU/A14B7420-alt1?$PLP-IMAGE$</value>

                    <value>http://images.timberland.com/is/image/TimberlandEU/A14B7420-alt1?$PLP-SMALL-IMAGE$</value>

                </values>

            </field>

            <field name=""SIZE"">

                <attributes>

                    <attribute>

                        <value language=""en_GB"">5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  055</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">5.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  060</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">6</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  065</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">6.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  070</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">7</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  075</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">7.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  080</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">8</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  085</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">8.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  090</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">9</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  095</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">9.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  100</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">10.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>CA14B7   W  110</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:055:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">5.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:060:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">6</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:065:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">6.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:070:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">7</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:075:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">7.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:080:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">8</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:085:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">8.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:090:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">9</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:095:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">9.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:100:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                    <attribute>

                        <value language=""en_GB"">10.5</value>

                        <stock>5000.0</stock>

                        <prices>

                            <price ref=""GBP"">115.0</price>

                        </prices>

                        <field name=""sku"">

                            <values>

<value>TB:0A14B7:432:110:W:1:</value>

                            </values>

                        </field>

                    </attribute>

                </attributes>

            </field>

        </fields>

        <categories>

            <categorytree>

                <category uniqueid=""SC_UK_WOMEN"">

                    <value language=""en_GB"">Women</value>

                </category>

            </categorytree>

            <categorytree>

                <category uniqueid=""SC_UK_WOMEN"">

                    <value language=""en_GB"">Women</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW"">

                    <value language=""en_GB"">Footwear</value>

                </category>

            </categorytree>

            <categorytree>

                <category uniqueid=""SC_UK_WOMEN"">

                    <value language=""en_GB"">Women</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW"">

                    <value language=""en_GB"">Footwear</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW-SIXINCH"">

                    <value language=""en_GB"">The Original 6-Inch Boot</value>

                </category>

            </categorytree>

            <categorytree>

                <category uniqueid=""SC_UK_WOMEN"">

                    <value language=""en_GB"">Women</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW"">

                    <value language=""en_GB"">Footwear</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW-BOOTS"">

                    <value language=""en_GB"">Boots</value>

                </category>

            </categorytree>

            <categorytree>

                <category uniqueid=""SC_UK_WOMEN"">

                    <value language=""en_GB"">Women</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW"">

                    <value language=""en_GB"">Footwear</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW-BOOTS"">

                    <value language=""en_GB"">Boots</value>

                </category>

                <category uniqueid=""SC_UK_WOMEN-FTW-BOOTS-CLASSICS"">

                    <value language=""en_GB"">Classic</value>

                </category>

            </categorytree>

            <categorytree>

            <category uniqueid=""WEBCAT"">WEBCAT</category>

            <category uniqueid=""shorts"">Shorts</category>

            </categorytree>

            <categorytree>

            <category uniqueid=""WEBSUBCAT"">WEBSUBCAT</category>

            <category uniqueid=""athletic"">Athletic</category>

            </categorytree>

            <categorytree>

            <category uniqueid=""WEBACTIVITY"">WEBACTIVITY</category>

            <category uniqueid=""rockclimbing"">Rock Climbing</category>

            </categorytree>

            <categorytree>

<category uniqueid=""WEBACTIVITY"">WEBACTIVITY</category>

<category uniqueid=""hiking"">Hiking</category>

</categorytree>

<categorytree>

<category uniqueid=""WEBACTIVITY"">WEBACTIVITY</category>

<category uniqueid=""trekking"">Trekking</category>

</categorytree>

<categorytree>

<category uniqueid=""WEBCOLLECTION"">WEBCOLLECTION</category>

<category uniqueid=""traverse"">Traverse</category>

</categorytree>

<categorytree>

<category uniqueid=""OTHER"">OTHER</category>

<category uniqueid=""cresta89nylon11elast"">Cresta—89% nylon, 11% elastane. Lightweight, breathable, stretchy fabric with a smooth hand</category>

</categorytree>

<categorytree>

<category uniqueid=""WEBMATERIALS"">WEBMATERIALS</category>

<category uniqueid=""nylon"">Nylon</category>

</categorytree>

        </categories>

    </record>");

           XElement xTransformedElementFields = new XElement("fields");

         XElement prodSku = new XElement("value");

            List<string> refcode = new List<string>();

​

            string dataImg = string.Empty;

        foreach (XElement xItem in xRecord.Element("fields").Elements("field"))

        {

             switch (xItem.Attribute("name").Value.ToLower())

             {

                default:

                     switch (xItem.Attribute("name").Value.ToLower())

                     {  

                        case("images"):

                           dataImg = xItem.Element("values").Element("value").Value;

                        break;

                     }

                 xTransformedElementFields.Add(xItem);

                 break;

             }

            //attributes

            /*if (xItem.Elements("attributes").Any())

                {

                    if (xItem.Element("attributes").Elements("attribute").Any())

                    {

                        if(xItem.Descendants("stock").Any()){

                            var sumStock = xItem.Descendants("stock").Where(s => !string.IsNullOrEmpty(s.Value)).Select(s => s.Value).ToList().Sum(x => Convert.ToInt32(x));

                            int featureVal =  sumStock * intSold90Days; 

                            xTransformedElementFields.Add(new XElement("field",

                                               new XAttribute("name", "FSM_Featured"),

                                               new XElement("values",

                                                  new XElement("value", featureVal)

                                                   )));

                            XElement CSFv = new XElement("values");

                            foreach(var xv in refcode.Distinct() ){

                                XElement CSF = new XElement("value");

                                CSF.Add(xv);

                                CSFv.Add(CSF);

                            }

                            xTransformedElementFields.Add(new XElement("field",

                                  new XAttribute("name", "FSM_CombinedSkuRef"),

                                      CSFv));

                        }

                    }

                }

            */

        }

        var listCat = new List<string>();

        if(xRecord.Elements("categories").Any()){

        var cat = xRecord.Elements("categories").Descendants("categorytree");

            foreach(var c in cat){

            var firstCat = c.Descendants("category").Distinct().First();

                Console.WriteLine(firstCat.Value);

                listCat.Add(firstCat.Value);

            }

        }

​

​

            /*var catid =xRecord.Element("categories").Descendants("category").Attributes("uniqueid");

            var catname = xRecord.Element("categories").Descendants("category");

​

            if (catid.Any())

            {

                            xTransformedElementFields.Add(new XElement("field",

                                 new XAttribute("name", "FSM_CategoryIds"),

                                 new XElement("values",

                                     catid.Select(c => c.Value).Distinct().ToList().Select(v => new XElement("value", new XCData(v.ToString()))))));

            }

            if (catname.Any())

            {

                            xTransformedElementFields.Add(new XElement("field",

                                 new XAttribute("name", "FSM_CategoryTitles"),

                                 new XElement("values",

                                     catname.Select(c => c.Value).Distinct().ToList().Select(v => new XElement("value", new XCData(v.ToString()))))));

            }*/

         xTransformedElementFields.Add(new XElement("field",

                 new XAttribute("name", "FSM_ParentCategory"),

                                        new XElement("values", 

                                                     listCat.Select(c=> c).Distinct().ToList().Select(s=> 

                                            new XElement("value",new XCData("FSM_"+ s))))));

         xTransformedElementFields.Add(new XElement("field",

                 new XAttribute("name", "FSM_DATA_IMAGE"),

                                        new XElement("values",

                                            new XElement("value",dataImg))));

            Console.WriteLine(xTransformedElementFields);

    }

}