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 xSourceRecord= XElement.Parse(@"<record>

  <fields>

    <field name=""plu"">

      <values>

        <value>65</value>

      </values>

    </field>

    <field name=""style_name"">

      <values>

        <value>BISHOP</value>

      </values>

    </field>

    <field name=""publish"">

      <values>

        <value>true</value>

      </values>

    </field>

    <field name=""price"">

      <values>

        <value currency=""AUD"">249.00</value>

      </values>

    </field>

    <field name=""brand"">

      <values>

        <value>Specsavers</value>

      </values>

    </field>

    <field name=""style_number"">

      <values>

        <value>1042074</value>

      </values>

    </field>

    <field name=""materials"">

      <values>

        <value>Metal</value>

      </values>

    </field>

    <field name=""frame_type"">

      <values>

        <value>Optical</value>

      </values>

    </field>

    <field name=""release_date"">

      <values>

        <value>22/07/2013</value>

      </values>

    </field>

    <field name=""frame_gender"">

      <values>

        <value>Male</value>

      </values>

    </field>

    <field name=""type"">

      <values>

        <value>Glasses</value>

      </values>

    </field>

    <field name=""colors"">

      <attributes>

        <attribute>

          <value>Gold</value>

          <publish>true</publish>

          <prices>

            <price ref=""AUD"">249.00</price>

          </prices>

          <field name=""sku"">

            <values>

              <value>21000461</value>

            </values>

          </field>

          <field name=""images"">

            <values>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-angled-130x73.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-case-130x73.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-front-130x73.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-ortho-130x73.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-side-130x73.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-angled-200x113.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-case-200x113.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-front-200x113.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-ortho-200x113.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-side-200x113.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-angled-320x180.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-case-320x180.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-front-320x180.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-ortho-320x180.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-side-320x180.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-angled-640x360.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-case-640x360.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-front-640x360.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-ortho-640x360.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-side-640x360.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-angled-940x529.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-case-940x529.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-front-940x529.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-ortho-940x529.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-side-940x529.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-angled-2000x1125.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-case-2000x1125.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-front-2000x1125.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-ortho-2000x1125.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/images.specsavers.com/glasses-images/21000461-side-2000x1125.jpg</value>

              <value>https://s3-eu-west-1.amazonaws.com/video.specsavers.com/Frames/21000461.mp4</value>

            </values>

          </field>

          <field name=""bridge_width"">

            <values>

              <value>18.0</value>

            </values>

          </field>

          <field name=""lens_suitability"">

            <values>

              <value>Single vision</value>

              <value>Multifocals</value>

              <value>Bifocals</value>

            </values>

          </field>

          <field name=""lens_width"">

            <values>

              <value>56.0</value>

            </values>

          </field>

          <field name=""lens_depth"">

            <values>

              <value>45.6</value>

            </values>

          </field>

          <field name=""arm_length"">

            <values>

              <value>145.0</value>

            </values>

          </field>

          <field name=""frame_pd"">

            <values>

              <value>74</value>

            </values>

          </field>

          <field name=""frame_compatibility"">

            <values>

              <value>ophthalmic</value>

            </values>

          </field>

          <field name=""materials"">

            <values>

              <value>Metal</value>

            </values>

          </field>

          <field name=""release_date"">

            <values>

              <value>22/07/2013</value>

            </values>

          </field>

        </attribute>

      </attributes>

    </field>

  </fields>

  <categories>

    <categorytree>

      <category uniqueid=""frame_category18"">Timeless</category>

    </categorytree>

    <categorytree>

      <category uniqueid=""frame_category19"">Men's Glasses</category>

    </categorytree>

    <categorytree>

      <category uniqueid=""frame_gender20"">Male</category>

    </categorytree>

  </categories>

</record>");

           XElement xTransformedElementFields = new XElement("fields");

            var xAttributeElements = from attributeElement in xSourceRecord.Element("fields").Elements("field")

                                     where attributeElement.Attributes("name").Any(a => !string.IsNullOrEmpty(a.Value)) &&

                                        attributeElement.Elements("attributes").Any(ats => ats.Elements("attribute").Any(a => a.Elements("value").Any(v => !string.IsNullOrEmpty(v.Value))))

                                     select attributeElement;

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

        {

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

             {

                default:

                 xTransformedElementFields.Add(xItem);

                 break;

             } 

        }

        //attributes

        List<string> validImg = new List<string>(){"front-940x529.jpg","side-940x529.jpg","front-320x180.jpg","side-320x180.jpg"};

          if (xAttributeElements.Any())

            {

                //attributePrices = GetAttributePrices(xAttributeElements);

            }

            foreach (var xItem in xAttributeElements)

            {

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

                    {

                        default:

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

                            {

                                default:

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

                                    {

                                        case ("colors"):

                                            if (xItem.Descendants("field").Any(f => f.Attributes("name").Any(n => n.Value.ToLower() == "images") && f.Descendants("value").Any(v => !string.IsNullOrEmpty(v.Value))))

                                            {

                                                foreach(var x in xItem.Descendants("field").Where(f => f.Attributes("name").Any(n => n.Value.ToLower() == "images")).Descendants("value"))

                                                    {

                                                        Console.WriteLine(x);

                                                    }

                                            }

​

                                                break;

                                    }

                                break;

                            }

                            xTransformedElementFields.Add(xItem);

                            break;

                    }

            }

​

​

            /*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()))))));

            }*/

            //Console.WriteLine(xTransformedElementFields);

    }

}