public override void ProcessCommand()
{
try
{
CrossRef_AniDB_TraktV2Repository repCrossRef = new CrossRef_AniDB_TraktV2Repository();
CrossRef_AniDB_TraktV2 xref = repCrossRef.GetByID(CrossRef_AniDB_TraktID);
if (xref == null) return;
Trakt_ShowRepository repShow = new Trakt_ShowRepository();
Trakt_Show tvShow = repShow.GetByTraktSlug(xref.TraktID);
if (tvShow == null) return;
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
AniDB_Anime anime = repAnime.GetByAnimeID(xref.AnimeID);
if (anime == null) return;
string showName = "";
if (tvShow != null) showName = tvShow.Title;
AzureWebAPI.Send_CrossRefAniDBTrakt(xref, anime.MainTitle);
}
catch (Exception ex)
{
logger.ErrorException("Error processing CommandRequest_WebCacheSendXRefAniDBTrakt: {0}" + ex.ToString(), ex);
return;
}
}
public static bool CheckTraktValidity(string slug, bool removeDBEntries)
{
try
{
// get all the shows from the database and make sure they are still valid Trakt Slugs
Trakt_ShowRepository repShows = new Trakt_ShowRepository();
Trakt_Show show = repShows.GetByTraktSlug(slug);
// let's check if we can get this show on Trakt
int traktCode = TraktStatusCodes.Success;
// note - getting extended show info also updates it as well
TraktV2ShowExtended showOnline = GetShowInfoV2(show.TraktID, ref traktCode);
if (showOnline == null && traktCode == TraktStatusCodes.Not_Found)
{
if (removeDBEntries)
{
logger.Info("TRAKT_CLEANUP: Could not find '{0}' on Trakt so starting removal from database", show.TraktID);
RemoveTraktDBEntries(show);
}
return false;
}
return true;
}
catch (Exception ex)
{
logger.ErrorException("Error in TraktTVHelper.CleanupDatabase: " + ex.ToString(), ex);
return false;
}
}
public static void SaveExtendedShowInfoV2(TraktV2ShowExtended tvshow, List<TraktV2Season> seasons)
{
try
{
// save this data to the DB for use later
Trakt_ImageFanartRepository repFanart = new Trakt_ImageFanartRepository();
Trakt_ShowRepository repShows = new Trakt_ShowRepository();
Trakt_Show show = repShows.GetByTraktSlug(tvshow.ids.slug);
if (show == null)
show = new Trakt_Show();
show.Populate(tvshow);
repShows.Save(show);
if (tvshow.images != null && tvshow.images.fanart != null)
{
if (!string.IsNullOrEmpty(tvshow.images.fanart.full))
{
Trakt_ImageFanart fanart = repFanart.GetByShowIDAndSeason(show.Trakt_ShowID, 1);
if (fanart == null)
{
fanart = new Trakt_ImageFanart();
fanart.Enabled = 0;
}
fanart.ImageURL = tvshow.images.fanart.full;
fanart.Season = 1;
fanart.Trakt_ShowID = show.Trakt_ShowID;
repFanart.Save(fanart);
}
}
// save the seasons
Trakt_SeasonRepository repSeasons = new Trakt_SeasonRepository();
Trakt_EpisodeRepository repEpisodes = new Trakt_EpisodeRepository();
Trakt_ImagePosterRepository repPosters = new Trakt_ImagePosterRepository();
// delete episodes if they no longer exist on Trakt
if (seasons.Count > 0)
{
foreach (Trakt_Episode epTemp in repEpisodes.GetByShowID(show.Trakt_ShowID))
{
TraktV2Episode ep = null;
TraktV2Season sea = seasons.FirstOrDefault(x => x.number == epTemp.Season);
if (sea != null)
ep = sea.episodes.FirstOrDefault(x => x.number == epTemp.EpisodeNumber);
// if the episode is null, it means it doesn't exist on Trakt, so we should delete it
if (ep == null)
repEpisodes.Delete(epTemp.Trakt_EpisodeID);
}
}
foreach (TraktV2Season sea in seasons)
{
Trakt_Season season = repSeasons.GetByShowIDAndSeason(show.Trakt_ShowID, sea.number);
if (season == null)
season = new Trakt_Season();
season.Season = sea.number;
season.URL = string.Format(TraktURIs.WebsiteSeason, show.TraktID, sea.number);
season.Trakt_ShowID = show.Trakt_ShowID;
repSeasons.Save(season);
if (sea.images != null && sea.images.poster != null)
{
if (!string.IsNullOrEmpty(sea.images.poster.full))
{
Trakt_ImagePoster poster = repPosters.GetByShowIDAndSeason(show.Trakt_ShowID, season.Season);
if (poster == null)
{
poster = new Trakt_ImagePoster();
poster.Enabled = 0;
}
poster.ImageURL = sea.images.poster.full;
poster.Season = season.Season;
poster.Trakt_ShowID = show.Trakt_ShowID;
repPosters.Save(poster);
}
}
if (sea.episodes != null)
{
foreach (TraktV2Episode ep in sea.episodes)
{
Trakt_Episode episode = repEpisodes.GetByShowIDSeasonAndEpisode(show.Trakt_ShowID, ep.season, ep.number);
if (episode == null)
episode = new Trakt_Episode();
Console.Write(ep.ids.trakt);
if (ep.images.screenshot != null)
episode.EpisodeImage = ep.images.screenshot.full;
else
episode.EpisodeImage = string.Empty;
episode.TraktID = ep.ids.TraktID;
episode.EpisodeNumber = ep.number;
episode.Overview = string.Empty; // this is now part of a separate API call for V2, we get this info from TvDB anyway
episode.Season = ep.season;
episode.Title = ep.title;
episode.URL = string.Format(TraktURIs.WebsiteEpisode, show.TraktID, ep.season, ep.number);
episode.Trakt_ShowID = show.Trakt_ShowID;
repEpisodes.Save(episode);
}
}
}
}
catch (Exception ex)
{
logger.ErrorException("Error in TraktTVHelper.SaveExtendedShowInfo: " + ex.ToString(), ex);
}
}
public static string LinkAniDBTrakt(ISession session, int animeID, enEpisodeType aniEpType, int aniEpNumber, string traktID, int seasonNumber, int traktEpNumber, bool excludeFromWebCache)
{
CrossRef_AniDB_TraktV2Repository repCrossRef = new CrossRef_AniDB_TraktV2Repository();
List<CrossRef_AniDB_TraktV2> xrefTemps = repCrossRef.GetByAnimeIDEpTypeEpNumber(session, animeID, (int)aniEpType, aniEpNumber);
if (xrefTemps != null && xrefTemps.Count > 0)
{
foreach (CrossRef_AniDB_TraktV2 xrefTemp in xrefTemps)
{
// delete the existing one if we are updating
TraktTVHelper.RemoveLinkAniDBTrakt(xrefTemp.AnimeID, (enEpisodeType)xrefTemp.AniDBStartEpisodeType, xrefTemp.AniDBStartEpisodeNumber,
xrefTemp.TraktID, xrefTemp.TraktSeasonNumber, xrefTemp.TraktStartEpisodeNumber);
}
}
// check if we have this information locally
// if not download it now
Trakt_ShowRepository repSeries = new Trakt_ShowRepository();
Trakt_Show traktShow = repSeries.GetByTraktSlug(traktID);
if (traktShow == null)
{
// we download the series info here just so that we have the basic info in the
// database before the queued task runs later
TraktV2ShowExtended tvshow = GetShowInfoV2(traktID);
}
// download and update series info, episode info and episode images
// will also download fanart, posters and wide banners
// download fanart, posters
DownloadAllImages(traktID);
CrossRef_AniDB_TraktV2 xref = repCrossRef.GetByTraktID(session, traktID, seasonNumber, traktEpNumber, animeID, (int)aniEpType, aniEpNumber);
if (xref == null)
xref = new CrossRef_AniDB_TraktV2();
xref.AnimeID = animeID;
xref.AniDBStartEpisodeType = (int)aniEpType;
xref.AniDBStartEpisodeNumber = aniEpNumber;
xref.TraktID = traktID;
xref.TraktSeasonNumber = seasonNumber;
xref.TraktStartEpisodeNumber = traktEpNumber;
if (traktShow != null)
xref.TraktTitle = traktShow.Title;
if (excludeFromWebCache)
xref.CrossRefSource = (int)CrossRefSource.WebCache;
else
xref.CrossRefSource = (int)CrossRefSource.User;
repCrossRef.Save(xref);
StatsCache.Instance.UpdateUsingAnime(animeID);
logger.Trace("Changed trakt association: {0}", animeID);
if (!excludeFromWebCache && ServerSettings.WebCache_Trakt_Send)
{
CommandRequest_WebCacheSendXRefAniDBTrakt req = new CommandRequest_WebCacheSendXRefAniDBTrakt(xref.CrossRef_AniDB_TraktV2ID);
req.Save();
}
return "";
}
public static void DownloadAllImages(string traktID)
{
try
{
//now download the images
Trakt_ShowRepository repShow = new Trakt_ShowRepository();
Trakt_Show show = repShow.GetByTraktSlug(traktID);
if (show == null) return;
if (ServerSettings.Trakt_DownloadFanart)
{
//download the fanart image for the show
Trakt_ImageFanartRepository repFanart = new Trakt_ImageFanartRepository();
Trakt_ImageFanart fanart = repFanart.GetByShowIDAndSeason(show.Trakt_ShowID, 1);
if (fanart != null)
{
if (!string.IsNullOrEmpty(fanart.FullImagePath))
{
if (!File.Exists(fanart.FullImagePath))
{
CommandRequest_DownloadImage cmd = new CommandRequest_DownloadImage(fanart.Trakt_ImageFanartID, JMMImageType.Trakt_Fanart, false);
cmd.Save();
}
}
}
}
// download the posters for seasons
Trakt_ImagePosterRepository repPosters = new Trakt_ImagePosterRepository();
foreach (Trakt_Season season in show.Seasons)
{
if (ServerSettings.Trakt_DownloadPosters)
{
Trakt_ImagePoster poster = repPosters.GetByShowIDAndSeason(season.Trakt_ShowID, season.Season);
if (poster != null)
{
if (!string.IsNullOrEmpty(poster.FullImagePath))
{
if (!File.Exists(poster.FullImagePath))
{
CommandRequest_DownloadImage cmd = new CommandRequest_DownloadImage(poster.Trakt_ImagePosterID, JMMImageType.Trakt_Poster, false);
cmd.Save();
}
}
}
}
if (ServerSettings.Trakt_DownloadEpisodes)
{
// download the screenshots for episodes
foreach (Trakt_Episode ep in season.Episodes)
{
if (!string.IsNullOrEmpty(ep.FullImagePath))
{
if (!File.Exists(ep.FullImagePath))
{
CommandRequest_DownloadImage cmd = new CommandRequest_DownloadImage(ep.Trakt_EpisodeID, JMMImageType.Trakt_Episode, false);
cmd.Save();
}
}
}
}
}
}
catch (Exception ex)
{
logger.ErrorException("Error in TraktTVHelper.UpdateAllInfoAndImages: " + ex.ToString(), ex);
}
}
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;
}
}
public List<int> GetSeasonNumbersForTrakt(string traktID)
{
List<int> seasonNumbers = new List<int>();
try
{
// refresh show info including season numbers from trakt
TraktV2ShowExtended tvshow = TraktTVHelper.GetShowInfoV2(traktID);
Trakt_ShowRepository repShows = new Trakt_ShowRepository();
Trakt_Show show = repShows.GetByTraktSlug(traktID);
if (show == null) return seasonNumbers;
foreach (Trakt_Season season in show.Seasons)
seasonNumbers.Add(season.Season);
return seasonNumbers;
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
return seasonNumbers;
}
}
public Contract_AniDB_AnimeCrossRefs GetCrossRefDetails(int animeID)
{
Contract_AniDB_AnimeCrossRefs result = new Contract_AniDB_AnimeCrossRefs();
result.AnimeID = animeID;
try
{
using (var session = JMMService.SessionFactory.OpenSession())
{
TvDB_SeriesRepository repSeries = new TvDB_SeriesRepository();
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
AniDB_Anime anime = repAnime.GetByAnimeID(animeID);
if (anime == null) return result;
TvDB_ImageFanartRepository repFanart = new TvDB_ImageFanartRepository();
TvDB_ImagePosterRepository repPosters = new TvDB_ImagePosterRepository();
TvDB_ImageWideBannerRepository repBanners = new TvDB_ImageWideBannerRepository();
// TvDB
foreach (CrossRef_AniDB_TvDBV2 xref in anime.GetCrossRefTvDBV2())
{
result.CrossRef_AniDB_TvDB.Add(xref.ToContract());
TvDB_Series ser = repSeries.GetByTvDBID(session, xref.TvDBID);
if (ser != null)
result.TvDBSeries.Add(ser.ToContract());
foreach (TvDB_Episode ep in anime.GetTvDBEpisodes())
result.TvDBEpisodes.Add(ep.ToContract());
foreach (TvDB_ImageFanart fanart in repFanart.GetBySeriesID(session, xref.TvDBID))
result.TvDBImageFanarts.Add(fanart.ToContract());
foreach (TvDB_ImagePoster poster in repPosters.GetBySeriesID(session, xref.TvDBID))
result.TvDBImagePosters.Add(poster.ToContract());
foreach (TvDB_ImageWideBanner banner in repBanners.GetBySeriesID(xref.TvDBID))
result.TvDBImageWideBanners.Add(banner.ToContract());
}
// Trakt
Trakt_ImageFanartRepository repTraktFanart = new Trakt_ImageFanartRepository();
Trakt_ImagePosterRepository repTraktPosters = new Trakt_ImagePosterRepository();
Trakt_ShowRepository repTrakt = new Trakt_ShowRepository();
foreach (CrossRef_AniDB_TraktV2 xref in anime.GetCrossRefTraktV2())
{
result.CrossRef_AniDB_Trakt.Add(xref.ToContract());
Trakt_Show show = repTrakt.GetByTraktSlug(session, xref.TraktID);
if (show != null)
{
result.TraktShows.Add(show.ToContract());
foreach (Trakt_ImageFanart fanart in repTraktFanart.GetByShowID(session, show.Trakt_ShowID))
result.TraktImageFanarts.Add(fanart.ToContract());
foreach (Trakt_ImagePoster poster in repTraktPosters.GetByShowID(session, show.Trakt_ShowID))
result.TraktImagePosters.Add(poster.ToContract());
}
}
// MovieDB
CrossRef_AniDB_Other xrefMovie = anime.GetCrossRefMovieDB();
if (xrefMovie == null)
result.CrossRef_AniDB_MovieDB = null;
else
result.CrossRef_AniDB_MovieDB = xrefMovie.ToContract();
MovieDB_Movie movie = anime.GetMovieDBMovie();
if (movie == null)
result.MovieDBMovie = null;
else
result.MovieDBMovie = movie.ToContract();
foreach (MovieDB_Fanart fanart in anime.GetMovieDBFanarts())
{
if (fanart.ImageSize.Equals(Constants.MovieDBImageSize.Original, StringComparison.InvariantCultureIgnoreCase))
result.MovieDBFanarts.Add(fanart.ToContract());
}
foreach (MovieDB_Poster poster in anime.GetMovieDBPosters())
{
if (poster.ImageSize.Equals(Constants.MovieDBImageSize.Original, StringComparison.InvariantCultureIgnoreCase))
result.MovieDBPosters.Add(poster.ToContract());
}
// MAL
List<CrossRef_AniDB_MAL> xrefMAL = anime.GetCrossRefMAL();
if (xrefMAL == null)
result.CrossRef_AniDB_MAL = null;
else
{
result.CrossRef_AniDB_MAL = new List<Contract_CrossRef_AniDB_MAL>();
foreach (CrossRef_AniDB_MAL xrefTemp in xrefMAL)
result.CrossRef_AniDB_MAL.Add(xrefTemp.ToContract());
}
}
return result;
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
return result;
}
}
public List<Contract_Trakt_Episode> GetAllTraktEpisodesByTraktID(string traktID)
{
List<Contract_Trakt_Episode> allEps = new List<Contract_Trakt_Episode>();
try
{
Trakt_ShowRepository repShows = new Trakt_ShowRepository();
Trakt_Show show = repShows.GetByTraktSlug(traktID);
if (show != null)
allEps = GetAllTraktEpisodes(show.Trakt_ShowID);
return allEps;
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
return allEps;
}
}
public Trakt_Show GetByTraktShow(ISession session)
{
Trakt_ShowRepository repTraktShows = new Trakt_ShowRepository();
return repTraktShows.GetByTraktSlug(session, TraktID);
}
private void PopulateTraktDetails()
{
try
{
Trakt_ShowRepository repShows = new Trakt_ShowRepository();
Show = repShows.GetByTraktSlug(TraktID);
if (Show == null) return;
Trakt_EpisodeRepository repTvEps = new Trakt_EpisodeRepository();
traktEpisodes = repTvEps.GetByShowID(Show.Trakt_ShowID);
if (traktEpisodes.Count > 0)
{
List<SortPropOrFieldAndDirection> sortCriteria = new List<SortPropOrFieldAndDirection>();
sortCriteria.Add(new SortPropOrFieldAndDirection("Season", false, SortType.eInteger));
sortCriteria.Add(new SortPropOrFieldAndDirection("EpisodeNumber", false, SortType.eInteger));
traktEpisodes = Sorting.MultiSort<Trakt_Episode>(traktEpisodes, sortCriteria);
}
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
}
