using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization.Formatters.Binary;

using System.IO;

using ExtensionMethods;

​

public class Program

{

    public static void Main()

    {

        var ord = new order();

        var lst = new List<order>();

        var lstAgrPai = new List<order>();

        var lstFilhos = new List<order>();

        lst.Add(new order{guid = "aaa",Parent="   ",ProductID="109",Description="Burger"     ,Quantity=(decimal)2.00});

        lst.Add(new order{guid = "bbb",Parent="aaa",ProductID="800",Description="Bacon"      ,Quantity=(decimal)0.70});

        lst.Add(new order{guid = "ccc",Parent="xxx",ProductID="101",Description="Fries"      ,Quantity=(decimal)1.80});

        lst.Add(new order{guid = "ddd",Parent="xxx",ProductID="101",Description="Fries"      ,Quantity=(decimal)1.80});

        lst.Add(new order{guid = "eee",Parent="xxx",ProductID="101",Description="Fries"      ,Quantity=(decimal)1.80});

        lst.Add(new order{guid = "fff",Parent="   ",ProductID="102",Description="Large Fries",Quantity=(decimal)2.80});     

        lst.Add(new order{guid = "ggg",Parent="   ",ProductID="109",Description="Burger"     ,Quantity=(decimal)2.00});

        lst.Add(new order{guid = "hhh",Parent="ggg",ProductID="800",Description="Bacon"      ,Quantity=(decimal)0.70});     

        lst.Add(new order{guid = "iii",Parent="   ",ProductID="102",Description="Large Fries",Quantity=(decimal)2.80});

        lst.Add(new order{guid = "zz1",Parent=""   ,ProductID="105",Description="Meat"       ,Quantity=(decimal)3.10});

        lst.Add(new order{guid = "zz2",Parent=""   ,ProductID="105",Description="Meat"       ,Quantity=(decimal)3.10});

        lst.Add(new order{guid = "zz3",Parent=""   ,ProductID="105",Description="Meat"       ,Quantity=(decimal)3.10});

        lst.Add(new order{guid = "xxx",Parent=""   ,ProductID="103",Description="Onion"       ,Quantity=(decimal)8.00}); //Sem Filhos (no kids)

        lst.Add(new order{guid = "zz5",Parent="z0",ProductID="105",Description="Meat"        ,Quantity=(decimal)3.10});

        lst.Add(new order{guid = "zz6",Parent="z0",ProductID="105",Description="Meat"        ,Quantity=(decimal)3.10});

        lst.Add(new order{guid = "zz4",Parent="z0",ProductID="105",Description="Meat"        ,Quantity=(decimal)3.10});

        lst.Add(new order{guid = "zz0",Parent="z0",ProductID="105",Description="Meat"        ,Quantity=(decimal)4.10});

        lst.Add(new order{guid = "0z3",Parent=null ,ProductID="100",Description="Abbb"       ,Quantity=(decimal)1.10});     

        lst.Add(new order{guid = "0z2",Parent=null ,ProductID="100",Description="Abbb"       ,Quantity=(decimal)1.10});

        lst.Add(new order{guid = "0z1",Parent=null ,ProductID="100",Description="Abbb"       ,Quantity=(decimal)1.10});

        //Teste 01

        Console.WriteLine("\n-Consolid 01:");

        var lstCons2 = lst.GroupBy(x => new

        {

             x.ProductID             

        }).Select(x => new

        {

             Parent = x.First().Parent,

             ProductID = x.Key.ProductID,   // x.First().Description,        

             Quantity = (decimal) x.Count(), //x.Sum(p => p.Quantity),

             Total = (decimal) x.Sum(p => p.Quantity)

        });

        foreach(var it in lstCons2.OrderBy(x => x.ProductID)) //ord.ListarD(lstCons2);

        { 

          //Console.WriteLine(  it.ProductID                        + ": " +  it.Parent                         + "; " + it.Quantity                            + "; " + it.Total + "; ");

            Console.WriteLine( (it.ProductID ?? "").PadLeft(4, ' ') + ": " + (it.Parent?? "").PadLeft(4, ' ')   + "; " + it.Quantity.ToString().PadLeft(5, ' ') + "; " + it.Total.ToString().PadLeft(5, ' ') + "; ");

        }

        //Teste 02

        Console.WriteLine("\n-Consolid 02:");

        var lstAgrpTmp = lst.GroupBy(x => new

        {

             x.ProductID,

             x.Parent    

        }).Select(x => new

        {

             id = x.OrderBy(o => o.guid).First().guid, //id = x.First().guid, 

             ProductID = x.Key.ProductID,            

             Parent = x.Key.Parent,

             CountVlr = (decimal) x.Count(), //x.Sum(p => p.Quantity),

             Total = (decimal)x.Sum(p => p.Quantity)

        });

        foreach(var it in lstAgrpTmp.OrderBy(x => x.ProductID))

        { 

            Console.WriteLine( "(" + (it.id ?? "").PadLeft(3, ' ') + ") " + (it.ProductID ?? "").PadLeft(4, ' ') + ": " + (it.Parent?? "").PadLeft(4, ' ')   + "; " + it.CountVlr.ToString().PadLeft(5, ' ') + "; " + it.Total.ToString().PadLeft(5, ' ') + "; ");

        }

        //Detalhe

        Console.WriteLine("\n-Detalhe:");

        ord.ListarId(lst);

​

        //Adicionar Itens Filho na Lista (Copia da lista para manter a lista original)  

        foreach(var it in lst.OrderBy(x => x.ProductID).ThenBy(x=> x.Parent).ToList())  //(copia por referencia) lstFilhos = lst.ToList();

        {

            var x = Extensions.DeepClone<order>(it) ;                       

            lstFilhos.Add(x);

        }       

        //Adicionar Itens Pai  na Lista (Copia da lista para manter a lista original)  

        foreach(var it in lstFilhos.OrderBy(x => x.ProductID).ThenBy(x=> x.Parent).ToList())

        {               

            //Adicionar Item Consolidado

            var itCons = lstAgrpTmp.Where(x=> x.id == it.guid).FirstOrDefault();

            if (itCons != null)

            {               

                var itFilho = lstFilhos.Where(x=> x.guid == it.guid).FirstOrDefault();              

                if(itFilho != null){                    

                    var itPai = Extensions.DeepClone<order>(itFilho)    ;                       

                    itPai.guidPai = it.guid;

                    itPai.Total = itCons.Total; itPai.Quantity = itCons.Total;      

                    if( itCons.CountVlr > 1){

                        itPai.FlagConsolidado = true;

                        itFilho.FlagConsolidado = true; //Marcar Consolidado no Filho

                    }

                    lstAgrPai.Add(itPai);

                }

            }                               

        }

        Console.WriteLine("\n-Lista Pai:");

        ord.ListarId(lstAgrPai);

        //Itens Filhos definir o Id dos Pais

        foreach(var it in lstFilhos.Where(x=> x.guidPai == null).OrderBy(x => x.ProductID).ThenBy(x=> x.Parent))

        {   

            //Encontrar o Pai

            var itPai = lstAgrPai.Where(x=> (x.ProductID ?? "") == (it.ProductID ?? "") && (x.Parent ?? "") == (it.Parent ?? "") ).FirstOrDefault();

            if (itPai != null)

            {

                //Ajustar 

                if( itPai.FlagConsolidado ){

                    it.guidPai = itPai.guid;

                    it.Total = itPai.Total;

                }

            }                               

        }

        //Teste - Forcar Erro (OK Funciona) - Comentado

        //foreach(var it in lstFilhos.OrderBy(x => x.guidPai).ThenBy(x=> x.guid)) {

        //  if (it.guid == "ddd"){ it.Quantity = 5;}

        //  if (it.guid == "ddd"){ it.Quantity = 0;}

        //}

        //Validar Itens

        //Valor Invalido <  0

        //Valor Valido   >= 0 

        //     Nao consolidado => 2

        //     Consolidado     => 1

        //     Erro            => -1 ou -2

        foreach(var it in lstFilhos.OrderBy(x => x.guidPai).ThenBy(x=> x.guid)) //.Where(x=> x.guidPai != null)

        {   

            it.nValidar = 1;

            if((it.guidPai ?? "").Equals("")){ it.nValidar = 2; continue;}

            //Sumarizar o proprio item pelo guidPai

            decimal TotalFilho = 0;

            try{

                TotalFilho = lstFilhos.Where(x=> (!(x.guidPai ?? "").Equals("")) && (it.guidPai == x.guidPai) ).Sum(x => x.Quantity);

                if(TotalFilho<=0 ) { it.nValidar = -1;}

            } catch (Exception)    { it.nValidar = -1;}

            //Encontrar o Pai

            if (TotalFilho > 0)

            {

                try{

                    var itPai = lstAgrPai.Where(x=> (x.guid ?? "") == (it.guidPai ?? "") ).FirstOrDefault();                    

                    if (itPai.Quantity != TotalFilho){

                        //Item Ivalido

                        it.nValidar = -2;

                    }

                } catch (Exception)    { it.nValidar = -2;}

            }           

        }

        Console.WriteLine("\n-Lista Filhos:");

        ord.ListarId(lstFilhos);

        //Detalhe

        Console.WriteLine("\n-Detalhe:");

        ord.ListarId(lst);

    }

}

​

​

​

[Serializable]

public  class order

{

    public  string  guid       {get;set;}

    public  string  guidPai    {get;set;}

    public  string  Parent     {get;set;}

    public  string  ProductID  {get;set;}

    public  string  Description{get;set;}

    public  decimal Quantity   {get;set;}

    public  decimal Total      {get;set;}

    public  bool    FlagConsolidado  {get;set;}

    public  int     nValidar  {get;set;}

    //public  order(){}

    public  void ListarResumo(List<order> lst){

        foreach(var it in lst.OrderBy(x => x.ProductID).ThenBy(x=> x.Parent))

        { 

            Console.WriteLine( "("        + (it.guid ?? "").PadRight(4, ' ') + ") " + 

                               "PId: "    + (it.ProductID ?? "").PadRight(4, ' ') + ": " +  

                               "Pai: "    + (it.Parent?? "").PadRight(5, ' ') + "; " + 

                               "Qtd: "    +  it.Quantity.ToString().PadLeft(5, ' ') + "; " +  

                               "QtdTot: " +  it.Total.ToString().PadLeft(5, ' ') + "; "

                             );

        }

    }

    public  void ListarId (List<order> lst1){

        foreach(var it in lst1.OrderBy(x => x.ProductID).ThenBy(x=> x.Parent).ThenBy(x=> x.guidPai).ThenBy(x=> x.guid))

        { 

            Console.WriteLine( " - "       + it.FlagConsolidado.ToString().PadRight(5, ' ') + "; " + 

                               "("         + (it.guidPai ?? "").PadRight(4, ' ') + ") " +  

                               "("         + (it.guid ?? "").PadRight(4, ' ') + ") " +  

                               "PId: "     + (it.ProductID ?? "").PadLeft(4, ' ') + ": " +  

                               "Pai: "     + (it.Parent?? "").PadRight(5, ' ')  + "; " + 

                               "Qtd: "     + it.Quantity.ToString().PadLeft(5, ' ') + "; " +  

                               "QtdTot: "  + it.Total.ToString().PadLeft(5, ' ') + "; " +

                               "Validar: " + it.nValidar.ToString().PadLeft(5, ' ') + "; "

                             );

        }

        Console.WriteLine(" - Total: " + lst1.Sum(x=>x.Total) + " ; Total.Qtde: " + lst1.Sum(x=>x.Quantity) + " ; Cont: " + lst1.Count);

        Console.WriteLine();

    }

}

​

namespace ExtensionMethods

{

    public static class Extensions

     {

        public static bool IsGreaterThan(this int i, int value)

        {

            return i > value;

        }

        public static T DeepClone<T>(T obj)

        {

            T objResult;

            using (MemoryStream ms = new MemoryStream())

            {

                BinaryFormatter bf = new BinaryFormatter();

                bf.Serialize(ms, obj);

                ms.Position = 0;

                objResult = (T)bf.Deserialize(ms);

            }

            return objResult;

        }

​

    }

}

​