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