private void LoadTijdAdd() { FilmDate.MinDate = DateTime.Now; var Function = new Functions(); DataRowCollection film = Functions.Select("SELECT naam,id FROM Films"); foreach (DataRow row in film) { CustomComboBox item = new CustomComboBox(); item.Text = row["naam"].ToString(); item.Value = Int32.Parse(row["id"].ToString()); MovieAdd.Items.Add(item); } DataRowCollection zaal = Functions.Select("SELECT naam,id FROM zalen"); foreach (DataRow row in zaal) { CustomComboBox item = new CustomComboBox(); item.Text = row["naam"].ToString(); item.Value = Int32.Parse(row["id"].ToString()); ZaalAdd.Items.Add(item); } }
public void LoadAdd(int film_id) { var Function = new Functions(); DataRowCollection data = Functions.Select("SELECT * FROM Genres"); foreach (DataRow row in data) { CustomComboBox item = new CustomComboBox(); item.Text = row["naam"].ToString(); item.Value = Int32.Parse(row["id"].ToString()); FilmGenre.Items.Add(item); } FilmAge.Items.Add("0"); FilmAge.Items.Add("6"); FilmAge.Items.Add("9"); FilmAge.Items.Add("12"); FilmAge.Items.Add("16"); FilmAge.Items.Add("18"); if (film_id > 0) { DataRowCollection film = Functions.Select("SELECT g.naam as GenreNaam, f.naam as FilmNaam, * FROM films f LEFT JOIN Genres g ON f.genre = g.id WHERE f.id= '" + film_id + "'"); FilmNaam.Text = film[0]["FilmNaam"].ToString(); FilmAge.Text = film[0]["leeftijd"].ToString(); FilmTime.Text = film[0]["speel_duur"].ToString(); FilmTrailer.Text = film[0]["youtube_code"].ToString(); FilmDisc.Text = film[0]["beschrijving"].ToString(); FilmGenre.Text = film[0]["GenreNaam"].ToString(); FilmGenre.SelectedIndex = FilmGenre.FindStringExact(film[0]["GenreNaam"].ToString()); FilmAge.SelectedIndex = FilmAge.FindStringExact(film[0]["leeftijd"].ToString()); FilmAddButton.Text = "Aanpassen"; } }