public CampingSpot GetASpot(int ID) { // String eventnr = Convert.ToString(ID); MySqlCommand command = new MySqlCommand("SELECT * FROM CAMPINGSPOT WHERE CAMPINGSPOTID=" + ID, connection); CampingSpot CampingSpot = null; try { connection.Open(); MySqlDataReader r = command.ExecuteReader(); r.Read(); int CampingSpotID = Convert.ToInt32(r["CAMPINGSPOTID"]); string CAMPSPOT = Convert.ToString(r["CAMPSPOT"]); int day = Convert.ToInt32(r["CAMPDAY"]); // string rfid = r["RFID"].ToString(); int NumberofParticipants = Convert.ToInt32(r["NUMBEROFPARTICIPANTS"]); decimal Price = Convert.ToDecimal(r["PRICE"]); // string email = r["EMAIL"].ToString(); int isavailabe = Convert.ToInt32(r["ISAVAILABLE"]); //bool isavailabel; //if (r["ISAVAILABLE"].ToString() == "NO") //{ // isavailabel = false; //} //else //{// YES // isavailabel = true; //} int HASPAID = Convert.ToInt32(r["HASPAID"]); //bool HASPAID; //if (r["HASPAID"].ToString() == "NO") //{ // HASPAID = false; //} //else //{// YES // HASPAID = true; //} return(CampingSpot = new CampingSpot(CampingSpotID, CAMPSPOT, day, isavailabe, NumberofParticipants, Price, HASPAID)); } catch { MessageBox.Show("Error occurred."); } finally { connection.Close(); } return(CampingSpot); // no visitor found. }
//private string GiveRFID(Visitor visitor, string RFIDTagNr) //{ // bool updated = visitordata.UpdateRFIDStatus(/*visitor,*/ RFIDTagNr); // if (updated) // { // return "Allowed to enter into Event."; // } // else // { // return "The visitor is already inside the spot!"; // } //} private void btnProcess_Click(object sender, EventArgs e) { if (tbspotID.Text != "") { lbRFIDStatus.Text = ""; lbWarning.Text = ""; lbGreetings.Text = ""; phidget.RFID.Tag += new RFIDTagEventHandler(AssignARFID); CampingSpot spot = CheckForSpotID(); int paymentStatus; if (spot != null) { lbWarning.Text = "The visitor has made a reserveration."; lbGreetings.Text = "Welcome to VestroVestival campingSpot "; lbday.Text = "Visitor has made the reservation for\n" + spot.day + " day(s)"; paymentStatus = CheckPaymentStatus(spot); if (RFIDTagNr != null) { lbGreetings.Text = "had a Rfid already"; lbWarning.Text = ""; } else { lbRFIDStatus.Text = ""; } } } }
//private string GiveRFID(Visitor visitor, string RFIDTagNr) //{ // bool updated = visitordata.UpdateRFIDStatus(/*visitor,*/ RFIDTagNr); // if (updated) // { // return "Allowed to enter into Event."; // } // else // { // return "The visitor is already inside the spot!"; // } //} private void btnProcess_Click(object sender, EventArgs e) { if (tbspotID.Text != "") { lbRFIDStatus.Text = ""; lbWarning.Text = ""; lbGreetings.Text = ""; phidget.RFID.Tag += new RFIDTagEventHandler(AssignARFID); CampingSpot spot = CheckForSpotID(); bool paymentStatus; if (spot != null) { lbWarning.Text = "The visitor has made a reserveration."; lbGreetings.Text = "Welcome to VestroVestival campingSpot "; paymentStatus = CheckPaymentStatus(spot); if (paymentStatus) { if (RFIDTagNr != null) { lbGreetings.Text = "had a Rfid already"; lbWarning.Text = ""; } else { lbRFIDStatus.Text = "Scan an RFID ."; } } else { lbWarning.Text = "The campingSpot fee is pending or not paid yet!"; } } } }
private bool CheckPaymentStatus(CampingSpot spot) { return(spot.HasPaid); }