public Location Find(UnLocode unLocode)
 {
     foreach (Location location in SampleLocations.GetAll())
     {
         if (location.UnLocode.Equals(unLocode))
         {
             return(location);
         }
     }
     return(null);
 }
Пример #2
0
        //TODO:atrosin Revise where and how is used the method
        public static void LoadHibernateData(ISession session, HandlingEventFactory handlingEventFactory,
                                             IHandlingEventRepository handlingEventRepository)
        {
            Console.WriteLine("*** Loading Hibernate data ***");

            foreach (Location location  in SampleLocations.GetAll())
            {
                session.Save(location);
            }

            foreach (Voyage voyage in SampleVoyages.GetAll())
            {
                session.Save(voyage);
            }

            /*session.Save(SampleVoyages.HONGKONG_TO_NEW_YORK);
             * session.Save(SampleVoyages.NEW_YORK_TO_DALLAS);
             * session.Save(SampleVoyages.DALLAS_TO_HELSINKI);
             * session.Save(SampleVoyages.HELSINKI_TO_HONGKONG);
             * session.Save(SampleVoyages.DALLAS_TO_HELSINKI_ALT);*/

            var routeSpecification = new RouteSpecification(SampleLocations.HONGKONG,
                                                            SampleLocations.HELSINKI,
                                                            DateUtil.ToDate("2009-03-15"));
            var trackingId = new TrackingId("ABC123");
            var abc123     = new Cargo(trackingId, routeSpecification);

            var itinerary = new Itinerary(
                new List <Leg>
            {
                new Leg(SampleVoyages.HONGKONG_TO_NEW_YORK, SampleLocations.HONGKONG, SampleLocations.NEWYORK,
                        DateUtil.ToDate("2009-03-02"), DateUtil.ToDate("2009-03-05")),
                new Leg(SampleVoyages.NEW_YORK_TO_DALLAS, SampleLocations.NEWYORK, SampleLocations.DALLAS,
                        DateUtil.ToDate("2009-03-06"), DateUtil.ToDate("2009-03-08")),
                new Leg(SampleVoyages.DALLAS_TO_HELSINKI, SampleLocations.DALLAS, SampleLocations.HELSINKI,
                        DateUtil.ToDate("2009-03-09"), DateUtil.ToDate("2009-03-12"))
            });

            abc123.AssignToRoute(itinerary);

            session.Save(abc123);


            HandlingEvent event1 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-01"), trackingId, null, SampleLocations.HONGKONG.UnLocode,
                HandlingType.RECEIVE
                );

            session.Save(event1);

            HandlingEvent event2 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-02"), trackingId,
                SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.HONGKONG.UnLocode,
                HandlingType.LOAD
                );

            session.Save(event2);

            HandlingEvent event3 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-05"), trackingId,
                SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.NEWYORK.UnLocode,
                HandlingType.UNLOAD
                );

            session.Save(event3);


            HandlingHistory handlingHistory = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId);

            abc123.DeriveDeliveryProgress(handlingHistory);

            session.Update(abc123);

            // Cargo JKL567

            var routeSpecification1 = new RouteSpecification(SampleLocations.HANGZOU,
                                                             SampleLocations.STOCKHOLM,
                                                             DateUtil.ToDate("2009-03-18"));
            var trackingId1 = new TrackingId("JKL567");
            var jkl567      = new Cargo(trackingId1, routeSpecification1);

            var itinerary1 = new Itinerary(new List <Leg>
            {
                new Leg(SampleVoyages.HONGKONG_TO_NEW_YORK,
                        SampleLocations.HANGZOU, SampleLocations.NEWYORK,
                        DateUtil.ToDate("2009-03-03"),
                        DateUtil.ToDate("2009-03-05")),
                new Leg(SampleVoyages.NEW_YORK_TO_DALLAS,
                        SampleLocations.NEWYORK, SampleLocations.DALLAS,
                        DateUtil.ToDate("2009-03-06"),
                        DateUtil.ToDate("2009-03-08")),
                new Leg(SampleVoyages.DALLAS_TO_HELSINKI,
                        SampleLocations.DALLAS, SampleLocations.STOCKHOLM,
                        DateUtil.ToDate("2009-03-09"),
                        DateUtil.ToDate("2009-03-11"))
            });

            jkl567.AssignToRoute(itinerary1);

            session.Save(jkl567);


            HandlingEvent event21 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-01"), trackingId1, null, SampleLocations.HANGZOU.UnLocode,
                HandlingType.RECEIVE);

            session.Save(event21);

            HandlingEvent event22 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-03"), trackingId1,
                SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.HANGZOU.UnLocode,
                HandlingType.LOAD
                );

            session.Save(event22);

            HandlingEvent event23 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-05"), trackingId1,
                SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.NEWYORK.UnLocode,
                HandlingType.UNLOAD
                );

            session.Save(event23);

            HandlingEvent event24 = handlingEventFactory.CreateHandlingEvent(
                new DateTime(), DateUtil.ToDate("2009-03-06"), trackingId1,
                SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.NEWYORK.UnLocode,
                HandlingType.LOAD
                );

            session.Save(event24);


            HandlingHistory handlingHistory1 = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId1);

            jkl567.DeriveDeliveryProgress(handlingHistory1);

            session.Update(jkl567);
        }
 public IList <Location> FindAll()
 {
     return(SampleLocations.GetAll());
 }
Пример #4
0
        //        private static void LoadHandlingEventData()
        //        {
        //            const string handlingEventSql =
        //                "insert into HandlingEvent (completionTime, registrationTime, type, location_id, voyage_id, cargo_id) " +
        //                "values (?, ?, ?, ?, ?, ?)";
        //
        //            var handlingEventArgs = new[]
        //                {
        //                    //XYZ (SESTO-FIHEL-DEHAM-CNHKG-JPTOK-AUMEL)
        //                    new object[] {Ts(0), Ts((0)), "RECEIVE", 1, null, 1},
        //                    new object[] {Ts((4)), Ts((5)), "LOAD", 1, 1, 1},
        //                    new object[] {Ts((14)), Ts((14)), "UNLOAD", 5, 1, 1},
        //                    new object[] {Ts((15)), Ts((15)), "LOAD", 5, 1, 1},
        //                    new object[] {Ts((30)), Ts((30)), "UNLOAD", 6, 1, 1},
        //                    new object[] {Ts((33)), Ts((33)), "LOAD", 6, 1, 1},
        //                    new object[] {Ts((34)), Ts((34)), "UNLOAD", 3, 1, 1},
        //                    new object[] {Ts((60)), Ts((60)), "LOAD", 3, 1, 1},
        //                    new object[] {Ts((70)), Ts((71)), "UNLOAD", 4, 1, 1},
        //                    new object[] {Ts((75)), Ts((75)), "LOAD", 4, 1, 1},
        //                    new object[] {Ts((88)), Ts((88)), "UNLOAD", 2, 1, 1},
        //                    new object[] {Ts((100)), Ts((102)), "CLAIM", 2, null, 1},
        //                    //ZYX (AUMEL - USCHI - DEHAM -)
        //                    new object[] {Ts((200)), Ts((201)), "RECEIVE", 2, null, 3},
        //                    new object[] {Ts((202)), Ts((202)), "LOAD", 2, 2, 3},
        //                    new object[] {Ts((208)), Ts((208)), "UNLOAD", 7, 2, 3},
        //                    new object[] {Ts((212)), Ts((212)), "LOAD", 7, 2, 3},
        //                    new object[] {Ts((230)), Ts((230)), "UNLOAD", 6, 2, 3},
        //                    new object[] {Ts((235)), Ts((235)), "LOAD", 6, 2, 3},
        //                    //ABC
        //                    new object[] {Ts((20)), Ts((21)), "CLAIM", 2, null, 2},
        //                    //CBA
        //                    new object[] {Ts((0)), Ts((1)), "RECEIVE", 2, null, 4},
        //                    new object[] {Ts((10)), Ts((11)), "LOAD", 2, 2, 4},
        //                    new object[] {Ts((20)), Ts((21)), "UNLOAD", 7, 2, 4},
        //                    //FGH
        //                    new object[] {Ts(100), Ts(160), "RECEIVE", 3, null, 5},
        //                    new object[] {Ts(150), Ts(110), "LOAD", 3, 3, 5},
        //                    //JKL
        //                    new object[] {Ts(200), Ts(220), "RECEIVE", 6, null, 6},
        //                    new object[] {Ts(300), Ts(330), "LOAD", 6, 3, 6},
        //                    new object[] {Ts(400), Ts(440), "UNLOAD", 5, 3, 6} // Unexpected event
        //                };
        //
        //            ExecuteUpdate(session, handlingEventSql, handlingEventArgs);
        //        }
        //
        //        private static void LoadCarrierMovementData()
        //        {
        //            const string voyageSql = "insert into Voyage (id, voyage_number) values (?, ?)";
        //            var voyageArgs = new[]
        //                {
        //                    new object[] {1, "0101"},
        //                    new object[] {2, "0202"},
        //                    new object[] {3, "0303"}
        //                };
        //            ExecuteUpdate(session, voyageSql, voyageArgs);
        //
        //            const string carrierMovementSql =
        //                "insert into CarrierMovement (id, voyage_id, departure_location_id, arrival_location_id, departure_time, arrival_time, cm_index) " +
        //                "values (?,?,?,?,?,?,?)";
        //
        //            var carrierMovementArgs = new[]
        //                {
        //                    // SESTO - FIHEL - DEHAM - CNHKG - JPTOK - AUMEL (voyage 0101)
        //                    new object[] {1, 1, 1, 5, Ts(1), Ts(2), 0},
        //                    new object[] {2, 1, 5, 6, Ts(1), Ts(2), 1},
        //                    new object[] {3, 1, 6, 3, Ts(1), Ts(2), 2},
        //                    new object[] {4, 1, 3, 4, Ts(1), Ts(2), 3},
        //                    new object[] {5, 1, 4, 2, Ts(1), Ts(2), 4},
        //                    // AUMEL - USCHI - DEHAM - SESTO - FIHEL (voyage 0202)
        //                    new object[] {7, 2, 2, 7, Ts(1), Ts(2), 0},
        //                    new object[] {8, 2, 7, 6, Ts(1), Ts(2), 1},
        //                    new object[] {9, 2, 6, 1, Ts(1), Ts(2), 2},
        //                    new object[] {6, 2, 1, 5, Ts(1), Ts(2), 3},
        //                    // CNHKG - AUMEL - FIHEL - DEHAM - SESTO - USCHI - JPTKO (voyage 0303)
        //                    new object[] {10, 3, 3, 2, Ts(1), Ts(2), 0},
        //                    new object[] {11, 3, 2, 5, Ts(1), Ts(2), 1},
        //                    new object[] {12, 3, 6, 1, Ts(1), Ts(2), 2},
        //                    new object[] {13, 3, 1, 7, Ts(1), Ts(2), 3},
        //                    new object[] {14, 3, 7, 4, Ts(1), Ts(2), 4}
        //                };
        //            ExecuteUpdate(session, carrierMovementSql, carrierMovementArgs);
        //        }
        //
        //        private static void LoadCargoData(ISession session)
        //        {
        //            const string cargoSql =
        //                "insert into Cargo (id, tracking_id, origin_id, spec_origin_id, spec_destination_id, spec_arrival_deadline, transport_status, current_voyage_id, last_known_location_id, is_misdirected, routing_status, calculated_at, unloaded_at_dest) " +
        //                "values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        //
        //            var cargoArgs = new[]
        //                {
        //                    new object[]
        //                        {
        //                            1, "XYZ", 1, 1, 2, Ts(10), "IN_PORT", null, 1, false, "ROUTED", Ts(100),
        //                            false
        //                        },
        //                    new object[]
        //                        {
        //                            2, "ABC", 1, 1, 5, Ts(20), "IN_PORT", null, 1, false, "ROUTED", Ts(100),
        //                            false
        //                        },
        //                    new object[]
        //                        {
        //                            3, "ZYX", 2, 2, 1, Ts(30), "IN_PORT", null, 1, false, "NOT_ROUTED", Ts(100),
        //                            false
        //                        },
        //                    new object[]
        //                        {
        //                            4, "CBA", 5, 5, 1, Ts(40), "IN_PORT", null, 1, false, "MISROUTED", Ts(100),
        //                            false
        //                        },
        //                    new object[]
        //                        {
        //                            5, "FGH", 1, 3, 5, Ts(50), "IN_PORT", null, 1, false, "ROUTED", Ts(100),
        //                            false
        //                        }, // Cargo origin differs from spec origin
        //                    new object[]
        //                        {
        //                            6, "JKL", 6, 6, 4, Ts(60), "IN_PORT", null, 1, true, "ROUTED", Ts(100),
        //                            false
        //                        }
        //                };
        //            ExecuteUpdate(session, cargoSql, cargoArgs);
        //        }
        //
        //        private static void LoadLocationData()
        //        {
        //
        //            var locationArgs = new List<Location>
        //                {
        //                    new Location( new UnLocode("SESTO"), "Stockholm") {Id = 1},
        //                    new Location( new UnLocode("AUMEL"), "Melbourne") {Id = 2},
        //                    new Location( new UnLocode("CNHKG"), "Hongkong") {Id = 3},
        //                    new Location( new UnLocode("JPTOK"), "Tokyo") {Id = 4},
        //                    new Location( new UnLocode("FIHEL"), "Helsinki") {Id = 5},
        //                    new Location( new UnLocode("DEHAM"), "Hamburg") {Id = 6},
        //                    new Location( new UnLocode("USCHI"), "Chicago") {Id = 7},
        //                };
        //            ExecuteUpdate(session, locationSql, locationArgs);
        //        }
        //
        //        private static void LoadItineraryData(ISession session)
        //        {
        //            const string legSql =
        //                "insert into Leg (id, cargo_id, voyage_id, load_location_id, unload_location_id, load_time, unload_time, leg_index) " +
        //                "values (?,?,?,?,?,?,?,?)";
        //
        //            var legArgs = new[]
        //                {
        //                    // Cargo 5: Hongkong - Melbourne - Stockholm - Helsinki
        //                    new object[] {1, 5, 1, 3, 2, Ts(1), Ts(2), 0},
        //                    new object[] {2, 5, 1, 2, 1, Ts(3), Ts(4), 1},
        //                    new object[] {3, 5, 1, 1, 5, Ts(4), Ts(5), 2},
        //                    // Cargo 6: Hamburg - Stockholm - Chicago - Tokyo
        //                    new object[] {4, 6, 2, 6, 1, Ts(1), Ts(2), 0},
        //                    new object[] {5, 6, 2, 1, 7, Ts(3), Ts(4), 1},
        //                    new object[] {6, 6, 2, 7, 4, Ts(5), Ts(6), 2}
        //                };
        //            ExecuteUpdate(session, legSql, legArgs);
        //        }


        public static void LoadMongoData(HandlingEventFactory handlingEventFactory,
                                         IHandlingEventRepository handlingEventRepository)
        {
            Console.WriteLine("*** Loading data ***");

            var db                 = Utils.ShippingDb;
            var locations          = GetLocationCollection();
            var mongoInsertOptions = new MongoInsertOptions()
            {
                Flags = InsertFlags.ContinueOnError
            };

            try
            {
                locations.InsertBatch(SampleLocations.GetAll(), mongoInsertOptions);
            }
            catch (WriteConcernException ex)
            {
            }
            var voyages = db.GetCollection <Location>("voyages");


            try
            {
                voyages.InsertBatch(SampleVoyages.GetAll(), mongoInsertOptions);
            }
            catch (WriteConcernException ex)
            {
            }

            var cargo = db.GetCollection <Cargo>("cargo");

            var routeSpecification = new RouteSpecification(SampleLocations.HONGKONG,
                                                            SampleLocations.HELSINKI,
                                                            DateUtil.ToDate("2009-03-15"));
            var trackingId     = new TrackingId("ABC123");
            var abc123exists   = new CargoRepositoryMongo(db).Find(trackingId) != null;
            var handlingEvents = db.GetCollection <HandlingEvent>("handlingEvents");

            if (!abc123exists)
            {
                var abc123    = new Cargo(trackingId, routeSpecification);
                var itinerary = new Itinerary(
                    new List <Leg>
                {
                    new Leg(SampleVoyages.HONGKONG_TO_NEW_YORK, SampleLocations.HONGKONG,
                            SampleLocations.NEWYORK,
                            DateUtil.ToDate("2009-03-02"), DateUtil.ToDate("2009-03-05")),
                    new Leg(SampleVoyages.NEW_YORK_TO_DALLAS, SampleLocations.NEWYORK, SampleLocations.DALLAS,
                            DateUtil.ToDate("2009-03-06"), DateUtil.ToDate("2009-03-08")),
                    new Leg(SampleVoyages.DALLAS_TO_HELSINKI, SampleLocations.DALLAS, SampleLocations.HELSINKI,
                            DateUtil.ToDate("2009-03-09"), DateUtil.ToDate("2009-03-12"))
                });
                abc123.AssignToRoute(itinerary);

                cargo.Insert(abc123);

                HandlingEvent event1 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-01"), trackingId, null, SampleLocations.HONGKONG.UnLocode,
                    HandlingType.RECEIVE
                    );


                handlingEvents.Insert(event1);

                HandlingEvent event2 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-02"), trackingId,
                    SampleVoyages.HONGKONG_TO_NEW_YORK.voyageNumber, SampleLocations.HONGKONG.UnLocode,
                    HandlingType.LOAD
                    );
                handlingEvents.Insert(event2);

                HandlingEvent event3 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-05"), trackingId,
                    SampleVoyages.HONGKONG_TO_NEW_YORK.voyageNumber, SampleLocations.NEWYORK.UnLocode,
                    HandlingType.UNLOAD
                    );
                handlingEvents.Insert(event3);


                HandlingHistory handlingHistory = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId);
                abc123.DeriveDeliveryProgress(handlingHistory);
                cargo.Save(abc123);
            }


            var trackingId1  = new TrackingId("JKL567");
            var jkl567exists = new CargoRepositoryMongo(db).Find(trackingId) != null;

            if (!jkl567exists)
            {
                var routeSpecification1 = new RouteSpecification(SampleLocations.HANGZOU,
                                                                 SampleLocations.STOCKHOLM,
                                                                 DateUtil.ToDate("2009-03-18"));
                var jkl567 = new Cargo(trackingId1, routeSpecification1);

                var itinerary1 = new Itinerary(new List <Leg>
                {
                    new Leg(SampleVoyages.HONGKONG_TO_NEW_YORK,
                            SampleLocations.HANGZOU, SampleLocations.NEWYORK,
                            DateUtil.ToDate("2009-03-03"),
                            DateUtil.ToDate("2009-03-05")),
                    new Leg(SampleVoyages.NEW_YORK_TO_DALLAS,
                            SampleLocations.NEWYORK, SampleLocations.DALLAS,
                            DateUtil.ToDate("2009-03-06"),
                            DateUtil.ToDate("2009-03-08")),
                    new Leg(SampleVoyages.DALLAS_TO_HELSINKI,
                            SampleLocations.DALLAS, SampleLocations.STOCKHOLM,
                            DateUtil.ToDate("2009-03-09"),
                            DateUtil.ToDate("2009-03-11"))
                });
                jkl567.AssignToRoute(itinerary1);
                cargo.Insert(jkl567);


                HandlingEvent event21 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-01"), trackingId1, null, SampleLocations.HANGZOU.UnLocode,
                    HandlingType.RECEIVE);

                handlingEvents.Insert(event21);

                HandlingEvent event22 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-03"), trackingId1,
                    SampleVoyages.HONGKONG_TO_NEW_YORK.voyageNumber, SampleLocations.HANGZOU.UnLocode,
                    HandlingType.LOAD
                    );
                handlingEvents.Insert(event22);

                HandlingEvent event23 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-05"), trackingId1,
                    SampleVoyages.HONGKONG_TO_NEW_YORK.voyageNumber, SampleLocations.NEWYORK.UnLocode,
                    HandlingType.UNLOAD
                    );
                handlingEvents.Insert(event23);

                HandlingEvent event24 = handlingEventFactory.CreateHandlingEvent(
                    new DateTime(), DateUtil.ToDate("2009-03-06"), trackingId1,
                    SampleVoyages.HONGKONG_TO_NEW_YORK.voyageNumber, SampleLocations.NEWYORK.UnLocode,
                    HandlingType.LOAD
                    );
                handlingEvents.Insert(event24);


                HandlingHistory handlingHistory1 = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId1);
                jkl567.DeriveDeliveryProgress(handlingHistory1);

                cargo.Save(jkl567);
            }
        }