public void SaveDisplayPreferences(DisplayPreferences dp)
{
var cmd = connection.CreateCommand();
cmd.CommandText = "replace into display_prefs (guid, view_type, show_labels, vertical_scroll, sort_order, index_by, use_banner, thumb_constraint_width, thumb_constraint_height, use_coverflow, use_backdrop) values (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11)";
cmd.AddParam("@1", dp.Id);
cmd.AddParam("@2", ViewTypeNames.GetEnum((string)dp.ViewType.Chosen).ToString());
cmd.AddParam("@3", dp.ShowLabels.Value);
cmd.AddParam("@4", dp.VerticalScroll.Value);
cmd.AddParam("@5", dp.SortOrder.ToString());
cmd.AddParam("@6", dp.IndexByString);
cmd.AddParam("@7", dp.UseBanner.Value);
cmd.AddParam("@8", dp.ThumbConstraint.Value.Width);
cmd.AddParam("@9", dp.ThumbConstraint.Value.Height);
cmd.AddParam("@10", dp.UseCoverflow.Value);
cmd.AddParam("@11", dp.UseBackdrop.Value);
QueueCommand(cmd);
}
public void SaveDisplayPreferences(DisplayPreferences dp)
{
var cmd = connection.CreateCommand();
cmd.CommandText = "replace into display_prefs (guid, view_type, show_labels, vertical_scroll, sort_order, index_by, use_banner, thumb_constraint_width, thumb_constraint_height, use_coverflow, use_backdrop) values (@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11)";
cmd.AddParam("@1", dp.Id);
cmd.AddParam("@2", ViewTypeNames.GetEnum((string)dp.ViewType.Chosen).ToString());
cmd.AddParam("@3", dp.ShowLabels.Value);
cmd.AddParam("@4", dp.VerticalScroll.Value);
cmd.AddParam("@5", dp.SortOrder.ToString());
cmd.AddParam("@6", dp.IndexByString);
cmd.AddParam("@7", dp.UseBanner.Value);
cmd.AddParam("@8", dp.ThumbConstraint.Value.Width);
cmd.AddParam("@9", dp.ThumbConstraint.Value.Height);
cmd.AddParam("@10", dp.UseCoverflow.Value);
cmd.AddParam("@11", dp.UseBackdrop.Value);
QueueCommand(cmd);
//custom prefs
//var delCmd = connection.CreateCommand();
//delCmd.CommandText = "delete from custom_display_prefs where guid = @guid";
//delCmd.AddParam("@guid", dp.Id);
//delCmd.ExecuteNonQuery();
var insCmd = connection.CreateCommand();
insCmd.CommandText = "insert or replace into custom_display_prefs(guid, parm_key, parm_value) values(@guid, @key, @value)";
insCmd.AddParam("@guid", dp.Id);
SQLiteParameter val = new SQLiteParameter("@value");
insCmd.Parameters.Add(val);
SQLiteParameter key = new SQLiteParameter("@key");
insCmd.Parameters.Add(key);
foreach (var pair in dp.CustomParms)
{
key.Value = pair.Key;
val.Value = pair.Value;
QueueCommand(insCmd);
}
}