private void UpdateScannedTag(object sender, TagEventArgs e)
{
if (scannedOnce == false)
{
this.scannedRFID = this.myRFIDHelper.RetrievedBraceletData;
this.tbScannedRFDNmb.Text = scannedRFID.RFIDNumber;
this.tbScannedRFIDStatus.Text = scannedRFID.Status.ToString();
if (this.scannedRFID.Status != StatusTypes.BraceletStatus.NOT_VALID)
{
lbReaderLog.Items.Insert(0, ">> Retrieved and RFID #:" + scannedRFID.RFIDNumber);
scannedOnce = true;
}
else
{
lbReaderLog.Items.Insert(0, "<< Or something went wrong");
lbReaderLog.Items.Insert(0, "<< Scanned RFID is not valid");
scannedOnce = false;
}
}
else
{
lbReaderLog.Items.Insert(0, "<< Press the button to scan again.");
lbReaderLog.Items.Insert(0, "<< You have already scanned once.");
}
}
/// <summary>
/// Sets the status of a certain bracelet to active
/// </summary>
/// <param name="chipNum"></param>
/// <returns></returns>
private bool ActivateBracelet(RFIDData chipData)
{
connection.Close();
bool methodResult = false;
String sql = "";
if (chipData.Status == StatusTypes.BraceletStatus.STAND_BY)
{
sql = "UPDATE RFIDS "
+ "SET STATUS = \"ACTIVE\""
+ "WHERE BRACELET_ID =" + " \"" + chipData.RFIDNumber + "\" ";
}
;
if (chipData.Status == StatusTypes.BraceletStatus.NOT_VALID)
{
sql = "INSERT INTO RFIDS "
+ " (STATUS,BRACELET_ID) values"
+ "(\"ACTIVE\"," + " \"" + chipData.RFIDNumber + "\"); ";
}
MySqlCommand command = new MySqlCommand(sql, connection);
try
{
connection.Open();
int affectedRows = 0;
affectedRows += command.ExecuteNonQuery();
switch (affectedRows)
{
case 0:
methodResult = false;
break;
//check sum == 1
case 1:
methodResult = true;
break;
default:
methodResult = false;
break;
}
}
catch (Exception ex)
{
methodResult = false;
//AutoClosingMessageBox.Show(ex.Message, "Oups!", messageShowTime);
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
return(methodResult);
}
public bool UpdateVisitorBracelet(RFIDData newChipData, string email)
{
connection.Close();
bool methodResult = false;
String sql = "UPDATE VISITORS "
+ "SET BRACELET_ID =" + " \"" + newChipData.RFIDNumber + "\" "
+ "WHERE LOWER(EMAIL) =" + " \"" + email.ToLower() + "\" ";
MySqlCommand command = new MySqlCommand(sql, connection);
try
{
connection.Open();
this.ActivateBracelet(newChipData);
int affectedRows = 0;
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
affectedRows += command.ExecuteNonQuery();
switch (affectedRows)
{
//check sum == 1
case 1:
methodResult = true;
break;
default:
methodResult = false;
break;
}
}
catch (Exception ex)
{
methodResult = false;
AutoClosingMessageBox.Show(ex.Message, "Oups!", messageShowTime);
}
finally
{
connection.Close();
}
return(methodResult);
}
private void ProcessThisTag(object sender, TagEventArgs e)
{
this.RetrievedBraceletData = new RFIDData(e.Tag.ToString());
}
