public static ZanrDTO readerToZanrDTO(MySqlDataReader reader)
{
ZanrDTO zanr = new ZanrDTO();
zanr.Id = reader.GetInt32("idZanr");
zanr.Naziv = reader["nazivZanr"].ToString();
return zanr;
}
public int insert(ZanrDTO zanr)
{
if(zanr==null)
return 0;
MySqlConnection conn = ConnectionPool.checkOutConnection();
MySqlCommand command = conn.CreateCommand();
command.CommandText = insertQuerry;
command.Parameters.AddWithValue("naziv", zanr.Naziv);
command.ExecuteNonQuery();
int id =(int) command.LastInsertedId;
ConnectionPool.checkInConnection(conn);
return id;
}
public List<FilmDTO> getAllByZanr(ZanrDTO zanr)
{
MySqlConnection connection = ConnectionPool.checkOutConnection();
MySqlCommand command = connection.CreateCommand();
command.CommandText = getByZanrQuerry;
command.Parameters.AddWithValue("idZanr", zanr.Id);
MySqlDataReader reader = command.ExecuteReader();
List<FilmDTO> lista = new List<FilmDTO>();
while (reader.Read())
{
FilmDTO film = readerToFilmDTO(reader);
film.Zanr = zanr;
film.Status = MySqlStatusFilmDAO.readerToStatusFilmDTO(reader); ;
film.Distributer = MySqlDistributerDAO.readerToDistributer(reader);
lista.Add(film);
}
reader.Close();
ConnectionPool.checkInConnection(connection);
return lista;
}