C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;
using TQL.BZT.BLL.DataContracts;
using TQL.BZT.Rules.Utils;
using System.Data.SqlClient;
using TQL.BZT.Repositories.Imaging;

/***********************************************************************************************************
 * *********************************************************************************************************
 * PLEASE NOTE:  It may be easier, and it is ok to use a BizTalk map rather than this code.  The new schemas
 *               and maps are so much better to work with.  In the future, when the custom functionality
 *               that would normally go in these methods can be generated by database settings, custom maps
 *               can be eliminated completely.
 ***********************************************************************************************************/

namespace TQL.BZT.Rules.CassInfo.Bunzl
{
    public class Rules210
    {

        /// <summary>
        /// Common 210 Settings for the group.
        /// ExtraCode to be added.But code not to be removed from Group settings.
        /// </summary>
        /// <param name="edi210Obj">ref 210 DataContract Object</param>
        /// <returns>210 DataContract Object by Reference</returns>
        public static void setGroupValues(ref TQLBZTEDI210 edi210Obj)
        {
            //Custom Rules Go Here
        }

        /***********************************************************************************************************
         * *********************************************************************************************************
         * PLEASE NOTE:  It may be easier, and it is ok to use a BizTalk map rather than this code.  The new schemas
         *               and maps are so much better to work with.  In the future, when the custom functionality
         *               that would normally go in these methods can be generated by database settings, custom maps
         *               can be eliminated completely.
         ***********************************************************************************************************/
        /// <summary>
        /// Custom Settings for individual customer
        /// </summary>
        /// <param name="edi210Obj">ref 210 DataContract Object</param>
        /// <returns>210 DataContract Object By Ref</returns>
        public static void setCustomerValues(ref TQLBZTEDI210 edi210Obj)
        {
            #region Rules
            /****       Initialize RulesInfoCollection for the Group  *****/
            RulesInfoCollection rulesinfocollection = new RulesInfoCollection();
            rulesinfocollection = edi210Obj.LOADHDR.RULEINFOCollection;

            /******    Set include/exclude flag. RuleType = 8   ******/
            /******    Derived from the defaults then modified  ******/

            //These are the most common used. Include them all. Let developer turn them off.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "B3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "C3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "G62", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N4", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "L3", "T");

            //Most Common Detail Charge Rules. Need to determine if this is moved to detail rules.
            //Not sure if there will be different rules by line level. Something to think about.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L5", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L0", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L7", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "", "T");

            //Never seen these used. Set to False. **** NOTE ***** These are not mapped in common 210 map. Flags are still checked.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "C2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "ITD", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "R3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "H3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "K1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N9_2", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N7Loop1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N7", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "M7", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "SPOLoop1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "S5Loop1", "F");

            //Detail Charge Rules set to false. Need to determine if this is moved to detail rules.
            //Not sure if there will be different rules by line level. Something to think about.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N9_5", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_POD", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_H1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_H2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L4", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_K1_2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_SPOLoop3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_SPOLoop3_SPO_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_SPOLoop3_SDQ_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N1_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N2_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N3_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N4_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N9_6", "F");
            #endregion

            bool hasValidWarehouseCode = true;
            bool hasValidBillOfLadingNumber = true;
            bool hasValidPurchaseOrderNumber = true;
            int errorCount = 0;

            string warehouseCode = "";
            string billOfLadingNumber = "";
            string purchaseOrderNumber = "";

            //Custom Rules Go Here
            #region Change B3_10 Qualifier from 140 "Actual" to 035 "Delivered";
            foreach (RulesInfo rule in edi210Obj.LOADHDR.RULEINFOCollection.Items)
            {
                if (rule.DESTINATIONNODE == "B310" && rule.DESTINATIONVALUE == "140") rule.DESTINATIONVALUE = "035";
            }
            #endregion

            #region Set R3
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC = "TQYL"; //R3*01
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ = "B"; //R3*02 "Origin"
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE = "J"; //R3*04 'J' Truckload, 'LT' LTL
            #endregion

            #region Change B3_10 Qualifier from 140 "Actual" to 035 "Delivered";
            foreach (RulesInfo rule in edi210Obj.LOADHDR.RULEINFOCollection.Items)
            {
                if (rule.DESTINATIONNODE == "B310" && rule.DESTINATIONVALUE == "140") rule.DESTINATIONVALUE = "035";
            }
            #endregion

            #region Add BT Address From Hardcoded values
            //Adds BT address info from Header Address and puts it in the top position of the StopInfoCollection.
            StopInfo210 AddressHdr = new StopInfo210();
            AddressHdr.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
            AddressHdr.ISFIRSTSTOP = true;
            AddressInfo AddressInfoColl = new AddressInfo();
            AddressInfoColl.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
            AddressInfoColl.HDRDETFLAG = "D";
            AddressInfoColl.ADDRESSQUAL = "BT";
            AddressInfoColl.NAME = "BUNZL C/O CASS";
            AddressInfoColl.ADDRESS = "PO BOX 67";
            AddressInfoColl.CITY = "ST LOUIS";
            AddressInfoColl.STATE = "MO";
            AddressInfoColl.ZIP = "63166";
            AddressInfoColl.COUNTRY = "US";

            AddressHdr.ADDRESSINFO = AddressInfoColl;
            edi210Obj.STOPINFOCollection.Items.Insert(0, AddressHdr);
            #endregion

            #region Change Address Qualifiers, Trim and UpperCase Postal code
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                if (stop.ADDRESSINFO.ADDRESSQUAL == "SF") stop.ADDRESSINFO.ADDRESSQUAL = "SH";
                if (stop.ADDRESSINFO.ADDRESSQUAL == "ST") stop.ADDRESSINFO.ADDRESSQUAL = "CN";

                stop.ADDRESSINFO.ZIP = stop.ADDRESSINFO.ZIP.ToUpper().Trim();
                string bunzl210_N902 = String.Empty;

                if ((edi210Obj.INVOICE.INVOICEHDR.FRTTERMS == "PP" && stop.ADDRESSINFO.ADDRESSQUAL == "SH") ||
                    (edi210Obj.INVOICE.INVOICEHDR.FRTTERMS == "CC" && stop.ADDRESSINFO.ADDRESSQUAL == "CN") ||
                    (edi210Obj.INVOICE.INVOICEHDR.FRTTERMS == "TP" && (stop.ISFIRSTSTOP || stop.ISLASTSTOP))
                    )
                {
                    string locName = String.Empty;
                    string zipcode = stop.ADDRESSINFO.ZIP.Trim();
                    if (zipcode.Contains(" ") && stop.ADDRESSINFO.COUNTRY.StartsWith("CA")) zipcode = zipcode.Replace(" ", "");
                    string address = stop.ADDRESSINFO.ADDRESS.ToUpper().Trim();
                    string name = stop.ADDRESSINFO.NAME.ToUpper().Trim();

                    //NEED TO ADD SWITCH CASE FOR THE 5 DIGIT CODE FOR THE RESPECTIVE WAREHOUSE
                    //This will validate the warehouse code
                    switch (zipcode)
                    {
                        //Add Zip Codes
                        #region Bunzl Warehouse Code Switch
                        case "01510":
                            bunzl210_N902 = "10104";
                            break;
                        case "01583":
                            bunzl210_N902 = "10100";
                            break;
                        case "04103":
                            bunzl210_N902 = "10101";
                            break;
                        case "06477":
                            bunzl210_N902 = "13130";
                            break;
                        case "07094":
                            bunzl210_N902 = "98981";
                            break;
                        case "08852":
                            bunzl210_N902 = "12120";
                            break;
                        case "08861":
                            if (address.Contains("1000") && address.Contains("AMBOY"))
                            {
                                if (name.Contains("R3") || name.Contains("METRO"))
                                {
                                    bunzl210_N902 = "13132";
                                }
                                else  //name.Contains("Northeast Central Warehouse"))
                                {
                                    bunzl210_N902 = "42421";
                                }
                            }
                            break;
                        case "10924":
                            bunzl210_N902 = "29294";
                            break;
                        case "12302":
                            bunzl210_N902 = "92920";
                            break;
                        case "14043":
                            bunzl210_N902 = "95950";
                            break;
                        case "15056":
                            bunzl210_N902 = "15150";
                            break;
                        case "17406":
                            if (address.Contains("3221") && address.Contains("ESPRESSO") && name.Contains("BPD"))
                            {
                                bunzl210_N902 = "89006";
                            }
                            else if (address.Contains("1510") && address.Contains("BARTLETT") && (name.Contains("BUNZL") || name.Contains("YORK")))
                            {
                                bunzl210_N902 = "18180";
                            }
                            break;
                        case "19020":
                            if (address.Contains("3600") && address.Contains("PROGRESS"))
                            {
                                if (name.Contains("RETAIL"))
                                {
                                    bunzl210_N902 = "29295";
                                }
                                else if (name.Contains("SCHWARZ") && name.Contains("SUPPLY"))
                                {
                                    bunzl210_N902 = "10103";
                                }
                                else if (name.Contains("SCHWARZ") && name.Contains("BRS"))
                                {
                                    bunzl210_N902 = "2605";
                                }
                            }
                            break;
                        case "19116":
                            bunzl210_N902 = "17170";
                            break;
                        case "21076":
                            bunzl210_N902 = "90900";
                            break;
                        case "23231":
                            bunzl210_N902 = "24244";
                            break;
                        case "27107":
                            bunzl210_N902 = "24240";
                            break;
                        case "27235":
                            bunzl210_N902 = "24242";
                            break;
                        case "28358":
                            bunzl210_N902 = "89014";
                            break;
                        case "28711":
                            bunzl210_N902 = "20202";
                            break;
                        case "29456":
                            bunzl210_N902 = "88880";
                            break;
                        case "30122":
                            if (address.Contains("825") && address.Contains("MAXHAM"))
                            {
                                if (address.Contains("400") && name.Contains("RITA")) //Suite 400
                                {
                                    bunzl210_N902 = "17174";
                                }
                                else if (address.Contains("400")) //if(name.Contains(***Bunzl Atlanta 20200)) //Suite 400
                                {
                                    bunzl210_N902 = "20200";
                                }
                                else if (address.Contains("100") && name.Contains("BPD")) //Suite 100
                                {
                                    bunzl210_N902 = "89002";
                                }
                                else if (address.Contains("100")) //if(name.Contains("Southeast Central Whse 42422")) //Suite 100
                                {
                                    bunzl210_N902 = "42422";
                                }
                            }
                            break;
                        case "33025":
                            bunzl210_N902 = "23236";
                            break;
                        case "33126":
                            bunzl210_N902 = "29298";
                            break;
                        case "33605":
                            bunzl210_N902 = "23235";
                            break;
                        case "33619":
                            if (address.Contains("9264") && address.Contains("COLUMBUS"))                  
                            {
                                bunzl210_N902 = "23230";
                            }
                            else if (address.Contains("9203") && address.Contains("KING") && (name.Contains("KING") || name.Contains("PALM")))
                            {
                                bunzl210_N902 = "23232";
                            }
                            break;
                        case "38118":
                            if (address.Contains("4037") && address.Contains("VISCOUNT") && (name.Contains("SAS") || name.Contains("SAFETY")))
                            {
                                bunzl210_N902 = "83831";
                            }
                            break;
                        case "38141":
                            bunzl210_N902 = "98983";
                            break;
						//Not a 5 digit code for Warehouse code mapping
                        //case "38225":
                        //    bunzl210_N902 = "2601";
                        //    break;
                        //case "38225":
                        //    bunzl210_N902 = "2602";
                        //    break;
                        //case "38225":
                        //    bunzl210_N902 = "2603";
                        //    break;
                        //case "38225":
                        //    bunzl210_N902 = "2604";
                        //    break;
                        case "38358":
                            bunzl210_N902 = "2612";
                            break;
                        case "38671":
                            bunzl210_N902 = "34340";
                            break;
                        case "41048":
                            bunzl210_N902 = "2611";
                            break;
                        case "42071":
                            bunzl210_N902 = "2608";
                            break;
                        case "43125":
                            bunzl210_N902 = "2606";
                            break;
                        case "44146":
                            bunzl210_N902 = "LG01";
                            break;
                        case "45011":
                            bunzl210_N902 = "89007";
                            break;
                        case "45014":
                            if (address.Contains("6021") && address.Contains("UNION"))
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
		                        {
                                    bunzl210_N902 = "50500";
                                }
		                        else if (name.Contains("MAJESTIC"))
                                {
                                    bunzl210_N902 = "75750";
                                }
                                else //name.Contains(***Bunzl Cincinnati  40400))
                                {
                                    bunzl210_N902 = "40400";
                                }
                            }
                            break;
                        case "46239":
                            bunzl210_N902 = "43430";
                            break;
                        case "46350":
                            bunzl210_N902 = "2607";
                            break;
                        case "47374":
                            bunzl210_N902 = "48481";
                            break;
                        case "48430":
                            bunzl210_N902 = "31310";
                            break;
                        case "52748":
                            bunzl210_N902 = "89009";
                            break;
                        case "55369":
                            bunzl210_N902 = "32320";
                            break;
                        case "55912":
                            bunzl210_N902 = "89010";
                            break;
                        case "60007":
                            if (address.Contains("2301") && address.Contains("LUNT"))
                            {
                                if (name.Contains("FOODHANDLER"))
                                {
                                    bunzl210_N902 = "88883";
                                }
                                else if (name.Contains("R3"))
                                {
                                    bunzl210_N902 = "38380";
                                }
                                else //name.Contains(***Mid-West Central Warehouse  42420))
                                {
                                    bunzl210_N902 = "42420";
                                }
                            }
                            else if (address.Contains("2521") && address.Contains("ALLAN") && name.Contains("EARTHWISE"))
                            {
                                bunzl210_N902 = "98982";
                            }
                            break;
                        case "60053":
                            bunzl210_N902 = "2600";
                            break;
                        case "60446":
                            bunzl210_N902 = "30300";
                            break;
                        case "63042":
                            bunzl210_N902 = "35350";
                            break;
                        case "63141":
                            if (address.Contains("City") && address.Contains("Place") && address.Contains("200"))   //1 City Place Ste 200
                            {
                                if (name.Contains("CORPORATE") && name.Contains("IMPORTS"))
                                {
                                    bunzl210_N902 = "99990";
                                }
                                else if (name.Contains("CORPORATE") && name.Contains("OFFICE"))
                                {
                                    bunzl210_N902 = "01000";
                                }
                            }
                            break;
                        case "64150":
                            if (address.Contains("5710"))                        
                            {
                                if (address.Contains("5710") && name.Contains("BPD") && name.Contains("CLARITY"))
                                {
                                    bunzl210_N902 = "86861";
                                }
                                else if (name.Contains("BPD"))
                                {
                                    bunzl210_N902 = "89001";
                                }
                            }
                            break;
                        case "64153":
                            bunzl210_N902 = "37370";
                            break;
                        case "65803":
                            bunzl210_N902 = "39390";
                            break;
                        case "67901":
                            bunzl210_N902 = "89011";
                            break;
                        case "68112":
                            bunzl210_N902 = "89003";
                            break;
                        case "70087":
                            bunzl210_N902 = "33330";
                            break;
                        case "72762":
                            bunzl210_N902 = "89008";
                            break;
                        case "73135":
                            bunzl210_N902 = "52520";
                            break;
                        case "75212":
                            bunzl210_N902 = "243";
                            break;
                        case "75234":
                            if (address.Contains("2005") && address.Contains("VALLEY") && address.Contains("100")) //Suite 100 //name.Contains("Bunzl Dallas 53530")
                            {
                                bunzl210_N902 = "53530";
                            }
                            else if (address.Contains("2005") && address.Contains("VALLEY") && address.Contains("120")) //Suite 120 //name.Contains("Southwest Central Warehouse")
                            {
                                bunzl210_N902 = "42423";
                            }
                            break;
                        case "75261":
                            bunzl210_N902 = "89016";
                            break;
                        case "76011":
                            bunzl210_N902 = "29297";
                            break;
                        case "77029":
                            bunzl210_N902 = "50502";
                            break;
                        case "77043":
                            bunzl210_N902 = "29296";
                            break;
                        case "77073":
                            bunzl210_N902 = "51510";
                            break;
                        case "78219":
                            bunzl210_N902 = "56560";
                            break;
                        case "80011":
                            //23rd Avenue, unsure if they will spell it out just using numbers
                            if (address.Contains("19700") && address.Contains("23"))
                            {
                                if (name.Contains("BPD"))                        
                                {
                                    bunzl210_N902 = "89015";
                                }
                                if (name.Contains("R3"))
                                {    
                                    bunzl210_N902 = "59590";
                                }
                            }
                            break;
                        case "80239":
                            bunzl210_N902 = "89017";
                            break;
                        case "80530":
                            bunzl210_N902 = "48480";
                            break;
                        case "84104":
                            bunzl210_N902 = "72720";
                            break;
                        case "85283":
                            bunzl210_N902 = "74740";
                            break;
                        case "87121":
                            bunzl210_N902 = "57570";
                            break;
                        case "89030":
                            bunzl210_N902 = "80807";
                            break;
                        case "90220":
                            bunzl210_N902 = "98984";
                            break;
                        case "90703":
                            bunzl210_N902 = "80800";
                            break;
                        case "90807":
                            bunzl210_N902 = "83830";
                            break;
                        case "91504":
                            bunzl210_N902 = "98980";
                            break;
                        case "91730":
                            if (address.Contains("8449") && address.Contains("MILLIKEN") && (name.Contains("FOODHANDLER") || name.Contains("RANCHO")))
                            {
                                bunzl210_N902 = "88881";
                            }
                            break;
                        case "91789":
                            bunzl210_N902 = "LG00";
                            break;
                        case "92806":
                            bunzl210_N902 = "70700";
                            break;
                        case "93030":
                            bunzl210_N902 = "73730";
                            break;
                        case "93455":
                            bunzl210_N902 = "73731";
                            break;
                        case "93725":
                            if (address.Contains("3722") && address.Contains("WILLOW")) //Suite 101
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "50503";
                                }
                                else if (name.Contains("BPD"))
                                {
                                    bunzl210_N902 = "89005";
                                }
                            }
                            break;
                        case "94538":
                            bunzl210_N902 = "85850";
                            break;
                        case "95377":
                            bunzl210_N902 = "71710";
                            break;
                        case "97015":
                            bunzl210_N902 = "82820";
                            break;
                        case "98001":
                            bunzl210_N902 = "98985";
                            break;
                        case "98390":
                            bunzl210_N902 = "76768";
                            break;
                        case "99019":
                            if (address.Contains("23502") && address.Contains("KNOX"))
                            {
                                if (name.Contains("R3"))
                                {
                                    bunzl210_N902 = "76765";
                                }
                                else if (name.Contains("BPD"))
                                {
                                    bunzl210_N902 = "89012";
                                }
                            }
                            break;
                        case "A1N5B8":
                            bunzl210_N902 = "94940";
                            break;
                        case "E1H2K9":
                            bunzl210_N902 = "93930";
                            break;
                        case "G1M2T6":
                            bunzl210_N902 = "60609";
                            break;
                        case "H1E1P4":
                            bunzl210_N902 = "60608";
                            break;
                        case "K7M8N8":
                            bunzl210_N902 = "66660";
                            break;
                        case "L7L0E8":
                            if (address.Contains("4240") && address.Contains("HARVESTER"))
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "54540";
                                }
                                else //if(name.Contains(***Bunzl Burlington 60604))
                                {
                                    bunzl210_N902 = "60604";
                                }
                            }
                            break;
                        case "R2R1V7":
                            bunzl210_N902 = "67670";
                            break;
                        case "S4N6P4":
                            bunzl210_N902 = "65650";
                            break;
                        case "T5V0A6":
                            if (address.Contains("12846") && address.Contains("170")) //170th Street
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "54541";
                                }
		                        else //if(name.Contains(***Bunzl Edmonton 61610))
		                        {
                                    bunzl210_N902 = "61610";
                                }
                            }
                            break;
                        case "V6W1G3":
                            bunzl210_N902 = "63630";
                            break;
                        default:
                            //If invalid set hasValidWarehouseCode to false
                            //Check for valid Warehouse Code
                            bunzl210_N902 = $"*******WAREHOUSE CODE NOT FOUND, Postal Code: {zipcode}*******";
                            hasValidWarehouseCode = false;
                            break;
                        #endregion
                    }
                    //If we got through the Switch statement without assigning a warehouse code, set the error
                    if (String.IsNullOrEmpty(bunzl210_N902))
                    {
                        bunzl210_N902 = $"***~~~WAREHOUSE CODE NOT FOUND, Postal Code: {zipcode}~~~***";
                    }
                    warehouseCode = bunzl210_N902;
                }
            }
            #endregion

            RefNumberInfoCollection refnumbertemp = new RefNumberInfoCollection();

            #region Add Header Reference Number
            foreach (RefNumberInfo refnum in edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items)
            {
                /*
                 * TODO: Waiting on the list of acceptable 5 digit codes, Need to add code to check for the REFNUMBERQUAL
                 * Warehouse Code 5N
                 * Compare to Acceptable 5 digit codes in switch case statment
                 */
                if ((refnum.REFNUMBERQUAL == "41" || refnum.REFNUMBERQUAL == "WC") && (refnum.EDISOURCE == "LM"))
                {
                    RefNumberInfo hrefnumber = new RefNumberInfo();
                    hrefnumber.HDRDETFLAG = "H";
                    hrefnumber.EDI210DESTINATION = "N9";
                    hrefnumber.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
                    hrefnumber.REFNUMBERQUAL = "WC";
                    hrefnumber.REFNUMBER = warehouseCode; //TODO: Change me based on list Mark Provides
                    edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber);
                }
                /*
                 * Send Purchase Order Number instead of SID, 4 (PO) PO#
                 * Purchase Order Number
                 * Format:  06N
                 */
                if ((refnum.REFNUMBERQUAL == "4" || refnum.REFNUMBERQUAL == "PO")) && (refnum.EDISOURCE == "LM"))
                {
                    RefNumberInfo hrefnumber2 = new RefNumberInfo();
                    hrefnumber2.HDRDETFLAG = "H";
                    hrefnumber2.EDI210DESTINATION = "N9";
                    hrefnumber2.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
                    hrefnumber2.REFNUMBERQUAL = "PO";
                    hrefnumber2.REFNUMBER = refnum.REFNUMBER;
                    edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber2);

                    //Check for valid Bill of Lading Number
                    //If invalid set hasValidPurchaseOrderNumber to false
                    purchaseOrderNumber = refnum.REFNUMBER;
                }
                /*
                 * Send BOL number instead of SID, 2  (BM) Bill of Lading Number
                 * Bill of Lading Number Formats 
                 * Single Shipment = 8N B/ L Number
                 * Consolidated Shipment = 9A / N 
                 * Consolidated B/ L Number with “C” or “X” prefix(C = Consolidated, X = X Doc)
                 */
                if ((refnum.REFNUMBERQUAL == "2" || refnum.REFNUMBERQUAL == "BM") && (refnum.EDISOURCE == "LM"))
                {
                    RefNumberInfo hrefnumber3 = new RefNumberInfo();
                    hrefnumber3.HDRDETFLAG = "H";
                    hrefnumber3.EDI210DESTINATION = "N9";
                    hrefnumber3.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
                    hrefnumber3.REFNUMBERQUAL = "BM";
                    hrefnumber3.REFNUMBER = refnum.REFNUMBER;
                    edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber3);

                    //Check for valid Bill of Lading Number
                    //If invalid set hasValidBillOfLadingNumber to false
                    billOfLadingNumber = refnum.REFNUMBER;
                }
            }
            #endregion
            
            #region Validate the Purchase Order Number set hasValidPurchaseOrderNumber
            //If it has a stop off...
            if (edi210Obj.STOPINFOCollection.Items.Count() > 2)
            {
                //If the Purchase Order Number is null or empty
                if (!String.IsNullOrEmpty(purchaseOrderNumber))
                {
                    hasValidPurchaseOrderNumber = false;
                }
                else
                {
                    if (!(purchaseOrderNumber.Length == 6))
                    {
                        //otherwise check for 6 digits
                        hasValidPurchaseOrderNumber = false;
                    }
                }
            }
            #endregion

            #region Validate the billOfLadingNumber set hasValidBillOfLadingNumber
            //If it has a stop off...
            if (edi210Obj.STOPINFOCollection.Items.Count() > 2)
            {
                //If the Bill of Lading Number is null or empty
                if (!String.IsNullOrEmpty(billOfLadingNumber))
                {
                    hasValidBillOfLadingNumber = false;
                }
                else
                {
                    //If the Bill of Lading Number is a Consolidated Shipment check to see it has 9 digits
                    if ((billOfLadingNumber.StartsWith("C") || billOfLadingNumber.StartsWith("X")) && !(billOfLadingNumber.Length == 9))
                    {
                        hasValidBillOfLadingNumber = false;
                    }
                    else if (!(billOfLadingNumber.Length == 8))
                    {
                        //otherwise check for 8 digits
                        hasValidBillOfLadingNumber = false;
                    }
                }
            }
            #endregion

            #region Error handling for N9
            if (!hasValidWarehouseCode)
            {
                //Flags the Error
                Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");

                //Declares a new reference number
                RefNumberInfo refNumError = new RefNumberInfo();

                //Header Details Flag to include the Reference number and set into header
                refNumError.HDRDETFLAG = "H";
                refNumError.EDI210DESTINATION = "N9";
                refNumError.REFNUMBERQUAL = "WC";
                refNumError.REFNUMBER = $"***~~~Invalid WarehouseCode: {warehouseCode}~~~***";
                //This adds the Reference into the reference collection
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refNumError);

                //Sets The SendPort Filter to trigger
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_WarehouseCode";

                //Increment the error count
                errorCount++;
            }

            if (!hasValidPurchaseOrderNumber)
            {
                //Flags the Error
                Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");

                //Declares a new reference number
                RefNumberInfo refNumError = new RefNumberInfo();

                //Header Details Flag to include the Reference number and set into header
                refNumError.HDRDETFLAG = "H";
                refNumError.EDI210DESTINATION = "N9";
                refNumError.REFNUMBERQUAL = "PO";
                refNumError.REFNUMBER = $"***~~~Invalid Purchase Order Number: {purchaseOrderNumber}~~~***";
                //This adds the Reference into the reference collection
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refNumError);

                //Sets The SendPort Filter to trigger
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_CustomerPO";

                //Increment the error count
                errorCount++;
            }

            if (!hasValidBillOfLadingNumber)
            {
                //Flags the Error
                Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");

                //Declares a new reference number
                RefNumberInfo refNumError = new RefNumberInfo();

                //Header Details Flag to include the Reference number and set into header
                refNumError.HDRDETFLAG = "H";
                refNumError.EDI210DESTINATION = "N9";
                refNumError.REFNUMBERQUAL = "BM";
                refNumError.REFNUMBER = $"***~~~Invalid Bill of Lading Number: {billOfLadingNumber}~~~***";
                //This adds the Reference into the reference collection
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refNumError);

                //Sets The SendPort Filter to trigger
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_BillOfLadingNumber";

                //Increment the error count
                errorCount++;
            }

            if (errorCount > 1)
            {
                RefNumberInfo refnumber5 = new RefNumberInfo();
                refnumber5.HDRDETFLAG = "H";
                refnumber5.EDI210DESTINATION = "N9";
                refnumber5.REFNUMBERQUAL = "PO";
                refnumber5.REFNUMBER = $"****Multiple Errors, BOL: {billOfLadingNumber}, PO: {purchaseOrderNumber}, WC: {warehouseCode}****";
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refnumber5);

                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_All";
            }
            #endregion

            #region EDI Plus
            //Call EDI PLus Populate Data
            PopulateData(ref edi210Obj);
            #endregion
        }

        public static void Template(ref TQLBZTEDI210 edi210Obj)
        {
            #region Change B3_10 Qualifier from 140 "Actual" to 035 "Delivered";
            foreach (RulesInfo rule in edi210Obj.LOADHDR.RULEINFOCollection.Items)
            {
                if (rule.DESTINATIONNODE == "B310" && rule.DESTINATIONVALUE == "140") rule.DESTINATIONVALUE = "035";
            }
            #endregion

            #region Pull LM Ref Numbers on EDI Linked Loads
            //Populate Load Manager Reference Numbers
            if (edi210Obj.EDILoadTypes.EDILoadTypeID == 1) TQL.BZT.Rules.Utils.LM.RefNumbers.PopulateLMReferenceNumbers(ref edi210Obj);
            #endregion

            #region Add Header Reference Number
            RefNumberInfo hrefnumber = new RefNumberInfo();
            hrefnumber.HDRDETFLAG = "H";
            hrefnumber.EDI210DESTINATION = "N9";
            hrefnumber.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
            hrefnumber.REFNUMBERQUAL = "CN";
            hrefnumber.REFNUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER.ToString();
            edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber);
            #endregion

            #region Add BT Address From EDI 204
            //Adds BT address info from Header Address and puts it in the top position of the StopInfoCollection.
            foreach (AddressInfo hdraddress in edi210Obj.LOADHDR.ADDRESSINFOCollection.Items)
            {
                if (hdraddress.ADDRESSQUAL == "BT")
                {
                    StopInfo210 AddressHdr = new StopInfo210();
                    AddressHdr.PONUMBER = hdraddress.PONUMBER;
                    AddressHdr.BZTSTOPID = hdraddress.BZTSTOPID;
                    AddressHdr.ISFIRSTSTOP = true;
                    AddressInfo AddressInfoColl = new AddressInfo();
                    AddressInfoColl.PONUMBER = hdraddress.PONUMBER;
                    AddressInfoColl.BZTSTOPID = hdraddress.BZTSTOPID;
                    AddressInfoColl.HDRDETFLAG = hdraddress.HDRDETFLAG;
                    AddressInfoColl.TQLADDRESSID = hdraddress.ID;
                    AddressInfoColl.ADDRESSQUAL = hdraddress.ADDRESSQUAL;
                    AddressInfoColl.NAME = hdraddress.NAME;
                    AddressInfoColl.IDQUAL = hdraddress.IDQUAL;
                    AddressInfoColl.ID = hdraddress.ID;
                    AddressInfoColl.ADDRESS = hdraddress.ADDRESS;
                    AddressInfoColl.CITY = hdraddress.CITY;
                    AddressInfoColl.STATE = hdraddress.STATE;
                    AddressInfoColl.ZIP = hdraddress.ZIP;
                    AddressInfoColl.COUNTRY = hdraddress.COUNTRY;
                    AddressHdr.ADDRESSINFO = AddressInfoColl;
                    edi210Obj.STOPINFOCollection.Items.Insert(0, AddressHdr);
                }

            }
            #endregion

            #region Shipment ID Validation
            //Remove Characters 
            if (!String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID))
            {
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains(':'))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace(":", "");
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains('#'))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace("#", "");
                //  '\'' is how to represent if it contains an apostrophe
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains('\''))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace("'", "");
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains('’'))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace("’", "");
            }

            //A little more extreme
            //Shipment must be 10 digits and start with UC.
            string sEDIShipmentID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Trim();

            if (!String.IsNullOrEmpty(sEDIShipmentID))
            {
                if (sEDIShipmentID.Contains('/'))
                {
                    string[] NonShipID = sEDIShipmentID.Split('/');

                    if (NonShipID[0].Trim().Length == 10 && NonShipID[0].Trim().Contains("UC"))
                    {
                        sEDIShipmentID = NonShipID[0];
                    }

                    else if (NonShipID[1].Trim().Length == 10 && NonShipID[1].Trim().Contains("UC"))
                    {
                        sEDIShipmentID = NonShipID[1];
                    }

                    else if (NonShipID.Length == 3)
                    {
                        if (NonShipID[2].Trim().Length == 10 && NonShipID[2].Trim().Contains("UC"))
                        {
                            sEDIShipmentID = NonShipID[2];
                        }
                    }
                    else
                    {
                        sEDIShipmentID = "****Invalid Shipment ID****";
                    }
                }
                else
                {
                    if (sEDIShipmentID.Length != 10 && !sEDIShipmentID.Contains("UC"))
                    {
                        sEDIShipmentID = "****Invalid Shipment ID****";
                    }
                }
            }
            else
            {
                sEDIShipmentID = "****Invalid Shipment ID****";
            }

            edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = sEDIShipmentID.Trim();
            #endregion

            #region Address Validation
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                //Trim Address Name if more than 30 characters;
                if (stop.ADDRESSINFO.NAME.Length > 30) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Substring(0, 30);

                //Remove Characters from Address Name
                if (!String.IsNullOrEmpty(stop.ADDRESSINFO.NAME))
                {
                    if (stop.ADDRESSINFO.NAME.Contains(':')) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Replace(":", "");
                    if (stop.ADDRESSINFO.NAME.Contains('#')) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Replace("#", "");
                    // '\'' is how to represent if it contains an apostrophe
                    if (stop.ADDRESSINFO.NAME.Contains('\'')) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Replace("'", "");
                }

                //Remove Characters from Street Address
                if (!String.IsNullOrEmpty(stop.ADDRESSINFO.ADDRESS))
                {
                    if (stop.ADDRESSINFO.ADDRESS.Contains(':')) stop.ADDRESSINFO.ADDRESS = stop.ADDRESSINFO.ADDRESS.Replace(":", "");
                    if (stop.ADDRESSINFO.ADDRESS.Contains('#')) stop.ADDRESSINFO.ADDRESS = stop.ADDRESSINFO.ADDRESS.Replace("#", "");
                    // '\'' is how to represent if it contains an apostrophe
                    if (stop.ADDRESSINFO.ADDRESS.Contains('\'')) stop.ADDRESSINFO.ADDRESS = stop.ADDRESSINFO.ADDRESS.Replace("'", "");
                }

                //Remove Characters from Address ID (N1*04)
                if (!String.IsNullOrEmpty(stop.ADDRESSINFO.ID))
                {
                    if (stop.ADDRESSINFO.ID.Contains(':')) stop.ADDRESSINFO.ID = stop.ADDRESSINFO.ADDRESS.Replace(":", "");
                    if (stop.ADDRESSINFO.ID.Contains('#')) stop.ADDRESSINFO.ID = stop.ADDRESSINFO.ADDRESS.Replace("#", "");
                    // '\'' is how to represent if it contains an apostrophe
                    if (stop.ADDRESSINFO.ID.Contains('\'')) stop.ADDRESSINFO.ID = stop.ADDRESSINFO.ADDRESS.Replace("'", "");
                }
            }
            #endregion

            #region Trim Weight to 0 decimal places
            decimal loadWeight = (decimal)edi210Obj.LOADHDR.LOADHDRINFO.WEIGHT;
            edi210Obj.LOADHDR.LOADHDRINFO.WEIGHT = Math.Round(loadWeight, 0);
            edi210Obj.LOADHDR.LOADHDRINFO.WEIGHTQUAL = "G";
            #endregion

            #region Trim Rate to 2 decimal places instead of 4
            foreach (ChargeInfo charge in edi210Obj.INVOICE.CHARGEINFOCollection.Items)
            {
                decimal rate = (decimal)charge.LINECHARGE;
                charge.LINECHARGE = decimal.Round(rate, 2);
            }
            #endregion

            #region Change Address Qualifiers
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                if (stop.ADDRESSINFO.ADDRESSQUAL == "SF") stop.ADDRESSINFO.ADDRESSQUAL = "SH";
                if (stop.ADDRESSINFO.ADDRESSQUAL == "ST") stop.ADDRESSINFO.ADDRESSQUAL = "CN";
            }
            #endregion

            #region Set R3
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC = "TQYL"; //R3*01
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ = "B"; //R3*02 "Origin"
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE = "J"; //R3*04 "Motor"
            #endregion

            #region Populate LM Dates/Times
            //Pull Load Date from LM data
            //Pull Load Date from LM data - tblpickups where 0 is the first stop
            DateTime? timePickedup = TQL.BZT.Rules.Utils.LM.Picks.TimeLoaded((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, 0);

            if (timePickedup.HasValue)
            {
                DateTime pickdate = (DateTime)timePickedup;
                DateTime picktime = (DateTime)timePickedup;

                String pickupDate = pickdate.ToString("yyyyMMdd");
                String pickupTime = picktime.ToString("HHmm");

                //Add Pickup Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = pickupDate;
                hrefnumber2.DATEQUAL = "86";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
            }

            else
            {
                //Pull Load Date from LM data - tblpickups where 0 is the first stop
                DateTime? loadPickUp = TQL.BZT.Rules.Utils.LM.Loads.LoadDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
                DateTime pickup = (DateTime)loadPickUp;

                String pickupDate = pickup.ToString("yyyyMMdd");
                String pickupTime = pickup.ToString("HHmm");

                //Add Pickup Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = pickupDate;
                hrefnumber2.DATEQUAL = "86";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
            }

            //Pull Load Date from LM data - tblDrops where 0 is the last drop
            DateTime? timeDelivered = TQL.BZT.Rules.Utils.LM.Drops.TimeDelivered((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, 0);

            if (timeDelivered.HasValue)
            {
                DateTime DeliverDate = (DateTime)timeDelivered;
                DateTime DeliverTime = (DateTime)timeDelivered;

                String DelDate = DeliverDate.ToString("yyyyMMdd");
                String DelTime = DeliverTime.ToString("HHmm");

                //Add Delivery Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = DelDate;
                hrefnumber2.DATEQUAL = "35";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
            }

            else
            {
                DateTime? loadDelivery = TQL.BZT.Rules.Utils.LM.Loads.DeliveryDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
                DateTime Delivery = (DateTime)loadDelivery;

                String DeliverDate = Delivery.ToString("yyyyMMdd");
                String pickupTime = Delivery.ToString("HHmm");

                //Add Delivery Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = DeliverDate;
                hrefnumber2.DATEQUAL = "35";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);

            }
            #endregion

            #region Pull Stop DateTimes
            //Used to pull Time Loaded and Time Delivered From Stops. Uses Appointment Info if not available.
            //Clear out existing datetimes
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                stop.DATETIMEINFOCollection.Items.Clear();
            }

            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                if (stop.STOPTYPEID == 2)
                {
                    DateTime? timeDroppedStopOff = TQL.BZT.Rules.Utils.LM.Drops.TimeDeliveredByStop((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)stop.LMPICKDROPROWID);

                    RefNumberInfo refnum = new RefNumberInfo();

                    if (timeDroppedStopOff.HasValue)
                    {
                        DateTime dropdateStopOff = (DateTime)timeDroppedStopOff;
                        DateTime droptimeStopOff = (DateTime)timeDroppedStopOff;

                        String dropoffDate = dropdateStopOff.ToString("yyyyMMdd");
                        String dropoffTime = droptimeStopOff.ToString("HHmm");

                        //Add DropStopOff Date to Stop Level G62 with Qualifier;
                        DateTimeInfo dropDTI = new DateTimeInfo();
                        dropDTI.DATE = dropoffDate;
                        dropDTI.DATEQUAL = "35";
                        dropDTI.TIME = dropoffTime;
                        dropDTI.TIMEQUAL = "9";
                        stop.DATETIMEINFOCollection.Items.Add(dropDTI);

                    }

                    else
                    {
                        DateTime? loadDropOff = TQL.BZT.Rules.Utils.LM.Loads.DeliveryDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);

                        DateTime pickupStopOff = (DateTime)loadDropOff;

                        String pickupDate = pickupStopOff.ToString("yyyyMMdd");
                        String pickupTime = pickupStopOff.ToString("HHmm");

                        //Add DropStopOff Date to Header G62 with Qualifier;
                        DateTimeInfo dropDTI = new DateTimeInfo();
                        dropDTI.DATE = pickupDate;
                        dropDTI.DATEQUAL = "35";
                        dropDTI.TIME = pickupTime;
                        dropDTI.TIMEQUAL = "9";
                        stop.DATETIMEINFOCollection.Items.Add(dropDTI);
                    }
                }

                else //StopTypeID = 1
                {
                    //DateTime? timePickedupStopOff = TQL.BZT.Rules.Utils.LM.Picks.TimeLoaded((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, 0);
                    DateTime? timePickedupStopOff = TQL.BZT.Rules.Utils.LM.Picks.TimeLoadedByStop((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)stop.LMPICKDROPROWID);

                    if (timePickedupStopOff.HasValue)
                    {
                        DateTime pickdateStopOff = (DateTime)timePickedupStopOff;
                        DateTime picktimeStopOff = (DateTime)timePickedupStopOff;

                        String pickupDate = pickdateStopOff.ToString("yyyyMMdd");
                        String pickupTime = picktimeStopOff.ToString("HHmm");

                        //Add Pickup Date to Stop Level G62 with Qualifier;
                        DateTimeInfo pickDTI = new DateTimeInfo();
                        pickDTI.DATE = pickupDate;
                        pickDTI.DATEQUAL = "86";
                        pickDTI.TIME = pickupTime;
                        pickDTI.TIMEQUAL = "8";
                        stop.DATETIMEINFOCollection.Items.Add(pickDTI);
                    }

                    else
                    {
                        DateTime? loadPickUp = TQL.BZT.Rules.Utils.LM.Loads.LoadDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);

                        DateTime pickupStopOff = (DateTime)loadPickUp;

                        String pickupDate = pickupStopOff.ToString("yyyyMMdd");
                        String pickupTime = pickupStopOff.ToString("HHmm");

                        //Add Pickup Date to Header G62 with Qualifier;
                        DateTimeInfo pickDTI = new DateTimeInfo();
                        pickDTI.DATE = pickupDate;
                        pickDTI.DATEQUAL = "86";
                        pickDTI.TIME = pickupTime;
                        pickDTI.TIMEQUAL = "8";
                        stop.DATETIMEINFOCollection.Items.Add(pickDTI);
                    }
                }
            }
            #endregion

            #region Pull Equipment
            //Pull carrierID and driverID from load.
            TQL.BZT.BLL.LMDataContracts.LoadDetail LMDetail = TQL.BZT.Rules.Utils.LM.Loads.LoadInfo((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);

            string carrierid = LMDetail.CarrierId.ToString();
            string driverid = LMDetail.DriverId.ToString();
            string trucknumber = "";
            string trailernumber = "";
            int? trailerID = LMDetail.TrailerId;

            string gDBConnstr = System.Configuration.ConfigurationManager.ConnectionStrings["TQLConnectionStringDefault"].ConnectionString;

            // set to devsqlclst if not returned from configuration file
            if (string.IsNullOrEmpty(gDBConnstr))
            {
                // If this is defined in configuration file , if not it will take default
                gDBConnstr = "Data Source=devsqlclst;Initial Catalog=TQL;Integrated Security=True;";
            }

            using (SqlConnection conn = new SqlConnection(gDBConnstr))
            {
                SqlCommand cmd = new SqlCommand("spEdiGetDriverDetails", conn);

                cmd.Parameters.AddWithValue("@lCarrierId", carrierid);
                cmd.Parameters.AddWithValue("@lDriver", driverid);

                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                conn.Open();

                SqlDataReader dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    trucknumber = dr["trucknumber"].ToString();
                    trailernumber = dr["trailernumber"].ToString();
                }

                //MessageBox.Show(trucknumber + " - " + trailernumber);

                //if (trailernumber != "NOTAVAIL")
                //{
                RefNumberInfo hrefnumber5 = new RefNumberInfo();
                hrefnumber5.EDI210DESTINATION = "TrailerNumber";
                hrefnumber5.REFNUMBERQUAL = "TrailerNumber";
                hrefnumber5.REFNUMBER = trailernumber;
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber5);

                edi210Obj.LOADHDR.LOADHDRINFO.DRIVERID = trailernumber;
                //}

            }

            //Set Trailer Type for N7_11;
            string TrailerType = LMDetail.TrailerType;

            RefNumberInfo hrefnumber6 = new RefNumberInfo();
            hrefnumber6.EDI210DESTINATION = "TrailerType";
            hrefnumber6.REFNUMBERQUAL = "TrailerType";
            hrefnumber6.REFNUMBER = TrailerType;
            edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber6);

            switch (trailerID)
            {
                case 1: //Reefer
                case 23: //Reefer Team
                case 37: //Chassis-Refrigerated
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "RT"; //Reefer
                    break;

                case 2: //Van
                case 3: //Van or Reefer
                case 12: //Vented Van
                case 24: //Van Team
                case 25: //Van or Reefer Team
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "TF"; //Van
                    break;

                case 4: //Flat
                case 5: //Step Deck
                case 6: //Removable Goose Neck
                case 7: //Flat 4 Ft Tarp
                case 8: //Flat 6 Ft Tarp
                case 9: //Flat 8 Ft Tarp
                case 10: //Flat With Sides
                case 11: //Double Drop
                case 27: //Flat Team
                case 14: //Step Deck with 4 ft tarp
                case 15: //Step Deck with 6 ft tarp
                case 16: //Step Deck with 8 ft tarp
                case 17: //Removable Goose Neck with 4 ft tarp
                case 18: //Removable Goose Neck with 6 ft tarp
                case 19: //Removable Goose Neck with 8 ft tarp
                case 20: //Double Drop with 4 ft tarp
                case 21: //Double Drop with 6 ft tarp
                case 22: //Double Drop with 8 ft tarp
                case 28: //Flatbed or Stepdeck
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "FT"; //Flat
                    break;

                default:
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "TL";
                    break;
            }

            #endregion

            #region Reorder Stops to order on EDI 204
            //Stops need to be in order from LM, not on the EDI file. Only pulls linked stops.
            //Uses ReOrder210Stops Function 
            ReOrder210Stops(ref edi210Obj, false, true, true);
            #endregion

            #region Pull Stops from LM
            //Need to pull stop information from LM not from the EDI tender, even when linked.
            edi210Obj.STOPINFOCollection.Items.Clear();

            StopInfo210Collection StopInfo210 = Utils.LM.Stops.PopulateEDI210Stops((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)edi210Obj.EDIPROPERTIES.BZTTRANSACTIONID);
            edi210Obj.STOPINFOCollection = StopInfo210;
            #endregion

            #region EDI Plus
            //Call EDI PLus Populate Data
            PopulateData(ref edi210Obj);
            #endregion
        }

        public static void ReOrder210Stops(ref TQLBZTEDI210 edi210Obj, bool EDISeq, bool LMSeq, bool RemoveCancelledStops)
        {
            try
            {
                StopInfo210Collection lmStops = TQL.BZT.Rules.Utils.LM.Stops.PopulateEDI210Stops((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)edi210Obj.LOADHDR.LOADHDRINFO.BZTTRANSACTIONID);
                Dictionary<int, int> lmStopsDict = lmStops.Items.Distinct().ToDictionary(i => (int)i.LMPICKDROPROWID, i => (int)i.STOPSEQ);
                var ediStopsToBeOrdered = edi210Obj.STOPINFOCollection.Items.ToList();

                if (!EDISeq && LMSeq)
                {
                    var ediStopsToBeOrderedNoCancelledStops = ediStopsToBeOrdered.Where(x => lmStopsDict.ContainsKey((int)x.LMPICKDROPROWID)).ToList();

                    var ediStopsOrdered = ediStopsToBeOrderedNoCancelledStops.OrderBy(x => lmStopsDict[(int)x.LMPICKDROPROWID]);

                    List<StopInfo210> ediStopsOrderedList = ediStopsOrdered.ToList();
                    StopInfo210Collection ediStopsOrderedWSeq = new StopInfo210Collection();
                    foreach (var stop in ediStopsOrderedList)
                    {
                        if (lmStopsDict.ContainsKey((int)stop.LMPICKDROPROWID))
                        {
                            stop.STOPSEQ = lmStopsDict.Single(x => x.Key == stop.LMPICKDROPROWID).Value;
                            ediStopsOrderedWSeq.Items.Add(stop);
                        }
                    }

                    edi210Obj.STOPINFOCollection = ediStopsOrderedWSeq;
                }

            }
            catch (Exception e)
            {
                TQL.BZT.Logger.LogGenerator.Log(true, false, true, true, false, "TQL.BZT.Rules.Target.ReOrder210Stops", 5100, EventLogEntryType.Error, e);
            }
        }

        private static void PopulateData(ref TQLBZTEDI210 edi210obj)
        {
            //string DocType = string.Empty;
            string LoadID = string.Empty;
            //string CustomerPO = string.Empty;
            int PONumber = default(int);
            int tpprofileid = default(int);

            try
            {
                //Document Type
                //DocType = edi210obj.

                //LoadID  = ref1
                LoadID = edi210obj.LOADHDR.LOADHDRINFO.SHIPMENTID;

                //CustomerLink
                tpprofileid = (int)edi210obj.TPPROFILEINFO.TPPROFILEID;

                //PoNumber 
                PONumber = (int)edi210obj.LOADHDR.LOADHDRINFO.PONUMBER;


                //Insert in to Icab // 
                bool statusUpdated = EDIPlusAcct.InsertICabProcess(10, PONumber, 3, null, null, null); //AppID : 10 = CASS , ProcessStatus :3 = Invalid
                //statusUpdated = EDIPlusAcct.InsertICabProcess(10, PONumber, 3, tpprofileid.ToString(), null, null); //AppID : 10 = CASS , ProcessStatus :3 = Invalid
                statusUpdated = EDIPlusAcct.InsertICabProcess(10, PONumber, 3, tpprofileid.ToString(), LoadID, null); //AppID : 10 = CASS , ProcessStatus :3 = Invalid

                if (!statusUpdated)
                {
                    string exMsg = string.Empty;
                    try
                    {
                        exMsg = String.Format("InsertICabProcess for LoadID- PONumber={0}\r\nLoadID={1}", edi210obj.LOADHDR.LOADHDRINFO.PONUMBER, (LoadID ?? string.Empty));
                    }
                    catch
                    {
                        exMsg = string.Empty;
                    }
                    TQL.BZT.Logger.LogGenerator.Log(false, false, true, false, true, "TQL.BZT.Rules.CassInfo.GenericEDIPlus", "TQL.BZT.Rules.CassInfo.GenericEDIPlus.Rules210.PopulateData+\r\n" + exMsg, 2022, EventLogEntryType.Error, null);
                    exMsg = null;

                }

                if (statusUpdated)
                {
                    //Update ICab CustomerLink = TPID
                    statusUpdated = EDIPlusAcct.updateICabProcessStatus(10, PONumber, 1); //AppID : 10 = CASS , ProcessStatus 1= Valid and ready to process

                    if (!statusUpdated)
                    {
                        string exMsg = string.Empty;
                        try
                        {
                            exMsg = String.Format("updateICabProcessStatus for CASS ICab processing - PONumber={0}\r\nLoadID={1}", edi210obj.LOADHDR.LOADHDRINFO.PONUMBER, (LoadID ?? string.Empty));
                        }
                        catch
                        {
                            exMsg = string.Empty;
                        }
                        TQL.BZT.Logger.LogGenerator.Log(false, false, true, false, true, "TQL.BZT.Rules.CassInfo.GenericEDIPlus", "TQL.BZT.Rules.CassInfo.GenericEDIPlus.Rules210.PopulateData+\r\n" + exMsg, 2023, EventLogEntryType.Error, null);
                        exMsg = null;

                    }

                }
            }

            catch (Exception ex)
            {
                string exMsg = null;
                try
                {
                    exMsg = "CASS - PopulateData \r\n" +
                        "nLoadID=" + LoadID + "\r\n";
                }
                catch
                {
                    exMsg = "CASS - PopulateData \r\n";
                }
                TQL.BZT.Logger.LogGenerator.Log(false, false, true, false, true, "TQL.BZT.Rules.CassInfo.GenericEDIPlus", "TQL.BZT.Rules.CassInfo.GenericEDIPlus.Rules210.PopulateData+\r\n" + exMsg, 2023, EventLogEntryType.Error, ex);

                exMsg = null;
            }
            finally
            {
                LoadID = null;

            }
        }
    }
}

​x
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;
using TQL.BZT.BLL.DataContracts;
using TQL.BZT.Rules.Utils;
using System.Data.SqlClient;
using TQL.BZT.Repositories.Imaging;
​
/***********************************************************************************************************
 * *********************************************************************************************************
 * PLEASE NOTE:  It may be easier, and it is ok to use a BizTalk map rather than this code.  The new schemas
 *               and maps are so much better to work with.  In the future, when the custom functionality
 *               that would normally go in these methods can be generated by database settings, custom maps
 *               can be eliminated completely.
 ***********************************************************************************************************/
​
namespace TQL.BZT.Rules.CassInfo.Bunzl
{
    public class Rules210
    {
​
        /// <summary>
        /// Common 210 Settings for the group.
        /// ExtraCode to be added.But code not to be removed from Group settings.
        /// </summary>
        /// <param name="edi210Obj">ref 210 DataContract Object</param>
        /// <returns>210 DataContract Object by Reference</returns>
        public static void setGroupValues(ref TQLBZTEDI210 edi210Obj)
        {
            //Custom Rules Go Here
        }
​
        /***********************************************************************************************************
         * *********************************************************************************************************
         * PLEASE NOTE:  It may be easier, and it is ok to use a BizTalk map rather than this code.  The new schemas
         *               and maps are so much better to work with.  In the future, when the custom functionality
         *               that would normally go in these methods can be generated by database settings, custom maps
         *               can be eliminated completely.
         ***********************************************************************************************************/
        /// <summary>
        /// Custom Settings for individual customer
        /// </summary>
        /// <param name="edi210Obj">ref 210 DataContract Object</param>
        /// <returns>210 DataContract Object By Ref</returns>
        public static void setCustomerValues(ref TQLBZTEDI210 edi210Obj)
        {
            #region Rules
            /****       Initialize RulesInfoCollection for the Group  *****/
            RulesInfoCollection rulesinfocollection = new RulesInfoCollection();
            rulesinfocollection = edi210Obj.LOADHDR.RULEINFOCollection;
​
            /******    Set include/exclude flag. RuleType = 8   ******/
            /******    Derived from the defaults then modified  ******/
​
            //These are the most common used. Include them all. Let developer turn them off.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "B3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "C3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "G62", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N4", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "L3", "T");
​
            //Most Common Detail Charge Rules. Need to determine if this is moved to detail rules.
            //Not sure if there will be different rules by line level. Something to think about.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L5", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L0", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L1", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L7", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "", "T");
​
            //Never seen these used. Set to False. **** NOTE ***** These are not mapped in common 210 map. Flags are still checked.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "C2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "ITD", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "R3", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "H3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "K1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N1Loop1_N9_2", "T");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N7Loop1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N7", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "M7", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "SPOLoop1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "S5Loop1", "F");
​
            //Detail Charge Rules set to false. Need to determine if this is moved to detail rules.
            //Not sure if there will be different rules by line level. Something to think about.
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N9_5", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_POD", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_H1", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_H2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_L4", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_K1_2", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_SPOLoop3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_SPOLoop3_SPO_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_SPOLoop3_SDQ_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N1_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N2_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N3_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N4_3", "F");
            Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "LXLoop1_N1Loop3_N9_6", "F");
            #endregion
​
            bool hasValidWarehouseCode = true;
            bool hasValidBillOfLadingNumber = true;
            bool hasValidPurchaseOrderNumber = true;
            int errorCount = 0;
​
            string warehouseCode = "";
            string billOfLadingNumber = "";
            string purchaseOrderNumber = "";
​
            //Custom Rules Go Here
            #region Change B3_10 Qualifier from 140 "Actual" to 035 "Delivered";
            foreach (RulesInfo rule in edi210Obj.LOADHDR.RULEINFOCollection.Items)
            {
                if (rule.DESTINATIONNODE == "B310" && rule.DESTINATIONVALUE == "140") rule.DESTINATIONVALUE = "035";
            }
            #endregion
​
            #region Set R3
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC = "TQYL"; //R3*01
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ = "B"; //R3*02 "Origin"
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE = "J"; //R3*04 'J' Truckload, 'LT' LTL
            #endregion
​
            #region Change B3_10 Qualifier from 140 "Actual" to 035 "Delivered";
            foreach (RulesInfo rule in edi210Obj.LOADHDR.RULEINFOCollection.Items)
            {
                if (rule.DESTINATIONNODE == "B310" && rule.DESTINATIONVALUE == "140") rule.DESTINATIONVALUE = "035";
            }
            #endregion
​
            #region Add BT Address From Hardcoded values
            //Adds BT address info from Header Address and puts it in the top position of the StopInfoCollection.
            StopInfo210 AddressHdr = new StopInfo210();
            AddressHdr.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
            AddressHdr.ISFIRSTSTOP = true;
            AddressInfo AddressInfoColl = new AddressInfo();
            AddressInfoColl.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
            AddressInfoColl.HDRDETFLAG = "D";
            AddressInfoColl.ADDRESSQUAL = "BT";
            AddressInfoColl.NAME = "BUNZL C/O CASS";
            AddressInfoColl.ADDRESS = "PO BOX 67";
            AddressInfoColl.CITY = "ST LOUIS";
            AddressInfoColl.STATE = "MO";
            AddressInfoColl.ZIP = "63166";
            AddressInfoColl.COUNTRY = "US";
​
            AddressHdr.ADDRESSINFO = AddressInfoColl;
            edi210Obj.STOPINFOCollection.Items.Insert(0, AddressHdr);
            #endregion
​
            #region Change Address Qualifiers, Trim and UpperCase Postal code
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                if (stop.ADDRESSINFO.ADDRESSQUAL == "SF") stop.ADDRESSINFO.ADDRESSQUAL = "SH";
                if (stop.ADDRESSINFO.ADDRESSQUAL == "ST") stop.ADDRESSINFO.ADDRESSQUAL = "CN";
​
                stop.ADDRESSINFO.ZIP = stop.ADDRESSINFO.ZIP.ToUpper().Trim();
                string bunzl210_N902 = String.Empty;
​
                if ((edi210Obj.INVOICE.INVOICEHDR.FRTTERMS == "PP" && stop.ADDRESSINFO.ADDRESSQUAL == "SH") ||
                    (edi210Obj.INVOICE.INVOICEHDR.FRTTERMS == "CC" && stop.ADDRESSINFO.ADDRESSQUAL == "CN") ||
                    (edi210Obj.INVOICE.INVOICEHDR.FRTTERMS == "TP" && (stop.ISFIRSTSTOP || stop.ISLASTSTOP))
                    )
                {
                    string locName = String.Empty;
                    string zipcode = stop.ADDRESSINFO.ZIP.Trim();
                    if (zipcode.Contains(" ") && stop.ADDRESSINFO.COUNTRY.StartsWith("CA")) zipcode = zipcode.Replace(" ", "");
                    string address = stop.ADDRESSINFO.ADDRESS.ToUpper().Trim();
                    string name = stop.ADDRESSINFO.NAME.ToUpper().Trim();
​
                    //NEED TO ADD SWITCH CASE FOR THE 5 DIGIT CODE FOR THE RESPECTIVE WAREHOUSE
                    //This will validate the warehouse code
                    switch (zipcode)
                    {
                        //Add Zip Codes
                        #region Bunzl Warehouse Code Switch
                        case "01510":
                            bunzl210_N902 = "10104";
                            break;
                        case "01583":
                            bunzl210_N902 = "10100";
                            break;
                        case "04103":
                            bunzl210_N902 = "10101";
                            break;
                        case "06477":
                            bunzl210_N902 = "13130";
                            break;
                        case "07094":
                            bunzl210_N902 = "98981";
                            break;
                        case "08852":
                            bunzl210_N902 = "12120";
                            break;
                        case "08861":
                            if (address.Contains("1000") && address.Contains("AMBOY"))
                            {
                                if (name.Contains("R3") || name.Contains("METRO"))
                                {
                                    bunzl210_N902 = "13132";
                                }
                                else  //name.Contains("Northeast Central Warehouse"))
                                {
                                    bunzl210_N902 = "42421";
                                }
                            }
                            break;
                        case "10924":
                            bunzl210_N902 = "29294";
                            break;
                        case "12302":
                            bunzl210_N902 = "92920";
                            break;
                        case "14043":
                            bunzl210_N902 = "95950";
                            break;
                        case "15056":
                            bunzl210_N902 = "15150";
                            break;
                        case "17406":
                            if (address.Contains("3221") && address.Contains("ESPRESSO") && name.Contains("BPD"))
                            {
                                bunzl210_N902 = "89006";
                            }
                            else if (address.Contains("1510") && address.Contains("BARTLETT") && (name.Contains("BUNZL") || name.Contains("YORK")))
                            {
                                bunzl210_N902 = "18180";
                            }
                            break;
                        case "19020":
                            if (address.Contains("3600") && address.Contains("PROGRESS"))
                            {
                                if (name.Contains("RETAIL"))
                                {
                                    bunzl210_N902 = "29295";
                                }
                                else if (name.Contains("SCHWARZ") && name.Contains("SUPPLY"))
                                {
                                    bunzl210_N902 = "10103";
                                }
                                else if (name.Contains("SCHWARZ") && name.Contains("BRS"))
                                {
                                    bunzl210_N902 = "2605";
                                }
                            }
                            break;
                        case "19116":
                            bunzl210_N902 = "17170";
                            break;
                        case "21076":
                            bunzl210_N902 = "90900";
                            break;
                        case "23231":
                            bunzl210_N902 = "24244";
                            break;
                        case "27107":
                            bunzl210_N902 = "24240";
                            break;
                        case "27235":
                            bunzl210_N902 = "24242";
                            break;
                        case "28358":
                            bunzl210_N902 = "89014";
                            break;
                        case "28711":
                            bunzl210_N902 = "20202";
                            break;
                        case "29456":
                            bunzl210_N902 = "88880";
                            break;
                        case "30122":
                            if (address.Contains("825") && address.Contains("MAXHAM"))
                            {
                                if (address.Contains("400") && name.Contains("RITA")) //Suite 400
                                {
                                    bunzl210_N902 = "17174";
                                }
                                else if (address.Contains("400")) //if(name.Contains(***Bunzl Atlanta 20200)) //Suite 400
                                {
                                    bunzl210_N902 = "20200";
                                }
                                else if (address.Contains("100") && name.Contains("BPD")) //Suite 100
                                {
                                    bunzl210_N902 = "89002";
                                }
                                else if (address.Contains("100")) //if(name.Contains("Southeast Central Whse 42422")) //Suite 100
                                {
                                    bunzl210_N902 = "42422";
                                }
                            }
                            break;
                        case "33025":
                            bunzl210_N902 = "23236";
                            break;
                        case "33126":
                            bunzl210_N902 = "29298";
                            break;
                        case "33605":
                            bunzl210_N902 = "23235";
                            break;
                        case "33619":
                            if (address.Contains("9264") && address.Contains("COLUMBUS"))                  
                            {
                                bunzl210_N902 = "23230";
                            }
                            else if (address.Contains("9203") && address.Contains("KING") && (name.Contains("KING") || name.Contains("PALM")))
                            {
                                bunzl210_N902 = "23232";
                            }
                            break;
                        case "38118":
                            if (address.Contains("4037") && address.Contains("VISCOUNT") && (name.Contains("SAS") || name.Contains("SAFETY")))
                            {
                                bunzl210_N902 = "83831";
                            }
                            break;
                        case "38141":
                            bunzl210_N902 = "98983";
                            break;
                        //Not a 5 digit code for Warehouse code mapping
                        //case "38225":
                        //    bunzl210_N902 = "2601";
                        //    break;
                        //case "38225":
                        //    bunzl210_N902 = "2602";
                        //    break;
                        //case "38225":
                        //    bunzl210_N902 = "2603";
                        //    break;
                        //case "38225":
                        //    bunzl210_N902 = "2604";
                        //    break;
                        case "38358":
                            bunzl210_N902 = "2612";
                            break;
                        case "38671":
                            bunzl210_N902 = "34340";
                            break;
                        case "41048":
                            bunzl210_N902 = "2611";
                            break;
                        case "42071":
                            bunzl210_N902 = "2608";
                            break;
                        case "43125":
                            bunzl210_N902 = "2606";
                            break;
                        case "44146":
                            bunzl210_N902 = "LG01";
                            break;
                        case "45011":
                            bunzl210_N902 = "89007";
                            break;
                        case "45014":
                            if (address.Contains("6021") && address.Contains("UNION"))
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "50500";
                                }
                                else if (name.Contains("MAJESTIC"))
                                {
                                    bunzl210_N902 = "75750";
                                }
                                else //name.Contains(***Bunzl Cincinnati  40400))
                                {
                                    bunzl210_N902 = "40400";
                                }
                            }
                            break;
                        case "46239":
                            bunzl210_N902 = "43430";
                            break;
                        case "46350":
                            bunzl210_N902 = "2607";
                            break;
                        case "47374":
                            bunzl210_N902 = "48481";
                            break;
                        case "48430":
                            bunzl210_N902 = "31310";
                            break;
                        case "52748":
                            bunzl210_N902 = "89009";
                            break;
                        case "55369":
                            bunzl210_N902 = "32320";
                            break;
                        case "55912":
                            bunzl210_N902 = "89010";
                            break;
                        case "60007":
                            if (address.Contains("2301") && address.Contains("LUNT"))
                            {
                                if (name.Contains("FOODHANDLER"))
                                {
                                    bunzl210_N902 = "88883";
                                }
                                else if (name.Contains("R3"))
                                {
                                    bunzl210_N902 = "38380";
                                }
                                else //name.Contains(***Mid-West Central Warehouse  42420))
                                {
                                    bunzl210_N902 = "42420";
                                }
                            }
                            else if (address.Contains("2521") && address.Contains("ALLAN") && name.Contains("EARTHWISE"))
                            {
                                bunzl210_N902 = "98982";
                            }
                            break;
                        case "60053":
                            bunzl210_N902 = "2600";
                            break;
                        case "60446":
                            bunzl210_N902 = "30300";
                            break;
                        case "63042":
                            bunzl210_N902 = "35350";
                            break;
                        case "63141":
                            if (address.Contains("City") && address.Contains("Place") && address.Contains("200"))   //1 City Place Ste 200
                            {
                                if (name.Contains("CORPORATE") && name.Contains("IMPORTS"))
                                {
                                    bunzl210_N902 = "99990";
                                }
                                else if (name.Contains("CORPORATE") && name.Contains("OFFICE"))
                                {
                                    bunzl210_N902 = "01000";
                                }
                            }
                            break;
                        case "64150":
                            if (address.Contains("5710"))                        
                            {
                                if (address.Contains("5710") && name.Contains("BPD") && name.Contains("CLARITY"))
                                {
                                    bunzl210_N902 = "86861";
                                }
                                else if (name.Contains("BPD"))
                                {
                                    bunzl210_N902 = "89001";
                                }
                            }
                            break;
                        case "64153":
                            bunzl210_N902 = "37370";
                            break;
                        case "65803":
                            bunzl210_N902 = "39390";
                            break;
                        case "67901":
                            bunzl210_N902 = "89011";
                            break;
                        case "68112":
                            bunzl210_N902 = "89003";
                            break;
                        case "70087":
                            bunzl210_N902 = "33330";
                            break;
                        case "72762":
                            bunzl210_N902 = "89008";
                            break;
                        case "73135":
                            bunzl210_N902 = "52520";
                            break;
                        case "75212":
                            bunzl210_N902 = "243";
                            break;
                        case "75234":
                            if (address.Contains("2005") && address.Contains("VALLEY") && address.Contains("100")) //Suite 100 //name.Contains("Bunzl Dallas 53530")
                            {
                                bunzl210_N902 = "53530";
                            }
                            else if (address.Contains("2005") && address.Contains("VALLEY") && address.Contains("120")) //Suite 120 //name.Contains("Southwest Central Warehouse")
                            {
                                bunzl210_N902 = "42423";
                            }
                            break;
                        case "75261":
                            bunzl210_N902 = "89016";
                            break;
                        case "76011":
                            bunzl210_N902 = "29297";
                            break;
                        case "77029":
                            bunzl210_N902 = "50502";
                            break;
                        case "77043":
                            bunzl210_N902 = "29296";
                            break;
                        case "77073":
                            bunzl210_N902 = "51510";
                            break;
                        case "78219":
                            bunzl210_N902 = "56560";
                            break;
                        case "80011":
                            //23rd Avenue, unsure if they will spell it out just using numbers
                            if (address.Contains("19700") && address.Contains("23"))
                            {
                                if (name.Contains("BPD"))                        
                                {
                                    bunzl210_N902 = "89015";
                                }
                                if (name.Contains("R3"))
                                {    
                                    bunzl210_N902 = "59590";
                                }
                            }
                            break;
                        case "80239":
                            bunzl210_N902 = "89017";
                            break;
                        case "80530":
                            bunzl210_N902 = "48480";
                            break;
                        case "84104":
                            bunzl210_N902 = "72720";
                            break;
                        case "85283":
                            bunzl210_N902 = "74740";
                            break;
                        case "87121":
                            bunzl210_N902 = "57570";
                            break;
                        case "89030":
                            bunzl210_N902 = "80807";
                            break;
                        case "90220":
                            bunzl210_N902 = "98984";
                            break;
                        case "90703":
                            bunzl210_N902 = "80800";
                            break;
                        case "90807":
                            bunzl210_N902 = "83830";
                            break;
                        case "91504":
                            bunzl210_N902 = "98980";
                            break;
                        case "91730":
                            if (address.Contains("8449") && address.Contains("MILLIKEN") && (name.Contains("FOODHANDLER") || name.Contains("RANCHO")))
                            {
                                bunzl210_N902 = "88881";
                            }
                            break;
                        case "91789":
                            bunzl210_N902 = "LG00";
                            break;
                        case "92806":
                            bunzl210_N902 = "70700";
                            break;
                        case "93030":
                            bunzl210_N902 = "73730";
                            break;
                        case "93455":
                            bunzl210_N902 = "73731";
                            break;
                        case "93725":
                            if (address.Contains("3722") && address.Contains("WILLOW")) //Suite 101
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "50503";
                                }
                                else if (name.Contains("BPD"))
                                {
                                    bunzl210_N902 = "89005";
                                }
                            }
                            break;
                        case "94538":
                            bunzl210_N902 = "85850";
                            break;
                        case "95377":
                            bunzl210_N902 = "71710";
                            break;
                        case "97015":
                            bunzl210_N902 = "82820";
                            break;
                        case "98001":
                            bunzl210_N902 = "98985";
                            break;
                        case "98390":
                            bunzl210_N902 = "76768";
                            break;
                        case "99019":
                            if (address.Contains("23502") && address.Contains("KNOX"))
                            {
                                if (name.Contains("R3"))
                                {
                                    bunzl210_N902 = "76765";
                                }
                                else if (name.Contains("BPD"))
                                {
                                    bunzl210_N902 = "89012";
                                }
                            }
                            break;
                        case "A1N5B8":
                            bunzl210_N902 = "94940";
                            break;
                        case "E1H2K9":
                            bunzl210_N902 = "93930";
                            break;
                        case "G1M2T6":
                            bunzl210_N902 = "60609";
                            break;
                        case "H1E1P4":
                            bunzl210_N902 = "60608";
                            break;
                        case "K7M8N8":
                            bunzl210_N902 = "66660";
                            break;
                        case "L7L0E8":
                            if (address.Contains("4240") && address.Contains("HARVESTER"))
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "54540";
                                }
                                else //if(name.Contains(***Bunzl Burlington 60604))
                                {
                                    bunzl210_N902 = "60604";
                                }
                            }
                            break;
                        case "R2R1V7":
                            bunzl210_N902 = "67670";
                            break;
                        case "S4N6P4":
                            bunzl210_N902 = "65650";
                            break;
                        case "T5V0A6":
                            if (address.Contains("12846") && address.Contains("170")) //170th Street
                            {
                                if (name.Contains("R3") || name.Contains("SAFETY"))
                                {
                                    bunzl210_N902 = "54541";
                                }
                                else //if(name.Contains(***Bunzl Edmonton 61610))
                                {
                                    bunzl210_N902 = "61610";
                                }
                            }
                            break;
                        case "V6W1G3":
                            bunzl210_N902 = "63630";
                            break;
                        default:
                            //If invalid set hasValidWarehouseCode to false
                            //Check for valid Warehouse Code
                            bunzl210_N902 = $"*******WAREHOUSE CODE NOT FOUND, Postal Code: {zipcode}*******";
                            hasValidWarehouseCode = false;
                            break;
                        #endregion
                    }
                    //If we got through the Switch statement without assigning a warehouse code, set the error
                    if (String.IsNullOrEmpty(bunzl210_N902))
                    {
                        bunzl210_N902 = $"***~~~WAREHOUSE CODE NOT FOUND, Postal Code: {zipcode}~~~***";
                    }
                    warehouseCode = bunzl210_N902;
                }
            }
            #endregion
​
            RefNumberInfoCollection refnumbertemp = new RefNumberInfoCollection();
​
            #region Add Header Reference Number
            foreach (RefNumberInfo refnum in edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items)
            {
                /*
                 * TODO: Waiting on the list of acceptable 5 digit codes, Need to add code to check for the REFNUMBERQUAL
                 * Warehouse Code 5N
                 * Compare to Acceptable 5 digit codes in switch case statment
                 */
                if ((refnum.REFNUMBERQUAL == "41" || refnum.REFNUMBERQUAL == "WC") && (refnum.EDISOURCE == "LM"))
                {
                    RefNumberInfo hrefnumber = new RefNumberInfo();
                    hrefnumber.HDRDETFLAG = "H";
                    hrefnumber.EDI210DESTINATION = "N9";
                    hrefnumber.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
                    hrefnumber.REFNUMBERQUAL = "WC";
                    hrefnumber.REFNUMBER = warehouseCode; //TODO: Change me based on list Mark Provides
                    edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber);
                }
                /*
                 * Send Purchase Order Number instead of SID, 4 (PO) PO#
                 * Purchase Order Number
                 * Format:  06N
                 */
                if ((refnum.REFNUMBERQUAL == "4" || refnum.REFNUMBERQUAL == "PO")) && (refnum.EDISOURCE == "LM"))
                {
                    RefNumberInfo hrefnumber2 = new RefNumberInfo();
                    hrefnumber2.HDRDETFLAG = "H";
                    hrefnumber2.EDI210DESTINATION = "N9";
                    hrefnumber2.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
                    hrefnumber2.REFNUMBERQUAL = "PO";
                    hrefnumber2.REFNUMBER = refnum.REFNUMBER;
                    edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber2);
​
                    //Check for valid Bill of Lading Number
                    //If invalid set hasValidPurchaseOrderNumber to false
                    purchaseOrderNumber = refnum.REFNUMBER;
                }
                /*
                 * Send BOL number instead of SID, 2  (BM) Bill of Lading Number
                 * Bill of Lading Number Formats 
                 * Single Shipment = 8N B/ L Number
                 * Consolidated Shipment = 9A / N 
                 * Consolidated B/ L Number with “C” or “X” prefix(C = Consolidated, X = X Doc)
                 */
                if ((refnum.REFNUMBERQUAL == "2" || refnum.REFNUMBERQUAL == "BM") && (refnum.EDISOURCE == "LM"))
                {
                    RefNumberInfo hrefnumber3 = new RefNumberInfo();
                    hrefnumber3.HDRDETFLAG = "H";
                    hrefnumber3.EDI210DESTINATION = "N9";
                    hrefnumber3.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
                    hrefnumber3.REFNUMBERQUAL = "BM";
                    hrefnumber3.REFNUMBER = refnum.REFNUMBER;
                    edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber3);
​
                    //Check for valid Bill of Lading Number
                    //If invalid set hasValidBillOfLadingNumber to false
                    billOfLadingNumber = refnum.REFNUMBER;
                }
            }
            #endregion
            
            #region Validate the Purchase Order Number set hasValidPurchaseOrderNumber
            //If it has a stop off...
            if (edi210Obj.STOPINFOCollection.Items.Count() > 2)
            {
                //If the Purchase Order Number is null or empty
                if (!String.IsNullOrEmpty(purchaseOrderNumber))
                {
                    hasValidPurchaseOrderNumber = false;
                }
                else
                {
                    if (!(purchaseOrderNumber.Length == 6))
                    {
                        //otherwise check for 6 digits
                        hasValidPurchaseOrderNumber = false;
                    }
                }
            }
            #endregion
​
            #region Validate the billOfLadingNumber set hasValidBillOfLadingNumber
            //If it has a stop off...
            if (edi210Obj.STOPINFOCollection.Items.Count() > 2)
            {
                //If the Bill of Lading Number is null or empty
                if (!String.IsNullOrEmpty(billOfLadingNumber))
                {
                    hasValidBillOfLadingNumber = false;
                }
                else
                {
                    //If the Bill of Lading Number is a Consolidated Shipment check to see it has 9 digits
                    if ((billOfLadingNumber.StartsWith("C") || billOfLadingNumber.StartsWith("X")) && !(billOfLadingNumber.Length == 9))
                    {
                        hasValidBillOfLadingNumber = false;
                    }
                    else if (!(billOfLadingNumber.Length == 8))
                    {
                        //otherwise check for 8 digits
                        hasValidBillOfLadingNumber = false;
                    }
                }
            }
            #endregion
​
            #region Error handling for N9
            if (!hasValidWarehouseCode)
            {
                //Flags the Error
                Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");
​
                //Declares a new reference number
                RefNumberInfo refNumError = new RefNumberInfo();
​
                //Header Details Flag to include the Reference number and set into header
                refNumError.HDRDETFLAG = "H";
                refNumError.EDI210DESTINATION = "N9";
                refNumError.REFNUMBERQUAL = "WC";
                refNumError.REFNUMBER = $"***~~~Invalid WarehouseCode: {warehouseCode}~~~***";
                //This adds the Reference into the reference collection
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refNumError);
​
                //Sets The SendPort Filter to trigger
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_WarehouseCode";
​
                //Increment the error count
                errorCount++;
            }
​
            if (!hasValidPurchaseOrderNumber)
            {
                //Flags the Error
                Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");
​
                //Declares a new reference number
                RefNumberInfo refNumError = new RefNumberInfo();
​
                //Header Details Flag to include the Reference number and set into header
                refNumError.HDRDETFLAG = "H";
                refNumError.EDI210DESTINATION = "N9";
                refNumError.REFNUMBERQUAL = "PO";
                refNumError.REFNUMBER = $"***~~~Invalid Purchase Order Number: {purchaseOrderNumber}~~~***";
                //This adds the Reference into the reference collection
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refNumError);
​
                //Sets The SendPort Filter to trigger
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_CustomerPO";
​
                //Increment the error count
                errorCount++;
            }
​
            if (!hasValidBillOfLadingNumber)
            {
                //Flags the Error
                Common.UpdateIncludeSegmentRule(ref rulesinfocollection, "N9", "T");
​
                //Declares a new reference number
                RefNumberInfo refNumError = new RefNumberInfo();
​
                //Header Details Flag to include the Reference number and set into header
                refNumError.HDRDETFLAG = "H";
                refNumError.EDI210DESTINATION = "N9";
                refNumError.REFNUMBERQUAL = "BM";
                refNumError.REFNUMBER = $"***~~~Invalid Bill of Lading Number: {billOfLadingNumber}~~~***";
                //This adds the Reference into the reference collection
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refNumError);
​
                //Sets The SendPort Filter to trigger
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_BillOfLadingNumber";
​
                //Increment the error count
                errorCount++;
            }
​
            if (errorCount > 1)
            {
                RefNumberInfo refnumber5 = new RefNumberInfo();
                refnumber5.HDRDETFLAG = "H";
                refnumber5.EDI210DESTINATION = "N9";
                refnumber5.REFNUMBERQUAL = "PO";
                refnumber5.REFNUMBER = $"****Multiple Errors, BOL: {billOfLadingNumber}, PO: {purchaseOrderNumber}, WC: {warehouseCode}****";
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Insert(0, refnumber5);
​
                edi210Obj.EDIPROPERTIES.DESTFILENAME = "CassInfo_Bunzl210Error_All";
            }
            #endregion
​
            #region EDI Plus
            //Call EDI PLus Populate Data
            PopulateData(ref edi210Obj);
            #endregion
        }
​
        public static void Template(ref TQLBZTEDI210 edi210Obj)
        {
            #region Change B3_10 Qualifier from 140 "Actual" to 035 "Delivered";
            foreach (RulesInfo rule in edi210Obj.LOADHDR.RULEINFOCollection.Items)
            {
                if (rule.DESTINATIONNODE == "B310" && rule.DESTINATIONVALUE == "140") rule.DESTINATIONVALUE = "035";
            }
            #endregion
​
            #region Pull LM Ref Numbers on EDI Linked Loads
            //Populate Load Manager Reference Numbers
            if (edi210Obj.EDILoadTypes.EDILoadTypeID == 1) TQL.BZT.Rules.Utils.LM.RefNumbers.PopulateLMReferenceNumbers(ref edi210Obj);
            #endregion
​
            #region Add Header Reference Number
            RefNumberInfo hrefnumber = new RefNumberInfo();
            hrefnumber.HDRDETFLAG = "H";
            hrefnumber.EDI210DESTINATION = "N9";
            hrefnumber.PONUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER;
            hrefnumber.REFNUMBERQUAL = "CN";
            hrefnumber.REFNUMBER = edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER.ToString();
            edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber);
            #endregion
​
            #region Add BT Address From EDI 204
            //Adds BT address info from Header Address and puts it in the top position of the StopInfoCollection.
            foreach (AddressInfo hdraddress in edi210Obj.LOADHDR.ADDRESSINFOCollection.Items)
            {
                if (hdraddress.ADDRESSQUAL == "BT")
                {
                    StopInfo210 AddressHdr = new StopInfo210();
                    AddressHdr.PONUMBER = hdraddress.PONUMBER;
                    AddressHdr.BZTSTOPID = hdraddress.BZTSTOPID;
                    AddressHdr.ISFIRSTSTOP = true;
                    AddressInfo AddressInfoColl = new AddressInfo();
                    AddressInfoColl.PONUMBER = hdraddress.PONUMBER;
                    AddressInfoColl.BZTSTOPID = hdraddress.BZTSTOPID;
                    AddressInfoColl.HDRDETFLAG = hdraddress.HDRDETFLAG;
                    AddressInfoColl.TQLADDRESSID = hdraddress.ID;
                    AddressInfoColl.ADDRESSQUAL = hdraddress.ADDRESSQUAL;
                    AddressInfoColl.NAME = hdraddress.NAME;
                    AddressInfoColl.IDQUAL = hdraddress.IDQUAL;
                    AddressInfoColl.ID = hdraddress.ID;
                    AddressInfoColl.ADDRESS = hdraddress.ADDRESS;
                    AddressInfoColl.CITY = hdraddress.CITY;
                    AddressInfoColl.STATE = hdraddress.STATE;
                    AddressInfoColl.ZIP = hdraddress.ZIP;
                    AddressInfoColl.COUNTRY = hdraddress.COUNTRY;
                    AddressHdr.ADDRESSINFO = AddressInfoColl;
                    edi210Obj.STOPINFOCollection.Items.Insert(0, AddressHdr);
                }
​
            }
            #endregion
​
            #region Shipment ID Validation
            //Remove Characters 
            if (!String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID))
            {
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains(':'))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace(":", "");
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains('#'))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace("#", "");
                //  '\'' is how to represent if it contains an apostrophe
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains('\''))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace("'", "");
                if (edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Contains('’'))
                    edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Replace("’", "");
            }
​
            //A little more extreme
            //Shipment must be 10 digits and start with UC.
            string sEDIShipmentID = edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID.Trim();
​
            if (!String.IsNullOrEmpty(sEDIShipmentID))
            {
                if (sEDIShipmentID.Contains('/'))
                {
                    string[] NonShipID = sEDIShipmentID.Split('/');
​
                    if (NonShipID[0].Trim().Length == 10 && NonShipID[0].Trim().Contains("UC"))
                    {
                        sEDIShipmentID = NonShipID[0];
                    }
​
                    else if (NonShipID[1].Trim().Length == 10 && NonShipID[1].Trim().Contains("UC"))
                    {
                        sEDIShipmentID = NonShipID[1];
                    }
​
                    else if (NonShipID.Length == 3)
                    {
                        if (NonShipID[2].Trim().Length == 10 && NonShipID[2].Trim().Contains("UC"))
                        {
                            sEDIShipmentID = NonShipID[2];
                        }
                    }
                    else
                    {
                        sEDIShipmentID = "****Invalid Shipment ID****";
                    }
                }
                else
                {
                    if (sEDIShipmentID.Length != 10 && !sEDIShipmentID.Contains("UC"))
                    {
                        sEDIShipmentID = "****Invalid Shipment ID****";
                    }
                }
            }
            else
            {
                sEDIShipmentID = "****Invalid Shipment ID****";
            }
​
            edi210Obj.LOADHDR.LOADHDRINFO.SHIPMENTID = sEDIShipmentID.Trim();
            #endregion
​
            #region Address Validation
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                //Trim Address Name if more than 30 characters;
                if (stop.ADDRESSINFO.NAME.Length > 30) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Substring(0, 30);
​
                //Remove Characters from Address Name
                if (!String.IsNullOrEmpty(stop.ADDRESSINFO.NAME))
                {
                    if (stop.ADDRESSINFO.NAME.Contains(':')) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Replace(":", "");
                    if (stop.ADDRESSINFO.NAME.Contains('#')) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Replace("#", "");
                    // '\'' is how to represent if it contains an apostrophe
                    if (stop.ADDRESSINFO.NAME.Contains('\'')) stop.ADDRESSINFO.NAME = stop.ADDRESSINFO.NAME.Replace("'", "");
                }
​
                //Remove Characters from Street Address
                if (!String.IsNullOrEmpty(stop.ADDRESSINFO.ADDRESS))
                {
                    if (stop.ADDRESSINFO.ADDRESS.Contains(':')) stop.ADDRESSINFO.ADDRESS = stop.ADDRESSINFO.ADDRESS.Replace(":", "");
                    if (stop.ADDRESSINFO.ADDRESS.Contains('#')) stop.ADDRESSINFO.ADDRESS = stop.ADDRESSINFO.ADDRESS.Replace("#", "");
                    // '\'' is how to represent if it contains an apostrophe
                    if (stop.ADDRESSINFO.ADDRESS.Contains('\'')) stop.ADDRESSINFO.ADDRESS = stop.ADDRESSINFO.ADDRESS.Replace("'", "");
                }
​
                //Remove Characters from Address ID (N1*04)
                if (!String.IsNullOrEmpty(stop.ADDRESSINFO.ID))
                {
                    if (stop.ADDRESSINFO.ID.Contains(':')) stop.ADDRESSINFO.ID = stop.ADDRESSINFO.ADDRESS.Replace(":", "");
                    if (stop.ADDRESSINFO.ID.Contains('#')) stop.ADDRESSINFO.ID = stop.ADDRESSINFO.ADDRESS.Replace("#", "");
                    // '\'' is how to represent if it contains an apostrophe
                    if (stop.ADDRESSINFO.ID.Contains('\'')) stop.ADDRESSINFO.ID = stop.ADDRESSINFO.ADDRESS.Replace("'", "");
                }
            }
            #endregion
​
            #region Trim Weight to 0 decimal places
            decimal loadWeight = (decimal)edi210Obj.LOADHDR.LOADHDRINFO.WEIGHT;
            edi210Obj.LOADHDR.LOADHDRINFO.WEIGHT = Math.Round(loadWeight, 0);
            edi210Obj.LOADHDR.LOADHDRINFO.WEIGHTQUAL = "G";
            #endregion
​
            #region Trim Rate to 2 decimal places instead of 4
            foreach (ChargeInfo charge in edi210Obj.INVOICE.CHARGEINFOCollection.Items)
            {
                decimal rate = (decimal)charge.LINECHARGE;
                charge.LINECHARGE = decimal.Round(rate, 2);
            }
            #endregion
​
            #region Change Address Qualifiers
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                if (stop.ADDRESSINFO.ADDRESSQUAL == "SF") stop.ADDRESSINFO.ADDRESSQUAL = "SH";
                if (stop.ADDRESSINFO.ADDRESSQUAL == "ST") stop.ADDRESSINFO.ADDRESSQUAL = "CN";
            }
            #endregion
​
            #region Set R3
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_SCAC = "TQYL"; //R3*01
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_RSEQ = "B"; //R3*02 "Origin"
            if (String.IsNullOrEmpty(edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE)) edi210Obj.LOADHDR.LOADHDRINFO.MS3_TRTYPE = "J"; //R3*04 "Motor"
            #endregion
​
            #region Populate LM Dates/Times
            //Pull Load Date from LM data
            //Pull Load Date from LM data - tblpickups where 0 is the first stop
            DateTime? timePickedup = TQL.BZT.Rules.Utils.LM.Picks.TimeLoaded((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, 0);
​
            if (timePickedup.HasValue)
            {
                DateTime pickdate = (DateTime)timePickedup;
                DateTime picktime = (DateTime)timePickedup;
​
                String pickupDate = pickdate.ToString("yyyyMMdd");
                String pickupTime = picktime.ToString("HHmm");
​
                //Add Pickup Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = pickupDate;
                hrefnumber2.DATEQUAL = "86";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
            }
​
            else
            {
                //Pull Load Date from LM data - tblpickups where 0 is the first stop
                DateTime? loadPickUp = TQL.BZT.Rules.Utils.LM.Loads.LoadDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
                DateTime pickup = (DateTime)loadPickUp;
​
                String pickupDate = pickup.ToString("yyyyMMdd");
                String pickupTime = pickup.ToString("HHmm");
​
                //Add Pickup Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = pickupDate;
                hrefnumber2.DATEQUAL = "86";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
            }
​
            //Pull Load Date from LM data - tblDrops where 0 is the last drop
            DateTime? timeDelivered = TQL.BZT.Rules.Utils.LM.Drops.TimeDelivered((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, 0);
​
            if (timeDelivered.HasValue)
            {
                DateTime DeliverDate = (DateTime)timeDelivered;
                DateTime DeliverTime = (DateTime)timeDelivered;
​
                String DelDate = DeliverDate.ToString("yyyyMMdd");
                String DelTime = DeliverTime.ToString("HHmm");
​
                //Add Delivery Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = DelDate;
                hrefnumber2.DATEQUAL = "35";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
            }
​
            else
            {
                DateTime? loadDelivery = TQL.BZT.Rules.Utils.LM.Loads.DeliveryDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
                DateTime Delivery = (DateTime)loadDelivery;
​
                String DeliverDate = Delivery.ToString("yyyyMMdd");
                String pickupTime = Delivery.ToString("HHmm");
​
                //Add Delivery Date to Header G62 with Qualifier;
                DateTimeInfo hrefnumber2 = new DateTimeInfo();
                hrefnumber2.DATE = DeliverDate;
                hrefnumber2.DATEQUAL = "35";
                edi210Obj.LOADHDR.DATETIMEINFOCollection.Items.Add(hrefnumber2);
​
            }
            #endregion
​
            #region Pull Stop DateTimes
            //Used to pull Time Loaded and Time Delivered From Stops. Uses Appointment Info if not available.
            //Clear out existing datetimes
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                stop.DATETIMEINFOCollection.Items.Clear();
            }
​
            foreach (StopInfo210 stop in edi210Obj.STOPINFOCollection.Items)
            {
                if (stop.STOPTYPEID == 2)
                {
                    DateTime? timeDroppedStopOff = TQL.BZT.Rules.Utils.LM.Drops.TimeDeliveredByStop((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)stop.LMPICKDROPROWID);
​
                    RefNumberInfo refnum = new RefNumberInfo();
​
                    if (timeDroppedStopOff.HasValue)
                    {
                        DateTime dropdateStopOff = (DateTime)timeDroppedStopOff;
                        DateTime droptimeStopOff = (DateTime)timeDroppedStopOff;
​
                        String dropoffDate = dropdateStopOff.ToString("yyyyMMdd");
                        String dropoffTime = droptimeStopOff.ToString("HHmm");
​
                        //Add DropStopOff Date to Stop Level G62 with Qualifier;
                        DateTimeInfo dropDTI = new DateTimeInfo();
                        dropDTI.DATE = dropoffDate;
                        dropDTI.DATEQUAL = "35";
                        dropDTI.TIME = dropoffTime;
                        dropDTI.TIMEQUAL = "9";
                        stop.DATETIMEINFOCollection.Items.Add(dropDTI);
​
                    }
​
                    else
                    {
                        DateTime? loadDropOff = TQL.BZT.Rules.Utils.LM.Loads.DeliveryDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
​
                        DateTime pickupStopOff = (DateTime)loadDropOff;
​
                        String pickupDate = pickupStopOff.ToString("yyyyMMdd");
                        String pickupTime = pickupStopOff.ToString("HHmm");
​
                        //Add DropStopOff Date to Header G62 with Qualifier;
                        DateTimeInfo dropDTI = new DateTimeInfo();
                        dropDTI.DATE = pickupDate;
                        dropDTI.DATEQUAL = "35";
                        dropDTI.TIME = pickupTime;
                        dropDTI.TIMEQUAL = "9";
                        stop.DATETIMEINFOCollection.Items.Add(dropDTI);
                    }
                }
​
                else //StopTypeID = 1
                {
                    //DateTime? timePickedupStopOff = TQL.BZT.Rules.Utils.LM.Picks.TimeLoaded((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, 0);
                    DateTime? timePickedupStopOff = TQL.BZT.Rules.Utils.LM.Picks.TimeLoadedByStop((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)stop.LMPICKDROPROWID);
​
                    if (timePickedupStopOff.HasValue)
                    {
                        DateTime pickdateStopOff = (DateTime)timePickedupStopOff;
                        DateTime picktimeStopOff = (DateTime)timePickedupStopOff;
​
                        String pickupDate = pickdateStopOff.ToString("yyyyMMdd");
                        String pickupTime = picktimeStopOff.ToString("HHmm");
​
                        //Add Pickup Date to Stop Level G62 with Qualifier;
                        DateTimeInfo pickDTI = new DateTimeInfo();
                        pickDTI.DATE = pickupDate;
                        pickDTI.DATEQUAL = "86";
                        pickDTI.TIME = pickupTime;
                        pickDTI.TIMEQUAL = "8";
                        stop.DATETIMEINFOCollection.Items.Add(pickDTI);
                    }
​
                    else
                    {
                        DateTime? loadPickUp = TQL.BZT.Rules.Utils.LM.Loads.LoadDateTime((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
​
                        DateTime pickupStopOff = (DateTime)loadPickUp;
​
                        String pickupDate = pickupStopOff.ToString("yyyyMMdd");
                        String pickupTime = pickupStopOff.ToString("HHmm");
​
                        //Add Pickup Date to Header G62 with Qualifier;
                        DateTimeInfo pickDTI = new DateTimeInfo();
                        pickDTI.DATE = pickupDate;
                        pickDTI.DATEQUAL = "86";
                        pickDTI.TIME = pickupTime;
                        pickDTI.TIMEQUAL = "8";
                        stop.DATETIMEINFOCollection.Items.Add(pickDTI);
                    }
                }
            }
            #endregion
​
            #region Pull Equipment
            //Pull carrierID and driverID from load.
            TQL.BZT.BLL.LMDataContracts.LoadDetail LMDetail = TQL.BZT.Rules.Utils.LM.Loads.LoadInfo((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER);
​
            string carrierid = LMDetail.CarrierId.ToString();
            string driverid = LMDetail.DriverId.ToString();
            string trucknumber = "";
            string trailernumber = "";
            int? trailerID = LMDetail.TrailerId;
​
            string gDBConnstr = System.Configuration.ConfigurationManager.ConnectionStrings["TQLConnectionStringDefault"].ConnectionString;
​
            // set to devsqlclst if not returned from configuration file
            if (string.IsNullOrEmpty(gDBConnstr))
            {
                // If this is defined in configuration file , if not it will take default
                gDBConnstr = "Data Source=devsqlclst;Initial Catalog=TQL;Integrated Security=True;";
            }
​
            using (SqlConnection conn = new SqlConnection(gDBConnstr))
            {
                SqlCommand cmd = new SqlCommand("spEdiGetDriverDetails", conn);
​
                cmd.Parameters.AddWithValue("@lCarrierId", carrierid);
                cmd.Parameters.AddWithValue("@lDriver", driverid);
​
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                conn.Open();
​
                SqlDataReader dr = cmd.ExecuteReader();
​
                while (dr.Read())
                {
                    trucknumber = dr["trucknumber"].ToString();
                    trailernumber = dr["trailernumber"].ToString();
                }
​
                //MessageBox.Show(trucknumber + " - " + trailernumber);
​
                //if (trailernumber != "NOTAVAIL")
                //{
                RefNumberInfo hrefnumber5 = new RefNumberInfo();
                hrefnumber5.EDI210DESTINATION = "TrailerNumber";
                hrefnumber5.REFNUMBERQUAL = "TrailerNumber";
                hrefnumber5.REFNUMBER = trailernumber;
                edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber5);
​
                edi210Obj.LOADHDR.LOADHDRINFO.DRIVERID = trailernumber;
                //}
​
            }
​
            //Set Trailer Type for N7_11;
            string TrailerType = LMDetail.TrailerType;
​
            RefNumberInfo hrefnumber6 = new RefNumberInfo();
            hrefnumber6.EDI210DESTINATION = "TrailerType";
            hrefnumber6.REFNUMBERQUAL = "TrailerType";
            hrefnumber6.REFNUMBER = TrailerType;
            edi210Obj.LOADHDR.REFNUMBERINFOCollection.Items.Add(hrefnumber6);
​
            switch (trailerID)
            {
                case 1: //Reefer
                case 23: //Reefer Team
                case 37: //Chassis-Refrigerated
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "RT"; //Reefer
                    break;
​
                case 2: //Van
                case 3: //Van or Reefer
                case 12: //Vented Van
                case 24: //Van Team
                case 25: //Van or Reefer Team
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "TF"; //Van
                    break;
​
                case 4: //Flat
                case 5: //Step Deck
                case 6: //Removable Goose Neck
                case 7: //Flat 4 Ft Tarp
                case 8: //Flat 6 Ft Tarp
                case 9: //Flat 8 Ft Tarp
                case 10: //Flat With Sides
                case 11: //Double Drop
                case 27: //Flat Team
                case 14: //Step Deck with 4 ft tarp
                case 15: //Step Deck with 6 ft tarp
                case 16: //Step Deck with 8 ft tarp
                case 17: //Removable Goose Neck with 4 ft tarp
                case 18: //Removable Goose Neck with 6 ft tarp
                case 19: //Removable Goose Neck with 8 ft tarp
                case 20: //Double Drop with 4 ft tarp
                case 21: //Double Drop with 6 ft tarp
                case 22: //Double Drop with 8 ft tarp
                case 28: //Flatbed or Stepdeck
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "FT"; //Flat
                    break;
​
                default:
                    edi210Obj.LOADHDR.LOADHDRINFO.EQUIPCODE = "TL";
                    break;
            }
​
            #endregion
​
            #region Reorder Stops to order on EDI 204
            //Stops need to be in order from LM, not on the EDI file. Only pulls linked stops.
            //Uses ReOrder210Stops Function 
            ReOrder210Stops(ref edi210Obj, false, true, true);
            #endregion
​
            #region Pull Stops from LM
            //Need to pull stop information from LM not from the EDI tender, even when linked.
            edi210Obj.STOPINFOCollection.Items.Clear();
​
            StopInfo210Collection StopInfo210 = Utils.LM.Stops.PopulateEDI210Stops((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)edi210Obj.EDIPROPERTIES.BZTTRANSACTIONID);
            edi210Obj.STOPINFOCollection = StopInfo210;
            #endregion
​
            #region EDI Plus
            //Call EDI PLus Populate Data
            PopulateData(ref edi210Obj);
            #endregion
        }
​
        public static void ReOrder210Stops(ref TQLBZTEDI210 edi210Obj, bool EDISeq, bool LMSeq, bool RemoveCancelledStops)
        {
            try
            {
                StopInfo210Collection lmStops = TQL.BZT.Rules.Utils.LM.Stops.PopulateEDI210Stops((int)edi210Obj.LOADHDR.LOADHDRINFO.PONUMBER, (int)edi210Obj.LOADHDR.LOADHDRINFO.BZTTRANSACTIONID);
                Dictionary<int, int> lmStopsDict = lmStops.Items.Distinct().ToDictionary(i => (int)i.LMPICKDROPROWID, i => (int)i.STOPSEQ);
                var ediStopsToBeOrdered = edi210Obj.STOPINFOCollection.Items.ToList();
​
                if (!EDISeq && LMSeq)
                {
                    var ediStopsToBeOrderedNoCancelledStops = ediStopsToBeOrdered.Where(x => lmStopsDict.ContainsKey((int)x.LMPICKDROPROWID)).ToList();
​
                    var ediStopsOrdered = ediStopsToBeOrderedNoCancelledStops.OrderBy(x => lmStopsDict[(int)x.LMPICKDROPROWID]);
​
                    List<StopInfo210> ediStopsOrderedList = ediStopsOrdered.ToList();
                    StopInfo210Collection ediStopsOrderedWSeq = new StopInfo210Collection();
                    foreach (var stop in ediStopsOrderedList)
                    {
                        if (lmStopsDict.ContainsKey((int)stop.LMPICKDROPROWID))
                        {
                            stop.STOPSEQ = lmStopsDict.Single(x => x.Key == stop.LMPICKDROPROWID).Value;
                            ediStopsOrderedWSeq.Items.Add(stop);
                        }
                    }
​
                    edi210Obj.STOPINFOCollection = ediStopsOrderedWSeq;
                }
​
            }
            catch (Exception e)
            {
                TQL.BZT.Logger.LogGenerator.Log(true, false, true, true, false, "TQL.BZT.Rules.Target.ReOrder210Stops", 5100, EventLogEntryType.Error, e);
            }
        }
​
        private static void PopulateData(ref TQLBZTEDI210 edi210obj)
        {
            //string DocType = string.Empty;
            string LoadID = string.Empty;
            //string CustomerPO = string.Empty;
            int PONumber = default(int);
            int tpprofileid = default(int);
​
            try
            {
                //Document Type
                //DocType = edi210obj.
​
                //LoadID  = ref1
                LoadID = edi210obj.LOADHDR.LOADHDRINFO.SHIPMENTID;
​
                //CustomerLink
                tpprofileid = (int)edi210obj.TPPROFILEINFO.TPPROFILEID;
​
                //PoNumber 
                PONumber = (int)edi210obj.LOADHDR.LOADHDRINFO.PONUMBER;
​
​
                //Insert in to Icab // 
                bool statusUpdated = EDIPlusAcct.InsertICabProcess(10, PONumber, 3, null, null, null); //AppID : 10 = CASS , ProcessStatus :3 = Invalid
                //statusUpdated = EDIPlusAcct.InsertICabProcess(10, PONumber, 3, tpprofileid.ToString(), null, null); //AppID : 10 = CASS , ProcessStatus :3 = Invalid
                statusUpdated = EDIPlusAcct.InsertICabProcess(10, PONumber, 3, tpprofileid.ToString(), LoadID, null); //AppID : 10 = CASS , ProcessStatus :3 = Invalid
​
                if (!statusUpdated)
                {
                    string exMsg = string.Empty;
                    try
                    {
                        exMsg = String.Format("InsertICabProcess for LoadID- PONumber={0}\r\nLoadID={1}", edi210obj.LOADHDR.LOADHDRINFO.PONUMBER, (LoadID ?? string.Empty));
                    }
                    catch
                    {
                        exMsg = string.Empty;
                    }
                    TQL.BZT.Logger.LogGenerator.Log(false, false, true, false, true, "TQL.BZT.Rules.CassInfo.GenericEDIPlus", "TQL.BZT.Rules.CassInfo.GenericEDIPlus.Rules210.PopulateData+\r\n" + exMsg, 2022, EventLogEntryType.Error, null);
                    exMsg = null;
​
                }
​
                if (statusUpdated)
                {
                    //Update ICab CustomerLink = TPID
                    statusUpdated = EDIPlusAcct.updateICabProcessStatus(10, PONumber, 1); //AppID : 10 = CASS , ProcessStatus 1= Valid and ready to process
​
                    if (!statusUpdated)
                    {
                        string exMsg = string.Empty;
                        try
                        {
                            exMsg = String.Format("updateICabProcessStatus for CASS ICab processing - PONumber={0}\r\nLoadID={1}", edi210obj.LOADHDR.LOADHDRINFO.PONUMBER, (LoadID ?? string.Empty));
                        }
                        catch
                        {
                            exMsg = string.Empty;
                        }
                        TQL.BZT.Logger.LogGenerator.Log(false, false, true, false, true, "TQL.BZT.Rules.CassInfo.GenericEDIPlus", "TQL.BZT.Rules.CassInfo.GenericEDIPlus.Rules210.PopulateData+\r\n" + exMsg, 2023, EventLogEntryType.Error, null);
                        exMsg = null;
​
                    }
​
                }
            }
​
            catch (Exception ex)
            {
                string exMsg = null;
                try
                {
                    exMsg = "CASS - PopulateData \r\n" +
                        "nLoadID=" + LoadID + "\r\n";
                }
                catch
                {
                    exMsg = "CASS - PopulateData \r\n";
                }
                TQL.BZT.Logger.LogGenerator.Log(false, false, true, false, true, "TQL.BZT.Rules.CassInfo.GenericEDIPlus", "TQL.BZT.Rules.CassInfo.GenericEDIPlus.Rules210.PopulateData+\r\n" + exMsg, 2023, EventLogEntryType.Error, ex);
​
                exMsg = null;
            }
            finally
            {
                LoadID = null;
​
            }
        }
    }
}

Cached Result
Last Run:	4:14:13 pm
Compile:	0.094s
Execute:	0s
Memory:	32kb
CPU:	0s

View IL Code