private void btnUpdate_Click(object sender, EventArgs e)
        { //Checking the fields and comboboxes and the selected values during updating process
            bool fields = checkFields(txtICPassport.Text);

            if (fields == true)
            {
                bool found = CustChecking(txtICPassport.Text);
                if (found == true)
                {
                    bool tour = TourChecking(cmbBooking.Text);
                    if (tour == true)
                    {
                        bool hotelCheck = PackHotChecking(cmbBooking.Text);
                        if (hotelCheck == true)
                        {
                            DialogResult confirm;
                            confirm = MessageBox.Show($"Please, Confirm modification with the following details \n\n IC/Passport ID : {txtICPassport.Text} \n Booking Type : {cmbBooking.Text} \n Location : {cmbLocation.Text} \n Booking Date : {dateTimePicker1.Text} \n Hotel : {cmbHotel.Text} \n Room Type : {cmbRoom.Text}", "Confirm Booking", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                            if (confirm == DialogResult.OK)
                            { // update booking based on the type
                                if (cmbBooking.Text == "Tour Package")
                                {
                                    DBConnect Update  = new DBConnect();
                                    bool      success = Update.UpdateTourBooking(txtBookingNo.Text, txtICPassport.Text, dateTimePicker1.Text, cmbBooking.Text, cmbLocation.Text);
                                    successful(success);
                                }

                                else if (cmbBooking.Text == "Tour Package & Hotel")
                                {
                                    DBConnect update  = new DBConnect();
                                    bool      success = update.UpdateBooking(txtBookingNo.Text, txtICPassport.Text, dateTimePicker1.Text, cmbBooking.Text, cmbLocation.Text, cmbHotel.Text, cmbRoom.Text, int.Parse(cmbNight.Text));
                                    successful(success);
                                }
                                else if (cmbBooking.Text == "Hotel")
                                {
                                    DBConnect update  = new DBConnect();
                                    bool      success = update.UpdateHotelBooking(txtBookingNo.Text, txtICPassport.Text, dateTimePicker1.Text, cmbBooking.Text, cmbHotel.Text, cmbRoom.Text, int.Parse(cmbNight.Text));
                                    successful(success);
                                }
                            }
                        }
                    }
                }
            }
        }