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