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