public void AddRating(SeasonRating rating)
        {
            var command = GetCommand("AddSeasonRating", System.Data.CommandType.StoredProcedure);

            AddParameter(command, "@PersonId", rating.Person.Id);
            AddParameter(command, "@SeasonId", rating.Season.Id);
            AddParameter(command, "@Rating", rating.Rating);
            AddParameter(command, "@YearViewed", rating.YearViewed);

            ExecuteNonQueryChecked(command);
        }
        public void AddSeasonRating(int personId, int seasonId, double rating, DateTime yearViewed)
        {
            var seasonRating = new SeasonRating()
            {
                Person = new Person() { Id = personId },
                Season = new Season() { Id = seasonId},
                Rating = rating,
                YearViewed = yearViewed
            };

            _seasonRatingRepository.AddRating(seasonRating);
        }