Inheritance: DbRepository
Exemplo n.º 1
0
 private static void AddSchedule(TiplocRepository tiprep, List<TiplocCode> tiplocs, ScheduleRepository schedrep, dynamic rowData, int retryCount = 0)
 {
     try
     {
         AddSchedule(tiplocs, schedrep, rowData);
     }
     catch (TiplocNotFoundException tnfe)
     {
         TiplocCode t = new TiplocCode
         {
             Tiploc = tnfe.Code
         };
         t.TiplocId = tiprep.InsertTiploc(t.Tiploc);
         tiplocs.Add(t);
         AddSchedule(tiplocs, schedrep, rowData);
     }
     catch (DbException dbe)
     {
         Trace.TraceError(dbe.ToString());
         if (retryCount <= 3)
         {
             Trace.TraceInformation("Retrying");
             AddSchedule(tiprep, tiplocs, schedrep, rowData, ++retryCount);
         }
         else
         {
             Trace.TraceError("Retry count exceeded");
             //throw;
         }
     }
 }
Exemplo n.º 2
0
 private static void AddAssociation(dynamic rowData, List<TiplocCode> tiplocs, TiplocRepository tipRep, AssociationRepository aRep)
 {
     try
     {
         Association assoc = AssociationJsonMapper.ParseJsonAssociation(rowData.JsonAssociationV1, tiplocs);
         switch (assoc.TransactionType)
         {
             case TransactionType.Create:
                 Trace.TraceInformation("Inserted Association From UID {0} -> {1}, Type {2}, Indicator {3}",
                     assoc.MainTrainUid, assoc.AssocTrainUid, assoc.AssociationType, assoc.STPIndicator);
                 break;
             case TransactionType.Delete:
                 Trace.TraceInformation("Delete Association UID {0} For {1}",
                     assoc.MainTrainUid, assoc.StartDate);
                 break;
         }
         aRep.AddAssociation(assoc);
     }
     catch (TiplocNotFoundException tnfe)
     {
         TiplocCode t = new TiplocCode
         {
             Tiploc = tnfe.Code
         };
         t.TiplocId = tipRep.InsertTiploc(t.Tiploc);
         tiplocs.Add(t);
         AddAssociation(rowData, tiplocs, tipRep, aRep);
     }
 }
Exemplo n.º 3
0
        static void Main(string[] args)
        {
            // this data is fetchable via http://nrodwiki.rockshore.net/index.php/ReferenceData
            string jsonData = File.ReadAllText("CORPUSExtract.json");

            TiplocContainer container = JsonConvert.DeserializeObject<TiplocContainer>(jsonData);

            System.Console.WriteLine("Loaded {0} Tiplocs", container.TIPLOCDATA.Count());

            TiplocRepository tiplocRepo = new TiplocRepository();

            ulong counter = 1;
            foreach (var tiploc in container.TIPLOCDATA)
            {
                System.Console.WriteLine("Processing number {0}", counter);
                if (!string.IsNullOrWhiteSpace(tiploc.STANOX) &&
                    !string.IsNullOrWhiteSpace(tiploc.TIPLOC) &&
                    tiplocRepo.GetTiplocByStanox(tiploc.STANOX) == null)
                {
                    System.Console.WriteLine("Inserting {0}", tiploc.NLCDESC);
                    tiplocRepo.InsertTiploc(tiploc.ToTiplocCode());
                }
                counter++;
            }
        }
Exemplo n.º 4
0
        public void TestVSTP()
        {
            const string msg = "{\"VSTPCIFMsgV1\":{\"schemaLocation\":\"http://xml.networkrail.co.uk/ns/2008/Train itm_vstp_cif_messaging_v1.xsd\",\"classification\":\"industry\",\"timestamp\":\"1376123424000\",\"owner\":\"Network Rail\",\"originMsgId\":\"2013-08-10T08:30:24-00:00vstp.networkrail.co.uk\",\"Sender\":{\"organisation\":\"Network Rail\",\"application\":\"TOPS\",\"component\":\"VSTP\"},\"schedule\":{\"schedule_id\":\"\",\"transaction_type\":\"Create\",\"schedule_start_date\":\"2013-08-10\",\"schedule_end_date\":\"2013-08-10\",\"schedule_days_runs\":\"0000010\",\"applicable_timetable\":\"Y\",\"CIF_bank_holiday_running\":\" \",\"CIF_train_uid\":\" 08698\",\"train_status\":\"2\",\"CIF_stp_indicator\":\"N\",\"schedule_segment\":[{\"signalling_id\":\"\",\"uic_code\":\"\",\"atoc_code\":\"\",\"CIF_train_category\":\"\",\"CIF_headcode\":\"\",\"CIF_course_indicator\":\"\",\"CIF_train_service_code\":\"55460180\",\"CIF_business_sector\":\"\",\"CIF_power_type\":\"D\",\"CIF_timing_load\":\"\",\"CIF_speed\":\"\",\"CIF_operating_characteristics\":\"\",\"CIF_train_class\":\"\",\"CIF_sleepers\":\"\",\"CIF_reservations\":\"0\",\"CIF_connection_indicator\":\"\",\"CIF_catering_code\":\"\",\"CIF_service_branding\":\"\",\"CIF_traction_class\":\"\",\"schedule_location\":[{\"scheduled_arrival_time\":\" \",\"scheduled_departure_time\":\"124400\",\"scheduled_pass_time\":\" \",\"public_arrival_time\":\" \",\"public_departure_time\":\"00\",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\" \",\"CIF_activity\":\"TB\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"HMSHBRF\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"125000\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"WACRJN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"130900\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"NNTNABJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"131100\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"NNTN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"131800\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"HINCKLY\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"132430\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"CROFTS\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"133400\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"WGSTNNJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"133800\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"LESTRSJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"134030\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"LESTER\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"135900\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"SYSTNSJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"135930\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"SYSTNEJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"140700\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MLTNFBY\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"141100\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MLTNSDG\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"141830\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MLTNWHI\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"142100\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"OAKHASH\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"142230\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"LAGHJN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"142400\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"OAKHAM\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"142830\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MANTONJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"143200\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MANTLFF\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"143400\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"KETTON\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"144000\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"STAMUFF\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"144330\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"HELPSTN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"144930\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"NENGLNN\"}}},{\"scheduled_arrival_time\":\"145230\",\"scheduled_departure_time\":\"161830\",\"scheduled_pass_time\":\"      \",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"PBROVGB\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"162100\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"PBROEFL\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"162330\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"PBRO\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"162500\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"PBROE\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"163200\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"WHTLSEA\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"164130\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MRCH\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"165730\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"ELYYNJN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"170030\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"ELYY\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"170130\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"ELYYDLN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"171030\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"SOHAM\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"171830\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"CHPNJN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"172200\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"KENNETT\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"173330\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"BSTEDMS\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"175000\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"HAGHLYJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"175200\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"STWMRKT\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"180300\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"IPSWESJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"180430\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"IPSWICH\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"180600\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"IPSWHJN\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"181800\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MANNTNJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"181900\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MANNTEJ\"}}},{\"scheduled_arrival_time\":\"      \",\"scheduled_departure_time\":\"      \",\"scheduled_pass_time\":\"182200\",\"public_arrival_time\":\"      \",\"public_departure_time\":\"      \",\"CIF_platform\":\"\",\"CIF_line\":\"\",\"CIF_path\":\"\",\"CIF_activity\":\"\",\"CIF_engineering_allowance\":\"\",\"CIF_pathing_allowance\":\"\",\"CIF_performance_allowance\":\"\",\"location\":{\"tiploc\":{\"tiploc_id\":\"MISTLEY\"}}},{\"scheduled_arrival_time\":\"183800\",\"scheduled_departure_time\":\" \",\"scheduled_pass_time\":\" \",\"public_arrival_time\":\"00\",\"public_departure_time\":\" \",\"CIF_platform\":\"\",\"CIF_line\":\" \",\"CIF_path\":\"\",\"CIF_activity\":\"TF\",\"CIF_engineering_allowance\":\" \",\"CIF_pathing_allowance\":\" \",\"CIF_performance_allowance\":\" \",\"location\":{\"tiploc\":{\"tiploc_id\":\"PRKSGBR\"}}}]}]}}}";
            ScheduleTrain train = null;

            var tiplocs = new TiplocRepository().GetTiplocs().ToList();

            var data = JsonConvert.DeserializeObject<dynamic>(msg);
            try
            {
                train = VSTPMapper.ParseJsonVSTP(data, tiplocs);
            }
            catch (TiplocNotFoundException tnfe)
            {
                Trace.TraceError("Could not add VSTP: {0}", tnfe);
            }
            catch (Exception e)
            {
                Trace.TraceError("Could not add VSTP: {0}", e);
            }
            Trace.TraceInformation(train.Headcode);
        }
Exemplo n.º 5
0
        static void Main(string[] args)
        {
            TraceHelper.SetupTrace();
            AppDomain.CurrentDomain.UnhandledException += (s, e) =>
            {
                Trace.TraceError("Unhandled Exception: {0}", e.ExceptionObject);
                TraceHelper.FlushLog();
                Environment.Exit(1);
            };

            var options = new Options();
            CommandLine.CommandLineParser.Default.ParseArguments(args, options);
            bool delete = true;
            var tiprep = new TiplocRepository();
            var tiplocs = tiprep.GetTiplocs().ToList();
            var schedrep = new ScheduleRepository();
            var aRep = new AssociationRepository();

            string tempDir = Path.GetTempPath();
            Trace.TraceInformation("Temporary Directory is {0}", tempDir);
            string gzFile = Path.Combine(tempDir, string.Format("{0:yyyyMMdd}.gz", DateTime.UtcNow));
            string jsonFile = Path.Combine(tempDir, string.Format("{0:yyyyMMdd}.json", DateTime.UtcNow));
            Trace.TraceInformation("GZIP File is {0}", gzFile);
            Trace.TraceInformation("JSON File is {0}", jsonFile);
            bool fail = false;
            try
            {
                if (options.ForceDownload || !File.Exists(gzFile))
                {
                    ScheduleService.DownloadSchedule(gzFile,
                        // defaults to all
                        options.Toc,
                        // defaults to daily
                        options.ScheduleType,
                        // defaults to previous day (e.g. on monday download sunday - http://nrodwiki.rockshore.net/index.php/Schedule)
                        options.Day.HasValue ? options.Day.Value : DateTime.Today.AddDays(-1).DayOfWeek);
                }
                else
                {
                    Trace.TraceInformation("File {0} already exists", gzFile);
                }
                if (options.ForceDownload || !File.Exists(jsonFile))
                {
                    using (FileStream originalFileStream = File.OpenRead(gzFile))
                    {
                        using (FileStream decompressedFileStream = File.Create(jsonFile))
                        {
                            using (GZipStream decompressionStream = new GZipStream(originalFileStream, CompressionMode.Decompress))
                            {
                                Console.WriteLine("Decompressing {0} to {1}", gzFile, jsonFile);
                                decompressionStream.CopyTo(decompressedFileStream);
                                Console.WriteLine("Decompressed: {0}", jsonFile);
                            }
                        }
                    }
                }
                else
                {
                    Trace.TraceInformation("File {0} already exists", jsonFile);
                }
                if (File.Exists(jsonFile))
                {
                    foreach (string row in File.ReadLines(jsonFile))
                    {
                        var rowData = JsonConvert.DeserializeObject<dynamic>(row);
                        try
                        {
                            if (rowData.JsonTimetableV1 != null
                                && options.ScheduleType == ScheduleType.DailyUpdate
                                && !options.Day.HasValue)
                            {
                                if (!options.IgnoreWrongDate)
                                {
                                    // defaults to previous day (e.g. on monday download sunday - http://nrodwiki.rockshore.net/index.php/Schedule)
                                    DateTime dateCheck = DateTime.Today;
                                    DateTime unixTs = new DateTime(1970, 1, 1);
                                    DateTime date = unixTs.AddSeconds((double)rowData.JsonTimetableV1.timestamp);
                                    if (date.Date != dateCheck)
                                    {
                                        fail = true;
                                        throw new Exception(string.Format("Time stamp in file is for {0:dd/MM/yyyy} but requested {1:dd/MM/yyyy}",
                                            date, dateCheck));
                                    }
                                }
                            }
                            else if (rowData.JsonScheduleV1 != null)
                            {
                                AddSchedule(tiprep, tiplocs, schedrep, rowData);
                            }
                            else if (rowData.JsonAssociationV1 != null)
                            {
                                AddAssociation(rowData, tiplocs, tiprep, aRep);
                            }
                        }
                        catch (Exception e)
                        {
                            Trace.TraceError(e.ToString());
                            fail = true;
                            delete = false;
                            throw;
                        }
                    }
                }
            }
            catch (Exception)
            {
                fail = true;
            }
            finally
            {
                if (options.Delete && delete)
                {
                    File.Delete(gzFile);
                    File.Delete(jsonFile);
                }
                TraceHelper.FlushLog();
            }
            if (fail)
            {
                Environment.Exit(1);
            }
        }
Exemplo n.º 6
0
        static void Main(string[] args)
        {
            // this data is fetchable via http://nrodwiki.rockshore.net/index.php/ReferenceData
            List<TDElement> allSmartData = new List<TDElement>();

            foreach (string smartExtract in Directory.GetFiles(".", "SMARTExtract*.json"))
            {
                Trace.TraceInformation("Loading SMART data from {0}", smartExtract);
                string smartData = File.ReadAllText(smartExtract);
                allSmartData.AddRange(JsonConvert.DeserializeObject<TDContainer>(smartData).BERTHDATA);
            }

            TDContainer container = new TDContainer
            {
                BERTHDATA = allSmartData
            };
            ILookup<string, TDElement> tdElementsByArea = allSmartData
                .Where(td => !string.IsNullOrEmpty(td.STANOX))
                .ToLookup(td => td.TD);

            if (args.Length > 0 && args[0].Equals("extract", System.StringComparison.InvariantCultureIgnoreCase))
            {
                System.Console.WriteLine("Writing to SMARTExtract.txt");
                File.WriteAllText("SMARTExtract.txt",
                    string.Join(Environment.NewLine, container.BERTHDATA.Select(b => b.ToString())));
                return;
            }

            TiplocRepository _tiplocRepo = new TiplocRepository();

            var dbTiplocs = _tiplocRepo.Get();

            string tiplocData = File.ReadAllText("CORPUSExtract.json");
            ILookup<string, TiplocCode> tiplocByStanox = JsonConvert.DeserializeObject<TiplocContainer>(tiplocData).TIPLOCDATA
                .Select(t => t.ToTiplocCode())
                .ToLookup(t => t.Stanox);

            System.Console.WriteLine("Loaded {0} TD Elements", container.BERTHDATA.Count());

            System.Console.WriteLine("Enter Query");
            string data;
            while (!string.IsNullOrEmpty((data = System.Console.ReadLine())))
            {
                if (data.StartsWith("query=", StringComparison.InvariantCultureIgnoreCase))
                {
                    GenerateQuery(data, tdElementsByArea, tiplocByStanox);
                    continue;
                }
                var clauses = data.Split(',');
                if (!clauses.Any())
                    break;

                var results = container.BERTHDATA
                    .Where(t => t.TD.Equals(clauses[0], System.StringComparison.InvariantCultureIgnoreCase));

                if (clauses.Length > 1)
                {
                    results = results.Where(t => t.FROMBERTH.Equals(clauses[1], System.StringComparison.InvariantCultureIgnoreCase));
                }

                results = results
                    .OrderBy(t => t.STANME)
                    .ThenBy(t => string.IsNullOrEmpty(t.PLATFORM) ? -1 : int.Parse(t.PLATFORM))
                    .ThenBy(t => t.EventType);

                System.Console.WriteLine(string.Join("", Enumerable.Repeat("=", 72).ToArray()));

                System.Console.WriteLine("TD".PadRight(4) +
                    "F-B".PadRight(6) +
                    "T-B".PadRight(6) +
                    "F-L".PadRight(4) +
                    "T-L".PadRight(4) +
                    "STANME".PadRight(10) +
                    "P".PadRight(4) +
                    "EVENT-TYPE".PadRight(12) +
                    "STEP-TYPE".ToString().PadRight(10) +
                    "OFFSET".ToString().PadRight(6));
                System.Console.WriteLine(string.Join("", Enumerable.Repeat("=", 72).ToArray()));

                foreach (var result in results)
                {
                    System.Console.WriteLine(result);
                }
                System.Console.WriteLine(string.Join("", Enumerable.Repeat("=", 72).ToArray()));

            }
        }