public async Task <MovieDetails> AddMovie(MovieAddRequest request)
{
var movieToAdd = Mapper.Map <Movie>(request);
await MovieRepo.CreateAsync(movieToAdd);
await MovieRepo.SaveChangesAsync();
var addedMovie = Mapper.Map <MovieDetails>(movieToAdd);
return(addedMovie);
}
public async Task <IActionResult> CreateMovie([FromBody] MovieAddRequest request)
{
var movieSameTitleAndDate = await MovieService.GetMovie(request.Title, request.ReleaseDate);
if (movieSameTitleAndDate != null)
{
return(BadRequest(ApiResponse.Failure("Movie", $"Movie {request.Title} released: {request.ReleaseDate.Date} exists")));
}
var addedMovie = await MovieService.AddMovie(request);
return(Ok(ApiResponse <MovieDetails> .Success(addedMovie)));
}
public int Insert(MovieAddRequest model)
{
SqlParameter id = SqlDbParameter.Instance.BuildParam("@Id", 0, System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Output);
_baseService.SqlAdapter.ExecuteQuery(new DbCommandDef
{
DbCommandText = "dbo.Movies_Insert",
DbCommandType = System.Data.CommandType.StoredProcedure,
DbParameters = new SqlParameter[]
{
new SqlParameter("@Title", model.Title),
new SqlParameter("@Genre", model.Genre),
id
}
});
return(id.Value.ToInt32());
}
