public DisplayPreferences RetrieveDisplayPreferences(DisplayPreferences dp)
{
var cmd = connection.CreateCommand();
cmd.CommandText = "select view_type, show_labels, vertical_scroll, sort_order, index_by, use_banner, thumb_constraint_width, thumb_constraint_height, use_coverflow, use_backdrop from display_prefs where guid = @guid";
cmd.AddParam("@guid", dp.Id);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
try
{
dp.ViewType.Chosen = ViewTypeNames.GetName((ViewType)Enum.Parse(typeof(ViewType), reader.GetString(0)));
}
catch
{
dp.ViewType.Chosen = ViewTypeNames.GetName(MediaBrowser.Library.ViewType.Poster);
}
dp.ShowLabels.Value = reader.GetBoolean(1);
dp.VerticalScroll.Value = reader.GetBoolean(2);
try
{
dp.SortOrder = reader.GetString(3);
}
catch { }
if (Config.Instance.RememberIndexing)
{
dp.IndexBy = reader.GetString(4);
}
else
{
dp.IndexBy = "None";
}
dp.UseBanner.Value = reader.GetBoolean(5);
dp.ThumbConstraint.Value = new Microsoft.MediaCenter.UI.Size(reader.GetInt32(6), reader.GetInt32(7));
dp.UseCoverflow.Value = reader.GetBoolean(8);
dp.UseBackdrop.Value = reader.GetBoolean(9);
}
}
return(dp);
}
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);
}
}
public DisplayPreferences RetrieveDisplayPreferences(DisplayPreferences dp)
{
var cmd = connection.CreateCommand();
cmd.CommandText = "select view_type, show_labels, vertical_scroll, sort_order, index_by, use_banner, thumb_constraint_width, thumb_constraint_height, use_coverflow, use_backdrop from display_prefs where guid = @guid";
cmd.AddParam("@guid", dp.Id);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
dp.StopListeningForChanges(); //turn this off or we'll trigger the save routine before everything is filled in
try
{
dp.ViewType.Chosen = ViewTypeNames.GetName((ViewType)Enum.Parse(typeof(ViewType), reader.GetString(0)));
}
catch
{
dp.ViewType.Chosen = ViewTypeNames.GetName(MediaBrowser.Library.ViewType.Poster);
}
dp.ShowLabels.Value = reader.GetBoolean(1);
dp.VerticalScroll.Value = reader.GetBoolean(2);
try
{
dp.SortOrder = reader.GetString(3);
}
catch { }
if (Config.Instance.RememberIndexing)
{
dp.IndexBy = reader.GetString(4);
}
else
{
dp.IndexBy = Localization.LocalizedStrings.Instance.GetString("NoneDispPref");
}
dp.UseBanner.Value = reader.GetBoolean(5);
dp.ThumbConstraint.Value = new Microsoft.MediaCenter.UI.Size(reader.GetInt32(6), reader.GetInt32(7));
dp.UseCoverflow.Value = reader.GetBoolean(8);
dp.UseBackdrop.Value = reader.GetBoolean(9);
dp.ListenForChanges(); //turn back on
}
}
cmd = connection.CreateCommand();
cmd.CommandText = "select parm_key, parm_value from custom_display_prefs where guid = @guid";
cmd.AddParam("@guid", dp.Id);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
try
{
dp.CustomParms[reader.GetString(0)] = reader.GetString(1);
}
catch (Exception e)
{
Logger.ReportException("Error reading custom display prefs.", e);
}
}
}
return(dp);
}
