public async Task <IActionResult> GetPlaces(int cityId)
        {
            var placesFromRepo = await _repository.GetPlacesForCity(cityId);

            var placesToReturn = Mapper.Map <IEnumerable <PlaceDto> >(placesFromRepo);

            return(Ok(placesToReturn));
        }
        public async Task <IActionResult> GetCity(int id, int cityId)
        {
            var cityFromRepo = await _repository.GetCityForCountry(id, cityId);

            if (cityFromRepo == null)
            {
                return(NotFound());
            }
            var cityToReturn   = Mapper.Map <CityDto>(cityFromRepo);
            var placesFromRepo = await _repository.GetPlacesForCity(cityId);

            var placesToReturn = Mapper.Map <IEnumerable <PlaceDto> >(placesFromRepo);

            cityToReturn.Places = placesToReturn;
            return(Ok(cityToReturn));
        }
        public async Task <IActionResult> AddComment([FromBody] CommentForCreationDto newComment, int id, int cityId, int placeId)
        {
            var placeFromRepo = await _repository.GetPlaceForCity(cityId, placeId);

            if (placeFromRepo == null)
            {
                return(NotFound());
            }
            var commentToAdd = Mapper.Map <Comment>(newComment);

            commentToAdd.Date = DateTime.Now;
            _repository.AddCommentForPlace(commentToAdd);
            if (!await _repository.Save())
            {
                throw new Exception("Failed");
            }
            var commentsFromRepo = await _repository.GetCommentsForPlace(placeId);

            var avgRating = commentsFromRepo.Average(c => c.Rating);

            placeFromRepo.Rating = avgRating;
            if (!await _repository.Save())
            {
                throw new Exception("Failed");
            }
            var placesFromRepo = await _repository.GetPlacesForCity(cityId);

            avgRating = placesFromRepo.Average(p => p.Rating);
            var cityFromRepo = await _repository.GetCityForCountry(id, cityId);

            cityFromRepo.Rating = avgRating;
            if (!await _repository.Save())
            {
                throw new Exception("Failed");
            }
            var citiesFromRepo = await _repository.GetCitiesForCountry(id);

            avgRating = citiesFromRepo.Average(c => c.Rating);
            var countryFromRepo = await _repository.GetCountry(id);

            countryFromRepo.Rating = avgRating;
            if (!await _repository.Save())
            {
                throw new Exception("Failed");
            }
            return(NoContent());
        }