private void PopulateCrossRefs() { try { CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); crossRefTvDBV2 = repCrossRef.GetByAnimeID(AnimeID); } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } }
public override void ProcessCommand() { try { //if (string.IsNullOrEmpty(ServerSettings.WebCacheAuthKey)) return; CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); CrossRef_AniDB_TvDBV2 xref = repCrossRef.GetByID(CrossRef_AniDB_TvDBID); if (xref == null) return; AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime anime = repAnime.GetByAnimeID(xref.AnimeID); if (anime == null) return; AzureWebAPI.Send_CrossRefAniDBTvDB(xref, anime.MainTitle); } catch (Exception ex) { logger.ErrorException("Error processing CommandRequest_WebCacheSendXRefAniDBTvDB: {0}" + ex.ToString(), ex); return; } }
public static string LinkAniDBTvDB(int animeID, enEpisodeType aniEpType, int aniEpNumber, int tvDBID, int tvSeasonNumber, int tvEpNumber, bool excludeFromWebCache) { using (var session = JMMService.SessionFactory.OpenSession()) { CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefTemps = repCrossRef.GetByAnimeIDEpTypeEpNumber(session, animeID, (int)aniEpType, aniEpNumber); if (xrefTemps != null && xrefTemps.Count > 0) { foreach (CrossRef_AniDB_TvDBV2 xrefTemp in xrefTemps) { // delete the existing one if we are updating TvDBHelper.RemoveLinkAniDBTvDB(xrefTemp.AnimeID, (enEpisodeType)xrefTemp.AniDBStartEpisodeType, xrefTemp.AniDBStartEpisodeNumber, xrefTemp.TvDBID, xrefTemp.TvDBSeasonNumber, xrefTemp.TvDBStartEpisodeNumber); } } // check if we have this information locally // if not download it now TvDB_SeriesRepository repSeries = new TvDB_SeriesRepository(); TvDB_Series tvSeries = repSeries.GetByTvDBID(tvDBID); if (tvSeries == null) { // we download the series info here just so that we have the basic info in the // database before the queued task runs later tvSeries = GetSeriesInfoOnline(tvDBID); } // download and update series info, episode info and episode images // will also download fanart, posters and wide banners CommandRequest_TvDBUpdateSeriesAndEpisodes cmdSeriesEps = new CommandRequest_TvDBUpdateSeriesAndEpisodes(tvDBID, false); cmdSeriesEps.Save(); CrossRef_AniDB_TvDBV2 xref = repCrossRef.GetByTvDBID(session, tvDBID, tvSeasonNumber, tvEpNumber, animeID, (int)aniEpType, aniEpNumber); if (xref == null) xref = new CrossRef_AniDB_TvDBV2(); xref.AnimeID = animeID; xref.AniDBStartEpisodeType = (int)aniEpType; xref.AniDBStartEpisodeNumber = aniEpNumber; xref.TvDBID = tvDBID; xref.TvDBSeasonNumber = tvSeasonNumber; xref.TvDBStartEpisodeNumber = tvEpNumber; if (tvSeries != null) xref.TvDBTitle = tvSeries.SeriesName; if (excludeFromWebCache) xref.CrossRefSource = (int)CrossRefSource.WebCache; else xref.CrossRefSource = (int)CrossRefSource.User; repCrossRef.Save(xref); StatsCache.Instance.UpdateUsingAnime(animeID); logger.Trace("Changed tvdb association: {0}", animeID); if (!excludeFromWebCache) { CommandRequest_WebCacheSendXRefAniDBTvDB req = new CommandRequest_WebCacheSendXRefAniDBTvDB(xref.CrossRef_AniDB_TvDBV2ID); req.Save(); } if (ServerSettings.Trakt_IsEnabled && !string.IsNullOrEmpty(ServerSettings.Trakt_AuthToken)) { CrossRef_AniDB_TraktV2Repository repTraktXrefs = new CrossRef_AniDB_TraktV2Repository(); if (repTraktXrefs.GetByAnimeID(animeID).Count == 0) { // check for Trakt associations CommandRequest_TraktSearchAnime cmd2 = new CommandRequest_TraktSearchAnime(animeID, false); cmd2.Save(session); } } } return ""; }
public override void ProcessCommand() { logger.Info("Processing CommandRequest_TraktSearchAnime: {0}", AnimeID); try { using (var session = JMMService.SessionFactory.OpenSession()) { // first check if the user wants to use the web cache if (ServerSettings.WebCache_TvDB_Get) { try { CrossRef_AniDB_TraktResult crossRef = XMLService.Get_CrossRef_AniDB_Trakt(AnimeID); if (crossRef != null) { TraktTVShow showInfo = TraktTVHelper.GetShowInfo(crossRef.TraktID); if (showInfo != null) { logger.Trace("Found trakt match on web cache for {0} - id = {1}", AnimeID, showInfo.title); TraktTVHelper.LinkAniDBTrakt(AnimeID, crossRef.TraktID, crossRef.TraktSeasonNumber, true); return; } } } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } } // lets try to see locally if we have a tvDB link for this anime // Trakt allows the use of TvDB ID's or their own Trakt ID's CrossRef_AniDB_TvDBV2Repository repCrossRefTvDB = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefTvDBs = repCrossRefTvDB.GetByAnimeID(session, AnimeID); if (xrefTvDBs != null && xrefTvDBs.Count == 1) //TODO this is temporary code, until trakt also allows multiple links { TraktTVShow showInfo = TraktTVHelper.GetShowInfo(xrefTvDBs[0].TvDBID); if (showInfo != null) { // make sure the season specified by TvDB also exists on Trakt Trakt_ShowRepository repShow = new Trakt_ShowRepository(); Trakt_Show traktShow = repShow.GetByTraktID(session, showInfo.TraktID); if (traktShow != null) { Trakt_SeasonRepository repSeasons = new Trakt_SeasonRepository(); Trakt_Season traktSeason = repSeasons.GetByShowIDAndSeason(session, traktShow.Trakt_ShowID, xrefTvDBs[0].TvDBSeasonNumber); if (traktSeason != null) { logger.Trace("Found trakt match using TvDBID locally {0} - id = {1}", AnimeID, showInfo.title); TraktTVHelper.LinkAniDBTrakt(AnimeID, showInfo.TraktID, traktSeason.Season, true); return; } } } } // if not lets try the tvdb web cache based on the same reasoning if (ServerSettings.WebCache_TvDB_Get) { List<JMMServer.Providers.Azure.CrossRef_AniDB_TvDB> cacheResults = JMMServer.Providers.Azure.AzureWebAPI.Get_CrossRefAniDBTvDB(AnimeID); if (cacheResults != null && cacheResults.Count > 0) { TraktTVShow showInfo = TraktTVHelper.GetShowInfo(cacheResults[0].TvDBID); if (showInfo != null) { // make sure the season specified by TvDB also exists on Trakt Trakt_ShowRepository repShow = new Trakt_ShowRepository(); Trakt_Show traktShow = repShow.GetByTraktID(session, showInfo.TraktID); if (traktShow != null) { Trakt_SeasonRepository repSeasons = new Trakt_SeasonRepository(); Trakt_Season traktSeason = repSeasons.GetByShowIDAndSeason(session, traktShow.Trakt_ShowID, cacheResults[0].TvDBSeasonNumber); if (traktSeason != null) { logger.Trace("Found trakt match on web cache by using TvDBID {0} - id = {1}", AnimeID, showInfo.title); TraktTVHelper.LinkAniDBTrakt(AnimeID, showInfo.TraktID, traktSeason.Season, true); return; } } } } } // finally lets try searching Trakt directly string searchCriteria = ""; AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime anime = repAnime.GetByAnimeID(session, AnimeID); if (anime == null) return; searchCriteria = anime.MainTitle; // if not wanting to use web cache, or no match found on the web cache go to TvDB directly List<TraktTVShow> results = TraktTVHelper.SearchShow(searchCriteria); logger.Trace("Found {0} trakt results for {1} ", results.Count, searchCriteria); if (ProcessSearchResults(session, results, searchCriteria)) return; if (results.Count == 0) { foreach (AniDB_Anime_Title title in anime.GetTitles(session)) { if (title.TitleType.ToUpper() != Constants.AnimeTitleType.Official.ToUpper()) continue; if (searchCriteria.ToUpper() == title.Title.ToUpper()) continue; results = TraktTVHelper.SearchShow(searchCriteria); logger.Trace("Found {0} trakt results for search on {1}", results.Count, title.Title); if (ProcessSearchResults(session, results, title.Title)) return; } } } } catch (Exception ex) { logger.Error("Error processing CommandRequest_TvDBSearchAnime: {0} - {1}", AnimeID, ex.ToString()); return; } }
public override void ProcessCommand() { logger.Info("Processing CommandRequest_TraktSearchAnime: {0}", AnimeID); try { using (var session = JMMService.SessionFactory.OpenSession()) { // first check if the user wants to use the web cache if (ServerSettings.WebCache_Trakt_Get) { try { List<Contract_Azure_CrossRef_AniDB_Trakt> contracts = new List<Contract_Azure_CrossRef_AniDB_Trakt>(); List<JMMServer.Providers.Azure.CrossRef_AniDB_Trakt> resultsCache = JMMServer.Providers.Azure.AzureWebAPI.Get_CrossRefAniDBTrakt(AnimeID); if (resultsCache != null && resultsCache.Count > 0) { foreach (JMMServer.Providers.Azure.CrossRef_AniDB_Trakt xref in resultsCache) { TraktV2ShowExtended showInfo = TraktTVHelper.GetShowInfoV2(xref.TraktID); if (showInfo != null) { logger.Trace("Found trakt match on web cache for {0} - id = {1}", AnimeID, showInfo.title); TraktTVHelper.LinkAniDBTrakt(AnimeID, (enEpisodeType)xref.AniDBStartEpisodeType, xref.AniDBStartEpisodeNumber, xref.TraktID, xref.TraktSeasonNumber, xref.TraktStartEpisodeNumber, true); return; } } } } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } } // lets try to see locally if we have a tvDB link for this anime // Trakt allows the use of TvDB ID's or their own Trakt ID's CrossRef_AniDB_TvDBV2Repository repCrossRefTvDB = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefTvDBs = repCrossRefTvDB.GetByAnimeID(session, AnimeID); if (xrefTvDBs != null && xrefTvDBs.Count > 0) { foreach (CrossRef_AniDB_TvDBV2 tvXRef in xrefTvDBs) { // first search for this show by the TvDB ID List<TraktV2SearchTvDBIDShowResult> searchResults = TraktTVHelper.SearchShowByIDV2(TraktSearchIDType.tvdb, tvXRef.TvDBID.ToString()); if (searchResults != null && searchResults.Count > 0) { // since we are searching by ID, there will only be one 'show' result TraktV2Show resShow = null; foreach (TraktV2SearchTvDBIDShowResult res in searchResults) { if (res.ResultType == SearchIDType.Show) { resShow = res.show; break; } } if (resShow != null) { TraktV2ShowExtended showInfo = TraktTVHelper.GetShowInfoV2(resShow.ids.slug); if (showInfo != null && showInfo.ids != null) { // make sure the season specified by TvDB also exists on Trakt Trakt_ShowRepository repShow = new Trakt_ShowRepository(); Trakt_Show traktShow = repShow.GetByTraktSlug(session, showInfo.ids.slug); if (traktShow != null) { Trakt_SeasonRepository repSeasons = new Trakt_SeasonRepository(); Trakt_Season traktSeason = repSeasons.GetByShowIDAndSeason(session, traktShow.Trakt_ShowID, xrefTvDBs[0].TvDBSeasonNumber); if (traktSeason != null) { logger.Trace("Found trakt match using TvDBID locally {0} - id = {1}", AnimeID, showInfo.title); TraktTVHelper.LinkAniDBTrakt(AnimeID, (AniDBAPI.enEpisodeType)tvXRef.AniDBStartEpisodeType, tvXRef.AniDBStartEpisodeNumber, showInfo.ids.slug, tvXRef.TvDBSeasonNumber, tvXRef.TvDBStartEpisodeNumber, true); return; } } } } } } } // finally lets try searching Trakt directly string searchCriteria = ""; AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime anime = repAnime.GetByAnimeID(session, AnimeID); if (anime == null) return; searchCriteria = anime.MainTitle; // if not wanting to use web cache, or no match found on the web cache go to TvDB directly List<TraktV2SearchShowResult> results = TraktTVHelper.SearchShowV2(searchCriteria); logger.Trace("Found {0} trakt results for {1} ", results.Count, searchCriteria); if (ProcessSearchResults(session, results, searchCriteria)) return; if (results.Count == 0) { foreach (AniDB_Anime_Title title in anime.GetTitles(session)) { if (title.TitleType.ToUpper() != Constants.AnimeTitleType.Official.ToUpper()) continue; if (searchCriteria.ToUpper() == title.Title.ToUpper()) continue; results = TraktTVHelper.SearchShowV2(searchCriteria); logger.Trace("Found {0} trakt results for search on {1}", results.Count, title.Title); if (ProcessSearchResults(session, results, title.Title)) return; } } } } catch (Exception ex) { logger.Error("Error processing CommandRequest_TvDBSearchAnime: {0} - {1}", AnimeID, ex.ToString()); return; } }
/// <summary> /// Sends the current user's TvDB links to the web cache, and then admin approves them /// </summary> /// <returns></returns> public string UseMyTvDBLinksWebCache(int animeID) { try { // Get all the links for this user and anime CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefs = repCrossRef.GetByAnimeID(animeID); if (xrefs == null) return "No Links found to use"; AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime anime = repAnime.GetByAnimeID(animeID); if (anime == null) return "Anime not found"; // make sure the user doesn't alreday have links List<JMMServer.Providers.Azure.CrossRef_AniDB_TvDB> results = JMMServer.Providers.Azure.AzureWebAPI.Admin_Get_CrossRefAniDBTvDB(animeID); bool foundLinks = false; if (results != null) { foreach (JMMServer.Providers.Azure.CrossRef_AniDB_TvDB xref in results) { if (xref.Username.Equals(ServerSettings.AniDB_Username, StringComparison.InvariantCultureIgnoreCase)) { foundLinks = true; break; } } } if (foundLinks) return "Links already exist, please approve them instead"; // send the links to the web cache foreach (CrossRef_AniDB_TvDBV2 xref in xrefs) { Providers.Azure.AzureWebAPI.Send_CrossRefAniDBTvDB(xref, anime.MainTitle); } // now get the links back from the cache and approve them results = JMMServer.Providers.Azure.AzureWebAPI.Admin_Get_CrossRefAniDBTvDB(animeID); if (results != null) { List<JMMServer.Providers.Azure.CrossRef_AniDB_TvDB> linksToApprove = new List<Providers.Azure.CrossRef_AniDB_TvDB>(); foreach (JMMServer.Providers.Azure.CrossRef_AniDB_TvDB xref in results) { if (xref.Username.Equals(ServerSettings.AniDB_Username, StringComparison.InvariantCultureIgnoreCase)) linksToApprove.Add(xref); } foreach (JMMServer.Providers.Azure.CrossRef_AniDB_TvDB xref in linksToApprove) { JMMServer.Providers.Azure.AzureWebAPI.Admin_Approve_CrossRefAniDBTvDB(xref.CrossRef_AniDB_TvDBId.Value); } return "Success"; } else return "Failure to send links to web cache"; } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); return ex.Message; } }
/// <summary> /// Removes all tvdb links for one anime /// </summary> /// <param name="animeID"></param> /// <returns></returns> public string RemoveLinkAniDBTvDBForAnime(int animeID) { try { AnimeSeriesRepository repSeries = new AnimeSeriesRepository(); AnimeSeries ser = repSeries.GetByAnimeID(animeID); if (ser == null) return "Could not find Series for Anime!"; CrossRef_AniDB_TvDBV2Repository repCrossRef= new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefs = repCrossRef.GetByAnimeID(animeID); if (xrefs == null) return ""; AniDB_Anime_DefaultImageRepository repDefaults = new AniDB_Anime_DefaultImageRepository(); foreach (CrossRef_AniDB_TvDBV2 xref in xrefs) { // check if there are default images used associated List<AniDB_Anime_DefaultImage> images = repDefaults.GetByAnimeID(animeID); foreach (AniDB_Anime_DefaultImage image in images) { if (image.ImageParentType == (int)JMMImageType.TvDB_Banner || image.ImageParentType == (int)JMMImageType.TvDB_Cover || image.ImageParentType == (int)JMMImageType.TvDB_FanArt) { if (image.ImageParentID == xref.TvDBID) repDefaults.Delete(image.AniDB_Anime_DefaultImageID); } } TvDBHelper.RemoveLinkAniDBTvDB(xref.AnimeID, (enEpisodeType)xref.AniDBStartEpisodeType, xref.AniDBStartEpisodeNumber, xref.TvDBID, xref.TvDBSeasonNumber, xref.TvDBStartEpisodeNumber); } return ""; } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); return ex.Message; } }
public static void ScanForMatches() { AnimeSeriesRepository repSeries = new AnimeSeriesRepository(); List<AnimeSeries> allSeries = repSeries.GetAll(); CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> allCrossRefs = repCrossRef.GetAll(); List<int> alreadyLinked = new List<int>(); foreach (CrossRef_AniDB_TvDBV2 xref in allCrossRefs) { alreadyLinked.Add(xref.AnimeID); } foreach (AnimeSeries ser in allSeries) { if (alreadyLinked.Contains(ser.AniDB_ID)) continue; AniDB_Anime anime = ser.GetAnime(); if (anime!= null) { logger.Trace("Found anime without tvDB association: " + anime.MainTitle); if (!anime.SearchOnTvDB) continue; if (anime.IsTvDBLinkDisabled) { logger.Trace("Skipping scan tvDB link because it is disabled: " + anime.MainTitle); continue; } } CommandRequest_TvDBSearchAnime cmd = new CommandRequest_TvDBSearchAnime(ser.AniDB_ID, false); cmd.Save(); } }
public List<Contract_AnimeSeries> GetSeriesWithMissingEpisodes(int maxRecords, int jmmuserID) { DateTime start = DateTime.Now; AnimeSeriesRepository repSeries = new AnimeSeriesRepository(); AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); JMMUserRepository repUsers = new JMMUserRepository(); // get all the series List<Contract_AnimeSeries> seriesContractList = new List<Contract_AnimeSeries>(); try { JMMUser user = repUsers.GetByID(jmmuserID); if (user == null) return seriesContractList; List<AnimeSeries> series = repSeries.GetWithMissingEpisodes(); List<AniDB_Anime> animes = repAnime.GetAll(); Dictionary<int, AniDB_Anime> dictAnimes = new Dictionary<int, AniDB_Anime>(); foreach (AniDB_Anime anime in animes) dictAnimes[anime.AnimeID] = anime; // tvdb CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> allCrossRefs = repCrossRef.GetAll(); Dictionary<int, List<CrossRef_AniDB_TvDBV2>> dictCrossRefsV2 = new Dictionary<int, List<CrossRef_AniDB_TvDBV2>>(); foreach (CrossRef_AniDB_TvDBV2 xref in allCrossRefs) { if (!dictCrossRefsV2.ContainsKey(xref.AnimeID)) dictCrossRefsV2[xref.AnimeID] = new List<CrossRef_AniDB_TvDBV2>(); dictCrossRefsV2[xref.AnimeID].Add(xref); } // moviedb CrossRef_AniDB_OtherRepository repOtherCrossRef = new CrossRef_AniDB_OtherRepository(); List<CrossRef_AniDB_Other> allOtherCrossRefs = repOtherCrossRef.GetAll(); Dictionary<int, CrossRef_AniDB_Other> dictMovieCrossRefs = new Dictionary<int, CrossRef_AniDB_Other>(); foreach (CrossRef_AniDB_Other xref in allOtherCrossRefs) { if (xref.CrossRefType == (int)CrossRefType.MovieDB) dictMovieCrossRefs[xref.AnimeID] = xref; } // MAL CrossRef_AniDB_MALRepository repMALCrossRef = new CrossRef_AniDB_MALRepository(); List<CrossRef_AniDB_MAL> allMALCrossRefs = repMALCrossRef.GetAll(); Dictionary<int, List<CrossRef_AniDB_MAL>> dictMALCrossRefs = new Dictionary<int, List<CrossRef_AniDB_MAL>>(); foreach (CrossRef_AniDB_MAL xref in allMALCrossRefs) { if (!dictMALCrossRefs.ContainsKey(xref.AnimeID)) dictMALCrossRefs[xref.AnimeID] = new List<CrossRef_AniDB_MAL>(); dictMALCrossRefs[xref.AnimeID].Add(xref); } // user records AnimeSeries_UserRepository repSeriesUser = new AnimeSeries_UserRepository(); List<AnimeSeries_User> userRecordList = repSeriesUser.GetByUserID(jmmuserID); Dictionary<int, AnimeSeries_User> dictUserRecords = new Dictionary<int, AnimeSeries_User>(); foreach (AnimeSeries_User serUser in userRecordList) dictUserRecords[serUser.AnimeSeriesID] = serUser; int i = 1; foreach (AnimeSeries aser in series) { if (!dictAnimes.ContainsKey(aser.AniDB_ID)) continue; AniDB_Anime anime = dictAnimes[aser.AniDB_ID]; if (!user.AllowedAnime(anime)) continue; List<CrossRef_AniDB_TvDBV2> xrefs = new List<CrossRef_AniDB_TvDBV2>(); if (dictCrossRefsV2.ContainsKey(aser.AniDB_ID)) xrefs = dictCrossRefsV2[aser.AniDB_ID]; CrossRef_AniDB_Other xrefMovie = null; if (dictMovieCrossRefs.ContainsKey(aser.AniDB_ID)) xrefMovie = dictMovieCrossRefs[aser.AniDB_ID]; AnimeSeries_User userRec = null; if (dictUserRecords.ContainsKey(aser.AnimeSeriesID)) userRec = dictUserRecords[aser.AnimeSeriesID]; List<CrossRef_AniDB_MAL> xrefMAL = null; if (dictMALCrossRefs.ContainsKey(aser.AniDB_ID)) xrefMAL = dictMALCrossRefs[aser.AniDB_ID]; List<TvDB_Series> sers = new List<TvDB_Series>(); foreach (CrossRef_AniDB_TvDBV2 xref in xrefs) sers.Add(xref.GetTvDBSeries()); MovieDB_Movie movie = null; if (xrefMovie != null) movie = xrefMovie.GetMovieDB_Movie(); seriesContractList.Add(aser.ToContract(dictAnimes[aser.AniDB_ID], xrefs, xrefMovie, userRec, sers, xrefMAL, false, null, null, null, null,movie)); if (i == maxRecords) break; i++; } TimeSpan ts = DateTime.Now - start; logger.Info("GetSeriesWithMissingEpisodes in {0} ms", ts.TotalMilliseconds); } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } return seriesContractList; }
public List<Contract_AnimeSeries> GetAllSeries(int userID) { AnimeSeriesRepository repSeries = new AnimeSeriesRepository(); AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository(); //TODO: Custom Tags: Do I need to add custom tags for searches // get all the series List<Contract_AnimeSeries> seriesContractList = new List<Contract_AnimeSeries>(); try { DateTime start = DateTime.Now; DateTime start2 = DateTime.Now; List<AnimeSeries> series = repSeries.GetAll(); List<AniDB_Anime> animes = repAnime.GetAll(); Dictionary<int, AniDB_Anime> dictAnimes = new Dictionary<int, AniDB_Anime>(); foreach (AniDB_Anime anime in animes) dictAnimes[anime.AnimeID] = anime; TimeSpan ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:Anime:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // tvdb - cross refs CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> allCrossRefs = repCrossRef.GetAll(); Dictionary<int, List<CrossRef_AniDB_TvDBV2>> dictCrossRefsV2 = new Dictionary<int, List<CrossRef_AniDB_TvDBV2>>(); foreach (CrossRef_AniDB_TvDBV2 xref in allCrossRefs) { if (!dictCrossRefsV2.ContainsKey(xref.AnimeID)) dictCrossRefsV2[xref.AnimeID] = new List<CrossRef_AniDB_TvDBV2>(); dictCrossRefsV2[xref.AnimeID].Add(xref); } ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:TvDB CrossRefs:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // tvdb - series info TvDB_SeriesRepository repTvSeries = new TvDB_SeriesRepository(); List<TvDB_Series> allTvSeries = repTvSeries.GetAll(); Dictionary<int, TvDB_Series> dictTvSeries = new Dictionary<int, TvDB_Series>(); foreach (TvDB_Series tvs in allTvSeries) dictTvSeries[tvs.SeriesID] = tvs; ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:TvDB:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // moviedb CrossRef_AniDB_OtherRepository repOtherCrossRef = new CrossRef_AniDB_OtherRepository(); List<CrossRef_AniDB_Other> allOtherCrossRefs = repOtherCrossRef.GetAll(); Dictionary<int, CrossRef_AniDB_Other> dictMovieCrossRefs = new Dictionary<int, CrossRef_AniDB_Other>(); foreach (CrossRef_AniDB_Other xref in allOtherCrossRefs) { if (xref.CrossRefType == (int)CrossRefType.MovieDB) dictMovieCrossRefs[xref.AnimeID] = xref; } ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:MovieDB:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // MAL CrossRef_AniDB_MALRepository repMALCrossRef = new CrossRef_AniDB_MALRepository(); List<CrossRef_AniDB_MAL> allMALCrossRefs = repMALCrossRef.GetAll(); Dictionary<int, List<CrossRef_AniDB_MAL>> dictMALCrossRefs = new Dictionary<int, List<CrossRef_AniDB_MAL>>(); foreach (CrossRef_AniDB_MAL xref in allMALCrossRefs) { if (!dictMALCrossRefs.ContainsKey(xref.AnimeID)) dictMALCrossRefs[xref.AnimeID] = new List<CrossRef_AniDB_MAL>(); dictMALCrossRefs[xref.AnimeID].Add(xref); } ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:MAL:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // user records AnimeSeries_UserRepository repSeriesUser = new AnimeSeries_UserRepository(); List<AnimeSeries_User> userRecordList = repSeriesUser.GetByUserID(userID); Dictionary<int, AnimeSeries_User> dictUserRecords = new Dictionary<int, AnimeSeries_User>(); foreach (AnimeSeries_User serUser in userRecordList) dictUserRecords[serUser.AnimeSeriesID] = serUser; ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:UserRecs:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // default images AniDB_Anime_DefaultImageRepository repDefImages = new AniDB_Anime_DefaultImageRepository(); List<AniDB_Anime_DefaultImage> allDefaultImages = repDefImages.GetAll(); ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:DefaultImages:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; // titles List<AniDB_Anime_Title> allTitles = repTitles.GetAllForLocalSeries(); Dictionary<int, List<AniDB_Anime_Title>> dictTitles = new Dictionary<int, List<AniDB_Anime_Title>>(); foreach (AniDB_Anime_Title atit in allTitles) { if (!dictTitles.ContainsKey(atit.AnimeID)) dictTitles[atit.AnimeID] = new List<AniDB_Anime_Title>(); dictTitles[atit.AnimeID].Add(atit); } ts2 = DateTime.Now - start2; logger.Info("GetAllSeries:Titles:RawData in {0} ms", ts2.TotalMilliseconds); start2 = DateTime.Now; TimeSpan ts = DateTime.Now - start; logger.Info("GetAllSeries:RawData in {0} ms", ts.TotalMilliseconds); Dictionary<int, AniDB_Anime_DefaultImage> dictDefaultsPosters = new Dictionary<int, AniDB_Anime_DefaultImage>(); Dictionary<int, AniDB_Anime_DefaultImage> dictDefaultsFanart = new Dictionary<int, AniDB_Anime_DefaultImage>(); Dictionary<int, AniDB_Anime_DefaultImage> dictDefaultsWideBanner = new Dictionary<int, AniDB_Anime_DefaultImage>(); start = DateTime.Now; foreach (AniDB_Anime_DefaultImage defaultImage in allDefaultImages) { ImageSizeType sizeType = (ImageSizeType)defaultImage.ImageType; if (sizeType == ImageSizeType.Fanart) dictDefaultsFanart[defaultImage.AnimeID] = defaultImage; if (sizeType == ImageSizeType.Poster) dictDefaultsPosters[defaultImage.AnimeID] = defaultImage; if (sizeType == ImageSizeType.WideBanner) dictDefaultsWideBanner[defaultImage.AnimeID] = defaultImage; } foreach (AnimeSeries aser in series) { if (!dictAnimes.ContainsKey(aser.AniDB_ID)) continue; List<CrossRef_AniDB_TvDBV2> xrefs = new List<CrossRef_AniDB_TvDBV2>(); if (dictCrossRefsV2.ContainsKey(aser.AniDB_ID)) xrefs = dictCrossRefsV2[aser.AniDB_ID]; List<TvDB_Series> tvseriesV2 = new List<TvDB_Series>(); if (xrefs != null) { foreach (CrossRef_AniDB_TvDBV2 xref in xrefs) { if (dictTvSeries.ContainsKey(xref.TvDBID)) tvseriesV2.Add(dictTvSeries[xref.TvDBID]); } } CrossRef_AniDB_Other xrefMovie = null; if (dictMovieCrossRefs.ContainsKey(aser.AniDB_ID)) xrefMovie = dictMovieCrossRefs[aser.AniDB_ID]; List<CrossRef_AniDB_MAL> xrefMAL = null; if (dictMALCrossRefs.ContainsKey(aser.AniDB_ID)) xrefMAL = dictMALCrossRefs[aser.AniDB_ID]; MovieDB_Movie movie = null; if (xrefMovie != null) movie = xrefMovie.GetMovieDB_Movie(); AnimeSeries_User userRec = null; if (dictUserRecords.ContainsKey(aser.AnimeSeriesID)) userRec = dictUserRecords[aser.AnimeSeriesID]; List<AniDB_Anime_Title> titles = null; if (dictTitles.ContainsKey(aser.AniDB_ID)) titles = dictTitles[aser.AniDB_ID]; AniDB_Anime_DefaultImage defPoster = null; AniDB_Anime_DefaultImage defFanart = null; AniDB_Anime_DefaultImage defWideBanner = null; if (dictDefaultsPosters.ContainsKey(aser.AniDB_ID)) defPoster = dictDefaultsPosters[aser.AniDB_ID]; if (dictDefaultsFanart.ContainsKey(aser.AniDB_ID)) defFanart = dictDefaultsFanart[aser.AniDB_ID]; if (dictDefaultsWideBanner.ContainsKey(aser.AniDB_ID)) defWideBanner = dictDefaultsWideBanner[aser.AniDB_ID]; seriesContractList.Add(aser.ToContract(dictAnimes[aser.AniDB_ID], xrefs, xrefMovie, userRec, tvseriesV2, xrefMAL, true, defPoster, defFanart, defWideBanner, titles, movie)); } ts = DateTime.Now - start; logger.Info("GetAllSeries:ProcessedData in {0} ms", ts.TotalMilliseconds); } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } return seriesContractList; }
public static void MigrateTvDBLinks_V1_to_V2() { try { AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); TvDB_EpisodeRepository repEps = new TvDB_EpisodeRepository(); CrossRef_AniDB_TvDBRepository repCrossRefTvDB = new CrossRef_AniDB_TvDBRepository(); CrossRef_AniDB_TvDBV2Repository repCrossRefTvDBNew = new CrossRef_AniDB_TvDBV2Repository(); using (var session = JMMService.SessionFactory.OpenSession()) { List<CrossRef_AniDB_TvDB> xrefsTvDB = repCrossRefTvDB.GetAll(); foreach (CrossRef_AniDB_TvDB xrefTvDB in xrefsTvDB) { CrossRef_AniDB_TvDBV2 xrefNew = new CrossRef_AniDB_TvDBV2(); xrefNew.AnimeID = xrefTvDB.AnimeID; xrefNew.CrossRefSource = xrefTvDB.CrossRefSource; xrefNew.TvDBID = xrefTvDB.TvDBID; xrefNew.TvDBSeasonNumber = xrefTvDB.TvDBSeasonNumber; TvDB_Series ser = xrefTvDB.GetTvDBSeries(session); if (ser != null) xrefNew.TvDBTitle = ser.SeriesName; // determine start ep type if (xrefTvDB.TvDBSeasonNumber == 0) xrefNew.AniDBStartEpisodeType = (int)AniDBAPI.enEpisodeType.Special; else xrefNew.AniDBStartEpisodeType = (int)AniDBAPI.enEpisodeType.Episode; xrefNew.AniDBStartEpisodeNumber = 1; xrefNew.TvDBStartEpisodeNumber = 1; repCrossRefTvDBNew.Save(xrefNew); } // create cross ref's for specials foreach (CrossRef_AniDB_TvDB xrefTvDB in xrefsTvDB) { AniDB_Anime anime = repAnime.GetByAnimeID(xrefTvDB.AnimeID); if (anime == null) continue; // this anime has specials if (anime.EpisodeCountSpecial <= 0) continue; // this tvdb series has a season 0 (specials) List<int> seasons = repEps.GetSeasonNumbersForSeries(xrefTvDB.TvDBID); if (!seasons.Contains(0)) continue; //make sure we are not doubling up CrossRef_AniDB_TvDBV2 temp = repCrossRefTvDBNew.GetByTvDBID(xrefTvDB.TvDBID, 0, 1, xrefTvDB.AnimeID, (int)AniDBAPI.enEpisodeType.Special, 1); if (temp != null) continue; CrossRef_AniDB_TvDBV2 xrefNew = new CrossRef_AniDB_TvDBV2(); xrefNew.AnimeID = xrefTvDB.AnimeID; xrefNew.CrossRefSource = xrefTvDB.CrossRefSource; xrefNew.TvDBID = xrefTvDB.TvDBID; xrefNew.TvDBSeasonNumber = 0; xrefNew.TvDBStartEpisodeNumber = 1; xrefNew.AniDBStartEpisodeType = (int)AniDBAPI.enEpisodeType.Special; xrefNew.AniDBStartEpisodeNumber = 1; TvDB_Series ser = xrefTvDB.GetTvDBSeries(session); if (ser != null) xrefNew.TvDBTitle = ser.SeriesName; repCrossRefTvDBNew.Save(xrefNew); } } } catch (Exception ex) { logger.ErrorException("Could not MigrateTvDBLinks_V1_to_V2: " + ex.ToString(), ex); } }
public void InitStats() { try { DateTime start = DateTime.Now; ClearAllData(); #region Get the data AnimeGroupRepository repGroups = new AnimeGroupRepository(); AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AnimeSeriesRepository repSeries = new AnimeSeriesRepository(); AniDB_CategoryRepository repCats = new AniDB_CategoryRepository(); AniDB_Anime_CategoryRepository repAnimeCat = new AniDB_Anime_CategoryRepository(); AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository(); List<AnimeGroup> allGrps = repGroups.GetAll(); Dictionary<int, AnimeGroup> allGroupsDict = new Dictionary<int, AnimeGroup>(); foreach (AnimeGroup agrp in allGrps) allGroupsDict[agrp.AnimeGroupID] = agrp; TimeSpan ts = DateTime.Now - start; logger.Info("Get All GROUPS (Database) in {0} ms", ts.TotalMilliseconds); // anime start = DateTime.Now; List<AniDB_Anime> allAnime = repAnime.GetAll(); Dictionary<int, AniDB_Anime> allAnimeDict = new Dictionary<int, AniDB_Anime>(); foreach (AniDB_Anime anime in allAnime) allAnimeDict[anime.AnimeID] = anime; ts = DateTime.Now - start; logger.Info("Get All ANIME (Database) in {0} ms", ts.TotalMilliseconds); // categories start = DateTime.Now; 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<int>> allAnimeCatgeoriesDict = new Dictionary<int, List<int>>(); // animeid / list of category id's foreach (AniDB_Anime_Category aniCat in allAnimeCatgeories) { if (!allAnimeCatgeoriesDict.ContainsKey(aniCat.AnimeID)) allAnimeCatgeoriesDict[aniCat.AnimeID] = new List<int>(); allAnimeCatgeoriesDict[aniCat.AnimeID].Add(aniCat.CategoryID); } ts = DateTime.Now - start; logger.Info("Get All CATEGORIES (Database) in {0} ms", ts.TotalMilliseconds); // titles start = DateTime.Now; List<AniDB_Anime_Title> allTitles = repTitles.GetAll(); Dictionary<int, List<AniDB_Anime_Title>> allTitlesDict = new Dictionary<int, List<AniDB_Anime_Title>>(); // animeid / list of titles foreach (AniDB_Anime_Title aniTitle in allTitles) { if (!allTitlesDict.ContainsKey(aniTitle.AnimeID)) allTitlesDict[aniTitle.AnimeID] = new List<AniDB_Anime_Title>(); allTitlesDict[aniTitle.AnimeID].Add(aniTitle); } ts = DateTime.Now - start; logger.Info("Get All TITLES (Database) in {0} ms", ts.TotalMilliseconds); // user votes start = DateTime.Now; AniDB_VoteRepository repVotes = new AniDB_VoteRepository(); List<AniDB_Vote> allVotes = repVotes.GetAll(); ts = DateTime.Now - start; logger.Info("Get All VOTES (Database) in {0} ms", ts.TotalMilliseconds); // video quality start = DateTime.Now; AdhocRepository rep = new AdhocRepository(); Dictionary<int, string> allVidQuality = rep.GetAllVideoQualityByGroup(); ts = DateTime.Now - start; logger.Info("Get VIDEO QUALITY STATS (Database) in {0} ms", ts.TotalMilliseconds); // video quality episode stats start = DateTime.Now; Dictionary<int, AnimeVideoQualityStat> dictStats = rep.GetEpisodeVideoQualityStatsByAnime(); ts = DateTime.Now - start; logger.Info("Get VIDEO QUALITY EPISODE STATS (Database) in {0} ms", ts.TotalMilliseconds); // audio and subtitle language stats start = DateTime.Now; Dictionary<int, LanguageStat> dictAudioStats = rep.GetAudioLanguageStatsForAnime(); Dictionary<int, LanguageStat> dictSubtitleStats = rep.GetSubtitleLanguageStatsForAnime(); ts = DateTime.Now - start; logger.Info("Get LANGUAGE STATS (Database) in {0} ms", ts.TotalMilliseconds); start = DateTime.Now; List<AnimeSeries> allSeries = repSeries.GetAll(); ts = DateTime.Now - start; logger.Info("Get All Series (Database) in {0} ms", ts.TotalMilliseconds); // TvDB start = DateTime.Now; CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> allCrossRefs = repCrossRef.GetAll(); List<int> animeWithTvDBCrossRef = new List<int>(); foreach (CrossRef_AniDB_TvDBV2 xref in allCrossRefs) { if (!animeWithTvDBCrossRef.Contains(xref.AnimeID)) animeWithTvDBCrossRef.Add(xref.AnimeID); } ts = DateTime.Now - start; logger.Info("Get All AniDB->TvDB Cross Refs (Database) in {0} ms", ts.TotalMilliseconds); // MovieDB start = DateTime.Now; CrossRef_AniDB_OtherRepository repOtherCrossRef = new CrossRef_AniDB_OtherRepository(); List<CrossRef_AniDB_Other> allOtherCrossRefs = repOtherCrossRef.GetAll(); List<int> animeWithMovieCrossRef = new List<int>(); foreach (CrossRef_AniDB_Other xref in allOtherCrossRefs) { if (!animeWithMovieCrossRef.Contains(xref.AnimeID) && xref.CrossRefType == (int)CrossRefType.MovieDB) animeWithMovieCrossRef.Add(xref.AnimeID); } ts = DateTime.Now - start; logger.Info("Get All AniDB->MovieDB Cross Refs (Database) in {0} ms", ts.TotalMilliseconds); // MAL start = DateTime.Now; CrossRef_AniDB_MALRepository repMALCrossRef = new CrossRef_AniDB_MALRepository(); List<CrossRef_AniDB_MAL> allMALCrossRefs = repMALCrossRef.GetAll(); List<int> animeWithMALCrossRef = new List<int>(); foreach (CrossRef_AniDB_MAL xref in allMALCrossRefs) { if (!animeWithMALCrossRef.Contains(xref.AnimeID)) animeWithMALCrossRef.Add(xref.AnimeID); } ts = DateTime.Now - start; logger.Info("Get All AniDB->MAL Cross Refs (Database) in {0} ms", ts.TotalMilliseconds); #endregion start = DateTime.Now; var session = JMMService.SessionFactory.OpenSession(); foreach (AnimeGroup ag in allGrps) { // get all the series for this group List<AnimeSeries> seriesForGroup = new List<AnimeSeries>(); GetAnimeSeriesRecursive(ag, ref seriesForGroup, allSeries, allGroupsDict); /* if (ag.AnimeGroupID == 915) { Console.Write(""); } */ DateTime? Stat_AirDate_Min = null; DateTime? Stat_AirDate_Max = null; DateTime? Stat_EndDate = new DateTime(1980, 1, 1); DateTime? Stat_SeriesCreatedDate = null; bool isComplete = false; bool hasFinishedAiring = false; bool isCurrentlyAiring = false; List<int> categoryIDList = new List<int>(); List<string> audioLanguageList = new List<string>(); List<string> subtitleLanguageList = new List<string>(); string Stat_AllTitles = ""; string Stat_AllCategories = ""; string Stat_AllVideoQualityEpisodes = ""; decimal totalVotesPerm = 0, totalVotesTemp = 0, totalVotes = 0; int countVotesPerm = 0, countVotesTemp = 0, countVotes = 0; bool hasTvDB = true; bool hasMAL = true; bool hasMovieDB = true; bool hasMovieDBOrTvDB = true; int seriesCount = 0; int epCount = 0; foreach (AnimeSeries series in seriesForGroup) { seriesCount++; if (allAnimeDict.ContainsKey(series.AniDB_ID)) { AniDB_Anime thisAnime = allAnimeDict[series.AniDB_ID]; epCount = epCount + thisAnime.EpisodeCountNormal; // 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 (dictStats.ContainsKey(series.AniDB_ID)) { if (series.AniDB_ID == 7656) { Debug.Print(""); } AnimeVideoQualityStat stat = dictStats[series.AniDB_ID]; foreach (KeyValuePair<string, int> kvp in stat.VideoQualityEpisodeCount) { if (kvp.Value >= thisAnime.EpisodeCountNormal) { if (Stat_AllVideoQualityEpisodes.Length > 0) Stat_AllVideoQualityEpisodes += ","; Stat_AllVideoQualityEpisodes += kvp.Key; } } } // Calculate Air Date DateTime? thisDate = thisAnime.AirDate; if (thisDate.HasValue) { if (Stat_AirDate_Min.HasValue) { if (thisDate.Value < Stat_AirDate_Min.Value) Stat_AirDate_Min = thisDate; } else Stat_AirDate_Min = thisDate; if (Stat_AirDate_Max.HasValue) { if (thisDate.Value > Stat_AirDate_Max.Value) Stat_AirDate_Max = thisDate; } else Stat_AirDate_Max = thisDate; } // calculate end date // if the end date is NULL it actually means it is ongoing, so this is the max possible value thisDate = thisAnime.EndDate; if (thisDate.HasValue && Stat_EndDate.HasValue) { if (thisDate.Value > Stat_EndDate.Value) Stat_EndDate = thisDate; } else Stat_EndDate = null; // Calculate Series Created Date thisDate = series.DateTimeCreated; if (thisDate.HasValue) { if (Stat_SeriesCreatedDate.HasValue) { if (thisDate.Value < Stat_SeriesCreatedDate.Value) Stat_SeriesCreatedDate = thisDate; } else Stat_SeriesCreatedDate = thisDate; } /* if (series.AniDB_ID == 2369) Debug.Write("Test"); */ // Note - only one series has to be finished airing to qualify if (thisAnime.EndDate.HasValue && thisAnime.EndDate.Value < DateTime.Now) hasFinishedAiring = true; // Note - only one series has to be currently airing to qualify if (!thisAnime.EndDate.HasValue || thisAnime.EndDate.Value > DateTime.Now) isCurrentlyAiring = true; // We evaluate IsComplete as true if // 1. series has finished airing // 2. user has all episodes locally // Note - only one series has to be complete for the group to be considered complete if (thisAnime.EndDate.HasValue) { if (thisAnime.EndDate.Value < DateTime.Now && series.MissingEpisodeCount == 0 && series.MissingEpisodeCountGroups == 0) { isComplete = true; } } // get categories if (allAnimeCatgeoriesDict.ContainsKey(series.AniDB_ID)) { foreach (int catID in allAnimeCatgeoriesDict[series.AniDB_ID]) { if (!categoryIDList.Contains(catID)) categoryIDList.Add(catID); } } // get audio languages if (dictAudioStats.ContainsKey(series.AniDB_ID)) { foreach (string lanName in dictAudioStats[series.AniDB_ID].LanguageNames) { if (!audioLanguageList.Contains(lanName)) audioLanguageList.Add(lanName); } } // get subtitle languages if (dictSubtitleStats.ContainsKey(series.AniDB_ID)) { foreach (string lanName in dictSubtitleStats[series.AniDB_ID].LanguageNames) { if (!subtitleLanguageList.Contains(lanName)) subtitleLanguageList.Add(lanName); } } // get titles if (allTitlesDict.ContainsKey(series.AniDB_ID)) { foreach (AniDB_Anime_Title title in allTitlesDict[series.AniDB_ID]) { if (Stat_AllTitles.Length > 0) Stat_AllTitles += ","; Stat_AllTitles += title.Title; } } // get votes foreach (AniDB_Vote vote in allVotes) { if (vote.EntityID == series.AniDB_ID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp)) { countVotes++; totalVotes += (decimal)vote.VoteValue; if (vote.VoteType == (int)AniDBVoteType.Anime) { countVotesPerm++; totalVotesPerm += (decimal)vote.VoteValue; } if (vote.VoteType == (int)AniDBVoteType.AnimeTemp) { countVotesTemp++; totalVotesTemp += (decimal)vote.VoteValue; } break; } } } // for the group, if any of the series don't have a tvdb link // we will consider the group as not having a tvdb link if (!animeWithTvDBCrossRef.Contains(series.AniDB_ID)) hasTvDB = false; if (!animeWithMovieCrossRef.Contains(series.AniDB_ID)) hasMovieDB = false; if (!animeWithMALCrossRef.Contains(series.AniDB_ID)) hasMAL = false; if (!animeWithTvDBCrossRef.Contains(series.AniDB_ID) && !animeWithMovieCrossRef.Contains(series.AniDB_ID)) hasMovieDBOrTvDB = false; } if (allVidQuality.ContainsKey(ag.AnimeGroupID)) StatGroupVideoQuality[ag.AnimeGroupID] = allVidQuality[ag.AnimeGroupID]; else StatGroupVideoQuality[ag.AnimeGroupID] = ""; StatGroupVideoQualityEpisodes[ag.AnimeGroupID] = Stat_AllVideoQualityEpisodes; StatGroupIsComplete[ag.AnimeGroupID] = isComplete; StatGroupIsFinishedAiring[ag.AnimeGroupID] = hasFinishedAiring; StatGroupIsCurrentlyAiring[ag.AnimeGroupID] = isCurrentlyAiring; StatGroupSeriesCount[ag.AnimeGroupID] = seriesCount; StatGroupEpisodeCount[ag.AnimeGroupID] = epCount; StatGroupTitles[ag.AnimeGroupID] = Stat_AllTitles; StatGroupAirDate_Max[ag.AnimeGroupID] = Stat_AirDate_Max; StatGroupAirDate_Min[ag.AnimeGroupID] = Stat_AirDate_Min; StatGroupEndDate[ag.AnimeGroupID] = Stat_EndDate; StatGroupSeriesCreatedDate[ag.AnimeGroupID] = Stat_SeriesCreatedDate; StatGroupHasTvDB[ag.AnimeGroupID] = hasTvDB; StatGroupHasMAL[ag.AnimeGroupID] = hasMAL; StatGroupHasMovieDB[ag.AnimeGroupID] = hasMovieDB; StatGroupHasMovieDBOrTvDB[ag.AnimeGroupID] = hasMovieDBOrTvDB; decimal? Stat_UserVoteOverall = null; if (countVotes > 0) Stat_UserVoteOverall = totalVotes / (decimal)countVotes / (decimal)100; StatGroupUserVoteOverall[ag.AnimeGroupID] = Stat_UserVoteOverall; decimal? Stat_UserVotePermanent = null; if (countVotesPerm > 0) Stat_UserVotePermanent = totalVotesPerm / (decimal)countVotesPerm / (decimal)100; StatGroupUserVotePermanent[ag.AnimeGroupID] = Stat_UserVotePermanent; decimal? Stat_UserVoteTemporary = null; if (countVotesTemp > 0) Stat_UserVoteTemporary = totalVotesTemp / (decimal)countVotesTemp / (decimal)100; StatGroupUserVoteTemporary[ag.AnimeGroupID] = Stat_UserVoteTemporary; StatGroupAniDBRating[ag.AnimeGroupID] = ag.AniDBRating; Stat_AllCategories = ""; foreach (int catID in categoryIDList) { if (!allCatgeoriesDict.ContainsKey(catID)) continue; string catName = allCatgeoriesDict[catID].CategoryName; if (Stat_AllCategories.Length > 0) Stat_AllCategories += "|"; Stat_AllCategories += catName; } this.StatGroupCategories[ag.AnimeGroupID] = Stat_AllCategories; string Stat_AudioLanguages = ""; foreach (string audioLan in audioLanguageList) { if (Stat_AudioLanguages.Length > 0) Stat_AudioLanguages += ","; Stat_AudioLanguages += audioLan; } this.StatGroupAudioLanguages[ag.AnimeGroupID] = Stat_AudioLanguages; string Stat_SubtitleLanguages = ""; foreach (string subLan in subtitleLanguageList) { if (Stat_SubtitleLanguages.Length > 0) Stat_SubtitleLanguages += ","; Stat_SubtitleLanguages += subLan; } this.StatGroupSubtitleLanguages[ag.AnimeGroupID] = Stat_SubtitleLanguages; UpdateGroupFilterUsingGroup(ag.AnimeGroupID); UpdatePlexAnimeGroup(session, ag, allSeries); } ts = DateTime.Now - start; logger.Info("GetAllGroups (Contracts) in {0} ms", ts.TotalMilliseconds); //UpdateAllAnimeContracts(); } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } }
public List<CrossRef_AniDB_TvDBV2> GetCrossRefTvDBV2(ISession session) { CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); return repCrossRef.GetByAnimeID(session, this.AnimeID); }
public override void ProcessCommand() { logger.Info("Processing CommandRequest_TvDBSearchAnime: {0}", AnimeID); try { using (var session = JMMService.SessionFactory.OpenSession()) { // first check if the user wants to use the web cache if (ServerSettings.WebCache_TvDB_Get) { try { List<JMMServer.Providers.Azure.CrossRef_AniDB_TvDB> cacheResults = JMMServer.Providers.Azure.AzureWebAPI.Get_CrossRefAniDBTvDB(AnimeID); if (cacheResults != null && cacheResults.Count > 0) { // check again to see if there are any links, user may have manually added links while // this command was in the queue CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefTemp = repCrossRef.GetByAnimeID(AnimeID); if (xrefTemp != null && xrefTemp.Count > 0) return; foreach (JMMServer.Providers.Azure.CrossRef_AniDB_TvDB xref in cacheResults) { TvDB_Series tvser = TvDBHelper.GetSeriesInfoOnline(cacheResults[0].TvDBID); if (tvser != null) { logger.Trace("Found tvdb match on web cache for {0}", AnimeID); TvDBHelper.LinkAniDBTvDB(AnimeID, (AniDBAPI.enEpisodeType)cacheResults[0].AniDBStartEpisodeType, cacheResults[0].AniDBStartEpisodeNumber, cacheResults[0].TvDBID, cacheResults[0].TvDBSeasonNumber, cacheResults[0].TvDBStartEpisodeNumber, true); } else { //if we got a TvDB ID from the web cache, but couldn't find it on TheTvDB.com, it could mean 2 things //1. thetvdb.com is offline //2. the id is no longer valid // if the id is no longer valid we should remove it from the web cache /*if (TvDBHelper.ConfirmTvDBOnline()) { }*/ } } return; } } catch (Exception) { } } string searchCriteria = ""; AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime anime = repAnime.GetByAnimeID(AnimeID); if (anime == null) return; searchCriteria = anime.MainTitle; // if not wanting to use web cache, or no match found on the web cache go to TvDB directly List<TVDBSeriesSearchResult> results = JMMService.TvdbHelper.SearchSeries(searchCriteria); logger.Trace("Found {0} tvdb results for {1} on TheTvDB", results.Count, searchCriteria); if (ProcessSearchResults(results, searchCriteria)) return; if (results.Count == 0) { foreach (AniDB_Anime_Title title in anime.GetTitles()) { if (title.TitleType.ToUpper() != Constants.AnimeTitleType.Official.ToUpper()) continue; if (searchCriteria.ToUpper() == title.Title.ToUpper()) continue; results = JMMService.TvdbHelper.SearchSeries(title.Title); logger.Trace("Found {0} tvdb results for search on {1}", results.Count, title.Title); if (ProcessSearchResults(results, title.Title)) return; } } } } catch (Exception ex) { logger.Error("Error processing CommandRequest_TvDBSearchAnime: {0} - {1}", AnimeID, ex.ToString()); return; } }
public Contract_Trakt_Activity GetTraktFriendInfo(int maxResults, bool animeOnly, bool getShouts, bool getScrobbles) { CrossRef_AniDB_TraktRepository repXrefTrakt = new CrossRef_AniDB_TraktRepository(); CrossRef_AniDB_TvDBV2Repository repXrefTvDB = new CrossRef_AniDB_TvDBV2Repository(); AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AnimeSeriesRepository repSeries = new AnimeSeriesRepository(); Trakt_FriendRepository repFriends = new Trakt_FriendRepository(); Trakt_EpisodeRepository repEpisodes = new Trakt_EpisodeRepository(); Trakt_ShowRepository repShows = new Trakt_ShowRepository(); Contract_Trakt_Activity contract = new Contract_Trakt_Activity(); contract.HasTraktAccount = true; if (string.IsNullOrEmpty(ServerSettings.Trakt_Username) || string.IsNullOrEmpty(ServerSettings.Trakt_Password)) contract.HasTraktAccount = false; contract.TraktFriends = new List<Contract_Trakt_Friend>(); contract.TraktFriendRequests = new List<Contract_Trakt_FriendFrequest>(); contract.TraktFriendActivity = new List<Contract_Trakt_FriendActivity>(); try { int i = 1; foreach (TraktTV_Activity act in StatsCache.Instance.TraktFriendActivityInfo) { if (i >= maxResults) break; if (act.ActivityAction == (int)TraktActivityAction.Scrobble && !getScrobbles) continue; if (act.ActivityAction == (int)TraktActivityAction.Shout && !getShouts) continue; Contract_Trakt_FriendActivity contractAct = new Contract_Trakt_FriendActivity(); if (act.show == null) continue; // find the anime and series based on the trakt id int? animeID = null; CrossRef_AniDB_Trakt xref = null; if (act.episode != null) xref = repXrefTrakt.GetByTraktID(act.show.TraktID, int.Parse(act.episode.season)); if (xref != null) animeID = xref.AnimeID; else { // try a rough match // since we won't always do an exact match by season List<CrossRef_AniDB_Trakt> traktXrefs = repXrefTrakt.GetByTraktID(act.show.TraktID); if (traktXrefs.Count > 0) animeID = traktXrefs[0].AnimeID; else { // try the tvdb id instead //TODO /* CrossRef_AniDB_TvDBV2 xrefTvDB = null; if (act.episode != null) xrefTvDB = repXrefTvDB.GetByTvDBID(int.Parse(act.show.tvdb_id), int.Parse(act.episode.season)); if (xrefTvDB != null) animeID = xrefTvDB.AnimeID;*/ } } // skip this activity if we can't find the anime and the user only wants to see anime related stuff if (!animeID.HasValue && animeOnly) { //TODO // however let's try and look it up on the web cache to see if it is an anime // this just might be an anime that user doesn't have in their local database continue; } // activity details contractAct.ActivityAction = act.ActivityAction; contractAct.ActivityType = act.ActivityType; contractAct.ActivityDate = Utils.GetAniDBDateAsDate(act.timestamp); if (act.elapsed != null) { contractAct.Elapsed = act.elapsed.full; contractAct.ElapsedShort = act.elapsed.shortElapsed; } Trakt_Friend traktFriend = repFriends.GetByUsername(act.user.username); if (traktFriend == null) return null; // user details contractAct.User = new Contract_Trakt_User(); contractAct.User.Trakt_FriendID = traktFriend.Trakt_FriendID; contractAct.User.Username = act.user.username; contractAct.User.Full_name = act.user.full_name; contractAct.User.Gender = act.user.gender; contractAct.User.Age = act.user.age; contractAct.User.Location = act.user.location; contractAct.User.About = act.user.about; contractAct.User.Joined = act.user.joined; contractAct.User.Avatar = act.user.avatar; contractAct.User.Url = act.user.url; contractAct.User.JoinedDate = Utils.GetAniDBDateAsDate(act.user.joined); // episode details if (act.ActivityAction == (int)TraktActivityAction.Scrobble && act.episode != null) // scrobble episode { contractAct.Episode = new Contract_Trakt_WatchedEpisode(); contractAct.Episode.AnimeSeriesID = null; contractAct.Episode.Episode_Number = act.episode.number; contractAct.Episode.Episode_Overview = act.episode.overview; contractAct.Episode.Episode_Season = act.episode.season; contractAct.Episode.Episode_Title = act.episode.title; contractAct.Episode.Episode_Url = act.episode.url; contractAct.Episode.Trakt_EpisodeID = -1; if (act.episode.images != null) contractAct.Episode.Episode_Screenshot = act.episode.images.screen; if (act.show != null) { contractAct.Episode.TraktShow = act.show.ToContract(); Trakt_Show show = repShows.GetByTraktID(act.show.TraktID); if (show != null) { Trakt_Episode episode = repEpisodes.GetByShowIDSeasonAndEpisode(show.Trakt_ShowID, int.Parse(act.episode.season), int.Parse(act.episode.number)); if (episode != null) contractAct.Episode.Trakt_EpisodeID = episode.Trakt_EpisodeID; } if (animeID.HasValue) { AnimeSeries ser = repSeries.GetByAnimeID(animeID.Value); if (ser != null) contractAct.Episode.AnimeSeriesID = ser.AnimeSeriesID; AniDB_Anime anime = repAnime.GetByAnimeID(animeID.Value); if (anime != null) contractAct.Episode.Anime = anime.ToContract(true, null); } } } // shout details if (act.ActivityAction == (int)TraktActivityAction.Shout && act.shout != null) // shout { contractAct.Shout = new Contract_Trakt_Shout(); contractAct.Shout.ShoutType = act.ActivityType; // episode or show contractAct.Shout.Text = act.shout.text; contractAct.Shout.Spoiler = act.shout.spoiler; contractAct.Shout.AnimeSeriesID = null; if (act.ActivityType == 1 && act.episode != null) // episode { contractAct.Shout.Episode_Number = act.episode.number; contractAct.Shout.Episode_Overview = act.episode.overview; contractAct.Shout.Episode_Season = act.episode.season; contractAct.Shout.Episode_Title = act.episode.title; contractAct.Shout.Episode_Url = act.episode.url; if (act.episode.images != null) contractAct.Shout.Episode_Screenshot = act.episode.images.screen; } if (act.show != null) // episode or show { if (act.episode == null) contractAct.Shout.Episode_Screenshot = act.show.images.fanart; contractAct.Shout.TraktShow = act.show.ToContract(); if (animeID.HasValue) { AnimeSeries ser = repSeries.GetByAnimeID(animeID.Value); if (ser != null) contractAct.Shout.AnimeSeriesID = ser.AnimeSeriesID; AniDB_Anime anime = repAnime.GetByAnimeID(animeID.Value); if (anime != null) contractAct.Shout.Anime = anime.ToContract(true, null); } } } contract.TraktFriendActivity.Add(contractAct); i++; } foreach (TraktTVFriendRequest req in StatsCache.Instance.TraktFriendRequests) { Contract_Trakt_FriendFrequest contractReq = req.ToContract(); contract.TraktFriendRequests.Add(contractReq); } } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); } return contract; }
// Removes all TVDB information from a series, bringing it back to a blank state. public static void RemoveLinkAniDBTvDB(int animeID, enEpisodeType aniEpType, int aniEpNumber, int tvDBID, int tvSeasonNumber, int tvEpNumber) { CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); CrossRef_AniDB_TvDBV2 xref = repCrossRef.GetByTvDBID(tvDBID, tvSeasonNumber, tvEpNumber, animeID, (int)aniEpType, aniEpNumber); if (xref == null) return; repCrossRef.Delete(xref.CrossRef_AniDB_TvDBV2ID); StatsCache.Instance.UpdateUsingAnime(animeID); CommandRequest_WebCacheDeleteXRefAniDBTvDB req = new CommandRequest_WebCacheDeleteXRefAniDBTvDB(animeID, (int)aniEpType, aniEpNumber, tvDBID, tvSeasonNumber, tvEpNumber); req.Save(); }
public static void DownloadAllEpisodes() { CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> allCrossRefs = repCrossRef.GetAll(); List<int> tvDBIDs = new List<int>(); foreach (CrossRef_AniDB_TvDBV2 xref in allCrossRefs) { if (!tvDBIDs.Contains(xref.TvDBID)) tvDBIDs.Add(xref.TvDBID); } DownloadAllEpisodes(tvDBIDs); }
public List<Contract_CrossRef_AniDB_TvDBV2> GetTVDBCrossRefV2(int animeID) { try { List<Contract_CrossRef_AniDB_TvDBV2> ret = new List<Contract_CrossRef_AniDB_TvDBV2>(); CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> xrefs = repCrossRef.GetByAnimeID(animeID); if (xrefs == null) return ret; foreach (CrossRef_AniDB_TvDBV2 xref in xrefs) ret.Add(xref.ToContract()); return ret; } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); return null; } }
public static void UpdateAllInfo(bool force) { CrossRef_AniDB_TvDBV2Repository repCrossRef = new CrossRef_AniDB_TvDBV2Repository(); List<CrossRef_AniDB_TvDBV2> allCrossRefs = repCrossRef.GetAll(); List<int> alreadyLinked = new List<int>(); foreach (CrossRef_AniDB_TvDBV2 xref in allCrossRefs) { CommandRequest_TvDBUpdateSeriesAndEpisodes cmd = new CommandRequest_TvDBUpdateSeriesAndEpisodes(xref.TvDBID, force); cmd.Save(); } }
public string LinkAniDBTvDB(int animeID, int aniEpType, int aniEpNumber, int tvDBID, int tvSeasonNumber, int tvEpNumber, int? crossRef_AniDB_TvDBV2ID) { try { CrossRef_AniDB_TvDBV2Repository repXref = new CrossRef_AniDB_TvDBV2Repository(); if (crossRef_AniDB_TvDBV2ID.HasValue) { CrossRef_AniDB_TvDBV2 xrefTemp = repXref.GetByID(crossRef_AniDB_TvDBV2ID.Value); // delete the existing one if we are updating TvDBHelper.RemoveLinkAniDBTvDB(xrefTemp.AnimeID, (enEpisodeType)xrefTemp.AniDBStartEpisodeType, xrefTemp.AniDBStartEpisodeNumber, xrefTemp.TvDBID, xrefTemp.TvDBSeasonNumber, xrefTemp.TvDBStartEpisodeNumber); } CrossRef_AniDB_TvDBV2 xref = repXref.GetByTvDBID(tvDBID, tvSeasonNumber, tvEpNumber, animeID, aniEpType, aniEpNumber); if (xref != null) { string msg = string.Format("You have already linked Anime ID {0} to this TvDB show/season/ep", xref.AnimeID); AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository(); AniDB_Anime anime = repAnime.GetByAnimeID(xref.AnimeID); if (anime != null) { msg = string.Format("You have already linked Anime {0} ({1}) to this TvDB show/season/ep", anime.MainTitle, xref.AnimeID); } return msg; } return TvDBHelper.LinkAniDBTvDB(animeID, (enEpisodeType)aniEpType, aniEpNumber, tvDBID, tvSeasonNumber, tvEpNumber, false); } catch (Exception ex) { logger.ErrorException(ex.ToString(), ex); return ex.Message; } }