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