public static RankingList Get() { RankingList res = new RankingList(); SqlCommand cmd = null; SqlDataReader dr = null; string query = "SELECT * FROM Ranking"; try { cmd = Methods.CreateBasicCommand(query); dr = Methods.ExecuteDataReaderCommand(cmd); while (dr.Read()) { int idRanking = dr.GetInt32(0); Ranking ranking = RankingDal.Get(idRanking); res.Add(new Ranking() { RankingId = ranking.RankingId, Puntuacion = ranking.Puntuacion, }); } } catch (SqlException ex) { //Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace); throw ex; } catch (Exception ex) { //Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace); throw ex; } finally { cmd.Connection.Close(); } return(res); }
public void Initialize() { RankingInstance = new NicoNicoRanking(Period, Target); RankingList.Clear(); if (Settings.Instance.RankingCategoryTotal) { RankingList.Add(new RankingResultViewModel(this, "カテゴリ合算", "all", RankingInstance)); } if (Settings.Instance.RankingEntameMusic) { RankingList.Add(new RankingResultViewModel(this, "エンタメ・音楽", "g_ent2", RankingInstance)); } if (Settings.Instance.RankingEntertainment) { RankingList.Add(new RankingResultViewModel(this, "エンターテイメント", "ent", RankingInstance)); } if (Settings.Instance.RankingMusic) { RankingList.Add(new RankingResultViewModel(this, "音楽", "music", RankingInstance)); } if (Settings.Instance.RankingSingaSong) { RankingList.Add(new RankingResultViewModel(this, "歌ってみた", "sing", RankingInstance)); } if (Settings.Instance.RankingPlayaMusic) { RankingList.Add(new RankingResultViewModel(this, "演奏してみた", "play", RankingInstance)); } if (Settings.Instance.RankingDancing) { RankingList.Add(new RankingResultViewModel(this, "踊ってみた", "dance", RankingInstance)); } if (Settings.Instance.RankingVOCALOID) { RankingList.Add(new RankingResultViewModel(this, "VOCALOID", "vocaloid", RankingInstance)); } if (Settings.Instance.RankingIndies) { RankingList.Add(new RankingResultViewModel(this, "ニコニコインディーズ", "nicoindies", RankingInstance)); } if (Settings.Instance.RankingLifeSports) { RankingList.Add(new RankingResultViewModel(this, "生活・一般・スポ", "g_life2", RankingInstance)); } if (Settings.Instance.RankingAnimal) { RankingList.Add(new RankingResultViewModel(this, "動物", "animal", RankingInstance)); } if (Settings.Instance.RankingCooking) { RankingList.Add(new RankingResultViewModel(this, "料理", "cooking", RankingInstance)); } if (Settings.Instance.RankingNature) { RankingList.Add(new RankingResultViewModel(this, "自然", "nature", RankingInstance)); } if (Settings.Instance.RankingTravel) { RankingList.Add(new RankingResultViewModel(this, "旅行", "travel", RankingInstance)); } if (Settings.Instance.RankingSports) { RankingList.Add(new RankingResultViewModel(this, "スポーツ", "sport", RankingInstance)); } if (Settings.Instance.RankingNicoNicoDougaLecture) { RankingList.Add(new RankingResultViewModel(this, "ニコニコ動画講座", "lecture", RankingInstance)); } if (Settings.Instance.RankingDriveVideo) { RankingList.Add(new RankingResultViewModel(this, "車載動画", "drive", RankingInstance)); } if (Settings.Instance.RankingHistory) { RankingList.Add(new RankingResultViewModel(this, "歴史", "history", RankingInstance)); } if (Settings.Instance.RankingPolitics) { RankingList.Add(new RankingResultViewModel(this, "政治", "g_politics", RankingInstance)); } if (Settings.Instance.RankingScienceTech) { RankingList.Add(new RankingResultViewModel(this, "科学・技術", "g_tech", RankingInstance)); } if (Settings.Instance.RankingScience) { RankingList.Add(new RankingResultViewModel(this, "科学", "science", RankingInstance)); } if (Settings.Instance.RankingNicoNicoTech) { RankingList.Add(new RankingResultViewModel(this, "ニコニコ技術部", "tech", RankingInstance)); } if (Settings.Instance.RankingHandicraft) { RankingList.Add(new RankingResultViewModel(this, "ニコニコ手芸部", "handcraft", RankingInstance)); } if (Settings.Instance.RankingMaking) { RankingList.Add(new RankingResultViewModel(this, "作ってみた", "make", RankingInstance)); } if (Settings.Instance.RankingAnimeGameIllust) { RankingList.Add(new RankingResultViewModel(this, "アニメ・ゲーム・絵", "g_culture2", RankingInstance)); } if (Settings.Instance.RankingAnime) { RankingList.Add(new RankingResultViewModel(this, "アニメ", "anime", RankingInstance)); } if (Settings.Instance.RankingGame) { RankingList.Add(new RankingResultViewModel(this, "ゲーム", "game", RankingInstance)); } if (Settings.Instance.RankingJikkyo) { RankingList.Add(new RankingResultViewModel(this, "実況プレイ動画", "jikkyo", RankingInstance)); } if (Settings.Instance.RankingTouhou) { RankingList.Add(new RankingResultViewModel(this, "東方", "toho", RankingInstance)); } if (Settings.Instance.RankingIdolmaster) { RankingList.Add(new RankingResultViewModel(this, "アイドルマスター", "imas", RankingInstance)); } if (Settings.Instance.RankingRadio) { RankingList.Add(new RankingResultViewModel(this, "ラジオ", "radio", RankingInstance)); } if (Settings.Instance.RankingDrawing) { RankingList.Add(new RankingResultViewModel(this, "描いてみた", "draw", RankingInstance)); } if (Settings.Instance.RankingOtherTotal) { RankingList.Add(new RankingResultViewModel(this, "その他合算", "g_other", RankingInstance)); } if (Settings.Instance.RankingReinoAre) { RankingList.Add(new RankingResultViewModel(this, "例のアレ", "are", RankingInstance)); } if (Settings.Instance.RankingDiary) { RankingList.Add(new RankingResultViewModel(this, "日記", "diary", RankingInstance)); } if (Settings.Instance.RankingOther) { RankingList.Add(new RankingResultViewModel(this, "その他", "other", RankingInstance)); } SelectedIndex = 0; }