private void buttonbookingstatus_Click(object sender, EventArgs e)
        {
            Customer_Book_Event cbe = new Customer_Book_Event(user);

            this.Hide();
            cbe.Show();
        }
        public void InsertInto(string a, string b, string c, int d, int p, string food, string equipment, double cost)
        {
            BookingService bService = new BookingService();
            int            result   = bService.Insert(new Booking()
            {
                EventType = a, Vanue = b, Date = c, NoOfGuest = d, Status = p, SelectedFood = food, SelectedEquipment = equipment, Cost = cost
            });

            if (result > 0)
            {
                BookingService bs = new BookingService();
                var            x  = bs.GetAllBooking();
                foreach (var s in x)
                {
                    m = s.Id;
                }

                if (Convert.ToInt32(textBox4.Text) > 0)
                {
                    Mailsend(m);
                    MessageBox.Show("request successsful!\n Remember your Booking Id is  " + m);
                    Customer_Home       ch = new Customer_Home();
                    Customer_Book_Event cb = new Customer_Book_Event();
                    cb.Hide();
                    ch.Show();
                }
                else
                {
                    MessageBox.Show("Number Of Guests can not be 0");
                }
            }
            else
            {
                MessageBox.Show("Error");
            }
        }