private void controlsToDistributer(DistributerDTO distributer) { distributer.Naziv = tbxNaziv.Text; distributer.Adresa = tbxAdresa.Text; distributer.Telefon = tbxBrojTelefona.Text; distributer.Email = tbxEmail.Text; }
public static DistributerDTO readerToDistributer(MySqlDataReader reader) { DistributerDTO distributer = new DistributerDTO(); distributer.Id = reader.GetInt32("idDistributer"); distributer.Naziv = reader["nazivDistributer"].ToString(); distributer.Adresa = reader["adresaDistributer"].ToString(); distributer.Telefon = reader["telefonDistributer"].ToString(); distributer.Email = reader["e_mailDistributer"].ToString(); return distributer; }
public DistributerDodajForm(DistributerDTO distributer) { InitializeComponent(); this.Text = "Izmjena distributera"; tbxNaziv.Text = distributer.Naziv; tbxAdresa.Text = distributer.Adresa; tbxEmail.Text = distributer.Email; tbxBrojTelefona.Text = distributer.Telefon; this.distributer = distributer; }
private bool insertDistributer() { if (validate()) { DistributerDTO distributer = new DistributerDTO(); controlsToDistributer(distributer); long id=BioskopUtil.getDAOFactory().getDistributerDAO().insert(distributer); if (id > 0) return true; else return false; } return false; }
public List<FilmDTO> getAllByDistributer(DistributerDTO distributer) { MySqlConnection connection = ConnectionPool.checkOutConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = getByDistributerQuerry; command.Parameters.AddWithValue("idDistributer", distributer.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 = MySqlStatusFilmDAO.readerToStatusFilmDTO(reader); film.Distributer = distributer; lista.Add(film); } reader.Close(); ConnectionPool.checkInConnection(connection); return lista; }
private void prikaziDetalje(DistributerDTO distributer) { lblNazivDist.Text = distributer.Naziv; lblAdresaDist.Text = distributer.Adresa; lblEmailDist.Text = distributer.Email; lblBrojTelefonaDist.Text = distributer.Telefon; List<FilmDTO> filmovi = BioskopUtil.getDAOFactory().getFilmDAO().getAllByDistributer(distributer); dgvFilmovi.Rows.Clear(); foreach (FilmDTO film in filmovi) { dgvFilmovi.Rows.Add(film.Naziv, film.Zanr.Naziv, film.Trajanje, film.Status.Naziv, film.Id); } showDistributer(); }
public long insert(DistributerDTO distributer) { if (distributer == null) { throw new MySqlDAOException(); } MySqlConnection connection = ConnectionPool.checkOutConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = insertQuerry; command.Parameters.AddWithValue("naziv", distributer.Naziv); command.Parameters.AddWithValue("adresa", distributer.Adresa); command.Parameters.AddWithValue("telefon", distributer.Telefon); command.Parameters.AddWithValue("eMail", distributer.Email); command.ExecuteNonQuery(); long id = command.LastInsertedId; ConnectionPool.checkInConnection(connection); return id; }
public bool update(DistributerDTO distributer) { if (distributer == null) { throw new MySqlDAOException(); } MySqlConnection connection = ConnectionPool.checkOutConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = updateQuerry; command.Parameters.AddWithValue("naziv", distributer.Naziv); command.Parameters.AddWithValue("adresa", distributer.Adresa); command.Parameters.AddWithValue("telefon", distributer.Telefon); command.Parameters.AddWithValue("eMail", distributer.Email); command.Parameters.AddWithValue("id", distributer.Id); int rows=command.ExecuteNonQuery(); ConnectionPool.checkInConnection(connection); return rows>0; }