Example #1
0
        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));
        }
Example #2
0
        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);
        }