Esempio n. 1
0
        private Dictionary <int, LanguageStat> GetAudioLanguageStatsByAnimeResults(ISessionWrapper session, string animeIdPredicate)
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();

            using (IDbCommand command = session.Connection.CreateCommand())
            {
                command.CommandText = GetAudioLanguageStatsByAnimeSQL(animeIdPredicate);

                using (IDataReader rdr = command.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        int          animeID   = Convert.ToInt32(rdr[0]);
                        string       mainTitle = rdr[1].ToString().Trim();
                        string       lanName   = rdr[2].ToString().Trim();
                        LanguageStat stat      = null;

                        if (!dictStats.TryGetValue(animeID, out stat))
                        {
                            stat = new LanguageStat
                            {
                                AnimeID       = animeID,
                                MainTitle     = mainTitle,
                                LanguageNames = new List <string>()
                            };
                            dictStats.Add(animeID, stat);
                        }

                        stat.LanguageNames.Add(lanName);
                    }
                }
            }

            return(dictStats);
        }
Esempio n. 2
0
        private Dictionary <int, LanguageStat> GetAudioLanguageStatsByAnimeResults(ISession session, int aID)
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();

            System.Data.IDbCommand command = session.Connection.CreateCommand();
            command.CommandText = GetAudioLanguageStatsByAnimeSQL(aID);

            using (IDataReader rdr = command.ExecuteReader())
            {
                while (rdr.Read())
                {
                    int    animeID   = int.Parse(rdr[0].ToString());
                    string mainTitle = rdr[1].ToString().Trim();
                    string lanName   = rdr[2].ToString().Trim();

                    if (!dictStats.ContainsKey(animeID))
                    {
                        LanguageStat stat = new LanguageStat();
                        stat.AnimeID       = animeID;
                        stat.MainTitle     = mainTitle;
                        stat.LanguageNames = new List <string>();
                        stat.LanguageNames.Add(lanName);
                        dictStats[animeID] = stat;
                    }
                    else
                    {
                        dictStats[animeID].LanguageNames.Add(lanName);
                    }
                }
            }

            return(dictStats);
        }
Esempio n. 3
0
        private Dictionary <int, LanguageStat> GetAudioLanguageStatsByAnimeResults(ISessionWrapper session, string animeIdPredicate)
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();
            string query = GetAudioLanguageStatsByAnimeSQL(animeIdPredicate);

            var rows = session.CreateSQLQuery(query)
                       .AddScalar("AnimeID", NHibernateUtil.Int32)
                       .AddScalar("MainTitle", NHibernateUtil.String)
                       .AddScalar("LanguageName", NHibernateUtil.String)
                       .List <object[]>();

            foreach (object[] cols in rows)
            {
                int          animeID   = Convert.ToInt32(cols[0]);
                string       mainTitle = cols[1].ToString().Trim();
                string       lanName   = cols[2].ToString().Trim();
                LanguageStat stat      = null;

                if (!dictStats.TryGetValue(animeID, out stat))
                {
                    stat = new LanguageStat
                    {
                        AnimeID       = animeID,
                        MainTitle     = mainTitle,
                        LanguageNames = new List <string>()
                    };
                    dictStats.Add(animeID, stat);
                }

                stat.LanguageNames.Add(lanName);
            }

            return(dictStats);
        }
Esempio n. 4
0
        public Dictionary <int, LanguageStat> GetAudioLanguageStatsForAnime()
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();


            using (var session = JMMService.SessionFactory.OpenSession())
            {
                System.Data.IDbCommand command = session.Connection.CreateCommand();
                command.CommandText  = "SELECT anime.AnimeID, anime.MainTitle, lan.LanguageName ";
                command.CommandText += "FROM AnimeSeries ser  ";
                command.CommandText += "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID ";
                command.CommandText += "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID ";
                command.CommandText += "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID ";
                command.CommandText += "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID ";
                command.CommandText += "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash ";
                command.CommandText +=
                    "INNER JOIN CrossRef_Languages_AniDB_File audio on audio.FileID = anifile.FileID ";
                command.CommandText += "INNER JOIN Language lan on audio.LanguageID = lan.LanguageID ";
                command.CommandText += "GROUP BY anime.AnimeID, anime.MainTitle, lan.LanguageName ";

                using (IDataReader rdr = command.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        int    animeID   = int.Parse(rdr[0].ToString());
                        string mainTitle = rdr[1].ToString().Trim();
                        string lanName   = rdr[2].ToString().Trim();


                        if (animeID == 7656)
                        {
                            Debug.Print("");
                        }

                        if (!dictStats.ContainsKey(animeID))
                        {
                            LanguageStat stat = new LanguageStat();
                            stat.AnimeID       = animeID;
                            stat.MainTitle     = mainTitle;
                            stat.LanguageNames = new List <string>();
                            stat.LanguageNames.Add(lanName);
                            dictStats[animeID] = stat;
                        }
                        else
                        {
                            dictStats[animeID].LanguageNames.Add(lanName);
                        }
                    }
                }
            }

            return(dictStats);
        }
Esempio n. 5
0
        private Dictionary <int, LanguageStat> GetSubtitleLanguageStatsByAnimeResults(ISessionWrapper session, string animeIdPredicate)
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();

            using (IDbCommand command = session.Connection.CreateCommand())
            {
                string query = "SELECT anime.AnimeID, anime.MainTitle, lan.LanguageName "
                               + "FROM AnimeSeries ser  "
                               + "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID "
                               + "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID "
                               + "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID "
                               + "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID "
                               + "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash "
                               + "INNER JOIN CrossRef_Subtitles_AniDB_File subt on subt.FileID = anifile.FileID "
                               + "INNER JOIN Language lan on subt.LanguageID = lan.LanguageID "
                               + "WHERE anime.AnimeID " + animeIdPredicate
                               + " GROUP BY anime.AnimeID, anime.MainTitle, lan.LanguageName ";

                command.CommandText = query;

                using (IDataReader rdr = command.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        int          animeID   = Convert.ToInt32(rdr[0]);
                        string       mainTitle = rdr[1].ToString().Trim();
                        string       lanName   = rdr[2].ToString().Trim();
                        LanguageStat stat      = null;

                        if (!dictStats.TryGetValue(animeID, out stat))
                        {
                            stat = new LanguageStat
                            {
                                AnimeID       = animeID,
                                MainTitle     = mainTitle,
                                LanguageNames = new List <string>()
                            };
                            dictStats.Add(animeID, stat);
                        }

                        stat.LanguageNames.Add(lanName);
                    }
                }
            }

            return(dictStats);
        }
Esempio n. 6
0
        public Dictionary <int, LanguageStat> GetSubtitleLanguageStatsByAnimeResults(ISession session, int aID)
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();

            System.Data.IDbCommand command = session.Connection.CreateCommand();
            command.CommandText  = "SELECT anime.AnimeID, anime.MainTitle, lan.LanguageName ";
            command.CommandText += "FROM AnimeSeries ser  ";
            command.CommandText += "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID ";
            command.CommandText += "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID ";
            command.CommandText += "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID ";
            command.CommandText += "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID ";
            command.CommandText += "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash ";
            command.CommandText += "INNER JOIN CrossRef_Subtitles_AniDB_File subt on subt.FileID = anifile.FileID ";
            command.CommandText += "INNER JOIN Language lan on subt.LanguageID = lan.LanguageID ";
            command.CommandText += "WHERE anime.AnimeID = " + aID.ToString();
            command.CommandText += " GROUP BY anime.AnimeID, anime.MainTitle, lan.LanguageName ";

            using (IDataReader rdr = command.ExecuteReader())
            {
                while (rdr.Read())
                {
                    int    animeID   = int.Parse(rdr[0].ToString());
                    string mainTitle = rdr[1].ToString().Trim();
                    string lanName   = rdr[2].ToString().Trim();

                    if (!dictStats.ContainsKey(animeID))
                    {
                        LanguageStat stat = new LanguageStat();
                        stat.AnimeID       = animeID;
                        stat.MainTitle     = mainTitle;
                        stat.LanguageNames = new List <string>();
                        stat.LanguageNames.Add(lanName);
                        dictStats[animeID] = stat;
                    }
                    else
                    {
                        dictStats[animeID].LanguageNames.Add(lanName);
                    }
                }
            }

            return(dictStats);
        }
Esempio n. 7
0
        private Dictionary <int, LanguageStat> GetSubtitleLanguageStatsByAnimeResults(ISessionWrapper session, string animeIdPredicate)
        {
            Dictionary <int, LanguageStat> dictStats = new Dictionary <int, LanguageStat>();
            string query = "SELECT DISTINCT anime.AnimeID, anime.MainTitle, lan.LanguageName "
                           + "FROM AnimeSeries ser  "
                           + "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID "
                           + "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID "
                           + "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID "
                           + "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID "
                           + "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash "
                           + "INNER JOIN CrossRef_Subtitles_AniDB_File subt on subt.FileID = anifile.FileID "
                           + "INNER JOIN Language lan on subt.LanguageID = lan.LanguageID "
                           + "WHERE anime.AnimeID " + animeIdPredicate;

            var rows = session.CreateSQLQuery(query)
                       .AddScalar("AnimeID", NHibernateUtil.Int32)
                       .AddScalar("MainTitle", NHibernateUtil.String)
                       .AddScalar("LanguageName", NHibernateUtil.String)
                       .List <object[]>();

            foreach (object[] cols in rows)
            {
                int          animeID   = Convert.ToInt32(cols[0]);
                string       mainTitle = cols[1].ToString().Trim();
                string       lanName   = cols[2].ToString().Trim();
                LanguageStat stat      = null;

                if (!dictStats.TryGetValue(animeID, out stat))
                {
                    stat = new LanguageStat
                    {
                        AnimeID       = animeID,
                        MainTitle     = mainTitle,
                        LanguageNames = new List <string>()
                    };
                    dictStats.Add(animeID, stat);
                }

                stat.LanguageNames.Add(lanName);
            }

            return(dictStats);
        }
        private Dictionary<int, LanguageStat> GetSubtitleLanguageStatsByAnimeResults(ISessionWrapper session, string animeIdPredicate)
        {
            Dictionary<int, LanguageStat> dictStats = new Dictionary<int, LanguageStat>();
            string query = "SELECT DISTINCT anime.AnimeID, anime.MainTitle, lan.LanguageName "
                + "FROM AnimeSeries ser  "
                + "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID "
                + "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID "
                + "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID "
                + "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID "
                + "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash "
                + "INNER JOIN CrossRef_Subtitles_AniDB_File subt on subt.FileID = anifile.FileID "
                + "INNER JOIN Language lan on subt.LanguageID = lan.LanguageID "
                + "WHERE anime.AnimeID " + animeIdPredicate;

            var rows = session.CreateSQLQuery(query)
                .AddScalar("AnimeID", NHibernateUtil.Int32)
                .AddScalar("MainTitle", NHibernateUtil.String)
                .AddScalar("LanguageName", NHibernateUtil.String)
                .List<object[]>();

            foreach (object[] cols in rows)
            {
                int animeID = Convert.ToInt32(cols[0]);
                string mainTitle = cols[1].ToString().Trim();
                string lanName = cols[2].ToString().Trim();
                LanguageStat stat = null;

                if (!dictStats.TryGetValue(animeID, out stat))
                {
                    stat = new LanguageStat
                    {
                        AnimeID = animeID,
                        MainTitle = mainTitle,
                        LanguageNames = new List<string>()
                    };
                    dictStats.Add(animeID, stat);
                }

                stat.LanguageNames.Add(lanName);
            }

            return dictStats;
        }
        private Dictionary<int, LanguageStat> GetAudioLanguageStatsByAnimeResults(ISessionWrapper session, string animeIdPredicate)
        {
            Dictionary<int, LanguageStat> dictStats = new Dictionary<int, LanguageStat>();
            string query = GetAudioLanguageStatsByAnimeSQL(animeIdPredicate);

            var rows = session.CreateSQLQuery(query)
                .AddScalar("AnimeID", NHibernateUtil.Int32)
                .AddScalar("MainTitle", NHibernateUtil.String)
                .AddScalar("LanguageName", NHibernateUtil.String)
                .List<object[]>();

            foreach (object[] cols in rows)
            {
                int animeID = Convert.ToInt32(cols[0]);
                string mainTitle = cols[1].ToString().Trim();
                string lanName = cols[2].ToString().Trim();
                LanguageStat stat = null;

                if (!dictStats.TryGetValue(animeID, out stat))
                {
                    stat = new LanguageStat
                    {
                        AnimeID = animeID,
                        MainTitle = mainTitle,
                        LanguageNames = new List<string>()
                    };
                    dictStats.Add(animeID, stat);
                }

                stat.LanguageNames.Add(lanName);
            }

            return dictStats;
        }
Esempio n. 10
0
        public Dictionary<int, LanguageStat> GetAudioLanguageStatsForAnime()
        {
            Dictionary<int, LanguageStat> dictStats = new Dictionary<int, LanguageStat>();

            using (var session = DatabaseFactory.SessionFactory.OpenSession())
            {
                System.Data.IDbCommand command = session.Connection.CreateCommand();
                command.CommandText = "SELECT anime.AnimeID, anime.MainTitle, lan.LanguageName ";
                command.CommandText += "FROM AnimeSeries ser  ";
                command.CommandText += "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID ";
                command.CommandText += "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID ";
                command.CommandText += "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID ";
                command.CommandText += "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID ";
                command.CommandText += "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash ";
                command.CommandText +=
                    "INNER JOIN CrossRef_Languages_AniDB_File audio on audio.FileID = anifile.FileID ";
                command.CommandText += "INNER JOIN Language lan on audio.LanguageID = lan.LanguageID ";
                command.CommandText += "GROUP BY anime.AnimeID, anime.MainTitle, lan.LanguageName ";

                using (IDataReader rdr = command.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        int animeID = int.Parse(rdr[0].ToString());
                        string mainTitle = rdr[1].ToString().Trim();
                        string lanName = rdr[2].ToString().Trim();

                        if (animeID == 7656)
                        {
                            Debug.Print("");
                        }

                        if (!dictStats.ContainsKey(animeID))
                        {
                            LanguageStat stat = new LanguageStat();
                            stat.AnimeID = animeID;
                            stat.MainTitle = mainTitle;
                            stat.LanguageNames = new List<string>();
                            stat.LanguageNames.Add(lanName);
                            dictStats[animeID] = stat;
                        }
                        else
                            dictStats[animeID].LanguageNames.Add(lanName);
                    }
                }
            }

            return dictStats;
        }
Esempio n. 11
0
		public Dictionary<int, LanguageStat> GetSubtitleLanguageStatsByAnimeResults(ISession session, int aID)
		{
			Dictionary<int, LanguageStat> dictStats = new Dictionary<int, LanguageStat>();

			System.Data.IDbCommand command = session.Connection.CreateCommand();
			command.CommandText = "SELECT anime.AnimeID, anime.MainTitle, lan.LanguageName ";
			command.CommandText += "FROM AnimeSeries ser  ";
			command.CommandText += "INNER JOIN AniDB_Anime anime on anime.AnimeID = ser.AniDB_ID ";
			command.CommandText += "INNER JOIN AnimeEpisode ep on ep.AnimeSeriesID = ser.AnimeSeriesID ";
			command.CommandText += "INNER JOIN AniDB_Episode aniep on ep.AniDB_EpisodeID = aniep.EpisodeID ";
			command.CommandText += "INNER JOIN CrossRef_File_Episode xref on aniep.EpisodeID = xref.EpisodeID ";
			command.CommandText += "INNER JOIN AniDB_File anifile on anifile.Hash = xref.Hash ";
			command.CommandText += "INNER JOIN CrossRef_Subtitles_AniDB_File subt on subt.FileID = anifile.FileID ";
			command.CommandText += "INNER JOIN Language lan on subt.LanguageID = lan.LanguageID ";
			command.CommandText += "WHERE anime.AnimeID = " + aID.ToString();
			command.CommandText += " GROUP BY anime.AnimeID, anime.MainTitle, lan.LanguageName ";

			using (IDataReader rdr = command.ExecuteReader())
			{
				while (rdr.Read())
				{
					int animeID = int.Parse(rdr[0].ToString());
					string mainTitle = rdr[1].ToString().Trim();
					string lanName = rdr[2].ToString().Trim();

					if (!dictStats.ContainsKey(animeID))
					{
						LanguageStat stat = new LanguageStat();
						stat.AnimeID = animeID;
						stat.MainTitle = mainTitle;
						stat.LanguageNames = new List<string>();
						stat.LanguageNames.Add(lanName);
						dictStats[animeID] = stat;
					}
					else
						dictStats[animeID].LanguageNames.Add(lanName);

				}
			}

			return dictStats;
		}
Esempio n. 12
0
		private Dictionary<int, LanguageStat> GetAudioLanguageStatsByAnimeResults(ISession session, int aID)
		{
			Dictionary<int, LanguageStat> dictStats = new Dictionary<int, LanguageStat>();

			System.Data.IDbCommand command = session.Connection.CreateCommand();
			command.CommandText = GetAudioLanguageStatsByAnimeSQL(aID);

			using (IDataReader rdr = command.ExecuteReader())
			{
				while (rdr.Read())
				{
					int animeID = int.Parse(rdr[0].ToString());
					string mainTitle = rdr[1].ToString().Trim();
					string lanName = rdr[2].ToString().Trim();

					if (!dictStats.ContainsKey(animeID))
					{
						LanguageStat stat = new LanguageStat();
						stat.AnimeID = animeID;
						stat.MainTitle = mainTitle;
						stat.LanguageNames = new List<string>();
						stat.LanguageNames.Add(lanName);
						dictStats[animeID] = stat;
					}
					else
						dictStats[animeID].LanguageNames.Add(lanName);

				}
			}

			return dictStats;
		}