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