private void setDBLocationToolStripMenuItem_Click(object sender, EventArgs e)
{
ChooseDbLocation form = new ChooseDbLocation();
form.ShowDialog();
ReloadIncidents();
}
private void setDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
{
ChooseDbLocation frm = new ChooseDbLocation();
frm.ShowDialog();
this.refreshDataSet();
}
public Database()
{
while (!DatabaseExists())
{
//MessageBox.Show("Test");
ChooseDbLocation frm = new ChooseDbLocation();
System.Windows.Forms.DialogResult result = frm.ShowDialog();
Program.LoadDbLocation();
if (result == System.Windows.Forms.DialogResult.Cancel && !DatabaseExists())
{
Program.ExitApp();
}
}
try
{
connectionString = @"Data Source=" + Program.DbLocation + ";Version=3;";
this.db = new SQLiteConnection(Database.connectionString, true);
dbVersion = GetDatabaseVersion();
//System.Windows.Forms.MessageBox.Show(Program.updater.CheckHigherVersion(dbVersion).ToString());
if (Program.dbUpdater.CheckHigherVersion(dbVersion))
{
System.Windows.Forms.MessageBox.Show("Newer database version found. Update will now run.");
Program.dbUpdater.UpdateDatabase(this, dbVersion);
}
}
catch (SQLiteException e)
{
System.Windows.Forms.MessageBox.Show("Could not open database: " + e.ToString());
Program.ExitApp();
}
}
