Example #1
0
        public ReturnValue Run()
        {
            ReturnValue _result = new ReturnValue();

            #region get ship method list

            TShipMethod _tShipMethod = new TShipMethod();
            _result = _tShipMethod.getShipMethodList();
            if (_result.Success == false)
            {
                _result.Success    = false;
                _result.ErrMessage = "getShipMethodList failed. \r\n " + _result.ErrMessage;

                Common.Log("getShipMethodList---ER \r\n" + _result.ErrMessage);

                return(_result);
            }
            ShipMethods = _result.ObjectList.ConvertAll(t => t as TShipMethod);

            #endregion

            #region get product list

            TProgram_Product _tProgram_Product = new TProgram_Product();
            _result = _tProgram_Product.getProgramProductList();
            if (_result.Success == false)
            {
                _result.Success    = false;
                _result.ErrMessage = "getProgramProductList failed. \r\n " + _result.ErrMessage;

                Common.Log("getProgramProductList---ER \r\n" + _result.ErrMessage);

                return(_result);
            }
            Products = _result.ObjectList.ConvertAll(t => t as TProgram_Product);


            #endregion

            #region get country list

            TCountry _tCountry = new TCountry();
            _result = _tCountry.getCountryList();
            if (_result.Success == false)
            {
                _result.Success    = false;
                _result.ErrMessage = "getCountryList failed. \r\n " + _result.ErrMessage;

                Common.Log("getCountryList---ER \r\n" + _result.ErrMessage);

                return(_result);
            }
            Countrys = _result.ObjectList.ConvertAll(t => t as TCountry);


            #endregion

            #region get state list

            TState _tState = new TState();
            _result = _tState.getStateList();
            if (_result.Success == false)
            {
                _result.Success    = false;
                _result.ErrMessage = "getStateList failed. \r\n " + _result.ErrMessage;

                Common.Log("getStateList---ER \r\n" + _result.ErrMessage);

                return(_result);
            }
            States = _result.ObjectList.ConvertAll(t => t as TState);


            #endregion

            #region get type list

            TType _tType = new TType();
            _result = _tType.geTTypeList();
            if (_result.Success == false)
            {
                _result.Success    = false;
                _result.ErrMessage = "geTTypeList failed. \r\n " + _result.ErrMessage;

                Common.Log("geTTypeList---ER \r\n" + _result.ErrMessage);

                return(_result);
            }
            Types = _result.ObjectList.ConvertAll(t => t as TType);


            #endregion

            #region PULLOrders

            _result = SS2.ShipStationAPI.PULLOrders();
            if (_result.Success == false)
            {
                _result.Success    = false;
                _result.ErrMessage = "PULLOrders failed. \r\n " + _result.ErrMessage;

                Common.Log("PULLOrders---ER \r\n" + _result.ErrMessage);

                Common.SentAlterEmail(1, _result.ErrMessage);

                return(_result);
            }

            List <ShipStationResponseOrder> orderList = _result.ObjectValue as List <ShipStationResponseOrder>;

            #endregion

            foreach (ShipStationResponseOrder order in orderList)
            {
                #region check program ID

                if (string.IsNullOrWhiteSpace(order.advancedOptions.customField1) == true)
                {
                    continue;
                }

                var programId = order.advancedOptions.customField1;

                Common.Log("ProgramID:" + programId + "  Order : " + order.orderId + "---Start");

                List <string> Programs = ConfigurationSettings.AppSettings["ProgramList"].Split(',').ToList();

                if (Programs.Exists(p => p.Equals(programId)) == false)
                {
                    _result.ErrMessage = "Program ID:" + programId + "  is valid";

                    errorNotes = errorNotes + order.orderId + "\r\n" + _result.ErrMessage + "\r\n";
                    failedRecord++;

                    Common.Log("ProgramID:" + programId + "  Order : " + order.orderId + "---ER \r\n" + _result.ErrMessage);

                    continue;
                }

                #endregion

                #region check order existed

                TShipStationOrders shipStationOrders = new TShipStationOrders();
                _result = shipStationOrders.getOrderBySOrderId(order.orderId);
                if (_result.Success == false)
                {
                    errorNotes = errorNotes + order.orderId + "\r\n" + _result.ErrMessage + "\r\n";
                    failedRecord++;

                    Common.Log("ProgramID:" + programId + "  Order : " + order.orderId + "---ER \r\n" + _result.ErrMessage);

                    continue;
                }
                shipStationOrders = _result.Object as TShipStationOrders;

                if (shipStationOrders.ID != 0)
                {
                    continue;
                }

                #endregion

                #region create ZStore Order

                _result = createZOrder(order);
                if (_result.Success == false)
                {
                    errorNotes = errorNotes + order.orderId + "\r\n" + _result.ErrMessage + "\r\n";
                    failedRecord++;

                    Common.Log("ProgramID:" + programId + "  Order : " + order.orderId + "---ER \r\n" + _result.ErrMessage);

                    continue;
                }

                TOrder _tOrder = _result.Object as TOrder;

                #endregion

                #region save Order

                _result = saveZOrder(_tOrder, order);
                if (_result.Success == false)
                {
                    errorNotes = errorNotes + order.orderId + "\r\n" + _result.ErrMessage + "\r\n";
                    failedRecord++;

                    Common.Log("ProgramID:" + programId + "  Order : " + order.orderId + "---ER \r\n" + _result.ErrMessage);

                    continue;
                }

                #endregion

                Common.Log("ProgramID:" + programId + "  Order : " + order.orderId + "---OK");
            }


            Common.SentAlterEmail(failedRecord, errorNotes);

            _result.Success = true;

            return(_result);
        }
Example #2
0
        private ReturnValue createZOrder(ShipStationResponseOrder order)
        {
            ReturnValue _result = new ReturnValue();

            int _sourceId = int.Parse(ConfigurationSettings.AppSettings["SourceId"]);
            int programID = int.Parse(order.advancedOptions.customField1);


            TOrder _tOrder = new TOrder();

            #region get OrderTypeId

            if (string.IsNullOrWhiteSpace(order.advancedOptions.customField3) == true)
            {
                _result.ErrMessage = string.Format("OrderType({0}) is empty. ", order.advancedOptions.customField3);
                _result.Success    = false;
                return(_result);
            }

            var itemType = Types.Find(s => s.Code.Equals(order.advancedOptions.customField3, StringComparison.OrdinalIgnoreCase));
            if (itemType == null)
            {
                if (Common.AutoCreateProduct == true)
                {
                    TType _tType = new TType();
                    _tType.Code            = order.advancedOptions.customField3;
                    _tType.ContentStatusId = 1;
                    _tType.Description     = order.advancedOptions.customField3;
                    _tType.GroupBy         = "ORDER";
                    _tType.CreatedOn       = System.DateTime.Now;
                    _result = _tType.Save();

                    _tType.TypeId = _result.IdentityId;
                    itemType      = _tType;

                    Types.Add(_tType);
                }
                else
                {
                    _result.ErrMessage = string.Format("OrderType({0}) can not be found. ", order.advancedOptions.customField3);
                    _result.Success    = false;
                    return(_result);
                }
            }

            _tOrder.OrderTypeId = itemType.TypeId;

            #endregion

            #region get ShipMethod

            if (string.IsNullOrWhiteSpace(order.advancedOptions.customField2) == true)
            {
                _result.ErrMessage = string.Format("ShipMethod({0}) is empty. ", order.advancedOptions.customField2);
                _result.Success    = false;
                return(_result);
            }

            var method = ShipMethods.Find(s => s.Code.Equals(order.advancedOptions.customField2, StringComparison.OrdinalIgnoreCase));
            if (method == null)
            {
                _result.ErrMessage = string.Format("ShipMethod({0}) can not be found. ", order.advancedOptions.customField2);
                _result.Success    = false;
                return(_result);
            }

            int shipMethodId = method.ShipMethodId;

            #endregion

            #region Address

            if (order.shipTo.phone != null)
            {
                order.shipTo.phone = order.shipTo.phone.Replace("+", "");
                if (order.shipTo.phone.Length > 13)
                {
                    order.shipTo.phone = "0000000000";
                }
            }
            if (string.IsNullOrWhiteSpace(order.shipTo.state) && order.shipTo.country != "US" && order.shipTo.country != "CA")
            {
                order.shipTo.state = "XX";
            }

            var address = new TAddress();

            var country = Countrys.Find(c => c.ISO2.Equals(order.shipTo.country, StringComparison.OrdinalIgnoreCase));
            if (country == null)
            {
                _result.ErrMessage = string.Format("Country({0}) can not be found. ", order.shipTo.country);
                _result.Success    = false;
                return(_result);
            }
            address.CountryId = country.CountryId;

            var state = States.Find(c => c.Code.Equals(order.shipTo.state, StringComparison.OrdinalIgnoreCase));
            if (state == null && order.shipTo.country != "US" && order.shipTo.country != "CA")
            {
                order.shipTo.state = "XX";
                state = States.Find(c => c.Code.Equals(order.shipTo.state, StringComparison.OrdinalIgnoreCase));
            }

            if (state == null)
            {
                _result.ErrMessage = string.Format("State({0}) can not be found. ", order.shipTo.state);
                _result.Success    = false;
                return(_result);
            }
            address.StateId = state.StateId;



            address.Address1 = order.shipTo.street1;
            address.Address2 = order.shipTo.street2;
            address.Address3 = order.shipTo.street3;
            if (address.Address1 == null)
            {
                address.Address1 = "";
            }
            if (address.Address2 == null)
            {
                address.Address2 = "";
            }
            if (address.Address3 == null)
            {
                address.Address3 = "";
            }

            if (address.Address1.Length > 35 || address.Address2.Length > 35 || address.Address3.Length > 35)
            {
                var temp = address.Address1 + " " + address.Address2 + " " + address.Address3;
                address.Address1 = temp.Substring(0, 35);
                temp             = temp.Substring(35);
                if (temp.Length > 35)
                {
                    address.Address2 = temp.Substring(0, 35);
                    temp             = temp.Substring(35);
                }
                else
                {
                    address.Address2 = temp;
                    temp             = "";
                }
                if (temp.Length > 35)
                {
                    address.Address3 = temp.Substring(0, 35);
                }
                else
                {
                    address.Address3 = temp;
                }
            }

            address.City       = order.shipTo.city;
            address.PostalCode = order.shipTo.postalCode;
            address.UpdatedOn  = DateTime.Now;
            address.ProgramId  = programID;

            _tOrder.Address = address;


            #endregion

            #region Customer

            var customer = new TCustomer();
            customer.SourceId  = _sourceId;
            customer.ProgramId = programID;
            customer.FirstName = order.shipTo.fname;
            customer.LastName  = order.shipTo.lname;
            customer.Email     = order.customerEmail;
            customer.Company   = order.shipTo.company;
            customer.CreatedOn = System.DateTime.Now;

            if (programID == 463)
            {
                customer.AltCustNum = "ONL" + order.orderNumber.ToString();
            }

            _tOrder.Customer = customer;

            #endregion

            #region Item Line

            #region   skip the SKU when importing if the SKU=’’ and fulfillmentsku=null and name like ‘coupon%’

            var query = order.items.Where(u =>
                                          (!string.IsNullOrEmpty(u.sku) || !string.IsNullOrEmpty(u.fulfillmentSku) || !u.name.ToLower().StartsWith("coupon"))
                                          );

            order.items = query.ToList <ShipStationResponseItem>();

            foreach (ShipStationResponseItem sitem in order.items)
            {
                if (sitem.sku == "" && string.IsNullOrEmpty(sitem.fulfillmentSku) && sitem.name.ToLower().IndexOf("coupon") == 0)
                {
                    order.items.Remove(sitem);
                }
            }

            #endregion


            var lineNum = 1;

            foreach (var lineItem in order.items)
            {
                var sku = string.IsNullOrEmpty(lineItem.fulfillmentSku) ? lineItem.sku : lineItem.fulfillmentSku;
                if (string.IsNullOrWhiteSpace(sku) == true)
                {
                    _result.ErrMessage = string.Format("SKU({0}) is empty.", sku);
                    _result.Success    = false;
                    return(_result);
                }



                var productItem = Products.Find(s => s.PartNumber != null && s.PartNumber.Equals(sku, StringComparison.OrdinalIgnoreCase) && s.ProgramId == programID);
                if (productItem == null)
                {
                    if (Common.AutoCreateProduct == true)
                    {
                        TProduct _tProduct = new TProduct();
                        _tProduct.PartNumber = sku;
                        _tProduct.Name       = lineItem.name;
                        _tProduct.ProgramID  = programID;

                        _result             = _tProduct.Save();
                        _tProduct.ProductId = _result.IdentityId;

                        TProgram_Product _tProgram_Product = new TProgram_Product();
                        _tProgram_Product.PartNumber      = sku;
                        _tProgram_Product.Name            = sku;
                        _tProgram_Product.ProgramId       = programID;
                        _tProgram_Product.ContentStatusId = 1;
                        _tProgram_Product.ProductId       = _tProduct.ProductId;

                        _result = _tProgram_Product.Save();

                        _tProgram_Product.ProgramProductId = _result.IdentityId;
                        productItem = _tProgram_Product;

                        Products.Add(_tProgram_Product);
                    }
                    else
                    {
                        _result.ErrMessage = string.Format("SKU({0}) can not be found. ", sku);
                        _result.Success    = false;
                        return(_result);
                    }
                }

                TOrder_Line_Item _tOrder_Line_Item = new TOrder_Line_Item();
                _tOrder_Line_Item.ProgramProductId  = productItem.ProgramProductId;
                _tOrder_Line_Item.PartNumber        = productItem.PartNumber;
                _tOrder_Line_Item.ProductName       = lineItem.name;
                _tOrder_Line_Item.Quantity          = lineItem.quantity;
                _tOrder_Line_Item.Price             = Convert.ToDouble(lineItem.unitPrice);
                _tOrder_Line_Item.ActualPrice       = _tOrder_Line_Item.Quantity * _tOrder_Line_Item.Price;
                _tOrder_Line_Item.OrderLineItemDate = lineItem.createDate;

                _tOrder_Line_Item.ShipToCustomerId = _tOrder.CustomerId;
                _tOrder_Line_Item.ShipToAddressId  = _tOrder.CustomerAddressId;
                _tOrder_Line_Item.ShipMethodId     = shipMethodId;
                _tOrder_Line_Item.LineNum          = lineNum;
                lineNum++;

                _tOrder.OrderLines.Add(_tOrder_Line_Item);
            }



            #endregion

            #region Order level

            _tOrder.AltOrderNum        = order.orderNumber.ToString();
            _tOrder.OrderDate          = order.orderDate;
            _tOrder.TotalOrderAmount   = Convert.ToDouble(order.orderTotal);
            _tOrder.TotalTax           = Convert.ToDouble(order.taxAmount);
            _tOrder.TotalShipping      = Convert.ToDouble(order.shippingAmount);
            _tOrder.TotalProductAmount = Convert.ToDouble(order.orderTotal - order.taxAmount - order.shippingAmount);
            _tOrder.ProgramId          = programID;
            _tOrder.SourceId           = _sourceId;
            _tOrder.StatusCode         = "AS";

            #endregion

            _result.Object = _tOrder;

            return(_result);
        }