private void timer1_Tick(object sender, EventArgs e) { Visitor_DataHelper visitorData = new Visitor_DataHelper(); timer1.Interval = 3000; timer1.Enabled = true; int nr = visitorData.GetPresentParticipants(); //if (nr > -1) //{ // totalVisitors.Text = nr.ToString(); //} }
private void button1_Click(object sender, EventArgs e) { //lbTotalNrSoldTickets.Text = ticketData.GetTicket().ToString(); // display total number of booked spots: lbavisitor.Text = VisitorData.getabsentvisitor().ToString(); lbtotalcamp.Text = campingSpotData.bOOKEDSPOT().ToString(); // display total number of sold supplies: lbhireditems.Text = BORROWEDDATA.GetTotalbORROWEDeQUIP().ToString(); lbtotalboat.Text = boatdata.GetBookedBoat().ToString(); // display total balance of all accounts: lbtotalbalnc.Text = VisitorData.CalculateTotalBalance().ToString(); //???// display number of participant left the event: SELECT COUNT(*) FROM PARTICIPANT WHERE HASCHECKEDIN = 'NO'; // display present total number of participants: lbpvisitor.Text = VisitorData.GetPresentParticipants().ToString(); }