Example #1
0
        /// <summary>
        /// Populate the ship-to data structure
        /// </summary>
        /// <param name="csv"></param>
        /// <param name="PopulateJDEAddress"></param>
        /// <returns></returns>
        public static ShipTo CSVToShipTo(ShipToCSV csv, bool LookupJDEaddress)
        {
            ShipTo shipTo = new ShipTo();

            shipTo.NewShipTos = new List <ShipToLine>();
            if (!PopulateShipToHeader(ref shipTo, csv))
            {
                //TODO: Error handler
            }
            foreach (DataRow r in csv.DT.Rows)
            {
                ShipToLine line = PopulateShipToLine(r, LookupJDEaddress);
                shipTo.NewShipTos.Add(line);
            }
            return(shipTo);
        }
Example #2
0
        /// <summary>
        /// Populate a single ship-to line from the CSV
        /// </summary>
        /// <param name="r"></param>
        /// <param name="LookupJDEAddress"></param>
        /// <returns></returns>
        private static ShipToLine PopulateShipToLine(DataRow r, bool LookupJDEaddress)
        {
            ShipToLine line = new ShipToLine();

            line.StoreName          = (null == r["SHIP TO NAME"].ToString()) ? "" : r.Field <String>("SHIP TO NAME").ToUpper();
            line.Address1           = (null == r.Field <String>("ADDRESS 1")) ? "" : r.Field <String>("ADDRESS 1").ToUpper();
            line.Address2           = (null == r.Field <String>("ADDRESS 2")) ? "" : r.Field <String>("ADDRESS 2").ToUpper();
            line.City               = (null == r.Field <String>("CITY")) ? "" : r.Field <String>("CITY").ToUpper();
            line.State              = (null == r.Field <String>("STATE")) ? "" : r.Field <String>("STATE").ToUpper();
            line.Zip                = (null == r.Field <String>("ZIP")) ? "" : r.Field <String>("ZIP").ToUpper();
            line.TaxAreaCode        = (null == r.Field <String>("TAX AREA CODE")) ? "" : r.Field <String>("TAX AREA CODE").ToUpper();
            line.TaxExplanationCode = (null == r.Field <String>("TAX EXPLANATION CODE")) ? "" : r.Field <String>("TAX EXPLANATION CODE").ToUpper();
            line.Concept            = (null == r.Field <String>("CONCEPT CODE")) ? "" : r.Field <String>("CONCEPT CODE").ToUpper();
            line.StoreNumber        = (null == r.Field <String>("STORE NUMBER")) ? "" : r.Field <String>("STORE NUMBER").ToUpper();
            if (true == LookupJDEaddress)
            {
                try
                {
                    string alky       = line.StoreNumber + "-" + line.Concept;
                    double?jdeaddress = JDE.GetAddressFromALKY(alky);
                    line.JDEAddress = (null == jdeaddress) ? 0 : (double)jdeaddress;
                }
                catch
                {
                    throw;
                }
            }
            else
            {
                line.JDEAddress = 0;
            }
            try
            {
                line.County = JDE.GetCounty(r.Field <String>("ZIP").ToUpper());
            }
            catch
            {
                throw;
            }
            return(line);
        }