public NewMovieRequestModel CreateNewMovie(int nextValue, NewMovieRequestModel newUserMovie)
{
string query1 = "INSERT INTO MOVIE (MOVIENO, TITLE, RELYEAR, RUNTIME) " +
"VALUES (@movienum, @newtitle, @releaseYear, @runTime) ";
// create connection and command
SqlConnection connecting = new SqlConnection(connectionString);
SqlCommand createNewMovie = new SqlCommand(query1, connecting);
createNewMovie.Parameters.Add("@movienum", SqlDbType.Int, 100).Value = nextValue;
createNewMovie.Parameters.Add("@newtitle", SqlDbType.VarChar, 100).Value = newUserMovie.Title;
createNewMovie.Parameters.Add("@releaseYear", SqlDbType.SmallInt).Value = newUserMovie.ReleaseYear;
createNewMovie.Parameters.Add("@runTime", SqlDbType.SmallInt).Value = newUserMovie.RunTime;
try
{
connecting.Open();
createNewMovie.ExecuteNonQuery();
connecting.Close();
}
catch (SqlException ex)
{
throw new ApplicationException($"Some sql error happened + {ex} + { ex.Message} + { ex.Errors} + { ex.Number}");
}
var outputMovie = newUserMovie;
outputMovie.MovieNum = nextValue;
return(outputMovie);
}
public ActionResult <NewMovieRequestModel> Post([FromBody] NewMovieRequestModel newUserMovie)
{
var nextValue = _DatabaseLayer.getNextMovieNum();
var result = _DatabaseLayer.CreateNewMovie(nextValue, newUserMovie);
var check = _DatabaseLayer.getAMovie(result.Title);
if (check == result.Title)
{
return(Ok(result));
}
else
{
return(BadRequest());
}
}
