private void btnConfirmPresident_Click(object sender, EventArgs e)
        {
            this.Hide();
            GuestReservation gr = new GuestReservation();

            gr.Show();
        }
        private void btnConfirmSDelux_Click_1(object sender, EventArgs e)
        {
            Room s = guest.confirm(txtBookSDelux.Text);

            if (s != null)
            {
                this.Hide();

                GuestReservation rg = new GuestReservation(s.Room_num, s.Room_floor, s.Room_type, s.Room_price, guest);

                rg.Show();
            }
            else
            {
                MessageBox.Show("Sorry room " + txtBookSDelux.Text + " is already booked.");
            }
        }
        private void btnConfirmSin_Click(object sender, EventArgs e)
        {
            Room s = guest.confirm(txtBookSin.Text);

            if (s != null)
            {
                this.Hide();

                GuestReservation rg = new GuestReservation(s.Room_num, s.Room_floor, s.Room_type, s.Room_price, guest);

                rg.Show();
            }
            else
            {
                MessageBox.Show("Sorry room " + txtBookSin.Text + " is already booked.");
            }
            //RoomForGuest a = new RoomForGuest();
            //try
            //{
            //    var rfg = from m in cntx.Rooms
            //              where m.Room_num == txtBookSin.Text
            //              select m;

            //    Room s = rfg.First();
            //    if (s.Room_bookingStatus.Equals("unbooked"))
            //    {
            //        this.Hide();
            //        GuestReservation rg = new GuestReservation(s.Room_num, s.Room_floor, s.Room_type, s.Room_price);

            //        rg.Show();

            //    }
            //    else
            //    {
            //        MessageBox.Show("Sorry room " + s.Room_num + " is already booked.");
            //    }
            //}

            //catch (Exception ex9)
            //{
            //    MessageBox.Show("Invalid RoomNO");
            //}
        }