예제 #1
0
        public bool OrdersEOD()
        {
            OrdersRepositoryDbMethods ordersRepositoryDbMethods = new OrdersRepositoryDbMethods();
            //Orders order = new Orders();
            //List<OrderDto> listOfOrders = ordersRepositoryDbMethods.ReadAllEodOrderDataToRepository();
            //foreach (var listOfOrder in listOfOrders)
            //{
            //    if (!string.IsNullOrEmpty(listOfOrder.InvoiceNumber))
            //    {
            //        order.UpdateOrderByInvoice(listOfOrder.InvoiceNumber, listOfOrder.TrackingCode);
            //        ordersRepositoryDbMethods.RemoveOrderFromOrderDataToRepository(listOfOrder.InvoiceNumber);
            //    }

            //}
            return ordersRepositoryDbMethods.CleanOrderDataToRepository();
        }
예제 #2
0
        public bool CreateShippingInformation(XDocument xdoc,OrderDto orderDto)
        {
            var context = new orderstatusEntities();
            OrdersRepositoryDbMethods ordersRepositoryDbMethods = new OrdersRepositoryDbMethods();
            try
            {
                int carrierType = 0;
               // <Shipment>
                dynamic shippingInformation = from x in xdoc.Descendants("Shipment")
                    select new
                    {

                        ShipmentID = x.Descendants("ShipmentID").First().Value != string.Empty ?  x.Descendants("ShipmentID").First().Value:"",
                        ShipmentDate = x.Descendants("ShipmentDate").First().Value != string.Empty ?  x.Descendants("ShipmentDate").First().Value:"",
                        Method = x.Descendants("Method").First().Value != string.Empty ?  x.Descendants("Method").First().Value:"",
                        FirstName = x.Descendants("FirstName").First().Value != string.Empty ?  x.Descendants("FirstName").First().Value:"",
                        LastName = x.Descendants("LastName").First().Value != string.Empty ? x.Descendants("LastName").First().Value : "",
                        Company = x.Descendants("Company").First().Value != string.Empty ? x.Descendants("Company").First().Value : "",
                        Address = x.Descendants("Address").First().Value != string.Empty ? x.Descendants("Address").First().Value : "",
                        Address2 = x.Descendants("Address2").First().Value != string.Empty ? x.Descendants("Address2").First().Value : "",
                        City = x.Descendants("City").First().Value != string.Empty ? x.Descendants("City").First().Value : "",
                        ZipCode = x.Descendants("ZipCode").First().Value != string.Empty ? x.Descendants("ZipCode").First().Value : "",
                        StateCode = x.Descendants("StateCode").First().Value != string.Empty ? x.Descendants("StateCode").First().Value : "",
                        CountryCode = x.Descendants("CountryCode").First().Value != string.Empty ? x.Descendants("CountryCode").First().Value : "",
                        Phone = x.Descendants("Phone").First().Value != string.Empty ? x.Descendants("Phone").First().Value : "",
                        Weight = x.Descendants("Weight").First().Value != string.Empty ? x.Descendants("Weight").First().Value : "",
                        Status = x.Descendants("Status").First().Value != string.Empty ? x.Descendants("Status").First().Value : "",
                        InternalComment = x.Descendants("InternalComment").First().Value != string.Empty ? x.Descendants("InternalComment").First().Value : "",
                        TrackingCode = x.Descendants("TrackingCode").First().Value,
                    };
                foreach (var ship in shippingInformation)
                {
                    var firstName = (ship.FirstName != null) ? ship.FirstName.ToString() : "";
                    var lastName = (ship.LastName != null) ? ship.LastName.ToString() : "";
                    orderDto.Name = firstName + " " + lastName;
                    orderDto.Company = (ship.Company != null) ? ship.Company.ToString() : "";
                    orderDto.Address = (ship.Address != null) ? ship.Address.ToString() : "";
                    orderDto.Address2 = (ship.Address2 != null) ? ship.Address2.ToString() : "";
                    orderDto.City = (ship.City != null) ? ship.City.ToString() : "";
                    orderDto.Zip = (ship.ZipCode != null) ? ship.ZipCode.ToString() : "";
                    orderDto.State = (ship.StateCode != null) ? ship.StateCode.ToString() : "";
                    orderDto.Country = (ship.CountryCode != null) ? ship.CountryCode.ToString() : "";
                    orderDto.Phone = (ship.Phone != null) ? ship.Phone.ToString() : "";
                    orderDto.TrackingCode = (ship.TrackingCode != null) ? ship.TrackingCode.ToString() : "";
                    string method = (ship.Method != null) ? ship.Method.ToString() : "";
                    if (!orderDto.InvoiceNumber.Equals("") && !orderDto.InvoiceNumber.Equals("0"))
                    {
                        if (!method.Equals(""))
                        {
                            if (method.Contains("UPS"))
                            {
                                orderDto.UpsUspsService = method.Replace("UPS -", "").Trim();
                                carrierType = CarrierType.Ups;
                            }
                            else
                            {
                                string upsResult = "";
                                try
                                {
                                    upsResult = GetAllUpsServices().SingleOrDefault(s => s.Contains(method)).Trim();
                                }
                                catch (Exception)
                                {
                                    upsResult = "";
                                }
                                if (!string.IsNullOrEmpty(upsResult))
                                {
                                    orderDto.UpsUspsService = method.Replace("UPS -", "");
                                    carrierType = CarrierType.Ups;
                                }
                                else
                                {
                                    if (method.Contains("USPS"))
                                    {
                                        orderDto.UpsUspsService = method;
                                        carrierType = CarrierType.Usps;
                                    }
                                    else
                                    {
                                        string uspsResult = "";
                                        try
                                        {
                                            uspsResult = GetAllUspsServices().SingleOrDefault(s => s.Contains(method));
                                        }
                                        catch (Exception)
                                        {

                                            uspsResult = "";
                                        }
                                        if (!string.IsNullOrEmpty(uspsResult))
                                        {

                                            orderDto.UpsUspsService = method;
                                            carrierType = CarrierType.Usps;

                                        }
                                        else
                                        {
                                            orderDto.UpsUspsService = "Ground";
                                        }
                                    }
                                }
                            }
                        }
                        else
                        {
                            orderDto.UpsUspsService = "Ground";
                        }
                        order newOrder = new order
                                             {
                                                 address = orderDto.Address,
                                                 address2 = orderDto.Address2,
                                                 city = orderDto.City,
                                                 company = orderDto.Company,
                                                 country = orderDto.Country,
                                                 customerid = orderDto.CustomerId,
                                                 date_created = DateTime.Now,
                                                 date_modifed = DateTime.Now,
                                                 email = orderDto.Email,
                                                 email_flag = orderDto.EmailFlag,
                                                 orderId = orderDto.OrderId,
                                                 storeId = orderDto.StoreId,
                                                 invoice_number = orderDto.InvoiceNumber,
                                                 name = orderDto.Name,
                                                 tracking_code = orderDto.TrackingCode,
                                                 phone = orderDto.Phone,
                                                 ups_service = orderDto.UpsUspsService,
                                                 state = orderDto.State
                                             };
                        context.orders.AddObject(newOrder);
                        context.SaveChanges();
                        ordersRepositoryDbMethods.InsertOrderDataToRepository(orderDto);
                    }
                }

            }
            catch (InvalidOperationException exc)
            {
                return false;
            }
            catch (ArgumentNullException exc)
            {
                return false;
            }
            catch (NullReferenceException exc)
            {
                return false;
            }
            catch (OptimisticConcurrencyException exc)
            {
                return false;
            }
            catch (UpdateException exc)
            {
                return false;
            }
            finally
            {
                context.Dispose();
            }
            return true;
        }