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();
}
