//-- DATABASE METHODS
public static void Load(bool defaultOnly)
{
// Reset color schemes
ColorSchemes = new List <ColorSchemeObj> ();
// Get color schemes
if (Database.Connect() && Settings.Selected.Visualization != null && Settings.Selected.Visualization.ID > 0 &&
Application.CanStreamedLevelBeLoaded(Settings.Selected.Visualization.BuildNumber))
{
// Database command
SqliteCommand cmd = new SqliteCommand(Database.Connection);
// Query statement
string sql = "SELECT id,name,viz_id,colors FROM color_scheme WHERE viz_id = @Viz_ID " +
(defaultOnly ? "AND name = @Name " : "") +
"ORDER BY name ASC";
cmd.CommandText = sql;
// Add Parameters to statement
cmd.Parameters.Add(new SqliteParameter("Viz_ID", Settings.Selected.Visualization.ID));
if (defaultOnly)
{
cmd.Parameters.Add(new SqliteParameter("Name", Settings.Selected.Visualization.Name));
}
// Get sql results
SqliteDataReader reader = cmd.ExecuteReader();
// Read sql results
while (reader.Read())
{
// Create color scheme object
ColorSchemeObj obj = new ColorSchemeObj(reader.GetString(1));
// Set values
obj.ID = reader.GetInt64(0);
obj.Visualization = Visualization.GetVisualization(reader.GetInt64(2), false);
obj.Colors = GetColors(reader.GetString(3));
// Add color scheme to colorSchemes array
ColorSchemes.Add(obj);
}
// Close reader
reader.Close();
cmd.Dispose();
// Close database connection
Database.Close();
}
}