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