public async Task <IActionResult> Save(MovieRatingDto movieRatingDto)
{
movieRatingDto.UserId = ActiveUser.Get().UserId;
var newMovieRating = await _movieRatingService.Insert(_mapper.Map <MovieRating>(movieRatingDto));
return(Created(string.Empty, _mapper.Map <MovieRatingDto>(newMovieRating)));
}
//For remove movie rating
public bool RemoveMovieRating(MovieRatingDto ratingDto)
{
var connection = (NpgsqlConnection)this.Database.GetDbConnection();
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "remove_user_rating";
command.Parameters.Add(new Npgsql.NpgsqlParameter("inputusername", NpgsqlTypes.NpgsqlDbType.Varchar)
{
Value = ratingDto.UserName
});
command.Parameters.Add(new Npgsql.NpgsqlParameter("inputtconst", NpgsqlTypes.NpgsqlDbType.Varchar)
{
Value = ratingDto.MovieId
});
var reader = command.ExecuteScalar();
return((bool)reader);
}
public bool AddMovieRating(MovieRatingDto movieRaingDto)
{
using (var ctx = new MoviesContext())
{
return(ctx.AddMovieRating(movieRaingDto));
}
}
public IActionResult Update(MovieRatingDto movieRatingDto)
{
var movieRating = _movieRatingService.Update(_mapper.Map <MovieRating>(movieRatingDto));
return(NoContent());
}
public IActionResult RemoveMovieRating(MovieRatingDto movieRatingDto)
{
bool result = ds.RemoveMovieRating(movieRatingDto);
return(Ok(result));
}
