public static byte[] CreateTDGProvisionWorkbook() { SetupBasicLogging(); //don't need act rn var actFraXml = LegApiClient.GetActFromJustice("fra"); var tdgFraActs = XML.XMLFunctions.ParseRegs(actFraXml, "Body", "441564"); var actXml = LegApiClient.GetActFromJustice(); var regXml = LegApiClient.GetRegulationFromJustice(); //XML to "Regulation" class //act = XMLFunctions.ParseRegs(actXml, "Body", "452135"); tdgr = XMLFunctions.ParseRegs(regXml, "Body", "1227365"); schedule1 = XMLFunctions.ParseRegs(regXml, "Schedule", "1230876"); schedule2 = XMLFunctions.ParseRegs(regXml, "Schedule", "1230890"); schedule3 = XMLFunctions.ParseRegs(regXml, "Schedule", "1231645"); //flag data we're interested in //TODO: can be added in the parsing to avoid an extra sweep act.PopulateDataFlags(); tdgr.PopulateDataFlags(); schedule1.PopulateDataFlags(); schedule2.PopulateDataFlags(); schedule3.PopulateDataFlags(); //output List of Regulations to JSON XMLFunctions.SerializeRegulationsToFile(act, actFileName); XMLFunctions.SerializeRegulationsToFile(tdgr, regFileName); XMLFunctions.SerializeRegulationsToFile(schedule1, schedule1FileName); XMLFunctions.SerializeRegulationsToFile(schedule2, schedule2FileName); XMLFunctions.SerializeRegulationsToFile(schedule3, schedule3FileName); return(CreateExcelWorkbook()); }
private static void ProcessTDGRegulations() { //ETLLogic.DeleteLegislation(); //DIGITAL OVERSIGHT LEG AND REG API => // var regXml = LegApiClient.GetRegulation("672172E"); //DOWNLOAD XML DIRECTLY FROM JUSTICE //using below because faster var regXml = LegApiClient.GetRegulationFromJustice(); var tdgRegs = XML.XMLFunctions.ParseRegs(regXml, "Body", "1227365"); tdgRegs.PopulateDataFlags(); //var dtSchedule2 = XML.XMLFunctions.ParseRegs(regXml, "Schedule", "1230890"); ETLLogic.ETLLegislationData(tdgRegs); //ETLLogic.ETLLegislationData(dtSchedule2); //string legislationFetchXml = GetLegislationFetchXml(); ETLLogic.FetchLegislationData(); //ETLLogic.DeleteLegislation(); // ACT FROM LEGS AND REGS //var act = LegApiClient.GetActSerialized("T-19.01", "eng"); //var max = act.Regs.Select((n, i) => (Reg: n.RegReg, Index: i)).Max(); //var actDetails = LegApiClient.GetRegulation("452135"); //var tdgAct = XML.XMLFunctions.ParseRegs(actDetails, "Body", "452135"); //ETLLogic.ETLLegislationData(tdgAct); // TDG REGULATIONS //var regXml = LegApiClient.GetRegulationFromJustice(); //var tdgRegs = XML.XMLFunctions.ParseRegs(regXml, "Body", "1227365"); //ETLLogic.ETLLegislationData(tdgRegs); var actXml = LegApiClient.GetActFromJustice("fra"); var tdgActs = XML.XMLFunctions.ParseRegs(actXml, "Body", "441564"); ETLLogic.ETLLegislationData(tdgActs); //schedule //var dtSchedule2 = XML.XMLFunctions.ParseRegs(regXml, "Schedule", "1230890"); //ETLLogic.ETLLegislationData(dtSchedule2); //string legislationFetchXml = GetLegislationFetchXml(); //ETLLogic.FetchLegislationData(legislationFetchXml); }
public void whenRequestingSerializedAct_fromlegsandregsAPI_and_RequestFormedCorrectly_thenReceiveValidData() { var act = LegApiClient.GetActSerialized("T-19.01", "eng"); Assert.NotNull(act); }
public void whenRequestingRegulationJson_fromlegsandregsAPI_and_RequestFormedCorrectly_thenReceiveValidData() { var reg = LegApiClient.GetRegulation("1227358e"); Assert.NotNull(reg); }