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