//per locatie
private void button6_Click(object sender, EventArgs e)
{
this.Hide();
var nextForm = new ZoekScherm(this, 2, "SELECT * FROM Boek WHERE vakId IN (SELECT vakId FROM Vak WHERE boekenkastId IN (SELECT boekenkastId FROM Boekenkast WHERE locatieId = @locatieId ));", "Locatie", "SELECT * FROM Locatie;", "naam", "locatieId");
nextForm.Show();
}
//per kast
private void button5_Click(object sender, EventArgs e)
{
this.Hide();
var nextForm = new ZoekScherm(this, 2, "SELECT * FROM Boek WHERE vakId IN (SELECT vakId FROM Vak WHERE boekenkastId = @boekenkastId );", "Boekenkast", "SELECT * FROM Boekenkast;", "plaats", "boekenkastId");
nextForm.Show();
}
//totaal overzicht
private void button1_Click(object sender, EventArgs e)
{
this.Hide();
var nextForm = new ZoekScherm(this, 3, "SELECT * FROM Boek ;", "Alle boeken");
nextForm.Show();
}
//per vak
private void button4_Click(object sender, EventArgs e)
{
this.Hide();
var nextForm = new ZoekScherm(this, 2, "SELECT * FROM Boek WHERE vakId = @vakId ;", "Vak", "SELECT * FROM Vak;", "naam", "vakId");
nextForm.Show();
}
//per titel
private void button2_Click(object sender, EventArgs e)
{
this.Hide();
var nextForm = new ZoekScherm(this, 1, "SELECT * FROM Boek WHERE titel = @titel ;", "Titel");
nextForm.Show();
}
//per genre
private void button3_Click(object sender, EventArgs e)
{
this.Hide();
var nextForm = new ZoekScherm(this, 1, "SELECT * FROM Boek WHERE genre = @genre ;", "Genre");
nextForm.Show();
}