private void AddUserRanking(string title, DateTime releaseDate, int rank)
{
using (TopTenRightNowContext context = new TopTenRightNowContext())
{
Movie movie = AppCache.EntityCache.GetMovieByTitleAndRelease(title, releaseDate);
if (movie == null)
{
movie = new Movie()
{
Title = title,
ReleaseDate = releaseDate,
RankingWeight = WeightFromRank(rank),
LastRankedTime = DateTime.Now
};
context.Movies.Add(movie);
}
UserRanking ranking = new UserRanking()
{
MovieId = movie.MovieId,
RankingWeight = WeightFromRank(rank),
RankedTime = DateTime.Now
};
context.UserRankings.Add(ranking);
context.SaveChanges();
}
}
public static Movie GetMovie(int movieId)
{
string key = string.Format("Movie_{0}", movieId);
Movie movie = cache[key] as Movie;
if (movie == null)
{
using (TopTenRightNowContext context = new TopTenRightNowContext())
{
movie = context.Movies.Find(movieId);
}
if (movie != null)
{
cache[key] = movie;
}
}
return(movie);
}
public static Movie GetMovieByTitleAndRelease(string title, DateTime releaseDate)
{
string key = string.Format("Movie_{0}_{1}", title, releaseDate);
Movie movie = cache[key] as Movie;
if (movie == null)
{
using (TopTenRightNowContext context = new TopTenRightNowContext())
{
movie = context.Movies.
Where(m => m.Title == title && m.ReleaseDate == releaseDate).
FirstOrDefault();
}
if (movie != null)
{
cache[key] = movie;
}
}
return(movie);
}
