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()); } }