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