public IActionResult CreateMovieHall([FromBody] MovieHallDto movieHallDto) { if (movieHallDto == null) { return(BadRequest()); } if (movieHallRepo.MovieHallExists(movieHallDto.MovieHallName)) { ModelState.AddModelError("", "Naziv dvorane vec postoji!"); return(StatusCode(404, ModelState)); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var movieHallObj = mapper.Map <MovieHall>(movieHallDto); if (!movieHallRepo.CreateMovieHall(movieHallObj)) { ModelState.AddModelError("", $"Doslo je do greske u spasavanju {movieHallObj.MovieHallName}"); return(StatusCode(500, ModelState)); } return(CreatedAtRoute("GetMovieHall", new { id = movieHallObj.MovieHallId }, movieHallObj)); }
public IActionResult UpdateMovieHall(int id, [FromBody] MovieHallDto movieHallDto) { if (movieHallDto == null || id != movieHallDto.MovieHallId) { return(BadRequest(ModelState)); } var movieHallObj = mapper.Map <MovieHall>(movieHallDto); if (!movieHallRepo.UpdateMovieHall(movieHallObj)) { ModelState.AddModelError("", $"Doslo je do greske u izmjeni {movieHallObj.MovieHallName}"); return(StatusCode(500, ModelState)); } return(NoContent()); }
IEnumerable <IMovieHall> IMovieHallContext.GetAll() { _connection.SqlConnection.Open(); var cmd = new MySqlCommand("SELECT * FROM moviehall", _connection.SqlConnection); var reader = cmd.ExecuteReader(); var movieHallRecords = new List <IMovieHall>(); while (reader.Read()) { var movieHall = new MovieHallDto { MovieHallId = (int)reader["MovieHallId"], MovieId = (int)reader["MovieId"], NrOfSeats = (int)reader["NrOfSeats"] }; movieHallRecords.Add(movieHall); } return(movieHallRecords); }