public List<Contract_AniDB_AnimeDetailed> GetAllAnimeDetailed()
{
List<Contract_AniDB_AnimeDetailed> contracts = new List<Contract_AniDB_AnimeDetailed>();
int countElements = 0;
try
{
DateTime start = DateTime.Now;
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
// build a dictionary of categories
AniDB_CategoryRepository repCats = new AniDB_CategoryRepository();
AniDB_Anime_CategoryRepository repAnimeCat = new AniDB_Anime_CategoryRepository();
List<AniDB_Category> allCatgeories = repCats.GetAll();
Dictionary<int, AniDB_Category> allCatgeoriesDict = new Dictionary<int, AniDB_Category>();
foreach (AniDB_Category cat in allCatgeories)
allCatgeoriesDict[cat.CategoryID] = cat;
List<AniDB_Anime_Category> allAnimeCatgeories = repAnimeCat.GetAll();
Dictionary<int, List<AniDB_Anime_Category>> allAnimeCatgeoriesDict = new Dictionary<int, List<AniDB_Anime_Category>>(); //
foreach (AniDB_Anime_Category aniCat in allAnimeCatgeories)
{
if (!allAnimeCatgeoriesDict.ContainsKey(aniCat.AnimeID))
allAnimeCatgeoriesDict[aniCat.AnimeID] = new List<AniDB_Anime_Category>();
allAnimeCatgeoriesDict[aniCat.AnimeID].Add(aniCat);
}
// build a dictionary of titles
AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository();
List<AniDB_Anime_Title> allTitles = repTitles.GetAll();
Dictionary<int, List<AniDB_Anime_Title>> allTitlesDict = new Dictionary<int, List<AniDB_Anime_Title>>();
foreach (AniDB_Anime_Title title in allTitles)
{
if (!allTitlesDict.ContainsKey(title.AnimeID))
allTitlesDict[title.AnimeID] = new List<AniDB_Anime_Title>();
allTitlesDict[title.AnimeID].Add(title);
}
// build a dictionary of tags
AniDB_TagRepository repTags = new AniDB_TagRepository();
AniDB_Anime_TagRepository repAnimeTag = new AniDB_Anime_TagRepository();
List<AniDB_Tag> allTags = repTags.GetAll();
Dictionary<int, AniDB_Tag> allTagsDict = new Dictionary<int, AniDB_Tag>();
foreach (AniDB_Tag tag in allTags)
allTagsDict[tag.TagID] = tag;
List<AniDB_Anime_Tag> allAnimeTags = repAnimeTag.GetAll();
Dictionary<int, List<AniDB_Anime_Tag>> allAnimeTagsDict = new Dictionary<int, List<AniDB_Anime_Tag>>(); //
foreach (AniDB_Anime_Tag aniTag in allAnimeTags)
{
if (!allAnimeTagsDict.ContainsKey(aniTag.AnimeID))
allAnimeTagsDict[aniTag.AnimeID] = new List<AniDB_Anime_Tag>();
allAnimeTagsDict[aniTag.AnimeID].Add(aniTag);
}
// build a dictionary of languages
AdhocRepository rep = new AdhocRepository();
Dictionary<int, LanguageStat> dictAudioStats = rep.GetAudioLanguageStatsForAnime();
Dictionary<int, LanguageStat> dictSubtitleStats = rep.GetSubtitleLanguageStatsForAnime();
Dictionary<int, string> dictAnimeVideoQualStats = rep.GetAllVideoQualityByAnime();
Dictionary<int, AnimeVideoQualityStat> dictAnimeEpisodeVideoQualStats = rep.GetEpisodeVideoQualityStatsByAnime();
List<AniDB_Anime> animes = repAnime.GetAll();
// user votes
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> allVotes = repVotes.GetAll();
int i = 0;
foreach (AniDB_Anime anime in animes)
{
i++;
//if (i >= 10) continue;
countElements++;
Contract_AniDB_AnimeDetailed contract = new Contract_AniDB_AnimeDetailed();
contract.AnimeTitles = new List<Contract_AnimeTitle>();
contract.Categories = new List<Contract_AnimeCategory>();
contract.Tags = new List<Contract_AnimeTag>();
contract.UserVote = null;
contract.AniDBAnime = anime.ToContract();
if (dictAnimeVideoQualStats.ContainsKey(anime.AnimeID))
contract.Stat_AllVideoQuality = dictAnimeVideoQualStats[anime.AnimeID];
else contract.Stat_AllVideoQuality = "";
contract.Stat_AllVideoQuality_Episodes = "";
// All Video Quality Episodes
// Try to determine if this anime has all the episodes available at a certain video quality
// e.g. the series has all episodes in blu-ray
if (dictAnimeEpisodeVideoQualStats.ContainsKey(anime.AnimeID))
{
AnimeVideoQualityStat stat = dictAnimeEpisodeVideoQualStats[anime.AnimeID];
foreach (KeyValuePair<string, int> kvp in stat.VideoQualityEpisodeCount)
{
if (kvp.Value >= anime.EpisodeCountNormal)
{
if (contract.Stat_AllVideoQuality_Episodes.Length > 0) contract.Stat_AllVideoQuality_Episodes += ",";
contract.Stat_AllVideoQuality_Episodes += kvp.Key;
}
}
}
List<string> audioLanguageList = new List<string>();
List<string> subtitleLanguageList = new List<string>();
// get audio languages
if (dictAudioStats.ContainsKey(anime.AnimeID))
{
foreach (string lanName in dictAudioStats[anime.AnimeID].LanguageNames)
{
if (!audioLanguageList.Contains(lanName)) audioLanguageList.Add(lanName);
}
}
// get subtitle languages
if (dictSubtitleStats.ContainsKey(anime.AnimeID))
{
foreach (string lanName in dictSubtitleStats[anime.AnimeID].LanguageNames)
{
if (!subtitleLanguageList.Contains(lanName)) subtitleLanguageList.Add(lanName);
}
}
contract.Stat_AudioLanguages = "";
foreach (string audioLan in audioLanguageList)
{
if (contract.Stat_AudioLanguages.Length > 0) contract.Stat_AudioLanguages += ",";
contract.Stat_AudioLanguages += audioLan;
}
contract.Stat_SubtitleLanguages = "";
foreach (string subLan in subtitleLanguageList)
{
if (contract.Stat_SubtitleLanguages.Length > 0) contract.Stat_SubtitleLanguages += ",";
contract.Stat_SubtitleLanguages += subLan;
}
if (allTitlesDict.ContainsKey(anime.AnimeID))
{
foreach (AniDB_Anime_Title title in allTitlesDict[anime.AnimeID])
{
Contract_AnimeTitle ctitle = new Contract_AnimeTitle();
ctitle.AnimeID = title.AnimeID;
ctitle.Language = title.Language;
ctitle.Title = title.Title;
ctitle.TitleType = title.TitleType;
contract.AnimeTitles.Add(ctitle);
countElements++;
}
}
if (allAnimeCatgeoriesDict.ContainsKey(anime.AnimeID))
{
List<AniDB_Anime_Category> aniCats = allAnimeCatgeoriesDict[anime.AnimeID];
foreach (AniDB_Anime_Category aniCat in aniCats)
{
if (allCatgeoriesDict.ContainsKey(aniCat.CategoryID))
{
AniDB_Category cat = allCatgeoriesDict[aniCat.CategoryID];
Contract_AnimeCategory ccat = new Contract_AnimeCategory();
ccat.CategoryDescription = cat.CategoryDescription;
ccat.CategoryID = cat.CategoryID;
ccat.CategoryName = cat.CategoryName;
ccat.IsHentai = cat.IsHentai;
ccat.ParentID = cat.ParentID;
ccat.Weighting = aniCat.Weighting;
contract.Categories.Add(ccat);
countElements++;
}
}
}
if (allAnimeTagsDict.ContainsKey(anime.AnimeID))
{
List<AniDB_Anime_Tag> aniTags = allAnimeTagsDict[anime.AnimeID];
foreach (AniDB_Anime_Tag aniTag in aniTags)
{
if (allTagsDict.ContainsKey(aniTag.TagID))
{
AniDB_Tag tag = allTagsDict[aniTag.TagID];
Contract_AnimeTag ctag = new Contract_AnimeTag();
ctag.Approval = aniTag.Approval;
ctag.GlobalSpoiler = tag.GlobalSpoiler;
ctag.LocalSpoiler = tag.LocalSpoiler;
ctag.Spoiler = tag.Spoiler;
ctag.TagCount = tag.TagCount;
ctag.TagDescription = tag.TagDescription;
ctag.TagID = tag.TagID;
ctag.TagName = tag.TagName;
contract.Tags.Add(ctag);
countElements++;
}
}
}
// get user vote
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
contract.UserVote = vote.ToContract();
break;
}
}
contracts.Add(contract);
}
TimeSpan ts = DateTime.Now - start;
logger.Info("GetAllAnimeDetailed in {0} ms {1}", ts.TotalMilliseconds, countElements);
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return contracts;
}
public Contract_AniDB_AnimeDetailed ToContractDetailed(ISession session)
{
//logger.Trace(" XXXX 01");
AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository();
AniDB_CategoryRepository repCats = new AniDB_CategoryRepository();
AniDB_TagRepository repTags = new AniDB_TagRepository();
Contract_AniDB_AnimeDetailed contract = new Contract_AniDB_AnimeDetailed();
contract.AnimeTitles = new List<Contract_AnimeTitle>();
contract.Categories = new List<Contract_AnimeCategory>();
contract.Tags = new List<Contract_AnimeTag>();
contract.AniDBAnime = this.ToContract(session);
//logger.Trace(" XXXX 02");
// get all the anime titles
List<AniDB_Anime_Title> animeTitles = repTitles.GetByAnimeID(session, AnimeID);
if (animeTitles != null)
{
foreach (AniDB_Anime_Title title in animeTitles)
{
Contract_AnimeTitle ctitle = new Contract_AnimeTitle();
ctitle.AnimeID = title.AnimeID;
ctitle.Language = title.Language;
ctitle.Title = title.Title;
ctitle.TitleType = title.TitleType;
contract.AnimeTitles.Add(ctitle);
}
}
//logger.Trace(" XXXX 03");
Dictionary<int, AniDB_Anime_Category> dictAnimeCats = new Dictionary<int, AniDB_Anime_Category>();
foreach (AniDB_Anime_Category animeCat in GetAnimeCategories(session))
dictAnimeCats[animeCat.CategoryID] = animeCat;
foreach (AniDB_Category cat in GetAniDBCategories(session))
{
Contract_AnimeCategory ccat = new Contract_AnimeCategory();
ccat.CategoryDescription = cat.CategoryDescription;
ccat.CategoryID = cat.CategoryID;
ccat.CategoryName = cat.CategoryName;
ccat.IsHentai = cat.IsHentai;
ccat.ParentID = cat.ParentID;
if (dictAnimeCats.ContainsKey(cat.CategoryID))
ccat.Weighting = dictAnimeCats[cat.CategoryID].Weighting;
else
ccat.Weighting = 0;
contract.Categories.Add(ccat);
}
//logger.Trace(" XXXX 04");
Dictionary<int, AniDB_Anime_Tag> dictAnimeTags = new Dictionary<int, AniDB_Anime_Tag>();
foreach (AniDB_Anime_Tag animeTag in GetAnimeTags(session))
dictAnimeTags[animeTag.TagID] = animeTag;
foreach (AniDB_Tag tag in GetAniDBTags(session))
{
Contract_AnimeTag ctag = new Contract_AnimeTag();
ctag.GlobalSpoiler = tag.GlobalSpoiler;
ctag.LocalSpoiler = tag.LocalSpoiler;
ctag.Spoiler = tag.Spoiler;
ctag.TagCount = tag.TagCount;
ctag.TagDescription = tag.TagDescription;
ctag.TagID = tag.TagID;
ctag.TagName = tag.TagName;
if (dictAnimeTags.ContainsKey(tag.TagID))
ctag.Approval = dictAnimeTags[tag.TagID].Approval;
else
ctag.Approval = 0;
contract.Tags.Add(ctag);
}
if (this.UserVote != null)
contract.UserVote = this.UserVote.ToContract();
AdhocRepository repAdHoc = new AdhocRepository();
List<string> audioLanguages = new List<string>();
List<string> subtitleLanguages = new List<string>();
//logger.Trace(" XXXX 06");
// audio languages
Dictionary<int, LanguageStat> dicAudio = repAdHoc.GetAudioLanguageStatsByAnime(session, this.AnimeID);
foreach (KeyValuePair<int, LanguageStat> kvp in dicAudio)
{
foreach (string lanName in kvp.Value.LanguageNames)
{
if (!audioLanguages.Contains(lanName))
audioLanguages.Add(lanName);
}
}
//logger.Trace(" XXXX 07");
// subtitle languages
Dictionary<int, LanguageStat> dicSubtitle = repAdHoc.GetSubtitleLanguageStatsByAnime(session, this.AnimeID);
foreach (KeyValuePair<int, LanguageStat> kvp in dicSubtitle)
{
foreach (string lanName in kvp.Value.LanguageNames)
{
if (!subtitleLanguages.Contains(lanName))
subtitleLanguages.Add(lanName);
}
}
//logger.Trace(" XXXX 08");
contract.Stat_AudioLanguages = "";
foreach (string audioLan in audioLanguages)
{
if (contract.Stat_AudioLanguages.Length > 0) contract.Stat_AudioLanguages += ",";
contract.Stat_AudioLanguages += audioLan;
}
//logger.Trace(" XXXX 09");
contract.Stat_SubtitleLanguages = "";
foreach (string subLan in subtitleLanguages)
{
if (contract.Stat_SubtitleLanguages.Length > 0) contract.Stat_SubtitleLanguages += ",";
contract.Stat_SubtitleLanguages += subLan;
}
//logger.Trace(" XXXX 10");
contract.Stat_AllVideoQuality = repAdHoc.GetAllVideoQualityForAnime(session, this.AnimeID);
contract.Stat_AllVideoQuality_Episodes = "";
AnimeVideoQualityStat stat = repAdHoc.GetEpisodeVideoQualityStatsForAnime(session, this.AnimeID);
if (stat != null && stat.VideoQualityEpisodeCount.Count > 0)
{
foreach (KeyValuePair<string, int> kvp in stat.VideoQualityEpisodeCount)
{
if (kvp.Value >= EpisodeCountNormal)
{
if (contract.Stat_AllVideoQuality_Episodes.Length > 0) contract.Stat_AllVideoQuality_Episodes += ",";
contract.Stat_AllVideoQuality_Episodes += kvp.Key;
}
}
}
//logger.Trace(" XXXX 11");
return contract;
}
