//code voor het klikken op de Toevoegen knop om een docent als begeleider toe te voegen in het begeleiders panel/venster
        private void Btn_Begeleidertoevoegen_Click(object sender, EventArgs e)
        {
            Begeleider_Service begeleiderService = new Begeleider_Service();

            int DocentNummer = int.Parse(Txt_Docentnummeradd.Text);

            string DocentName = Txt_Docentnaamtoadd.ToString();

            if (DocentNummer != 0 && DocentName != "")
            {
                begeleiderService.AddNewBegeleider(DocentNummer);
            }

            ShowPanel("Begeleiders");
        }
        //code voor het klikken op de Verwijderen knop voor het verwijderen van een begeleider in het begeleiders panel/venster
        private void Btn_Begeleiderverwijderen_Click(object sender, EventArgs e)
        {
            string message = "Weet u zeker dat u deze begeleider wilt verwijderen?";
            string caption = "Begeleider verwijderen";
            var    result  = MessageBox.Show(message, caption, MessageBoxButtons.YesNo);

            if (result == DialogResult.No)
            {
                ShowPanel("Begeleiders");
            }
            else if (result == DialogResult.Yes)
            {
                Begeleider_Service begeleiderService = new Begeleider_Service();

                int BegeleiderNummer = int.Parse(Txt_Begeleidernummer.Text);

                begeleiderService.DeleteBegeleider(BegeleiderNummer);
            }

            ShowPanel("Begeleiders");
        }
        //code voor het wijzigen van de inhoud van de te selecteren begeleider combobox voor het verwijderen van een begeleider in het begeleiders venster
        private void Cmb_Begeleiders_SelectedIndexChanged(object sender, EventArgs e)
        {
            Begeleider_Service begeleiderService = new Begeleider_Service();

            string selectedBegeleiderstring = cmb_Begeleiders.GetItemText(cmb_Begeleiders.SelectedItem);

            int begeleidernummer = int.Parse(selectedBegeleiderstring);

            Begeleider selectedbegeleider = begeleiderService.GetBegeleiderById(begeleidernummer);

            Txt_Begeleidernummer.Text = selectedbegeleider.Begeleidernummer.ToString();

            Txt_Docentnummer.Text = selectedbegeleider.Teachernumber.ToString();

            Txt_Docentnaam.Text = selectedbegeleider.Teachername.ToString();

            Txt_Schoolvak.Text = selectedbegeleider.Subject.ToString();

            Txt_Docentkamernummer.Text = selectedbegeleider.Teacherroomnumber.ToString();

            Txt_Begeleidernummer.Enabled  = false;
            Txt_Docentnummer.Enabled      = false;
            Txt_Docentkamernummer.Enabled = false;
        }
        private void ShowPanel(string panelName)
        {
            if (panelName == "Dashboard")
            {
                // hide all other panels
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                // show dashboard
                pnl_Dashboard.Show();
                img_Dashboard.Show();
            }
            else if (panelName == "Students")
            {
                // hide all other panels
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                // show students
                pnl_Students.Show();



                // fill the students listview within the students panel with a list of students
                SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
                List <Student> studentList = studService.GetStudents();

                // clear the listview before filling it again
                listViewStudents.Clear();

                foreach (SomerenModel.Student s in studentList)
                {
                    ListViewItem li = new ListViewItem(s.Studentname, s.Studentnumber);
                    listViewStudents.Items.Add(li);
                }
            }
            else if (panelName == "Lecturers")
            {
                //hide all other panels
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                pnl_Lecturers.Show();

                Teacher_Service teachService = new Teacher_Service();
                List <Teacher>  teacherList  = teachService.GetTeachers();

                listViewLecturers.Clear();

                foreach (Teacher t in teacherList)
                {
                    ListViewItem li = new ListViewItem(t.Teachername, t.Teachernumber);
                    listViewLecturers.Items.Add(li);
                }
            }
            else if (panelName == "Rooms")
            {
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                pnl_Rooms.Show();

                Room_Service roomService = new Room_Service();
                List <Room>  roomList    = roomService.GetRooms();

                ListRoomBox.Items.Clear();

                foreach (Room r in roomList)
                {
                    ListRoomBox.Items.Add(r.RoomToString());
                }
            }
            else if (panelName == "Activities")
            {
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                pnl_Activiteitenlijst.Show();

                Activity_Service activityService = new Activity_Service();
                List <Activity>  activityList    = activityService.GetActivities();

                lv_Activiteitenlijst.Items.Clear();
                cmb_Activiteiten.Items.Clear();

                foreach (Activity a in activityList)
                {
                    ListViewItem li = new ListViewItem(a.Number.ToString());
                    li.SubItems.Add(a.Description.ToString());
                    li.SubItems.Add(a.StartTime.ToString());
                    li.SubItems.Add(a.NumberofStudents.ToString());
                    li.SubItems.Add(a.NumberofLecturers.ToString());
                    lv_Activiteitenlijst.Items.Add(li);

                    cmb_Activiteiten.Items.Add(a.ActiviteitcmbBoxToString());
                }

                cmb_Activiteiten.SelectedIndex = 0;
            }
            else if (panelName == "Drank")
            {
                //Hide all other panels (once again)
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                //show the Drinks panel
                pnl_Drank.Show();

                Drank_Service drankService = new Drank_Service();
                List <Drank>  drankList    = drankService.GetDrinks();

                lv_Drank.Items.Clear();

                foreach (Drank d in drankList)
                {
                    //drankService.StockCheck(d);

                    ListViewItem li = new ListViewItem(d.DrankName.ToString());
                    li.SubItems.Add(d.StockAmount.ToString());
                    li.SubItems.Add(d.Price.ToString());
                    li.SubItems.Add(drankService.StockCheck(d));
                    lv_Drank.Items.Add(li);
                }
            }
            else if (panelName == "Kassa")
            {
                //Hide all the other panels
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Omzetrapportage.Hide();
                pnl_Begeleiders.Hide();

                //show the Kassa panel
                pnl_Kassa.Show();

                cmb_Students.Items.Clear();

                Student_Service studentService = new Student_Service();
                List <Student>  studentList    = studentService.GetStudents();

                foreach (Student s in studentList)
                {
                    cmb_Students.Items.Add(s.Studentname);
                }

                //eerste student selecteren als standaard.
                cmb_Students.SelectedIndex = 0;



                cmb_Drinks.Items.Clear();

                Drank_Service drinksService = new Drank_Service();
                List <Drank>  drankList     = drinksService.GetAllDrinks();

                foreach (Drank d in drankList)
                {
                    cmb_Drinks.Items.Add(d.DrankName);
                }

                //eerste drank selecteren als standaard.
                cmb_Drinks.SelectedIndex = 0;


                Bestelling_Kassa_Service bestellingService = new Bestelling_Kassa_Service();
                List <Bestelling>        orderList         = bestellingService.GetOrders();

                //hier de listview van de bestellingen leegmaken om daarna weer te kunnen vullen
                lv_Bestelling.Items.Clear();

                foreach (Bestelling b in orderList)
                {
                    //drankService.StockCheck(d);

                    ListViewItem Order = new ListViewItem(b.Bestellingsnummer.ToString());
                    Order.SubItems.Add(b.Datum.ToString());

                    Drank Ordereddrank = drinksService.GetDrankById(b.Dranknummer);

                    Order.SubItems.Add(Ordereddrank.DrankName.ToString());

                    Student OrderedStudent = studentService.GetStudentById(b.Studentnummer);

                    Order.SubItems.Add(OrderedStudent.Studentname.ToString());

                    lv_Bestelling.Items.Add(Order);
                }
            }
            else if (panelName == "Omzetrapportage")
            {
                //Hide all the other panels
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Begeleiders.Hide();

                //show this panel
                pnl_Omzetrapportage.Show();
            }
            else if (panelName == "Begeleiders")
            {
                //Hide all the other panels
                pnl_Dashboard.Hide();
                img_Dashboard.Hide();
                pnl_Students.Hide();
                pnl_Lecturers.Hide();
                pnl_Rooms.Hide();
                pnl_Activiteitenlijst.Hide();
                pnl_Drank.Hide();
                pnl_Kassa.Hide();
                pnl_Omzetrapportage.Hide();

                //show this panel
                pnl_Begeleiders.Show();

                Begeleider_Service begeleiderService = new Begeleider_Service();
                List <Begeleider>  begeleiderList    = begeleiderService.GetBegeleiders();

                lv_Begeleiders.Items.Clear();
                cmb_Begeleiders.Items.Clear();

                foreach (Begeleider b in begeleiderList)
                {
                    ListViewItem li = new ListViewItem(b.Begeleidernummer.ToString());
                    li.SubItems.Add(b.Teachernumber.ToString());
                    li.SubItems.Add(b.Teachername.ToString());
                    li.SubItems.Add(b.Subject.ToString());
                    li.SubItems.Add(b.Teacherroomnumber.ToString());
                    lv_Begeleiders.Items.Add(li);

                    cmb_Begeleiders.Items.Add(b.Begeleidernummer.ToString());
                }

                cmb_Begeleiders.SelectedIndex = 0;

                Teacher_Service teacherService = new Teacher_Service();
                List <Teacher>  teacherList    = teacherService.GetTeachers();

                cmb_Docenten.Items.Clear();

                foreach (Teacher t in teacherList)
                {
                    cmb_Docenten.Items.Add(t.Teachernumber);
                }
                cmb_Docenten.SelectedIndex = 0;
            }
        }