private void btnProcess_Click(object sender, EventArgs e) { if (RFIDTagNr != null) { lbChekingStatus.Text = ""; lbReservStatus.Text = ""; lbRFIDStatus.Text = ""; Visitor visitor = GetVisitor(RFIDTagNr); if (visitor != null) {// retrieved visitor details CampingReservation reserv = GetAReservation(visitor); if (reserv != null) { // reservation found for this participant if (UpdateStatus(reserv)) { // participant has checked in lbChekingStatus.Text = "CheckedIn."; } else { lbChekingStatus.Text = "The visitor is already checked into CampingSpot."; } } else { lbReservStatus.Text = "No reservation found "; } } else { lbReservStatus.Text = "visitor doesn't exists in the database."; } } }
public bool UpdateCheckingStatus(CampingReservation CampingReservation) { if (CampingReservation.PresentlyChekedIn) {// visitor is already inside the camping ground. return(false); } MySqlCommand command = new MySqlCommand("UPDATE CAMPINGRESERVATION SET PRESENTLYCHECKEDIN = 'YES' WHERE EVENTID = " + CampingReservation.EventID, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch { System.Windows.Forms.MessageBox.Show("Error Occured."); } finally { connection.Close(); } return(true); }
public CampingReservation GetReservation(int EventID, int SpotID) { MySqlCommand command = new MySqlCommand("SELECT * FROM CAMPINGRESERVATION WHERE EVENTID = " + EventID + " AND CAMPINGSPOTID = " + SpotID + "", connection); CampingReservation CampingReservation = null; try { connection.Open(); MySqlDataReader r = command.ExecuteReader(); bool x = r.Read(); if (r["EVENTID"] == DBNull.Value) { EventID = 0; // the visitor doesn't have a reservation. } else { EventID = Convert.ToInt32(r["EVENTID"]); } if (r["SPOTID"] == DBNull.Value) { SpotID = 0; // the visitor doesn't have a reservation. } else { SpotID = Convert.ToInt32(r["CAMPINGSPOTID"]); } bool CurrentlyCheckedIn; if (r["PRESENTLYCHECKEDIN"].ToString() == "YES") { CurrentlyCheckedIn = true; } else { CurrentlyCheckedIn = false; } return(CampingReservation = new CampingReservation(EventID, SpotID, CurrentlyCheckedIn)); // reservation found. } catch (Exception exc) { MessageBox.Show(exc.Message); } finally { connection.Close(); } return(CampingReservation); // no reservation }
private bool UpdateStatus(CampingReservation reserv) { CampingReservation_DataHelper reservData = new CampingReservation_DataHelper(); return(reservData.UpdateCheckingStatus(reserv)); }