private void MainWindow_Closed(object sender, EventArgs e)
{
if (myDatabase != null)
{
myDatabase.DisconnectDatabase();
}
}
private void BtInit_Click(object sender, EventArgs e)
{
MTEDatabaseSetup mydatabase = new MTEDatabaseSetup(this.workspace, this.databasename);
mydatabase.CreateDatabase();
mydatabase.ConnectDatabase();
mydatabase.CreateTable("Jagwar_FCT", StationCategory.FCT);
mydatabase.CreateTable("Jagwar_SFG", StationCategory.SFG);
mydatabase.CreateTable("Jagwar_FG00", StationCategory.FG00);
string rootFolder = @"C:\Works\Jagwar\PMTA\Pega example\Line#30\FG00\T170\Raw Data\LINE30_T170_20190815\Pega_FG00_T170\log";
string[] files = Directory.GetFiles(rootFolder, "*.txt", SearchOption.AllDirectories);
int newRecords = 0;
foreach (string onefile in files)
{
if (mydatabase.ParseLogIntoDB("Jagwar_FG00", StationCategory.FG00, onefile))
{
newRecords++;
}
}
mydatabase.DisconnectDatabase();
lStatus.Text = $"{newRecords} rows are inserted.";
}
private void MainForm_FormClosed(object sender, FormClosedEventArgs e)
{
DB_Jagwar.DisconnectDatabase();
DB_JagwarPlus.DisconnectDatabase();
}
