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.";
}
protected override void OnStart(string[] args)
{
//Debugger.Launch();
// Update the service state to Start Pending.
ServiceStatus serviceStatus = new ServiceStatus();
Log($"JUUL MTE Database setup service starts, version: {System.Reflection.Assembly.GetExecutingAssembly().GetName().Version}.");
EventLogWriter("JUUL MTE Database setup service starts.", EventCategory.ServiceStart);
DB_Jagwar = new MTEDatabaseSetup(DatabaseRootFolder, JagwarDatabaseFile);
DB_JagwarPlus = new MTEDatabaseSetup(DatabaseRootFolder, JagwarPlusDatabaseFile);
DB_Jagwar.InitializeVariables();
DB_Jagwar.CreateDatabase();
DB_Jagwar.ConnectDatabase();
DB_Jagwar.CreateTable(DBTable_Jagwar_FCT, StationCategory.FCT);
//DB_Jagwar.CreateTable(DBTable_JagwarC_FCT, StationCategory.FCT);
DB_Jagwar.CreateTable(DBTable_Jagwar_SFG, StationCategory.SFG);
DB_Jagwar.CreateTable(DBTable_Jagwar_FG00, StationCategory.FG00);
DB_Jagwar.CreateTable(DBTable_Jagwar_FG24, StationCategory.FG24);
DB_Jagwar.CreateFCTSummaryTable(DBTable_Jagwar_FCT_Summary);
DB_Jagwar.CreateSFGSummaryTable(DBTable_Jagwar_SFG_Summary);
DB_JagwarPlus.InitializeVariables();
DB_JagwarPlus.CreateDatabase();
DB_JagwarPlus.ConnectDatabase();
DB_JagwarPlus.CreateTable(DBTable_JagwarPlus_FCT, StationCategory.FCT);
DB_JagwarPlus.CreateTable(DBTable_JagwarPlus_SFG, StationCategory.SFG);
DB_JagwarPlus.CreateTable(DBTable_JagwarPlus_FG00, StationCategory.FG00);
DB_JagwarPlus.CreateTable(DBTable_JagwarPlus_FG24, StationCategory.FG24);
DB_JagwarPlus.CreateFCTSummaryTable(DBTable_JagwarPlus_FCT_Summary);
DB_JagwarPlus.CreateSFGSummaryTable(DBTable_JagwarPlus_SFG_Summary);
timer.Start();
// Update the service state to Running.
serviceStatus.dwCurrentState = ServiceState.SERVICE_RUNNING;
SetServiceStatus(this.ServiceHandle, ref serviceStatus);
}
