public void loadDGV()
        {
            dgvHotel.DataSource = null;
            dgvHotel.DataSource = DAOReservation.getAllReservation();
            dgvHotel.Columns["IdParticipant"].Visible = false;
            dgvHotel.Columns["IdHotel"].Visible       = false;

            // on redimensionne automatiquement la largeur des colonnes du datagridview
            dgvHotel.AutoResizeColumns();
        }
        private void BtnEditReservation_Click(object sender, EventArgs e)
        {
            Int32 idParticipant = ((KeyValuePair <int, String>)cBoxParticipant.SelectedItem).Key;
            Int32 idHotel       = ((KeyValuePair <int, String>)cBoxHotel.SelectedItem).Key;


            DAOReservation.editReservation(Convert.ToInt32(dgvHotel.CurrentRow.Cells[0].Value),
                                           idParticipant,
                                           idHotel,
                                           Convert.ToInt32(txtBoxNbJour.Text));

            loadDGV();
        }
        private void btnAddHotel_Click(object sender, EventArgs e)
        {
            if (txtBoxNbJour.Text == "Nombre de jours réservation")
            {
                MessageBox.Show("Vous devez remplir les champs");
            }
            else
            {
                Int32 idParticipant = ((KeyValuePair <int, String>)cBoxParticipant.SelectedItem).Key;
                Int32 idHotel       = ((KeyValuePair <int, String>)cBoxHotel.SelectedItem).Key;

                DAOReservation.addReservation(idParticipant, idHotel, Convert.ToInt32(txtBoxNbJour.Text));

                loadDGV();

                txtBoxNbJour.Text = "Nombre de jours réservation";
            }
        }
        private void btnDeleteHotel_Click(object sender, EventArgs e)
        {
            DAOReservation.delReservation(Convert.ToInt32(dgvHotel.CurrentRow.Cells[0].Value));

            loadDGV();
        }