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