private void OptAnvll()
{
try
{
using (var db = this.CreateCerebelloEntities())
{
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Saving to: {0}", new FileInfo("medicines.json").FullName);
// Downloading data from Anvisa official site.
var anvisaHelper = new AnvisaLeafletHelper();
var meds = anvisaHelper.DownloadAndCreateMedicinesJson();
Console.WriteLine("Total medicines: {0}", meds.Count);
Console.WriteLine("Saved to: {0}", new FileInfo("medicines.json").FullName);
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Done!");
Console.ForegroundColor = ConsoleColor.White;
}
}
catch (Exception ex)
{
ConsoleHelper.ConsoleWriteException(ex);
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Partially done!");
Console.ForegroundColor = ConsoleColor.White;
}
}
private void InitSysTables(CerebelloEntities db)
{
Console.WriteLine("Initialize_SYS_MedicalEntity");
Firestarter.Initialize_SYS_MedicalEntity(db);
Console.WriteLine("Initialize_SYS_MedicalSpecialty");
Firestarter.Initialize_SYS_MedicalSpecialty(db);
Console.WriteLine("Initialize_SYS_Contracts");
Firestarter.Initialize_SYS_Contracts(db);
Console.WriteLine("Initialize_SYS_Cid10");
Firestarter.Initialize_SYS_Cid10(
db,
progress: ConsoleHelper.ConsoleWriteProgressIntInt);
Console.WriteLine("Initialize_SYS_MedicalProcedures");
var cbhpmFilePath = Path.Combine(this.rootCerebelloPath, @"DB\cbhpm_2010.txt");
if (!File.Exists(cbhpmFilePath))
{
cbhpmFilePath = "cbhpm_2010.txt";
if (!File.Exists(cbhpmFilePath))
throw new Exception("Could not find file cbhpm_2010.txt");
}
Firestarter.Initialize_SYS_MedicalProcedures(
db,
cbhpmFilePath,
progress: ConsoleHelper.ConsoleWriteProgressIntInt);
Console.WriteLine("SaveLeafletsInMedicinesJsonToDb");
var anvisaHelper = new AnvisaLeafletHelper();
anvisaHelper.SaveLeafletsInMedicinesJsonToDb(
db,
progress: ConsoleHelper.ConsoleWriteProgressIntInt);
// Creating a minimal DB backup called __zero__.
if (this.isFuncBackupEnabled) Firestarter.CreateBackup(db, "__zero__");
}