/// <summary> /// Inserts the default color scheme of each available visualization into the database. /// </summary> public static void InsertDefaultCS() { if (GetConnection() != null && Settings.Visualizations != null && Settings.Visualizations.Length > 0) { foreach (VisualizationObj viz in Settings.Visualizations) { if (!ColorScheme.Exists(new ColorSchemeObj(viz.Name, viz))) { // Insert default color scheme. string sql = "INSERT INTO color_scheme (name, viz_id, colors) VALUES (@Name, @Viz_ID, @Colors)"; SqliteCommand cmd = new SqliteCommand(sql, Connection); // Add Parameters to statement cmd.Parameters.Add(new SqliteParameter("Name", viz.Name)); cmd.Parameters.Add(new SqliteParameter("Viz_ID", viz.ID)); if (Settings.Defaults.Colors.ContainsKey(viz.Name)) { // Set colors Color[] colors = Settings.Defaults.Colors [viz.Name]; cmd.Parameters.Add(new SqliteParameter("Colors", ColorScheme.FormatColors(colors))); // Execute insert statement cmd.ExecuteNonQuery(); // Dispose command cmd.Dispose(); } } } } }