public static StatusFilmDTO readerToStatusFilmDTO(MySqlDataReader reader) { StatusFilmDTO status = new StatusFilmDTO(); status.Id = reader.GetInt32("idStatusFilm"); status.Naziv = reader["nazivStatusFilm"].ToString(); return status; }
public List<FilmDTO> getAllByStatusFilm(StatusFilmDTO status) { MySqlConnection connection = ConnectionPool.checkOutConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = getByStatusQuerry; command.Parameters.AddWithValue("idStatus", status.Id); MySqlDataReader reader = command.ExecuteReader(); List<FilmDTO> lista = new List<FilmDTO>(); while (reader.Read()) { FilmDTO film = readerToFilmDTO(reader); film.Zanr = MySqlZanrDAO.readerToZanrDTO(reader); film.Status = status; film.Distributer = MySqlDistributerDAO.readerToDistributer(reader); lista.Add(film); } reader.Close(); ConnectionPool.checkInConnection(connection); return lista; }