예제 #1
0
        public void TestStoreOrder()
        {
            int orderId = 123;
            OrderBusinessComponent service = new OrderBusinessComponent(this.context);
            Order order = new Order()
            {
                OrderId = orderId
            };
            List <ChangeItem> changeItems = new List <ChangeItem>
            {
                new ChangeItem(ChangeType.ChildInsert, new OrderDetail()),
                new ChangeItem(ChangeType.ChildUpate, new OrderDetail()),
                new ChangeItem(ChangeType.ChildDelete, new OrderDetail())
            };

            Expect.Once.On(context).Method("SaveOrder").Will(Return.Value(orderId));
            Expect.Once.On(context).Method("SaveOrderDetail").Will(Return.Value(1));
            Expect.Once.On(context).Method("SaveOrderDetail").Will(Return.Value(1));
            Expect.Once.On(context).Method("DeleteOrderDetail");
            int resultOrderId = service.StoreOrder(order, changeItems);

            Assert.AreEqual <int>(orderId, resultOrderId);

            mockBuilder.VerifyAllExpectationsHaveBeenMet();
        }
예제 #2
0
        public static OrderBusinessComponent GetOrderBusinessComponent()
        {
            SetUnityContainer();
            OrderBusinessComponent orderBc = _unityContainer.Resolve <OrderBusinessComponent>();

            return(orderBc);
        }
예제 #3
0
        public void OrderShippedNotification(OrderShippedDTO order)
        {
            OrderBusinessComponent bc = DependencyInjectionHelper.GetOrderBusinessComponent();

            bc.SetOrderShipped(order.Id, order.ShippedDate);

            Console.WriteLine(string.Format("Status of Order with ID {0} updated!", order.Id));
        }
예제 #4
0
        public void TestDeleteOrder()
        {
            OrderBusinessComponent service = new OrderBusinessComponent(this.context);

            Expect.Once.On(context).Method("DeleteOrder").With(1);
            service.DeleteOrder(1);
            mockBuilder.VerifyAllExpectationsHaveBeenMet();
        }
예제 #5
0
        public DeleteOrderResponse DeleteOrder(DeleteOrderRequest request)
        {
            DeleteOrderResponse    response = new DeleteOrderResponse();
            OrderBusinessComponent bc       = DependencyInjectionHelper.GetOrderBusinessComponent();

            bc.DeleteOrder(request.Id);

            return(response);
        }
예제 #6
0
        public GetOrderResponse GetOrderById(GetOrderRequest request)
        {
            GetOrderResponse       response = new GetOrderResponse();
            OrderBusinessComponent bc       = DependencyInjectionHelper.GetOrderBusinessComponent();

            response.Order = OrderAdapter.OrderToDto(bc.GetOrderById(request.Id));

            return(response);
        }
예제 #7
0
        public GetOrdersResponse GetOrdersByCriteria(GetOrdersRequest request)
        {
            GetOrdersResponse      response = new GetOrdersResponse();
            OrderBusinessComponent bc       = DependencyInjectionHelper.GetOrderBusinessComponent();

            IQueryable <Order> orders = bc.GetOrdersByCriteria(request.SearchType, request.CustomerId);

            response.Orders = OrderAdapter.OrdersToListDtos(orders);

            return(response);
        }
예제 #8
0
        public StoreOrderResponse StoreOrder(StoreOrderRequest request)
        {
            StoreOrderResponse     response = new StoreOrderResponse();
            OrderBusinessComponent bc       = DependencyInjectionHelper.GetOrderBusinessComponent();

            Order order = OrderAdapter.DtoToOrder(request.Order);
            IEnumerable <ChangeItem> changeItems = OrderAdapter.GetChangeItems(request.Order, order);

            response.Id = bc.StoreOrder(order, changeItems);

            return(response);
        }
예제 #9
0
        public GetOrderResponse GetOrderById(GetOrderRequest request)
        {
            if (!HttpContext.Current.User.Identity.IsAuthenticated)
            {
                throw new FaultException <NotAuthenticatedFault>(new NotAuthenticatedFault());
            }
            GetOrderResponse       response = new GetOrderResponse();
            OrderBusinessComponent bc       = DependencyInjectionHelper.GetOrderBusinessComponent();

            response.Order = OrderAdapter.OrderToDto(bc.GetOrderById(request.Id));

            return(response);
        }
예제 #10
0
        public void TestGetOrderById()
        {
            OrderBusinessComponent service = new OrderBusinessComponent(this.context);
            Order order = new Order()
            {
                OrderId = 123
            };

            Expect.Once.On(context).Method("GetById").Will(Return.Value(order));
            Order resultOrder = service.GetOrderById(123);

            Assert.AreEqual <decimal>(order.OrderId, resultOrder.OrderId);
            mockBuilder.VerifyAllExpectationsHaveBeenMet();
        }
예제 #11
0
        public GetOrdersResponse GetOrdersByCriteria(GetOrdersRequest request)
        {
            if (!HttpContext.Current.User.Identity.IsAuthenticated)
            {
                throw new FaultException <NotAuthenticatedFault>(new NotAuthenticatedFault());
            }
            GetOrdersResponse      response = new GetOrdersResponse();
            OrderBusinessComponent bc       = DependencyInjectionHelper.GetOrderBusinessComponent();
            IQueryable <Order>     orders   = bc.GetOrdersByCriteria(request.SearchType, request.CustomerId);

            response.Orders = OrderAdapter.OrdersToListDtos(orders);

            return(response);;
        }
예제 #12
0
        public void TestGetOrderByCriteria()
        {
            OrderBusinessComponent service = new OrderBusinessComponent(this.context);
            Order order = new Order {
                OrderId = 456, Customer = new Customer {
                    CustomerId = 1234
                }
            };
            IList <Order> orders = new List <Order> {
                order
            };

            foreach (OrderSearchType type in Enum.GetValues(typeof(OrderSearchType)))
            {
                Expect.Once.On(context).Method("GetAll").Will(Return.Value(orders.AsQueryable()));
                IQueryable <Order> resultOrders = service.GetOrdersByCriteria(type, 1234);
                Assert.AreEqual <decimal>(1, resultOrders.Count());
                Assert.AreEqual <decimal>(order.OrderId, resultOrders.First().OrderId);
            }

            mockBuilder.VerifyAllExpectationsHaveBeenMet();
        }
예제 #13
0
        static void Main(string[] args)
        {
            string pwd1 = null;
            string pwd2 = null;

            //pwd1 = Logistika.Service.Common.Encryption.EncryptionManager.BasicEncrypt(User.Password);
            //pwd2 = Logistika.Service.Common.Encryption.EncryptionManager.Encrypt(User.Password, User.Contact.Email);

            ////--aHVycnlyMTI =

            pwd1 = Logistika.Service.Common.Encryption.EncryptionManager.BasicDecrypt("aHVycnlyMTI=");

            pwd2 = Logistika.Service.Common.Encryption.EncryptionManager.BasicDecrypt("aHVycnkxMg==");
            Console.ReadKey();
            return;

            string FileName       = null;
            string rootFolderPath = @"C:\API\Logistika\LogistikaService\Test\Files\ToFiles\";

            string destinationPath = @"C:\API\Logistika\LogistikaService\Test\Files\Archive\";

            FileName = "USERS_05222018_1.xlsx";
            string fullPathToExcel   = rootFolderPath + FileName;  //ie C:\Temp\YourExcel.xls
            string fullpathToArchive = destinationPath + FileName; //ie C:\Temp\YourExcel.xls


            if (new FileInfo(fullpathToArchive).Exists == false)
            {
                string    connString = string.Format("Provider =Microsoft.ACE.OLEDB.12.0;Data Source=" + fullPathToExcel + ";Extended Properties='Excel 12.0;HDR=yes'", fullPathToExcel);
                DataTable dt         = FileManager.GetDataTable("SELECT * FROM [Sheet1$]", connString);

                Thread.CurrentThread.CurrentCulture =
                    CultureInfo.CreateSpecificCulture("en-GB");
                Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-GB");

                var             date      = DateTime.Now;
                var             type      = "user";
                IList <Country> PhoneCode = null;

                if (type == "Order")
                {
                    if (dt != null)
                    {
                        var distinctOrders = dt.AsEnumerable().Select(c => Convert.ToString(c["VendorOrderID"])).Distinct().ToList <string>();
                        foreach (var order in distinctOrders)
                        {
                            var orders = dt.AsEnumerable().Where(x => Convert.ToString(x["VendorOrderID"]) == order).ToList();
                            if (orders != null && orders.Count() > 0)
                            {
                                string pickupLatitude   = null;
                                string pickupLongitude  = null;
                                string dropoffLatitude  = null;
                                string dropoffLongitude = null;
                                var    first            = orders[0];
                                //first["PICKUPHOUSE_FLATNO"].ToString() + first["PickupAddress"].ToString() + ", " + first["PICKUPCITY"].ToString() + ", " + first["PICKUPSTATE"].ToString() + " " + first["PICKUPPINCODE"].ToString() + ", " + first["PICKUPCOUNTRY"].ToString(),
                                //AIzaSyB9PgorTUksSwiRCNNTkfEEu1gaHIGG0Rw

                                string Pickupaddress = first["PickupAddress"].ToString() + ", " + first["PICKUPAREA_LOCALITY"].ToString() + ", " + first["PICKUPCITY"].ToString() + ", " + first["PICKUPSTATE"].ToString() + " " + first["PICKUPPINCODE"].ToString() + ", " + first["PICKUPCOUNTRY"].ToString();

                                string PickuprequestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false?key=AIzaSyB9PgorTUksSwiRCNNTkfEEu1gaHIGG0Rw", Uri.EscapeDataString(Pickupaddress));

                                WebRequest  request            = WebRequest.Create(PickuprequestUri);
                                WebResponse response           = request.GetResponse();
                                System.Xml.Linq.XDocument xdoc = XDocument.Load(response.GetResponseStream());

                                XElement result = xdoc.Element("GeocodeResponse").Element("result");
                                if (result != null)
                                {
                                    XElement locationElement = result.Element("geometry").Element("location");
                                    XElement pickuplat       = locationElement.Element("lat");
                                    XElement pickuplng       = locationElement.Element("lng");

                                    pickupLatitude  = pickuplat.Value;
                                    pickupLongitude = pickuplng.Value;
                                }


                                string DropOffaddress = first["DROPOFFADDRESS"].ToString() + ", " + first["DROPOFFAREA_LOCALITY"].ToString() + ", " + first["DROPOFFCITY"].ToString() + ", " + first["DROPOFFSTATE"].ToString() + " " + first["DROPOFFPINCODE"].ToString() + ", " + first["DROPOFFCOUNTRY"].ToString();

                                string DropoffrequestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(DropOffaddress));

                                WebRequest  requestD            = WebRequest.Create(DropoffrequestUri);
                                WebResponse responseD           = requestD.GetResponse();
                                System.Xml.Linq.XDocument xdocD = XDocument.Load(responseD.GetResponseStream());

                                XElement resultD = xdocD.Element("GeocodeResponse").Element("result");
                                if (resultD != null)
                                {
                                    XElement locationElementD = resultD.Element("geometry").Element("location");
                                    XElement dropOfflat       = locationElementD.Element("lat");
                                    XElement dropOfflng       = locationElementD.Element("lng");

                                    dropoffLatitude  = dropOfflat.Value;
                                    dropoffLongitude = dropOfflng.Value;
                                }



                                LogistikaOrderHeader tOrder = new LogistikaOrderHeader
                                {
                                    //ClientOrderSource = "FileImport_" + first["ServiceCode"].ToString(),
                                    CallType           = "Portal",
                                    ClientOrderSource  = "FileImport_" + Convert.ToString(System.DateTime.Now),
                                    ServiceCode        = first["ServiceCode"].ToString(),
                                    OrderType          = first["OrderType"].ToString(),
                                    FreightType        = first["FreightType"].ToString(),
                                    OrderByName        = first["OrderByName"].ToString(),
                                    OrderByPhoneNumber = first["OrderByPhoneNumber"].ToString(),
                                    OrderByEmail       = first["OrderByEmail"].ToString(),
                                    PickUpDate         = Convert.ToDateTime(first["PickUpDate"].ToString()),
                                    VendorOrderID      = first["VendorOrderID"].ToString(),
                                    Payment            = new Payment
                                    {
                                        Amount        = Convert.ToDouble(first["CHARGEDAMOUNT"].ToString()),
                                        PaymentMethod = first["PAYMENTMODE"].ToString()
                                    },
                                    PickupAddress = new List <Address>
                                    {
                                        new Address()
                                        {
                                            AddressLine1 = first["PickupAddress"].ToString(),
                                            Suite        = first["PICKUPHOUSE_FLATNO"].ToString(),
                                            Locality     = first["PICKUPAREA_LOCALITY"].ToString(),
                                            City         = first["PICKUPCITY"].ToString(),
                                            StateCode    = first["PICKUPSTATE"].ToString(),
                                            PostalCode   = first["PICKUPPINCODE"].ToString(),
                                            CountryCode  = first["PICKUPCOUNTRY"].ToString(),
                                            LandMark     = first["PICKUPLANDMARK"].ToString(),
                                            Instruction  = first["PICKUPINSTRUCTION"].ToString(),
                                            Latitude     = pickupLatitude,
                                            Longitude    = pickupLongitude
                                        }
                                    },
                                    DropoffAddress = new List <Address>
                                    {
                                        new Address()
                                        {
                                            AddressLine1 = first["DROPOFFADDRESS"].ToString(),
                                            Suite        = first["DROPOFFHOUSE_FLATNO"].ToString(),
                                            Locality     = first["DROPOFFAREA_LOCALITY"].ToString(),
                                            City         = first["DROPOFFCITY"].ToString(),
                                            StateCode    = first["DROPOFFSTATE"].ToString(),
                                            PostalCode   = first["DROPOFFPINCODE"].ToString(),
                                            CountryCode  = first["DROPOFFCOUNTRY"].ToString(),
                                            LandMark     = first["DROPOFFLANDMARK"].ToString(),
                                            Instruction  = first["DROPOFFINSTRUCTION"].ToString(),
                                            DropOffDate  = Convert.ToDateTime(first["DropOffDate"].ToString()),
                                            Name         = first["DROPOFFNAME"].ToString(),
                                            PhoneNumber  = first["DROPOFFPHONE"].ToString(),
                                            Latitude     = dropoffLatitude,
                                            Longitude    = dropoffLongitude
                                        }
                                    }
                                };
                                tOrder.LineItem = orders.Select(s => new LogistikaOrderLineItem
                                {
                                    Item = s["ITEM"].ToString(),
                                    //ItemType_FK = Convert.ToInt32(s["ItemType_FK"].ToString()),
                                    ShipmentType            = s["ShipmentType"].ToString(),
                                    GoodsType               = s["GOODSTYPE"].ToString(),
                                    UOM                     = s["UOM"].ToString(),
                                    Quantity                = Convert.ToInt32(s["NOOFITEMS"].ToString()),
                                    Weight                  = Convert.ToDouble(s["WEIGHT"].ToString()),
                                    Length                  = Convert.ToDouble(s["Length"].ToString()),
                                    Width                   = Convert.ToDouble(s["Width"].ToString()),
                                    Height                  = Convert.ToDouble(s["Height"].ToString()),
                                    IsPackagingRequiredFlag = Convert.ToBoolean(s["ISPACKAGINGREQUIRED?"].ToString()),
                                    IsPermitVerifiedFlag    = Convert.ToBoolean(s["ISPERMITVERIFIED?"].ToString())
                                }).ToList();


                                var service = new OrderBusinessComponent(new Logistika.Service.Common.DataAccess.Config.OrderDataAccess());
                                service.createOrder(tOrder);
                            }
                        }
                    }
                }
                if (type == "user")
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        LogistikaUser User = new LogistikaUser()
                        {
                            BranchId    = dt.Rows[i]["BranchId"].ToString(),
                            FirstName   = dt.Rows[i]["FirstName"].ToString(),
                            MiddleName  = dt.Rows[i]["MiddleName"].ToString(),
                            LastName    = dt.Rows[i]["LastName"].ToString(),
                            DateOfBirth = Convert.ToDateTime(dt.Rows[i]["DateOfBirth"].ToString()),
                            Designation = dt.Rows[i]["EmployeeRole"].ToString(),
                            JobTitle    = dt.Rows[i]["EmployeeTitle"].ToString(),
                            Contact     = new Contact()
                            {
                                Email  = dt.Rows[i]["PrimaryEmail"].ToString(),
                                Phone  = dt.Rows[i]["Phone"].ToString(),
                                Mobile = dt.Rows[i]["MobileNo"].ToString(),
                            },
                            Password  = dt.Rows[i]["Password"].ToString(),
                            Gender    = dt.Rows[i]["Gender"].ToString(),
                            OtherInfo = new List <DropdownData>
                            {
                                new DropdownData()
                                {
                                    Text  = "LicenseNumber",
                                    Value = dt.Rows[i]["LicenseNumber"].ToString(),
                                },
                                new DropdownData()
                                {
                                    Text  = "LicenceClass",
                                    Value = dt.Rows[i]["LicenceClass"].ToString(),
                                },
                                new DropdownData()
                                {
                                    Text  = "Experience",
                                    Value = dt.Rows[i]["Experience"].ToString(),
                                },
                                new DropdownData()
                                {
                                    Text  = "MonthlyWage",
                                    Value = dt.Rows[i]["MonthlyWage"].ToString(),
                                }
                            },
                            StartDate = Convert.ToDateTime(dt.Rows[i]["StartDate"].ToString()),
                            EndDate   = Convert.ToDateTime(dt.Rows[i]["EndDate"].ToString()),
                            Active    = Convert.ToBoolean(dt.Rows[i]["IsActive"].ToString()),
                            Addresses = new List <Address>
                            {
                                new Address()
                                {
                                    AddressLine1 = dt.Rows[i]["AddressLine1"].ToString(),
                                    Suite        = dt.Rows[i]["SuiteNo"].ToString(),
                                    //Locality = dt.Rows[i]["Locality"].ToString(),
                                    City        = dt.Rows[i]["City"].ToString(),
                                    StateCode   = dt.Rows[i]["State"].ToString(),
                                    PostalCode  = dt.Rows[i]["PinCode"].ToString(),
                                    CountryCode = dt.Rows[i]["CountryCode"].ToString(),
                                    LandMark    = dt.Rows[i]["LandMark"].ToString()
                                }
                            }
                        };
                        var Pservice = new UserBusinessComponent(new UserDataAccess());
                        PhoneCode = Pservice.GetCountryInfo(dt.Rows[i]["CountryCode"].ToString());
                        //PhoneCode = _userDataAccess.GetCountryInfo(dt.Rows[i]["CountryCode"].ToString());

                        if (User.Contact.Mobile.StartsWith("0"))
                        {
                            User.Contact.Mobile = User.Contact.Mobile.TrimStart('0');
                            User.Contact.Mobile = PhoneCode[0].PhoneCode + User.Contact.Mobile;
                        }
                        else if (!User.Contact.Mobile.StartsWith("0"))
                        {
                            User.Contact.Mobile = PhoneCode[0].PhoneCode + User.Contact.Mobile;
                        }
                        if (User.Contact.Phone.StartsWith("0"))
                        {
                            User.Contact.Phone = User.Contact.Phone.TrimStart('0');
                            User.Contact.Phone = PhoneCode[0].PhoneCode + User.Contact.Phone;
                        }
                        else if (!User.Contact.Phone.StartsWith("0"))
                        {
                            User.Contact.Phone = PhoneCode[0].PhoneCode + User.Contact.Phone;
                        }

                        var service = new UserBusinessComponent(new UserDataAccess());
                        service.SaveUser(User, null);
                    }
                }
                if (type == "fleet")
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Fleet Fleet = new Fleet()
                        {
                            FleetID         = dt.Rows[i]["FleetID"].ToString(),
                            Make            = dt.Rows[i]["Make"].ToString(),
                            Model           = dt.Rows[i]["Model"].ToString(),
                            ModelYear       = Convert.ToInt32(dt.Rows[i]["ModelYear"].ToString()),
                            Colour          = dt.Rows[i]["Colour"].ToString(),
                            StartingMileage = Convert.ToInt32(dt.Rows[i]["StartingMileage"].ToString()),
                            Payload         = dt.Rows[i]["Payload"].ToString(),
                            OwnerShipType   = dt.Rows[i]["OwnerShipType"].ToString(),
                            OverallLength   = dt.Rows[i]["OverallLength"].ToString(),
                            OverallWidth    = dt.Rows[i]["OverallWidth"].ToString(),
                            OverallHeight   = dt.Rows[i]["OverallHeight"].ToString(),
                            IsActive        = Convert.ToBoolean(dt.Rows[i]["IsActive"].ToString())
                        };
                        var service = new UserBusinessComponent(new UserDataAccess());
                        service.SaveFleet(Fleet, null, "File");
                    }
                }
                //Console.ReadLine();

                string[] fileList = Directory.GetFiles(rootFolderPath, "*.xlsx");

                if (Directory.Exists(rootFolderPath))
                {
                    foreach (string file in fileList)
                    {
                        FileInfo mFile = new FileInfo(file);
                        if (new FileInfo(destinationPath + "\\" + mFile.Name).Exists == false)
                        {
                            mFile.MoveTo(destinationPath + "\\" + mFile.Name);
                        }
                    }
                }
            }
        }