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));
}
