public IActionResult CreateMovies(MoviesCreateRequest moviesRequest) { Movies movies = new Movies() { MoviesID = 0, Name = moviesRequest.Name, Director = moviesRequest.Director, Genre = moviesRequest.Genre, MovieLength = moviesRequest.MovieLength, Rating = moviesRequest.Rating, ReleaseYear = moviesRequest.ReleaseYear, Title = moviesRequest.Title }; _unitOfWorkEntityFramework.MoviesCommand.Add(movies); var result = _unitOfWorkEntityFramework.Commit(); if (result) { return(Ok(new OkResponse("Movies Added Successfully !"))); } else { return(StatusCode(StatusCodes.Status500InternalServerError, "Something Went Wrong")); } }
public int Insert(MoviesCreateRequest model) { int result = 0; using (SqlConnection connection = new SqlConnection(connectionString)) { string sqlQuery = "Movies_Insert"; using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parameter = new SqlParameter(); parameter.ParameterName = "@Id"; parameter.SqlDbType = System.Data.SqlDbType.Int; parameter.Direction = System.Data.ParameterDirection.Output; //Alternatively command.Parameters.Add("@Id", SqlDBType.Int).Direction = ParameterDirection.Output; command.Parameters.Add(parameter); command.Parameters.AddWithValue("@Title", model.Title); command.Parameters.AddWithValue("@ReleaseYear", model.ReleaseYear); connection.Open(); command.ExecuteNonQuery(); //Non query means no result sets expected result = (int)command.Parameters["@Id"].Value; connection.Close(); } } return(result); }
public void InsertTest() { MoviesCreateRequest model = new MoviesCreateRequest { Title = "Some Movie", ReleaseYear = 2018 }; int result = service.Insert(model); Assert.IsTrue(result > 0, "The insert failed"); }
public HttpResponseMessage Create(MoviesCreateRequest createRequest) { // validate the data that the client sent //1. Did they send us anything at all? if (createRequest == null) { ModelState.AddModelError("", "missing boy data!"); //The emtpy string means the error applies to the whole request. } //2. check wheteher there aren any model errors. if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } //3. If we got this far, then the data is valid and we should call the service. int newId = movieService.Insert(createRequest); return(Request.CreateResponse(HttpStatusCode.OK, newId)); }
public IActionResult UpdateMovie(MoviesCreateRequest moviesRequest, int?id) { var movie = _iMoviesQueries.GetMoviesbyId(id); movie.Director = moviesRequest.Director; movie.Genre = moviesRequest.Genre; movie.MovieLength = moviesRequest.MovieLength; movie.Rating = moviesRequest.Rating; movie.ReleaseYear = moviesRequest.ReleaseYear; movie.Title = moviesRequest.Title; _unitOfWorkEntityFramework.MoviesCommand.Update(movie); var result = _unitOfWorkEntityFramework.Commit(); if (result) { return(Ok(new OkResponse("Movies Updated Successfully !"))); } else { return(StatusCode(StatusCodes.Status500InternalServerError, "Something Went Wrong")); } }