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