private void button1_Click(object sender, EventArgs e)
{
localhost.Service1 service = new localhost.Service1();
string name = txtname2.Text;
string dateofevent = txtbateofevent.Text;
string days = txtdayofevent.Text;
string usercode = txtcode2.Text;
string eventcode = txtcode3.Text;
string location = txtloct.Text;
string guestquantity = txtgq.Text;
string Payment = txtpaym.Text;
service.AddEvent(name, dateofevent, days, usercode, eventcode, location, guestquantity, Payment);
MessageBox.Show("Event has been booked");
}