public void Insert(string formatName, string extension, string format)
{
try {
string addressFormatSql = "INSERT OR IGNORE INTO " + SavedFormat.TABLE_NAME + " (" +
SavedFormat._ID + ", " +
SavedFormat.FORMAT_DRIVE + ", " +
SavedFormat.FORMAT_NAME + ", " +
SavedFormat.FORMAT_EXTENSION + ", " +
SavedFormat.SOURCE_PRINTER_NAME + ", " +
SavedFormat.FORMAT_TEXT + ", " +
SavedFormat.TIMESTAMP + ") " +
"VALUES (" + formatId++ + ", 'E:', '" + formatName + "', '" + extension + "', 'Sample', '" + format + "', " + System.DateTime.Now.Ticks + ")";
if (dbConnection != null)
{
dbConnection.Open();
using (SQLiteCommand insertAddressFormatCommand = new SQLiteCommand(addressFormatSql, dbConnection)) {
insertAddressFormatCommand.ExecuteNonQuery();
}
}
else
{
PrinterErrorsWindow errorWindow = new PrinterErrorsWindow("The database could not be found.");
errorWindow.ShowDialog();
}
} finally {
CloseDataBase();
}
}
private void ShowErrorDialogWindow(string errorMessage)
{
Application.Current.Dispatcher.Invoke(new Action(() => {
PrinterErrorsWindow printerErrorsWindow = new PrinterErrorsWindow(errorMessage)
{
Owner = myMainWindow
};
printerErrorsWindow.ShowDialog();
}));
}
private static void InitializeDatabase()
{
try {
if (!Directory.Exists(DATABASE_PATH))
{
Directory.CreateDirectory(DATABASE_PATH);
}
if (!File.Exists(DATABASE_PATH + DATABASE_NAME))
{
SQLiteConnection.CreateFile(DATABASE_PATH + DATABASE_NAME);
}
} catch (Exception e) {
PrinterErrorsWindow errorWindow = new PrinterErrorsWindow($"Error creating database: {e.Message}.");
errorWindow.ShowDialog();
}
}
