private void btLoadBS_Click(object sender, EventArgs e)
{
OFD.FileName = "BaseStation.sqb";
OFD.Title = "Load BaseStation SQB file";
OFD.Filter = "SQB files|*.sqb|All files|*.*";
if (OFD.ShowDialog(this) == DialogResult.OK)
{
string file = OFD.FileName;
var ir = new BaseStationReader( );
if (!ir.Connect(file))
{
RTB.Text += $"ERROR Reading BaseStation SQB database file: {file} - cannot open database\n";
}
else
{
RTB.Text += $"Reading BaseStation SQB database file: {file}\n";
string changes = ir.ReadDb(ref IDB);;
changes += $"DONE \n";
changes += $"Database contains {IDB.Count} records \n";
RTB.Text += changes;
}
}
}
// Collect Aircraft data from various sources
// Write into web aircraft database
private static void DoAircraftJob()
{
if (!jobAircrafts)
{
return;
}
Console.WriteLine($"\nCreating aircraft database ..");
// read FA db
if (jobAircraftsFAin)
{
string folder = Path.Combine(inputDir, faDbDirName);
Console.WriteLine($"Reading FA Json database folder file: {folder}");
Console.WriteLine(icaoDbReader.ReadDb(ref IDB, folder));
Console.WriteLine($"DONE - ICAO ModeS Database contains {IDB.Count} records\n");
}
// read BaseStation.sqb
if (jobAircraftsBS)
{
string file = Path.Combine(inputDir, basestationFile);
var ir = new BaseStationReader( );
if (!ir.Connect(file))
{
Console.WriteLine($"ERROR Reading BaseStation SQB database file: {file} - cannot open database");
}
else
{
Console.WriteLine($"Reading BaseStation SQB database file: {file}");
Console.WriteLine(ir.ReadDb(ref IDB));
Console.WriteLine($"DONE - ICAO ModeS Database contains {IDB.Count} records\n");
}
}
// read OSky aircrafts
if (jobAircraftsCsv)
{
string file = Path.Combine(inputDir, icaoAcCsvFile);
Console.WriteLine($"Reading ICAO Aircraft OpenSky CSV file: {file}");
Console.WriteLine(icaoCsvOpenSkyReader.ReadDb(ref IDB, file));
Console.WriteLine($"DONE - ICAO ModeS Database Database contains {IDB.Count} records\n");
}
// read manual additions
if (jobAircraftsAddon)
{
string file = Path.Combine(inputDir, icaoAddFile);
Console.WriteLine($"Reading ICAO Aircraft Addon CSV file: {file}");
Console.WriteLine(icaoCsvAddonReader.ReadDb(ref IDB, file));
Console.WriteLine($"DONE - ICAO ModeS Database Database contains {IDB.Count} records\n");
}
// Create now
if (IDB.Count <= 0)
{
Console.WriteLine($"ERROR - No Aircraft records found, load populated BaseStation first\n");
return;
}
var iw = new AircraftsDB( );
Console.WriteLine(iw.CreateDB(Path.Combine(outputDir, aircraftsDBFile)));
Console.WriteLine(iw.LoadDBfromIcao(IDB));
Console.WriteLine($"SQDB ICAO ModeS file written (or not if previously was an error...)");
}
