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(); } }
private void OnReviewQuery(int movieId, int userId) { var reviewDb = new ReviewDatabaseLayer <Review> (); var reviews = reviewDb.GetReviewsByMovieId(movieId); // First we clear old values _view.ClearReview(); foreach (var review in reviews) { _view.SetReview(review.MovieId, review.UserId, review.Date, review.Note); } }
public Calculator(string dbPath) { _reviewsConnection = new ReviewDatabaseLayer <Review> (dbPath); }
public MovieMeanCalculator(string reviewPath, string moviePath, string meanPath) { _reviewConnection = new ReviewDatabaseLayer <Review> (reviewPath); _movieConnection = new MovieDatabaseLayer(moviePath); _meanConnection = new MovieMeanConnection(meanPath); }