public void GetCommonMovies()
{
_reviewConnection = new ReviewDatabaseLayer <Review> (ReviewPath);
_movieConnection = new MovieDatabaseLayer(MoviePath);
while (true)
{
// var id1 = GetUser (1);
// var id2 = GetUser (2);
var id1 = 387418;
var id2 = 1008749;
// var sw = new Stopwatch ();
// sw.Start ();
//var movies = _reviewConnection.GetCommonMovies (id1, id2).ToArray ();
var movies = _reviewConnection.GetCommonMovies(id1, id2);
//sw.Stop ();
var moviesWithTitle = movies.Select(r => new { Title = _movieConnection.GetMovie(r.Item1.MovieId).Title, Id = r.Item1.MovieId });
// Console.WriteLine ("Found {0} common movies in {1}ms", movies.Count (), sw.ElapsedMilliseconds);
foreach (var movie in moviesWithTitle)
{
Console.WriteLine(" - {0} ({1})", movie.Title, movie.Id);
}
Console.ReadLine();
}
}
public float Calculate(int movieId)
{
var movies = _reviewConnection.GetReviewsByMovieId(movieId).ToArray();
var mean = ((float)(movies.Sum(r => r.Note))) / movies.Count();
_meanConnection.Save(new MovieMean {
Title = _movieConnection.GetMovie(movieId).Title, Id = movieId, Mean = mean
});
return(mean);
}
