private static void ProcessQuestionnaireTemplate() { //ETLLogic.DeleteQuestionnaireData(); Questionnaire excelTemplateGeneralCompliance = ReadExcelTemplateGeneralCompliance(); ETLLogic.ETLQuestionnaireData(excelTemplateGeneralCompliance); }
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); }
[STAThread] // Added to support UX static void Main(string[] args) { Console.BackgroundColor = ConsoleColor.Black; Console.ForegroundColor = ConsoleColor.Black; Console.SetWindowPosition(0, 0); Console.SetWindowSize(250, 50); /////////////////////QUESTIONNAIRE EXCEL SHEETS //ProcessQuestionnaireTemplate(); /////////////////////LEGISLATION ProcessTDGRegulations(); //string generalComplianceFetchXml = GetGeneralComplianceFetchXml(); // ETLLogic.FetchQuestionnaireData(generalComplianceFetchXml); ETLLogic.FetchLegislationData(); Console.WriteLine("Done. Press something."); Console.ReadKey(); }