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