public void Init()
{
TrackingId xyz = new TrackingId("XYZ");
Cargo cargoXYZ = createCargoWithDeliveryHistory(
xyz, SampleLocations.STOCKHOLM, SampleLocations.MELBOURNE,
handlingEventRepository.LookupHandlingHistoryOfCargo(xyz));
cargoDb.Add(xyz.IdString, cargoXYZ);
TrackingId zyx = new TrackingId("ZYX");
Cargo cargoZYX = createCargoWithDeliveryHistory(
zyx, SampleLocations.MELBOURNE, SampleLocations.STOCKHOLM,
handlingEventRepository.LookupHandlingHistoryOfCargo(zyx));
cargoDb.Add(zyx.IdString, cargoZYX);
TrackingId abc = new TrackingId("ABC");
Cargo cargoABC = createCargoWithDeliveryHistory(
abc, SampleLocations.STOCKHOLM, SampleLocations.HELSINKI,
handlingEventRepository.LookupHandlingHistoryOfCargo(abc));
cargoDb.Add(abc.IdString, cargoABC);
TrackingId cba = new TrackingId("CBA");
Cargo cargoCBA = createCargoWithDeliveryHistory(
cba, SampleLocations.HELSINKI, SampleLocations.STOCKHOLM,
handlingEventRepository.LookupHandlingHistoryOfCargo(cba));
cargoDb.Add(cba.IdString, cargoCBA);
}
public void RegisterHandlingEvent(DateTime completionTime, TrackingId trackingId, UnLocode unLocode, HandlingEventType type)
{
HandlingHistory handlingHistory = _handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId);
Location location = _locationRepository.Find(unLocode);
handlingHistory.RegisterHandlingEvent(type, location, DateTime.Now, completionTime);
}
public void InspectCargo(TrackingId trackingId)
{
Validate.NotNull(trackingId, "Tracking ID is required");
Cargo cargo;
using (var transactionScope = new TransactionScope())
{
cargo = cargoRepository.Find(trackingId);
if (cargo == null)
{
logger.Warn("Can't inspect non-existing cargo " + trackingId);
return;
}
HandlingHistory handlingHistory = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId);
cargo.DeriveDeliveryProgress(handlingHistory);
if (cargo.Delivery.IsMisdirected)
{
applicationEvents.CargoWasMisdirected(cargo);
}
if (cargo.Delivery.IsUnloadedAtDestination)
{
applicationEvents.CargoHasArrived(cargo);
}
cargoRepository.Store(cargo);
transactionScope.Complete();
}
}
public void FindEventsForCargo()
{
var trackingId = new TrackingId("XYZ");
IList <HandlingEvent> handlingEvents =
handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId).DistinctEventsByCompletionTime();
Assert.AreEqual(12, handlingEvents.Count);
}
public void Handle(CargoHasBeenAssignedToRouteEvent @event)
{
HandlingHistory existing = _repository.LookupHandlingHistoryOfCargo(@event.Source.TrackingId);
if (existing != null)
{
return;
}
HandlingHistory handlingHistory = new HandlingHistory(@event.Source.TrackingId);
_repository.Store(handlingHistory);
}
public ActionResult Track(string trackingId)
{
Cargo cargo = _cargoRepository.Find(new TrackingId(trackingId));
if (cargo == null)
{
ViewData.ModelState.AddModelError("trackingId", @"Provided tracking id is invalid.");
return(View());
}
HandlingHistory history = _handlingEventRepository.LookupHandlingHistoryOfCargo(new TrackingId(trackingId));
return(View(new CargoTrackingViewAdapter(cargo, history)));
}
protected override void DoHandle(CargoHasBeenAssignedToRouteMessage message)
{
TrackingId trackingId = new TrackingId(message.TrackingId);
HandlingHistory existing = _handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId);
if (existing != null)
{
return;
}
HandlingHistory handlingHistory = new HandlingHistory(trackingId);
_handlingEventRepository.Store(handlingHistory);
}
public void FindByCargoId()
{
TrackingId trackingId = new TrackingId("FGH");
Cargo cargo = cargoRepository.Find(trackingId);
Assert.AreEqual(SampleLocations.STOCKHOLM, cargo.Origin);
Assert.AreEqual(SampleLocations.HONGKONG, cargo.RouteSpecification.Origin);
Assert.AreEqual(SampleLocations.HELSINKI, cargo.RouteSpecification.Destination);
Assert.IsNotNull(cargo.Delivery);
IList <HandlingEvent> events =
handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId).DistinctEventsByCompletionTime();
Assert.AreEqual(2, events.Count);
HandlingEvent firstEvent = events[0];
AssertHandlingEvent(cargo, firstEvent, HandlingType.RECEIVE, SampleLocations.HONGKONG, 100, 160, Voyage.NONE);
HandlingEvent secondEvent = events[1];
Voyage hongkongMelbourneTokyoAndBack = new Voyage.Builder(
new VoyageNumber("0303"), SampleLocations.HONGKONG).
AddMovement(SampleLocations.MELBOURNE, new DateTime(), new DateTime()).
AddMovement(SampleLocations.TOKYO, new DateTime(), new DateTime()).
AddMovement(SampleLocations.HONGKONG, new DateTime(), new DateTime()).
Build();
AssertHandlingEvent(cargo, secondEvent, HandlingType.LOAD, SampleLocations.HONGKONG, 150, 110,
hongkongMelbourneTokyoAndBack);
IList <Leg> legs = cargo.Itinerary.Legs;
Assert.AreEqual(3, legs.Count);
Leg firstLeg = legs[0];
AssertLeg(firstLeg, "0101", SampleLocations.HONGKONG, SampleLocations.MELBOURNE);
Leg secondLeg = legs[1];
AssertLeg(secondLeg, "0101", SampleLocations.MELBOURNE, SampleLocations.STOCKHOLM);
Leg thirdLeg = legs[2];
AssertLeg(thirdLeg, "0101", SampleLocations.STOCKHOLM, SampleLocations.HELSINKI);
}
public ActionResult Search([ModelBinder(typeof(TrackCommandBinder))] TrackCommand trackCommand)
{
string trackingIdString = trackCommand.TrackingId;
var trackingId = new TrackingId(trackingIdString);
Cargo cargo = CargoRepository.Find(trackingId);
CargoTrackingViewAdapter cargoTrackingViewAdapter = null;
if (cargo != null)
{
IList <HandlingEvent> handlingEvents =
HandlingEventRepository.LookupHandlingHistoryOfCargo(trackingId)
.DistinctEventsByCompletionTime();
cargoTrackingViewAdapter = new CargoTrackingViewAdapter(cargo, handlingEvents);
}
else
{
SetMessage(UnknownMessageId);
}
return(View(cargoTrackingViewAdapter));
}
//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);
}
//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);
}
// 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);
}
}
// 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);
}
}