public static bool UpdateWhiteListValue(Extension e) { try { var SqlConnection = new SQLiteConnection("Data Source=" + DBLocation + "; Version=3"); SqlConnection.Open(); var sql = "UPDATE WhiteList SET Active = " + Convert.ToInt32(e.IsChecked) + " WHERE ID = " + e.ID; SQLiteCommand cmd = new SQLiteCommand(sql, SqlConnection); cmd.ExecuteNonQuery(); } catch (Exception ex) { return false; } return true; }
public static bool TrimFilesTable(Extension toDelete) { var SqlConnection = new SQLiteConnection("Data Source=" + DBLocation + "; Version=3"); SqlConnection.Open(); var sql = "Delete FROM FilesFound WHERE ExtensionID LIKE '%" + toDelete.ID + "'"; var cmd = new SQLiteCommand(sql, SqlConnection); cmd.ExecuteNonQuery(); SqlConnection.Close(); return true; }