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 string findNotCommon(string sku, string color){

            string[] left = sku.Split('_');

            string[] right = color.Split('_');

            string [] l = left.Distinct().ToArray();

            string[] r = right.Distinct().ToArray();

            var results = l.Except(r, StringComparer.OrdinalIgnoreCase);

            string id = String.Join("_",results);

            return id;

    }

    public static void Main()

    {

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

        <fields>

            <field name=""PFID"">

                <values>

                    <value>411329_SOFT_APPLE_GREEN</value>

                </values>

            </field>

            <field name=""Name"">

                <values>

                    <value>SKINNY DREAMING AWAY</value>

                </values>

            </field>

            <field name=""Description"">

                <values>

                    <value>Dummy Long Description for :SKINNY DREAMING AWAY</value>

                </values>

            </field>

            <field name=""Brand"">

                <values>

                    <value>WhiteStuff</value>

                </values>

            </field>

            <field name=""ColourGroup"">

                <values>

                    <value language=""en-GB"">GREEN</value>

                </values>

            </field>

​

            <field name=""Colour"">

                <values>

                    <value>SOFT_APPLE_GREEN</value>

                </values>

            </field>

            <field name=""ColourCode"">

                <values>

                    <value/>

                </values>

            </field>

​

            <field name=""Fabric"">

                <values>

                    <value language=""en-GB"">100% POLYESTER</value>

                </values>

            </field>

​

            <field name=""FabricType"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""Length"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""NeckShape"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""PatternType"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""PrimaryShape"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""ShirtFit"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""SleeveLength"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""Weight"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""EndUse"">

                <values>

                    <value language=""en-GB"">0</value>

                </values>

            </field>

            <field name=""Producturl"">

                <values>

                    <value language=""en-GB"">/action/ViewProduct-Start?SKU=411329128</value>

                </values>

            </field>

            <field name=""DateIntroduced"">

                <values>

                    <value>30/05/2014</value>

                </values>

            </field>

            <field name=""ProductImages"">

                <values>

                    <value>https://c3n4sovn.cloudimg.io/s/width/150/product-images/411/411329-MD-SOFT_APPLE_GREEN.jpg</value>

                </values>

            </field>

            <field name=""AlternateProductImages"">

                <values>

                    <value>https://c3n4sovn.cloudimg.io/s/width/150/product-images/411/411329-MF-SOFT_APPLE_GREEN.jpg</value>

                </values>

            </field>

            <field name=""ProductBadge"">

                <values>

                    <value/>

                </values>

            </field>

            <field name=""BVReviewRating"">

                <values>

                    <value>0</value>

                </values>

            </field>

            <field name=""BVReviewNumber"">

                <values>

                    <value>0</value>

                </values>

            </field>

​

​

            <field name=""prices""> 

                <values> 

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

                </values>

            </field>

​

​

            <field name=""Size"">

                <attributes>

                    <attribute>

                        <stock>40</stock>

                        <preorder>False</preorder>

                        <prices>

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

                        </prices>

​

​

                        <field name=""WasPrice"">

                            <values>

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

                            </values>

                        </field>

​

​

                        <field name=""sku"">

                            <values>

                                <value>411329128</value>

                            </values>

                        </field>

                        <value language=""en-GB"">OS</value>

                    </attribute>

​

                </attributes>

            </field>

        </fields>

        <categories>

            <categorytree>

​

                <category uniqueid=""1000012"">

                    <![CDATA[menswear]]>

                </category>

                <category uniqueid=""1000312"">

                    <![CDATA[Test Knitwear]]>

                </category>

            </categorytree>

        </categories>

    </record>

    <record>

        <fields>

            <field name=""PFID"">

                <values>

                    <value>411329_CLEAR_WATER_BLUE</value>

                </values>

            </field>

            <field name=""Name"">

                <values>

                    <value>SKINNY DREAMING AWAY</value>

                </values>

            </field>

            <field name=""Description"">

                <values>

                    <value>Dummy Long Description for :SKINNY DREAMING AWAY</value>

                </values>

            </field>

            <field name=""Brand"">

                <values>

                    <value>WhiteStuff</value>

                </values>

            </field>

            <field name=""ColourGroup"">

                <values>

                    <value language=""en-GB"">BLUE</value>

                </values>

            </field>

​

            <field name=""Colour"">

                <values>

                    <value>CLEAR_WATER_BLUE</value>

                </values>

            </field>

            <field name=""ColourCode"">

                <values>

                    <value/>

                </values>

            </field>

​

            <field name=""Fabric"">

                <values>

                    <value language=""en-GB"">100% POLYESTER</value>

                </values>

            </field>

​

            <field name=""FabricType"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""Length"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""NeckShape"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""PatternType"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

​

            <field name=""PrimaryShape"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""ShirtFit"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""SleeveLength"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""Weight"">

                <values>

                    <value language=""en-GB""/>

                </values>

            </field>

            <field name=""EndUse"">

                <values>

                    <value language=""en-GB"">0</value>

                </values>

            </field>

            <field name=""Producturl"">

                <values>

                    <value language=""en-GB"">/action/ViewProduct-Start?SKU=411329136</value>

                </values>

            </field>

            <field name=""DateIntroduced"">

                <values>

                    <value>30/05/2014</value>

                </values>

            </field>

            <field name=""ProductImages"">

                <values>

                    <value>https://c3n4sovn.cloudimg.io/s/width/150/product-images/411/411329-MD-CLEAR_WATER_BLUE.jpg</value>

                </values>

            </field>

            <field name=""AlternateProductImages"">

                <values>

                    <value>https://c3n4sovn.cloudimg.io/s/width/150/product-images/411/411329-MF-CLEAR_WATER_BLUE.jpg</value>

                </values>

            </field>

            <field name=""ProductBadge"">

                <values>

                    <value/>

                </values>

            </field>

            <field name=""BVReviewRating"">

                <values>

                    <value>0</value>

                </values>

            </field>

            <field name=""BVReviewNumber"">

                <values>

                    <value>0</value>

                </values>

            </field>

​

​

            <field name=""prices""> 

                <values> 

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

                </values>

            </field>

​

​

            <field name=""Size"">

                <attributes>

                    <attribute>

                        <stock>30</stock>

                        <preorder>False</preorder>

                        <prices>

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

                        </prices>

​

​

                        <field name=""WasPrice"">

                            <values>

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

                            </values>

                        </field>

​

​

                        <field name=""sku"">

                            <values>

                                <value>411329136</value>

                            </values>

                        </field>

                        <value language=""en-GB"">OS</value>

                    </attribute>

​

                </attributes>

            </field>

        </fields>

        <categories>

            <categorytree>

​

                <category uniqueid=""1000012"">

                    <![CDATA[menswear]]>

                </category>

                <category uniqueid=""1000312"">

                    <![CDATA[Test Knitwear]]>

                </category>

            </categorytree>

        </categories>

    </record></records>");

           XElement xTransformedElementFields = new XElement("records");

         XElement prodSku = new XElement("value");

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

​

            string dataImg      = string.Empty;

        string sku              = string.Empty;

        string color            = string.Empty;

        string multipleColor    = string.Empty;

        string id               = string.Empty;

        bool isMultiColour      = false;

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

        foreach(XElement xrec in xRecord.Elements("record"))

        {

            XElement xrecord = new XElement("record");

             XElement xfields = new XElement("fields");

        foreach (XElement xItem in xrec.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;

                         case("pfid"):

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

                        break;

                         case("colour"):

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

                        break;

                     }

                 xfields.Add(xItem);

                 break;

             }

            //Console.WriteLine(xfields);

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

                        }

                    }

                }

            */

        }

            //xTransformedElementFields.Add(fields);

            if(productIds.Count < 0 )

            {

            string Pid =    findNotCommon(sku,color);

                if(!string.IsNullOrEmpty(Pid)){

                    productIds.Add(Pid);

                }

            }

            else{

                var recentProductID = findNotCommon(sku,color);

                if(productIds.Contains(recentProductID)){

                isMultiColour = true;

                    id = recentProductID;

                }else{

                      isMultiColour = false;

                      productIds.Add(recentProductID);

                }

            }

            //Console.WriteLine(id);

            Console.WriteLine(sku);

            Console.WriteLine(color);

​

​

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

            }*/

         xfields.Add(new XElement("field",

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

                                        new XElement("values",

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

            xfields.Add(new XElement("field",

                 new XAttribute("name", "FSM_Multi_Colour"),

                                        new XElement("values",

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

            xfields.Add(new XElement("field",

                 new XAttribute("name", "ID"),

                                        new XElement("values",

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

            //Console.WriteLine(color);

            //Console.WriteLine(sku);

            //string output = string.Join(" ",commonWords);

            //Console.WriteLine(output);

        xrecord.Add(xfields);

        xTransformedElementFields.Add(xrecord);

    }

        //xTransformedElementFields.Add(record);

        Console.WriteLine(xTransformedElementFields);

        //Console.WriteLine(xTransformedElementFields);

    }

}