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