public override void ProcessCommand()
{
logger.Info("Processing CommandRequest_SyncMyVotes");
try
{
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
AniDBHTTPCommand_GetVotes cmd = new AniDBHTTPCommand_GetVotes();
cmd.Init(ServerSettings.AniDB_Username, ServerSettings.AniDB_Password);
enHelperActivityType ev = cmd.Process();
if (ev == enHelperActivityType.GotVotesHTTP)
{
foreach (Raw_AniDB_Vote_HTTP myVote in cmd.MyVotes)
{
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(myVote.EntityID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
// we can only have anime permanent or anime temp but not both
if (myVote.VoteType == enAniDBVoteType.Anime || myVote.VoteType == enAniDBVoteType.AnimeTemp)
{
if (dbVote.VoteType == (int)enAniDBVoteType.Anime || dbVote.VoteType == (int)enAniDBVoteType.AnimeTemp)
{
thisVote = dbVote;
}
}
else
{
thisVote = dbVote;
}
}
if (thisVote == null)
{
thisVote = new AniDB_Vote();
thisVote.EntityID = myVote.EntityID;
}
thisVote.VoteType = (int)myVote.VoteType;
thisVote.VoteValue = myVote.VoteValue;
repVotes.Save(thisVote);
if (myVote.VoteType == enAniDBVoteType.Anime || myVote.VoteType == enAniDBVoteType.AnimeTemp)
{
// download the anime info if the user doesn't already have it
CommandRequest_GetAnimeHTTP cmdAnime = new CommandRequest_GetAnimeHTTP(thisVote.EntityID, false, false);
cmdAnime.Save();
}
}
logger.Info("Processed Votes: {0} Items", cmd.MyVotes.Count);
}
}
catch (Exception ex)
{
logger.Error("Error processing CommandRequest_SyncMyVotes: {0} ", ex.ToString());
return;
}
}
public void VoteAnimeRevoke(int animeID)
{
// lets save to the database and assume it will work
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(animeID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
// we can only have anime permanent or anime temp but not both
if (dbVote.VoteType == (int)enAniDBVoteType.Anime || dbVote.VoteType == (int)enAniDBVoteType.AnimeTemp)
{
thisVote = dbVote;
}
}
if (thisVote == null) return;
CommandRequest_VoteAnime cmdVote = new CommandRequest_VoteAnime(animeID, thisVote.VoteType, -1);
cmdVote.Save();
repVotes.Delete(thisVote.AniDB_VoteID);
}
public Contract_AniDBVote GetUserVote(int animeID)
{
try
{
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(animeID);
if (dbVotes.Count == 0) return null;
return dbVotes[0].ToContract();
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return null;
}
/// <summary>
///
/// </summary>
/// <param name="animeID"></param>
/// <param name="voteValue">Must be 1 or 2 (Anime or Anime Temp(</param>
/// <param name="voteType"></param>
public void VoteAnime(int animeID, decimal voteValue, int voteType)
{
string msg = string.Format("Voting for anime: {0} - Value: {1}", animeID, voteValue);
logger.Info(msg);
// lets save to the database and assume it will work
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(animeID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
// we can only have anime permanent or anime temp but not both
if (voteType == (int)enAniDBVoteType.Anime || voteType == (int)enAniDBVoteType.AnimeTemp)
{
if (dbVote.VoteType == (int)enAniDBVoteType.Anime || dbVote.VoteType == (int)enAniDBVoteType.AnimeTemp)
{
thisVote = dbVote;
}
}
else
{
thisVote = dbVote;
}
}
if (thisVote == null)
{
thisVote = new AniDB_Vote();
thisVote.EntityID = animeID;
}
thisVote.VoteType = voteType;
int iVoteValue = 0;
if (voteValue > 0)
iVoteValue = (int)(voteValue * 100);
else
iVoteValue = (int)voteValue;
msg = string.Format("Voting for anime Formatted: {0} - Value: {1}", animeID, iVoteValue);
logger.Info(msg);
thisVote.VoteValue = iVoteValue;
repVotes.Save(thisVote);
CommandRequest_VoteAnime cmdVote = new CommandRequest_VoteAnime(animeID, voteType, voteValue);
cmdVote.Save();
}
public List<Contract_AnimeRating> GetAnimeRatings(int collectionState, int watchedState, int ratingVotedState, int userID)
{
List<Contract_AnimeRating> contracts = new List<Contract_AnimeRating>();
try
{
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
List<AnimeSeries> series = repSeries.GetAll();
Dictionary<int, AnimeSeries> dictSeries = new Dictionary<int, AnimeSeries>();
foreach (AnimeSeries ser in series)
dictSeries[ser.AniDB_ID] = ser;
RatingCollectionState _collectionState = (RatingCollectionState)collectionState;
RatingWatchedState _watchedState = (RatingWatchedState)watchedState;
RatingVotedState _ratingVotedState = (RatingVotedState)ratingVotedState;
DateTime start = DateTime.Now;
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
/*
// build a dictionary of categories
AniDB_CategoryRepository repCats = new AniDB_CategoryRepository();
AniDB_Anime_CategoryRepository repAnimeCat = new AniDB_Anime_CategoryRepository();
List<AniDB_Category> allCatgeories = repCats.GetAll();
Dictionary<int, AniDB_Category> allCatgeoriesDict = new Dictionary<int, AniDB_Category>();
foreach (AniDB_Category cat in allCatgeories)
allCatgeoriesDict[cat.CategoryID] = cat;
List<AniDB_Anime_Category> allAnimeCatgeories = repAnimeCat.GetAll();
Dictionary<int, List<AniDB_Anime_Category>> allAnimeCatgeoriesDict = new Dictionary<int, List<AniDB_Anime_Category>>(); //
foreach (AniDB_Anime_Category aniCat in allAnimeCatgeories)
{
if (!allAnimeCatgeoriesDict.ContainsKey(aniCat.AnimeID))
allAnimeCatgeoriesDict[aniCat.AnimeID] = new List<AniDB_Anime_Category>();
allAnimeCatgeoriesDict[aniCat.AnimeID].Add(aniCat);
}
// build a dictionary of titles
AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository();
List<AniDB_Anime_Title> allTitles = repTitles.GetAll();
Dictionary<int, List<AniDB_Anime_Title>> allTitlesDict = new Dictionary<int, List<AniDB_Anime_Title>>();
foreach (AniDB_Anime_Title title in allTitles)
{
if (!allTitlesDict.ContainsKey(title.AnimeID))
allTitlesDict[title.AnimeID] = new List<AniDB_Anime_Title>();
allTitlesDict[title.AnimeID].Add(title);
}
// build a dictionary of tags
AniDB_TagRepository repTags = new AniDB_TagRepository();
AniDB_Anime_TagRepository repAnimeTag = new AniDB_Anime_TagRepository();
List<AniDB_Tag> allTags = repTags.GetAll();
Dictionary<int, AniDB_Tag> allTagsDict = new Dictionary<int, AniDB_Tag>();
foreach (AniDB_Tag tag in allTags)
allTagsDict[tag.TagID] = tag;
List<AniDB_Anime_Tag> allAnimeTags = repAnimeTag.GetAll();
Dictionary<int, List<AniDB_Anime_Tag>> allAnimeTagsDict = new Dictionary<int, List<AniDB_Anime_Tag>>(); //
foreach (AniDB_Anime_Tag aniTag in allAnimeTags)
{
if (!allAnimeTagsDict.ContainsKey(aniTag.AnimeID))
allAnimeTagsDict[aniTag.AnimeID] = new List<AniDB_Anime_Tag>();
allAnimeTagsDict[aniTag.AnimeID].Add(aniTag);
}
// build a dictionary of languages
AdhocRepository rep = new AdhocRepository();
Dictionary<int, LanguageStat> dictAudioStats = rep.GetAudioLanguageStatsForAnime();
Dictionary<int, LanguageStat> dictSubtitleStats = rep.GetSubtitleLanguageStatsForAnime();
Dictionary<int, string> dictAnimeVideoQualStats = rep.GetAllVideoQualityByAnime();
Dictionary<int, AnimeVideoQualityStat> dictAnimeEpisodeVideoQualStats = rep.GetEpisodeVideoQualityStatsByAnime();
* */
List<AniDB_Anime> animes = repAnime.GetAll();
// user votes
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> allVotes = repVotes.GetAll();
JMMUserRepository repUsers = new JMMUserRepository();
JMMUser user = repUsers.GetByID(userID);
if (user == null) return contracts;
int i = 0;
foreach (AniDB_Anime anime in animes)
{
i++;
// evaluate collection states
if (_collectionState == RatingCollectionState.AllEpisodesInMyCollection)
{
if (!anime.FinishedAiring) continue;
if (!dictSeries.ContainsKey(anime.AnimeID)) continue;
if (dictSeries[anime.AnimeID].MissingEpisodeCount > 0) continue;
}
if (_collectionState == RatingCollectionState.InMyCollection)
if (!dictSeries.ContainsKey(anime.AnimeID)) continue;
if (_collectionState == RatingCollectionState.NotInMyCollection)
if (dictSeries.ContainsKey(anime.AnimeID)) continue;
if (!user.AllowedAnime(anime)) continue;
// evaluate watched states
if (_watchedState == RatingWatchedState.AllEpisodesWatched)
{
if (!dictSeries.ContainsKey(anime.AnimeID)) continue;
AnimeSeries_User userRec = dictSeries[anime.AnimeID].GetUserRecord(userID);
if (userRec == null) continue;
if (userRec.UnwatchedEpisodeCount > 0) continue;
}
if (_watchedState == RatingWatchedState.NotWatched)
{
if (dictSeries.ContainsKey(anime.AnimeID))
{
AnimeSeries_User userRec = dictSeries[anime.AnimeID].GetUserRecord(userID);
if (userRec != null)
{
if (userRec.UnwatchedEpisodeCount == 0) continue;
}
}
}
// evaluate voted states
if (_ratingVotedState == RatingVotedState.Voted)
{
bool voted = false;
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
voted = true;
break;
}
}
if (!voted) continue;
}
if (_ratingVotedState == RatingVotedState.NotVoted)
{
bool voted = false;
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
voted = true;
break;
}
}
if (voted) continue;
}
Contract_AnimeRating contract = new Contract_AnimeRating();
contract.AnimeID = anime.AnimeID;
Contract_AniDB_AnimeDetailed contractAnimeDetailed = new Contract_AniDB_AnimeDetailed();
contractAnimeDetailed.AnimeTitles = new List<Contract_AnimeTitle>();
contractAnimeDetailed.Tags = new List<Contract_AnimeTag>();
contractAnimeDetailed.CustomTags = new List<Contract_CustomTag>();
contractAnimeDetailed.UserVote = null;
contractAnimeDetailed.AniDBAnime = anime.ToContract();
// get user vote
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
contractAnimeDetailed.UserVote = vote.ToContract();
break;
}
}
contract.AnimeDetailed = contractAnimeDetailed;
if (dictSeries.ContainsKey(anime.AnimeID))
{
contract.AnimeSeries = dictSeries[anime.AnimeID].ToContract(dictSeries[anime.AnimeID].GetUserRecord(userID));
}
contracts.Add(contract);
}
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return contracts;
}
/// <summary>
/// Returns a list of recommendations based on the users votes
/// </summary>
/// <param name="maxResults"></param>
/// <param name="userID"></param>
/// <param name="recommendationType">1 = to watch, 2 = to download</param>
public List<Contract_Recommendation> GetRecommendations(int maxResults, int userID, int recommendationType)
{
List<Contract_Recommendation> recs = new List<Contract_Recommendation>();
try
{
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
JMMUserRepository repUsers = new JMMUserRepository();
JMMUser juser = repUsers.GetByID(userID);
if (juser == null) return recs;
// get all the anime the user has chosen to ignore
int ignoreType = 1;
switch (recommendationType)
{
case 1: ignoreType = 1; break;
case 2: ignoreType = 2; break;
}
IgnoreAnimeRepository repIgnore = new IgnoreAnimeRepository();
List<IgnoreAnime> ignored = repIgnore.GetByUserAndType(userID, ignoreType);
Dictionary<int, IgnoreAnime> dictIgnored = new Dictionary<int, Entities.IgnoreAnime>();
foreach (IgnoreAnime ign in ignored)
dictIgnored[ign.AnimeID] = ign;
// find all the series which the user has rated
List<AniDB_Vote> allVotes = repVotes.GetAll();
if (allVotes.Count == 0) return recs;
// sort by the highest rated
List<SortPropOrFieldAndDirection> sortCriteria = new List<SortPropOrFieldAndDirection>();
sortCriteria.Add(new SortPropOrFieldAndDirection("VoteValue", true, SortType.eInteger));
allVotes = Sorting.MultiSort<AniDB_Vote>(allVotes, sortCriteria);
Dictionary<int, Contract_Recommendation> dictRecs = new Dictionary<int, Contract_Recommendation>();
List<AniDB_Vote> animeVotes = new List<AniDB_Vote>();
foreach (AniDB_Vote vote in allVotes)
{
if (vote.VoteType != (int)enAniDBVoteType.Anime && vote.VoteType != (int)enAniDBVoteType.AnimeTemp) continue;
if (dictIgnored.ContainsKey(vote.EntityID)) continue;
// check if the user has this anime
AniDB_Anime anime = repAnime.GetByAnimeID(vote.EntityID);
if (anime == null) continue;
// get similar anime
List<AniDB_Anime_Similar> simAnime = anime.GetSimilarAnime();
// sort by the highest approval
sortCriteria = new List<SortPropOrFieldAndDirection>();
sortCriteria.Add(new SortPropOrFieldAndDirection("ApprovalPercentage", true, SortType.eDoubleOrFloat));
simAnime = Sorting.MultiSort<AniDB_Anime_Similar>(simAnime, sortCriteria);
foreach (AniDB_Anime_Similar link in simAnime)
{
if (dictIgnored.ContainsKey(link.SimilarAnimeID)) continue;
AniDB_Anime animeLink = repAnime.GetByAnimeID(link.SimilarAnimeID);
if (animeLink != null)
if (!juser.AllowedAnime(animeLink)) continue;
// don't recommend to watch anime that the user doesn't have
if (animeLink == null && recommendationType == 1) continue;
// don't recommend to watch series that the user doesn't have
AnimeSeries ser = repSeries.GetByAnimeID(link.SimilarAnimeID);
if (ser == null && recommendationType == 1) continue;
if (ser != null)
{
// don't recommend to watch series that the user has already started watching
AnimeSeries_User userRecord = ser.GetUserRecord(userID);
if (userRecord != null)
{
if (userRecord.WatchedEpisodeCount > 0 && recommendationType == 1) continue;
}
// don't recommend to download anime that the user has files for
if (ser.LatestLocalEpisodeNumber > 0 && recommendationType == 2) continue;
}
Contract_Recommendation rec = new Contract_Recommendation();
rec.BasedOnAnimeID = anime.AnimeID;
rec.RecommendedAnimeID = link.SimilarAnimeID;
// if we don't have the anime locally. lets assume the anime has a high rating
decimal animeRating = 850;
if (animeLink != null) animeRating = animeLink.AniDBRating;
rec.Score = CalculateRecommendationScore(vote.VoteValue, link.ApprovalPercentage, animeRating);
rec.BasedOnVoteValue = vote.VoteValue;
rec.RecommendedApproval = link.ApprovalPercentage;
// check if we have added this recommendation before
// this might happen where animes are recommended based on different votes
// and could end up with different scores
if (dictRecs.ContainsKey(rec.RecommendedAnimeID))
{
if (rec.Score < dictRecs[rec.RecommendedAnimeID].Score) continue;
}
rec.Recommended_AniDB_Anime = null;
if (animeLink != null)
rec.Recommended_AniDB_Anime = animeLink.ToContract();
rec.BasedOn_AniDB_Anime = anime.ToContract();
rec.Recommended_AnimeSeries = null;
if (ser != null)
rec.Recommended_AnimeSeries = ser.ToContract(ser.GetUserRecord(userID));
AnimeSeries serBasedOn = repSeries.GetByAnimeID(anime.AnimeID);
if (serBasedOn == null) continue;
rec.BasedOn_AnimeSeries = serBasedOn.ToContract(serBasedOn.GetUserRecord(userID));
dictRecs[rec.RecommendedAnimeID] = rec;
}
}
List<Contract_Recommendation> tempRecs = new List<Contract_Recommendation>();
foreach (Contract_Recommendation rec in dictRecs.Values)
tempRecs.Add(rec);
// sort by the highest score
sortCriteria = new List<SortPropOrFieldAndDirection>();
sortCriteria.Add(new SortPropOrFieldAndDirection("Score", true, SortType.eDoubleOrFloat));
tempRecs = Sorting.MultiSort<Contract_Recommendation>(tempRecs, sortCriteria);
int numRecs = 0;
foreach (Contract_Recommendation rec in tempRecs)
{
if (numRecs == maxResults) break;
recs.Add(rec);
numRecs++;
}
if (recs.Count == 0) return recs;
return recs;
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
return recs;
}
}
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<Contract_AniDB_AnimeDetailed> GetAllAnimeDetailed()
{
List<Contract_AniDB_AnimeDetailed> contracts = new List<Contract_AniDB_AnimeDetailed>();
int countElements = 0;
try
{
DateTime start = DateTime.Now;
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
// build a dictionary of titles
AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository();
List<AniDB_Anime_Title> allTitles = repTitles.GetAll();
Dictionary<int, List<AniDB_Anime_Title>> allTitlesDict = new Dictionary<int, List<AniDB_Anime_Title>>();
foreach (AniDB_Anime_Title title in allTitles)
{
if (!allTitlesDict.ContainsKey(title.AnimeID))
allTitlesDict[title.AnimeID] = new List<AniDB_Anime_Title>();
allTitlesDict[title.AnimeID].Add(title);
}
// build a dictionary of tags
AniDB_TagRepository repTags = new AniDB_TagRepository();
AniDB_Anime_TagRepository repAnimeTag = new AniDB_Anime_TagRepository();
List<AniDB_Tag> allTags = repTags.GetAll();
Dictionary<int, AniDB_Tag> allTagsDict = new Dictionary<int, AniDB_Tag>();
foreach (AniDB_Tag tag in allTags)
allTagsDict[tag.TagID] = tag;
List<AniDB_Anime_Tag> allAnimeTags = repAnimeTag.GetAll();
Dictionary<int, List<AniDB_Anime_Tag>> allAnimeTagsDict = new Dictionary<int, List<AniDB_Anime_Tag>>(); //
foreach (AniDB_Anime_Tag aniTag in allAnimeTags)
{
if (!allAnimeTagsDict.ContainsKey(aniTag.AnimeID))
allAnimeTagsDict[aniTag.AnimeID] = new List<AniDB_Anime_Tag>();
allAnimeTagsDict[aniTag.AnimeID].Add(aniTag);
}
// build a dictionary of custom tags
CustomTagRepository repCustomTags = new CustomTagRepository();
CrossRef_CustomTagRepository repXRefCustomTags = new CrossRef_CustomTagRepository();
List<CustomTag> allCustomTags = repCustomTags.GetAll();
Dictionary<int, CustomTag> allCustomTagsDict = new Dictionary<int, CustomTag>();
foreach (CustomTag tag in allCustomTags)
allCustomTagsDict[tag.CustomTagID] = tag;
List<CrossRef_CustomTag> allCustomTagsXRefs = repXRefCustomTags.GetAll();
Dictionary<int, List<CrossRef_CustomTag>> allCustomTagsXRefDict = new Dictionary<int, List<CrossRef_CustomTag>>(); //
foreach (CrossRef_CustomTag aniTag in allCustomTagsXRefs)
{
if (!allCustomTagsXRefDict.ContainsKey(aniTag.CrossRefID))
allCustomTagsXRefDict[aniTag.CrossRefID] = new List<CrossRef_CustomTag>();
allCustomTagsXRefDict[aniTag.CrossRefID].Add(aniTag);
}
// build a dictionary of languages
AdhocRepository rep = new AdhocRepository();
Dictionary<int, LanguageStat> dictAudioStats = rep.GetAudioLanguageStatsForAnime();
Dictionary<int, LanguageStat> dictSubtitleStats = rep.GetSubtitleLanguageStatsForAnime();
Dictionary<int, string> dictAnimeVideoQualStats = rep.GetAllVideoQualityByAnime();
Dictionary<int, AnimeVideoQualityStat> dictAnimeEpisodeVideoQualStats = rep.GetEpisodeVideoQualityStatsByAnime();
List<AniDB_Anime> animes = repAnime.GetAll();
// user votes
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> allVotes = repVotes.GetAll();
int i = 0;
foreach (AniDB_Anime anime in animes)
{
i++;
//if (i >= 10) continue;
countElements++;
Contract_AniDB_AnimeDetailed contract = new Contract_AniDB_AnimeDetailed();
contract.AnimeTitles = new List<Contract_AnimeTitle>();
contract.Tags = new List<Contract_AnimeTag>();
contract.CustomTags = new List<Contract_CustomTag>();
contract.UserVote = null;
contract.AniDBAnime = anime.ToContract();
if (dictAnimeVideoQualStats.ContainsKey(anime.AnimeID))
contract.Stat_AllVideoQuality = dictAnimeVideoQualStats[anime.AnimeID];
else contract.Stat_AllVideoQuality = "";
contract.Stat_AllVideoQuality_Episodes = "";
// All Video Quality Episodes
// Try to determine if this anime has all the episodes available at a certain video quality
// e.g. the series has all episodes in blu-ray
if (dictAnimeEpisodeVideoQualStats.ContainsKey(anime.AnimeID))
{
AnimeVideoQualityStat stat = dictAnimeEpisodeVideoQualStats[anime.AnimeID];
foreach (KeyValuePair<string, int> kvp in stat.VideoQualityEpisodeCount)
{
if (kvp.Value >= anime.EpisodeCountNormal)
{
if (contract.Stat_AllVideoQuality_Episodes.Length > 0) contract.Stat_AllVideoQuality_Episodes += ",";
contract.Stat_AllVideoQuality_Episodes += kvp.Key;
}
}
}
List<string> audioLanguageList = new List<string>();
List<string> subtitleLanguageList = new List<string>();
// get audio languages
if (dictAudioStats.ContainsKey(anime.AnimeID))
{
foreach (string lanName in dictAudioStats[anime.AnimeID].LanguageNames)
{
if (!audioLanguageList.Contains(lanName)) audioLanguageList.Add(lanName);
}
}
// get subtitle languages
if (dictSubtitleStats.ContainsKey(anime.AnimeID))
{
foreach (string lanName in dictSubtitleStats[anime.AnimeID].LanguageNames)
{
if (!subtitleLanguageList.Contains(lanName)) subtitleLanguageList.Add(lanName);
}
}
contract.Stat_AudioLanguages = "";
foreach (string audioLan in audioLanguageList)
{
if (contract.Stat_AudioLanguages.Length > 0) contract.Stat_AudioLanguages += ",";
contract.Stat_AudioLanguages += audioLan;
}
contract.Stat_SubtitleLanguages = "";
foreach (string subLan in subtitleLanguageList)
{
if (contract.Stat_SubtitleLanguages.Length > 0) contract.Stat_SubtitleLanguages += ",";
contract.Stat_SubtitleLanguages += subLan;
}
if (allTitlesDict.ContainsKey(anime.AnimeID))
{
foreach (AniDB_Anime_Title title in allTitlesDict[anime.AnimeID])
{
Contract_AnimeTitle ctitle = new Contract_AnimeTitle();
ctitle.AnimeID = title.AnimeID;
ctitle.Language = title.Language;
ctitle.Title = title.Title;
ctitle.TitleType = title.TitleType;
contract.AnimeTitles.Add(ctitle);
countElements++;
}
}
if (allAnimeTagsDict.ContainsKey(anime.AnimeID))
{
List<AniDB_Anime_Tag> aniTags = allAnimeTagsDict[anime.AnimeID];
foreach (AniDB_Anime_Tag aniTag in aniTags)
{
if (allTagsDict.ContainsKey(aniTag.TagID))
{
AniDB_Tag tag = allTagsDict[aniTag.TagID];
Contract_AnimeTag ctag = new Contract_AnimeTag();
ctag.Weight = aniTag.Weight;
ctag.GlobalSpoiler = tag.GlobalSpoiler;
ctag.LocalSpoiler = tag.LocalSpoiler;
//ctag.Spoiler = tag.Spoiler;
//ctag.TagCount = tag.TagCount;
ctag.TagDescription = tag.TagDescription;
ctag.TagID = tag.TagID;
ctag.TagName = tag.TagName;
contract.Tags.Add(ctag);
countElements++;
}
}
}
//TODO - Custom Tags: add custom tags
if (allCustomTagsXRefDict.ContainsKey(anime.AnimeID))
{
List<CrossRef_CustomTag> aniTags = allCustomTagsXRefDict[anime.AnimeID];
foreach (CrossRef_CustomTag aniTag in aniTags)
{
if (allCustomTagsDict.ContainsKey(aniTag.CustomTagID))
{
contract.CustomTags.Add(allCustomTagsDict[aniTag.CustomTagID].ToContract());
countElements++;
}
}
}
// get user vote
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
contract.UserVote = vote.ToContract();
break;
}
}
contracts.Add(contract);
}
TimeSpan ts = DateTime.Now - start;
logger.Info("GetAllAnimeDetailed in {0} ms {1}", ts.TotalMilliseconds, countElements);
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return contracts;
}
public AniDB_Vote GetUserVote(ISession session)
{
try
{
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
AniDB_Vote dbVote = repVotes.GetByAnimeID(session, this.AnimeID);
return dbVote;
}
catch (Exception ex)
{
logger.Error("Error in UserVote: {0}", ex.ToString());
return null;
}
}
public List<Contract_AnimeRating> GetAnimeRatings(int collectionState, int watchedState, int ratingVotedState, int userID)
{
List<Contract_AnimeRating> contracts = new List<Contract_AnimeRating>();
try
{
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
List<AnimeSeries> series = repSeries.GetAll();
Dictionary<int, AnimeSeries> dictSeries = new Dictionary<int, AnimeSeries>();
foreach (AnimeSeries ser in series)
dictSeries[ser.AniDB_ID] = ser;
RatingCollectionState _collectionState = (RatingCollectionState)collectionState;
RatingWatchedState _watchedState = (RatingWatchedState)watchedState;
RatingVotedState _ratingVotedState = (RatingVotedState)ratingVotedState;
DateTime start = DateTime.Now;
AniDB_AnimeRepository repAnime = new AniDB_AnimeRepository();
/*
// build a dictionary of categories
AniDB_CategoryRepository repCats = new AniDB_CategoryRepository();
AniDB_Anime_CategoryRepository repAnimeCat = new AniDB_Anime_CategoryRepository();
List<AniDB_Category> allCatgeories = repCats.GetAll();
Dictionary<int, AniDB_Category> allCatgeoriesDict = new Dictionary<int, AniDB_Category>();
foreach (AniDB_Category cat in allCatgeories)
allCatgeoriesDict[cat.CategoryID] = cat;
List<AniDB_Anime_Category> allAnimeCatgeories = repAnimeCat.GetAll();
Dictionary<int, List<AniDB_Anime_Category>> allAnimeCatgeoriesDict = new Dictionary<int, List<AniDB_Anime_Category>>(); //
foreach (AniDB_Anime_Category aniCat in allAnimeCatgeories)
{
if (!allAnimeCatgeoriesDict.ContainsKey(aniCat.AnimeID))
allAnimeCatgeoriesDict[aniCat.AnimeID] = new List<AniDB_Anime_Category>();
allAnimeCatgeoriesDict[aniCat.AnimeID].Add(aniCat);
}
// build a dictionary of titles
AniDB_Anime_TitleRepository repTitles = new AniDB_Anime_TitleRepository();
List<AniDB_Anime_Title> allTitles = repTitles.GetAll();
Dictionary<int, List<AniDB_Anime_Title>> allTitlesDict = new Dictionary<int, List<AniDB_Anime_Title>>();
foreach (AniDB_Anime_Title title in allTitles)
{
if (!allTitlesDict.ContainsKey(title.AnimeID))
allTitlesDict[title.AnimeID] = new List<AniDB_Anime_Title>();
allTitlesDict[title.AnimeID].Add(title);
}
// build a dictionary of tags
AniDB_TagRepository repTags = new AniDB_TagRepository();
AniDB_Anime_TagRepository repAnimeTag = new AniDB_Anime_TagRepository();
List<AniDB_Tag> allTags = repTags.GetAll();
Dictionary<int, AniDB_Tag> allTagsDict = new Dictionary<int, AniDB_Tag>();
foreach (AniDB_Tag tag in allTags)
allTagsDict[tag.TagID] = tag;
List<AniDB_Anime_Tag> allAnimeTags = repAnimeTag.GetAll();
Dictionary<int, List<AniDB_Anime_Tag>> allAnimeTagsDict = new Dictionary<int, List<AniDB_Anime_Tag>>(); //
foreach (AniDB_Anime_Tag aniTag in allAnimeTags)
{
if (!allAnimeTagsDict.ContainsKey(aniTag.AnimeID))
allAnimeTagsDict[aniTag.AnimeID] = new List<AniDB_Anime_Tag>();
allAnimeTagsDict[aniTag.AnimeID].Add(aniTag);
}
// build a dictionary of languages
AdhocRepository rep = new AdhocRepository();
Dictionary<int, LanguageStat> dictAudioStats = rep.GetAudioLanguageStatsForAnime();
Dictionary<int, LanguageStat> dictSubtitleStats = rep.GetSubtitleLanguageStatsForAnime();
Dictionary<int, string> dictAnimeVideoQualStats = rep.GetAllVideoQualityByAnime();
Dictionary<int, AnimeVideoQualityStat> dictAnimeEpisodeVideoQualStats = rep.GetEpisodeVideoQualityStatsByAnime();
* */
List<AniDB_Anime> animes = repAnime.GetAll();
// user votes
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> allVotes = repVotes.GetAll();
JMMUserRepository repUsers = new JMMUserRepository();
JMMUser user = repUsers.GetByID(userID);
if (user == null) return contracts;
int i = 0;
foreach (AniDB_Anime anime in animes)
{
i++;
// evaluate collection states
if (_collectionState == RatingCollectionState.AllEpisodesInMyCollection)
{
if (!anime.FinishedAiring) continue;
if (!dictSeries.ContainsKey(anime.AnimeID)) continue;
if (dictSeries[anime.AnimeID].MissingEpisodeCount > 0) continue;
}
if (_collectionState == RatingCollectionState.InMyCollection)
if (!dictSeries.ContainsKey(anime.AnimeID)) continue;
if (_collectionState == RatingCollectionState.NotInMyCollection)
if (dictSeries.ContainsKey(anime.AnimeID)) continue;
if (!user.AllowedAnime(anime)) continue;
// evaluate watched states
if (_watchedState == RatingWatchedState.AllEpisodesWatched)
{
if (!dictSeries.ContainsKey(anime.AnimeID)) continue;
AnimeSeries_User userRec = dictSeries[anime.AnimeID].GetUserRecord(userID);
if (userRec == null) continue;
if (userRec.UnwatchedEpisodeCount > 0) continue;
}
if (_watchedState == RatingWatchedState.NotWatched)
{
if (dictSeries.ContainsKey(anime.AnimeID))
{
AnimeSeries_User userRec = dictSeries[anime.AnimeID].GetUserRecord(userID);
if (userRec != null)
{
if (userRec.UnwatchedEpisodeCount == 0) continue;
}
}
}
// evaluate voted states
if (_ratingVotedState == RatingVotedState.Voted)
{
bool voted = false;
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
voted = true;
break;
}
}
if (!voted) continue;
}
if (_ratingVotedState == RatingVotedState.NotVoted)
{
bool voted = false;
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
voted = true;
break;
}
}
if (voted) continue;
}
Contract_AnimeRating contract = new Contract_AnimeRating();
contract.AnimeID = anime.AnimeID;
Contract_AniDB_AnimeDetailed contractAnimeDetailed = new Contract_AniDB_AnimeDetailed();
contractAnimeDetailed.AnimeTitles = new List<Contract_AnimeTitle>();
contractAnimeDetailed.Categories = new List<Contract_AnimeCategory>();
contractAnimeDetailed.Tags = new List<Contract_AnimeTag>();
contractAnimeDetailed.UserVote = null;
contractAnimeDetailed.AniDBAnime = anime.ToContract();
/*
if (dictAnimeVideoQualStats.ContainsKey(anime.AnimeID))
contractAnimeDetailed.Stat_AllVideoQuality = dictAnimeVideoQualStats[anime.AnimeID];
else contractAnimeDetailed.Stat_AllVideoQuality = "";
contractAnimeDetailed.Stat_AllVideoQuality_Episodes = "";
// All Video Quality Episodes
// Try to determine if this anime has all the episodes available at a certain video quality
// e.g. the series has all episodes in blu-ray
if (dictAnimeEpisodeVideoQualStats.ContainsKey(anime.AnimeID))
{
AnimeVideoQualityStat stat = dictAnimeEpisodeVideoQualStats[anime.AnimeID];
foreach (KeyValuePair<string, int> kvp in stat.VideoQualityEpisodeCount)
{
if (kvp.Value >= anime.EpisodeCountNormal)
{
if (contractAnimeDetailed.Stat_AllVideoQuality_Episodes.Length > 0) contractAnimeDetailed.Stat_AllVideoQuality_Episodes += ",";
contractAnimeDetailed.Stat_AllVideoQuality_Episodes += kvp.Key;
}
}
}
List<string> audioLanguageList = new List<string>();
List<string> subtitleLanguageList = new List<string>();
// get audio languages
if (dictAudioStats.ContainsKey(anime.AnimeID))
{
foreach (string lanName in dictAudioStats[anime.AnimeID].LanguageNames)
{
if (!audioLanguageList.Contains(lanName)) audioLanguageList.Add(lanName);
}
}
// get subtitle languages
if (dictSubtitleStats.ContainsKey(anime.AnimeID))
{
foreach (string lanName in dictSubtitleStats[anime.AnimeID].LanguageNames)
{
if (!subtitleLanguageList.Contains(lanName)) subtitleLanguageList.Add(lanName);
}
}
contractAnimeDetailed.Stat_AudioLanguages = "";
foreach (string audioLan in audioLanguageList)
{
if (contractAnimeDetailed.Stat_AudioLanguages.Length > 0) contractAnimeDetailed.Stat_AudioLanguages += ",";
contractAnimeDetailed.Stat_AudioLanguages += audioLan;
}
contractAnimeDetailed.Stat_SubtitleLanguages = "";
foreach (string subLan in subtitleLanguageList)
{
if (contractAnimeDetailed.Stat_SubtitleLanguages.Length > 0) contractAnimeDetailed.Stat_SubtitleLanguages += ",";
contractAnimeDetailed.Stat_SubtitleLanguages += subLan;
}
if (allTitlesDict.ContainsKey(anime.AnimeID))
{
foreach (AniDB_Anime_Title title in allTitlesDict[anime.AnimeID])
{
Contract_AnimeTitle ctitle = new Contract_AnimeTitle();
ctitle.AnimeID = title.AnimeID;
ctitle.Language = title.Language;
ctitle.Title = title.Title;
ctitle.TitleType = title.TitleType;
contractAnimeDetailed.AnimeTitles.Add(ctitle);
}
}
if (allAnimeCatgeoriesDict.ContainsKey(anime.AnimeID))
{
List<AniDB_Anime_Category> aniCats = allAnimeCatgeoriesDict[anime.AnimeID];
foreach (AniDB_Anime_Category aniCat in aniCats)
{
if (allCatgeoriesDict.ContainsKey(aniCat.CategoryID))
{
AniDB_Category cat = allCatgeoriesDict[aniCat.CategoryID];
Contract_AnimeCategory ccat = new Contract_AnimeCategory();
ccat.CategoryDescription = cat.CategoryDescription;
ccat.CategoryID = cat.CategoryID;
ccat.CategoryName = cat.CategoryName;
ccat.IsHentai = cat.IsHentai;
ccat.ParentID = cat.ParentID;
ccat.Weighting = aniCat.Weighting;
contractAnimeDetailed.Categories.Add(ccat);
}
}
}
if (allAnimeTagsDict.ContainsKey(anime.AnimeID))
{
List<AniDB_Anime_Tag> aniTags = allAnimeTagsDict[anime.AnimeID];
foreach (AniDB_Anime_Tag aniTag in aniTags)
{
if (allTagsDict.ContainsKey(aniTag.TagID))
{
AniDB_Tag tag = allTagsDict[aniTag.TagID];
Contract_AnimeTag ctag = new Contract_AnimeTag();
ctag.Approval = aniTag.Approval;
ctag.GlobalSpoiler = tag.GlobalSpoiler;
ctag.LocalSpoiler = tag.LocalSpoiler;
ctag.Spoiler = tag.Spoiler;
ctag.TagCount = tag.TagCount;
ctag.TagDescription = tag.TagDescription;
ctag.TagID = tag.TagID;
ctag.TagName = tag.TagName;
contractAnimeDetailed.Tags.Add(ctag);
}
}
}*/
// get user vote
foreach (AniDB_Vote vote in allVotes)
{
if (vote.EntityID == anime.AnimeID && (vote.VoteType == (int)AniDBVoteType.Anime || vote.VoteType == (int)AniDBVoteType.AnimeTemp))
{
contractAnimeDetailed.UserVote = vote.ToContract();
break;
}
}
contract.AnimeDetailed = contractAnimeDetailed;
if (dictSeries.ContainsKey(anime.AnimeID))
{
contract.AnimeSeries = dictSeries[anime.AnimeID].ToContract(dictSeries[anime.AnimeID].GetUserRecord(userID));
}
contracts.Add(contract);
}
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return contracts;
}
public System.IO.Stream VoteAnime(string userid, string objectid, string votevalue, string votetype)
{
Respond rsp = new Respond();
rsp.code = 500;
int objid = 0;
int usid = 0;
int vt = 0;
double vvalue = 0;
if (!int.TryParse(objectid, out objid))
return KodiHelper.GetStreamFromXmlObject(rsp);
if (!int.TryParse(userid, out usid))
return KodiHelper.GetStreamFromXmlObject(rsp);
if (!int.TryParse(votetype, out vt))
return KodiHelper.GetStreamFromXmlObject(rsp);
if (!double.TryParse(votevalue, NumberStyles.Any, CultureInfo.InvariantCulture, out vvalue))
return KodiHelper.GetStreamFromXmlObject(rsp);
using (var session = JMMService.SessionFactory.OpenSession())
{
if (vt == (int)enAniDBVoteType.Episode)
{
AnimeEpisodeRepository repEpisodes = new AnimeEpisodeRepository();
AnimeEpisode ep = repEpisodes.GetByID(session, objid);
AniDB_Anime anime = ep.GetAnimeSeries().GetAnime();
if (anime == null)
{
rsp.code = 404;
return KodiHelper.GetStreamFromXmlObject(rsp);
}
string msg = string.Format("Voting for anime episode: {0} - Value: {1}", ep.AnimeEpisodeID, vvalue);
logger.Info(msg);
// lets save to the database and assume it will work
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(ep.AnimeEpisodeID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
if (dbVote.VoteType == (int)enAniDBVoteType.Episode)
{
thisVote = dbVote;
}
}
if (thisVote == null)
{
thisVote = new AniDB_Vote();
thisVote.EntityID = ep.AnimeEpisodeID;
}
thisVote.VoteType = vt;
int iVoteValue = 0;
if (vvalue > 0)
iVoteValue = (int)(vvalue * 100);
else
iVoteValue = (int)vvalue;
msg = string.Format("Voting for anime episode Formatted: {0} - Value: {1}", ep.AnimeEpisodeID, iVoteValue);
logger.Info(msg);
thisVote.VoteValue = iVoteValue;
repVotes.Save(thisVote);
CommandRequest_VoteAnime cmdVote = new CommandRequest_VoteAnime(anime.AnimeID, vt, Convert.ToDecimal(vvalue));
cmdVote.Save();
}
if (vt == (int)enAniDBVoteType.Anime)
{
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
AnimeSeries ser = repSeries.GetByID(session, objid);
AniDB_Anime anime = ser.GetAnime();
if (anime == null)
{
rsp.code = 404;
return KodiHelper.GetStreamFromXmlObject(rsp);
}
string msg = string.Format("Voting for anime: {0} - Value: {1}", anime.AnimeID, vvalue);
logger.Info(msg);
// lets save to the database and assume it will work
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(anime.AnimeID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
// we can only have anime permanent or anime temp but not both
if (vt == (int)enAniDBVoteType.Anime || vt == (int)enAniDBVoteType.AnimeTemp)
{
if (dbVote.VoteType == (int)enAniDBVoteType.Anime ||
dbVote.VoteType == (int)enAniDBVoteType.AnimeTemp)
{
thisVote = dbVote;
}
}
else
{
thisVote = dbVote;
}
}
if (thisVote == null)
{
thisVote = new AniDB_Vote();
thisVote.EntityID = anime.AnimeID;
}
thisVote.VoteType = vt;
int iVoteValue = 0;
if (vvalue > 0)
iVoteValue = (int)(vvalue * 100);
else
iVoteValue = (int)vvalue;
msg = string.Format("Voting for anime Formatted: {0} - Value: {1}", anime.AnimeID, iVoteValue);
logger.Info(msg);
thisVote.VoteValue = iVoteValue;
repVotes.Save(thisVote);
CommandRequest_VoteAnime cmdVote = new CommandRequest_VoteAnime(anime.AnimeID, vt, Convert.ToDecimal(vvalue));
cmdVote.Save();
}
rsp.code = 200;
return KodiHelper.GetStreamFromXmlObject(rsp);
}
}
public bool VoteAnime(int animeID, decimal voteValue, enAniDBVoteType voteType)
{
if (!Login()) return false;
enHelperActivityType ev = enHelperActivityType.NoSuchVote;
AniDBCommand_Vote cmdVote = null;
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
lock (lockAniDBConnections)
{
Pause();
cmdVote = new AniDBCommand_Vote();
cmdVote.Init(animeID, voteValue, voteType);
SetWaitingOnResponse(true);
ev = cmdVote.Process(ref soUdp, ref remoteIpEndPoint, curSessionID, new UnicodeEncoding(true, false));
SetWaitingOnResponse(false);
if (ev == enHelperActivityType.Voted || ev == enHelperActivityType.VoteUpdated)
{
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(cmdVote.EntityID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
// we can only have anime permanent or anime temp but not both
if (cmdVote.VoteType == enAniDBVoteType.Anime || cmdVote.VoteType == enAniDBVoteType.AnimeTemp)
{
if (dbVote.VoteType == (int)enAniDBVoteType.Anime || dbVote.VoteType == (int)enAniDBVoteType.AnimeTemp)
{
thisVote = dbVote;
}
}
else
{
thisVote = dbVote;
}
}
if (thisVote == null)
{
thisVote = new AniDB_Vote();
thisVote.EntityID = cmdVote.EntityID;
}
thisVote.VoteType = (int)cmdVote.VoteType;
thisVote.VoteValue = cmdVote.VoteValue;
repVotes.Save(thisVote);
}
}
return false;
}
public void VoteAnime(string userid, string seriesid, string votevalue, string votetype)
{
int serid = 0;
int usid = 0;
int vt = 0;
double vvalue = 0;
if (!int.TryParse(seriesid, out serid))
return;
if (!int.TryParse(userid, out usid))
return;
if (!int.TryParse(votetype, out vt))
return;
if (!double.TryParse(votevalue, NumberStyles.Any, CultureInfo.InvariantCulture, out vvalue))
return;
using (var session = JMMService.SessionFactory.OpenSession())
{
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
AnimeSeries ser = repSeries.GetByID(session, serid);
AniDB_Anime anime = ser?.GetAnime();
if (anime == null)
return;
string msg = string.Format("Voting for anime: {0} - Value: {1}", anime.AnimeID, vvalue);
logger.Info(msg);
// lets save to the database and assume it will work
AniDB_VoteRepository repVotes = new AniDB_VoteRepository();
List<AniDB_Vote> dbVotes = repVotes.GetByEntity(anime.AnimeID);
AniDB_Vote thisVote = null;
foreach (AniDB_Vote dbVote in dbVotes)
{
// we can only have anime permanent or anime temp but not both
if (vt == (int) enAniDBVoteType.Anime || vt == (int) enAniDBVoteType.AnimeTemp)
{
if (dbVote.VoteType == (int) enAniDBVoteType.Anime ||
dbVote.VoteType == (int) enAniDBVoteType.AnimeTemp)
{
thisVote = dbVote;
}
}
else
{
thisVote = dbVote;
}
}
if (thisVote == null)
{
thisVote = new AniDB_Vote();
thisVote.EntityID = anime.AnimeID;
}
thisVote.VoteType = vt;
int iVoteValue = 0;
if (vvalue > 0)
iVoteValue = (int) (vvalue*100);
else
iVoteValue = (int) vvalue;
msg = string.Format("Voting for anime Formatted: {0} - Value: {1}", anime.AnimeID, iVoteValue);
logger.Info(msg);
thisVote.VoteValue = iVoteValue;
repVotes.Save(thisVote);
CommandRequest_VoteAnime cmdVote = new CommandRequest_VoteAnime(anime.AnimeID, vt, Convert.ToDecimal(vvalue));
cmdVote.Save();
}
}
