예제 #1
0
        public int Compare(object x, object y)
        {
            InvoiceHeaderGroup inv1 = (InvoiceHeaderGroup)x;
            InvoiceHeaderGroup inv2 = (InvoiceHeaderGroup)y;

            if (inv1 != null && inv2 != null)
            {
                if (inv1.Compare(inv1, inv2) != 0)
                {
                    //parse.elementList.Insert(0, "InvoiceHeaderGroup");
                    //Invg.Insert(0 , new KeyValuePair<string, List<string>>("InvoiceGroup", ));
                    Invg.Insert(0, new KeyValuePair <string, List <string> >("InvoiceGroup", InvoiceHeaderGroup.Invhdrgrp));
                    return(-1);
                }
                else
                {
                    return(0);
                }
            }
            return(1);
        }
예제 #2
0
        public int Compare(object x, object y)
        {
            bool result = true;

            InvoiceHeaderGroup invHdr1 = (InvoiceHeaderGroup)x;
            InvoiceHeaderGroup invHdr2 = (InvoiceHeaderGroup)y;

            if (invHdr1 != null && invHdr2 != null)
            {
                if (invHdr1.InvoiceNumber != invHdr2.InvoiceNumber)
                {
                    parse.elementList.Insert(0, "InvoiceNumber");
                    Invhdrgrp.Insert(0, "InvoiceNumber");
                }

                if (invHdr1.InvoiceType != invHdr2.InvoiceType)
                {
                    parse.elementList.Insert(0, "InvoiceType");
                    Invhdrgrp.Insert(0, "InvoiceType");
                }

                if (invHdr1.InvoiceResend != invHdr2.InvoiceResend)
                {
                    Invhdrgrp.Insert(0, "InvoiceResend");

                    parse.elementList.Insert(0, "InvoiceResend");
                }

                if (invHdr1.OrderShipmentStatus != invHdr2.OrderShipmentStatus)
                {
                    parse.elementList.Insert(0, "OrderShipmentStatus");
                    Invhdrgrp.Insert(0, "OrderShipmentStatus");
                }

                if (invHdr1.InvoiceDate != invHdr2.InvoiceDate)
                {
                    parse.elementList.Insert(0, "InvoiceDate");
                    Invhdrgrp.Insert(0, "InvoiceDate");
                }
                if (invHdr1.SalesOrderNumber != invHdr2.SalesOrderNumber)
                {
                    parse.elementList.Insert(0, "SalesOrderNumber");
                    Invhdrgrp.Insert(0, "SalesOrderNumber");
                }
                if (invHdr1.SalesOrderDate != invHdr2.SalesOrderDate)
                {
                    parse.elementList.Insert(0, "SalesOrderDate");
                    Invhdrgrp.Insert(0, "SalesOrderDate");
                }
                if (invHdr1.PurchaseOrderNumber != invHdr2.PurchaseOrderNumber)
                {
                    parse.elementList.Insert(0, "PurchaseOrderNumber");
                    Invhdrgrp.Insert(0, "PurchaseOrderNumber");
                }
                if (invHdr1.RedTailPOID != invHdr2.RedTailPOID)
                {
                    parse.elementList.Insert(0, "RedTailPOID");
                    Invhdrgrp.Insert(0, "RedTailPOID");
                }
                if (invHdr1.CurrencyCode != invHdr2.CurrencyCode)
                {
                    parse.elementList.Insert(0, "CurrencyCode");
                    Invhdrgrp.Insert(0, "CurrencyCode");
                }
                if (invHdr1.InvoiceAmount != invHdr2.InvoiceAmount)
                {
                    parse.elementList.Insert(0, "InvoiceAmount");
                    Invhdrgrp.Insert(0, "InvoiceAmount");
                }
                if (invHdr1.TaxAmount != invHdr2.TaxAmount)
                {
                    parse.elementList.Insert(0, "TaxAmount");
                    Invhdrgrp.Insert(0, "TaxAmount");
                }
                if (invHdr1.FreightAmount != invHdr2.FreightAmount)
                {
                    parse.elementList.Insert(0, "FreightAmount");
                    Invhdrgrp.Insert(0, "FreightAmount");
                }
                if (invHdr1.MiscChargeAmount != invHdr2.MiscChargeAmount)
                {
                    parse.elementList.Insert(0, "MiscChargeAmount");
                    Invhdrgrp.Insert(0, "MiscChargeAmount");
                }
                if (invHdr1.SalesDiscAmount != invHdr2.SalesDiscAmount)
                {
                    parse.elementList.Insert(0, "SalesDiscAmount");
                    Invhdrgrp.Insert(0, "SalesDiscAmount");
                }
                if (invHdr1.TermsDescription != invHdr2.TermsDescription)
                {
                    parse.elementList.Insert(0, "TermsDescription");
                    Invhdrgrp.Insert(0, "TermsDescription");
                }
                if (invHdr1.TermsDiscountPercent != invHdr2.TermsDiscountPercent)
                {
                    parse.elementList.Insert(0, "TermsDiscountPercent");
                    Invhdrgrp.Insert(0, "TermsDiscountPercent");
                }
                if (invHdr1.TermsDiscountDays != invHdr2.TermsDiscountDays)
                {
                    parse.elementList.Insert(0, "TermsDiscountDays");
                    Invhdrgrp.Insert(0, "TermsDiscountDays");
                }
                if (invHdr1.TermsNetDueDays != invHdr2.TermsNetDueDays)
                {
                    parse.elementList.Insert(0, "TermsNetDueDays");
                    Invhdrgrp.Insert(0, "TermsNetDueDays");
                }
                if (invHdr1.TermsDiscountDate != invHdr2.TermsDiscountDate)
                {
                    parse.elementList.Insert(0, "TermsDiscountDate");
                    Invhdrgrp.Insert(0, "TermsDiscountDate");
                }
                if (invHdr1.TermsNetDueDate != invHdr2.TermsNetDueDate)
                {
                    parse.elementList.Insert(0, "TermsNetDueDate");
                    Invhdrgrp.Insert(0, "TermsNetDueDate");
                }
                if (invHdr1.TermsDiscountBasis != invHdr2.TermsDiscountBasis)
                {
                    parse.elementList.Insert(0, "TermsDiscountBasis");
                    Invhdrgrp.Insert(0, "TermsDiscountBasis");
                }
                if (invHdr1.TermsDiscountAmount != invHdr2.TermsDiscountAmount)
                {
                    parse.elementList.Insert(0, "TermsDiscountAmount");
                    Invhdrgrp.Insert(0, "TermsDiscountAmount");
                }
                if (invHdr1.NetInvoiceAmount != invHdr2.NetInvoiceAmount)
                {
                    parse.elementList.Insert(0, "NetInvoiceAmount");
                    Invhdrgrp.Insert(0, "NetInvoiceAmount");
                }
                if (invHdr1.ShipVia != invHdr2.ShipVia)
                {
                    parse.elementList.Insert(0, "ShipVia");
                    Invhdrgrp.Insert(0, "ShipVia");
                }
                //if(!parse.line.Contains(invHdr1.AddressGroup.Addresses[0].EntityIDCode) &&
                //	!parse.line.Contains(invHdr2.AddressGroup.Addresses[0].EntityIDCode))
                //if (invHdr1.AddressGroup.Addresses[0].EntityIDCode != "SF" &&
                //invHdr2.AddressGroup.Addresses[0].EntityIDCode != "SF")
                {
                    if (invHdr1.AddressGroup.Compare(invHdr1.AddressGroup, invHdr2.AddressGroup) != 0)
                    {
                        //ihg.Insert(0, new KeyValuePair<string, List<string>>("AddressGroup", Address.addr));
                        //ihg.Insert
                        result = false;
                        //parse.elementList.Insert(0, addr);
                    }
                }                 //if(!parse.line.Contains(CommentGroup) &&  )
                                  //string obj = invHdr2.InvoiceItemGrouprr[0].CommentGroup.ToString();
                                  //string obj2 = obj.Remove(0, 12);
                                  //if (invHdr1.CommentGroup != null)
                                  //{
                                  //	string objx = invHdr1.InvoiceItemGrouprr[0].CommentGroup.ToString();
                                  //}
                                  //string obj1 = objx.Remove(0, 12);
                                  //if (!parse.line.Contains(obj1) && !parse.line.Contains(obj2))
                if ((invHdr1.CommentGroup != null && invHdr2.CommentGroup == null) ||
                    (invHdr2.CommentGroup != null && invHdr1.CommentGroup == null))
                {
                    parse.elementList.Insert(0, "CommentGroup");
                }
                else if (invHdr1.CommentGroup == null && invHdr2.CommentGroup == null)
                {
                }
                else
                {
                    invHdr1.CommentGroup.Compare(invHdr1.CommentGroup, invHdr2.CommentGroup);
                }
                if (invHdr1.InvoiceItemGrouprr != null && invHdr2.InvoiceItemGrouprr != null && invHdr1.InvoiceItemGrouprr.Count == invHdr2.InvoiceItemGrouprr.Count)
                {
                    for (int i = 0; i < invHdr1.InvoiceItemGrouprr.Count; i++)
                    {
                        if (invHdr1.InvoiceItemGrouprr[i].Compare(invHdr1.InvoiceItemGrouprr[i], invHdr2.InvoiceItemGrouprr[i]) != 0)
                        {
                            //if(LotRecord.lotr.Count > 0)

                            result = false;
                            //parse.elementList.Insert(0,ihg.Insert(0, new KeyValuePair<string, List<string>>("InvoiceItemGroup", InvoiceHeaderGroup.Invhdrgrp)); "InvoiceItemGroup");
                        }
                    }
                }

                if (CommentGroup != null)
                {
                    if (CommentGroup.cmnt.Count > 0)
                    {
                        ihg.Insert(0, new KeyValuePair <string, List <string> >("<CommentGroup>", CommentGroup.cmnt));
                    }
                }

                if (LotRecord.lotr.Count > 0)
                {
                    ihg.Insert(0, new KeyValuePair <string, List <string> >("<LotGroup>", LotRecord.lotr));
                }
                if (InvoiceItemGroup.InvItmGrp.Count > 0)
                {
                    ihg.Insert(0, new KeyValuePair <string, List <string> >("<InvoiceItemGroup>", InvoiceItemGroup.InvItmGrp));
                }
                if (Address.addr.Count > 0)
                {
                    ihg.Insert(0, new KeyValuePair <string, List <string> >("<AddressGroup>", Address.addr));
                }
                if (Invhdrgrp.Count > 0)
                {
                    ihg.Insert(0, new KeyValuePair <string, List <string> >("<InvoiceHeaderGroup>", InvoiceHeaderGroup.Invhdrgrp));
                }
            }
            else if (invHdr1 == null && invHdr2 == null)
            {
                result = true;
            }
            else
            {
                result = false;
            }

            return(result ? 0 : 1);
        }
예제 #3
0
        static void ain(string[] args)
        {
            //Console.WriteLine("Enter Target Path");
            //string targetPath = Console.ReadLine();
            //Console.WriteLine("Enter Source Path");
            //string sourcePath = Console.ReadLine();
            //Console.WriteLine("Enter Result File Path");
            //string resultFilePath = Console.ReadLine();
            //Console.WriteLine("Enter the path for Hiearchy File");
            //string Hiearchy = Console.ReadLine();
            var       path1 = "C:\\Users\\schaturvedi\\Downloads\\child.xml";
            XDocument doc1  = XDocument.Load(path1);
            var       alle  = doc1.Descendants();

            var    file1    = Program.DeSerialize(path1);
            string sorted   = Program.GetSortedXML(path1);
            string original = Program.GetOriginalXML(path1);

            Program.FillNodesAtKey(Program.GetXDOC(sorted).Root);

            string targetPath     = @"C:\Users\schaturvedi\Downloads\Invoices (1) (1)\Invoices (1)";
            string sourcePath     = @"C:\Users\schaturvedi\Downloads\810_20200131_032553";
            string resultFilePath = @"C:\Users\schaturvedi\Desktop\Test\Result.txt";
            string Hiearchy       = @"C:\Users\schaturvedi\Downloads\hiearchy.txt";

            string[] sourceFile = Directory.GetFiles(sourcePath, "*.xml");
            //string[] HiearchyFile = Directory.GetFiles(HiearchyPath, "*.xml");
            //List<InvoiceHeaderGroup> Hir = new List<InvoiceHeaderGroup>();
            var Source = DeSerialize(sourceFile[0]);
            //var Hiearchy = DeSerialize(HiearchyFile[0]);
            //Dictionary<string, string> pt = new Dictionary<string, string>();
            //string contents = File.ReadAllText(@"C:\Users\schaturvedi\Downloads\hiearchy.txt");
            //var lines = File.ReadLines(@"C:\Users\schaturvedi\Downloads\hiearchy.txt");
            //string[] vc = lines.ToArray();
            //vc = vc.Where(x => !string.IsNullOrEmpty(x)).ToArray();
            //List<string> temp = new List<string>();
            //foreach(var v in vc)
            //{
            //    if (v.Length > 3)
            //        temp.Add(v);
            //}
            //vc = temp.ToArray();
            //List<string[]> lineList = lines.ToList();

            //pt = File.ReadLines(@"C:\Users\schaturvedi\Downloads\hiearchy.txt").ToDictionary(k => k[0], v => v[1]);

            var SourceInvoices = Source?.InvoiceGroup?.ToDictionary(x => x.InvoiceHeaderGroup.InvoiceNumber, x => x.InvoiceHeaderGroup);
            //var HiearchyInvoices = Hiearchy?.InvoiceGroup?.ToDictionary(x => x.InvoiceHeaderGroup.InvoiceNumber, x => x.InvoiceHeaderGroup);
            //InvoiceHeaderGroup hire = Hiearchy.InvoiceGroup.
            //var HiearchyInvoices = Hiearchy?.InvoiceGroup?(x => x.InvoiceHeaderGroup)

            Dictionary <string, InvoiceHeaderGroup> TargetInvoices = new Dictionary <string, InvoiceHeaderGroup>();

            string[] targetFiles = Directory.GetFiles(targetPath, "*.xml");
            foreach (var t in targetFiles)
            {
                var TargetInvoice = DeSerialize(t);
                if (!TargetInvoices.ContainsKey(TargetInvoice.InvoiceGroup[0].InvoiceHeaderGroup.InvoiceNumber))
                {
                    TargetInvoices.Add(TargetInvoice.InvoiceGroup[0].InvoiceHeaderGroup.InvoiceNumber, TargetInvoice.InvoiceGroup[0].InvoiceHeaderGroup);
                }
            }
            // List<KeyValuePair<string, string>> res = new List<KeyValuePair<string, string>>();

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

            availableInTargetAbsetInSource = TargetInvoices.Keys.Except(SourceInvoices.Keys).ToList();


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

            availableInSourceAbsentInTarget = SourceInvoices.Keys.Except(TargetInvoices.Keys).ToList();

            availableInTargetAbsetInSource.ForEach(x => TargetInvoices.Remove(x));
            availableInSourceAbsentInTarget.ForEach(x => SourceInvoices.Remove(x));

            using (StreamReader sr = new StreamReader(Hiearchy))
            {
                line = sr.ReadToEnd();
            }


            //Code=2 when Invoice is available in meta but not in target
            //List<string> availableInMasterAbsentInTarget = new List<string>();
            //availableInMasterAbsentInTarget = parentInvoices.Keys.Except(childInvoices.Keys).ToList();
            // res.AddRange(availableInMasterAbsentInTarget.Select(x => new KeyValuePair<string, string>(x, "Invoice is available in source but not in target")).ToList());
            //availableInMasterAbsentInTarget.ForEach(x => parentInvoices.Remove(x));
            //Code=3 when Invoice is available in target but not in meta
            //List<string> availableInTargetAbsentInMaster = new List<string>();
            //availableInTargetAbsentInMaster = childInvoices.Keys.Except(parentInvoices.Keys).ToList();
            //res.AddRange(availableInTargetAbsentInMaster.Select(x => new KeyValuePair<string, string>(x, "Invoice is available in target but not in source")).ToList());
            //availableInTargetAbsentInMaster.ForEach(x => childInvoices.Remove(x));



            foreach (KeyValuePair <string, InvoiceHeaderGroup> entry in TargetInvoices)
            {
                string             key   = entry.Key;
                InvoiceHeaderGroup value = entry.Value;

                InvoiceHeaderGroup par = SourceInvoices[key];
                //InvoiceHeaderGroup Hir = HiearchyInvoices[key;

                AddressGroup       obj = new AddressGroup();
                InvoiceItemGroup   IIG = new InvoiceItemGroup();
                LotGroup           lt  = new LotGroup();
                LotRecord          lr  = new LotRecord();
                InvoiceGroup       ig  = new InvoiceGroup();
                InvoiceHeaderGroup h   = entry.Value;
                //foreach (KeyValuePair<string, InvoiceHeaderGroup> ent in HiearchyInvoices)
                //{
                //     h = ent.Value;
                //}


                {
                    if (ig.Compare(par, value) != 0)
                    {
                        //result.Insert(0, new KeyValuePair<string, List< KeyValuePair<string, List<string>>>>("<InvoiceGroup>", InvoiceHeaderGroup.ihg));
                        if (elementList.Count > 0)
                        {
                            final.Insert(0, new KeyValuePair <string, List <string> >(key, elementList));
                        }
                        elementList = new List <string>();
                    }
                }
                //}
            }

            /*     using (StreamWriter writer = new StreamWriter(resultFilePath))
             *
             *   {
             *       foreach (var x in result)
             *       {
             *           writer.WriteLine(x);
             *       }
             *
             *   }*/
            var dir = @"C:\Test\testing"; // folder location

            if (!Directory.Exists(dir))   // if it doesn't exist, create
            {
                Directory.CreateDirectory(dir);
            }

            // use Path.Combine to combine 2 strings to a path

            var filename = "Testing.txt";

            dir = System.IO.Path.Combine(dir, filename);

            File.Create(dir);

            /* using (StreamWriter writer = new StreamWriter(resultFilePath))
             * {
             *   Console.WriteLine("Invoices Present in Target but not in Source");
             *   foreach(var invoice in availableInTargetAbsetInSource)
             *   {
             *       writer.WriteLine(invoice);
             *   }
             *   Console.WriteLine("\n");
             * }
             *
             * using (StreamWriter writer = new StreamWriter(resultFilePath))
             * {
             *   Console.WriteLine("Invoices Present in Source not in Target");
             *   foreach (var invoice in availableInSourceAbsentInTarget)
             *   {
             *       writer.WriteLine(invoice);
             *   }
             *   Console.WriteLine("\n");
             *
             * }*/



            using (StreamWriter writer = new StreamWriter(resultFilePath))

            {
                for (int i = 0; i < final.Count; i++)
                {
                    var rt = final[i].Value.Distinct().ToList();
                    writer.WriteLine(final[i].Key);
                    if (rt.Count > 1)
                    {
                        for (int y = 0; y < rt.Count; y++)
                        {
                            writer.WriteLine(rt[y]);
                        }
                    }
                    else
                    {
                        writer.WriteLine(final[i].Value[0]);
                    }
                }

                //            for (int y = 0; y < rt.Count; y++)

                //                for (int i=0;i<result.Count;i++)
                //    {
                //        var rt = result[i].Value.Distinct().ToList();
                //        writer.WriteLine(result[i].Key);
                //        if (rt.Count > 1 )
                //        {

                //            for(int y =0 ; y<rt.Count; y++)

                //            {
                //                if(y==rt.Count-1)
                //                {
                //                    writer.WriteLine(rt[y].Key);
                //                    for (int k = 0; k < rt[y].Value.Count; k++)
                //                    {
                //                        writer.WriteLine(rt[y].Value[k]);
                //                    }
                //                    break;
                //                }
                //                else if(rt[y].Key != rt[y+1].Key)
                //                writer.WriteLine(rt[y].Key);
                //                for( int k=0;k<rt[y].Value.Count;k++)
                //                {
                //                    writer.WriteLine(rt[y].Value[k]);
                //                }

                //            }
                //        }

                //        else
                //        {
                //            writer.WriteLine(result[i].Value[0]);
                //        }

                //    }
            }
        }