/// <summary>
/// Returns the status of the requred RFID chip
/// </summary>
/// <param name="chipNum"></param>
/// <returns></returns>
public StatusTypes.BraceletStatus getRFIDStatus(string chipNum)
{
//First we make sure that something meaningful is returned in all cases
StatusTypes.BraceletStatus valueToReturn = StatusTypes.BraceletStatus.NOT_VALID;
// Somekind of a protective measure
chipNum = RemoveWhiteSpaces(chipNum);
// Some crazy ass db interaction
String sql = "SELECT * FROM RFIDS WHERE BRACELET_ID =" + " \"" + chipNum + "\" ";
MySqlCommand command = new MySqlCommand(sql, connection);
try
{
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader["STATUS"] != DBNull.Value)
{
string recStatus = reader["STATUS"].ToString();
// solution from msdn:
//Colors colorValue = (Colors) Enum.Parse(typeof(Colors), colorString);
StatusTypes.BraceletStatus bracStatus = (StatusTypes.BraceletStatus)Enum.Parse((typeof(StatusTypes.BraceletStatus)), recStatus);
// should create a new instance of a retrieved status for this particular chip
valueToReturn = bracStatus;
}
}
}
catch (Exception ex)
{
AutoClosingMessageBox.Show(ex.ToString(), "Oups! You can skip it", messageShowTime);
}
finally
{
connection.Close();
}
return(valueToReturn);
}
public void SetRFIDStatus(StatusTypes.BraceletStatus newStatus)
{
this.RFIDStatus = newStatus;
}
//--------Methods:
//private StatusTypes.BraceletStatus GetStatus(string chipNum)
//{
// //Database interaction here:
// StatusTypes.BraceletStatus tempData = DBHelper.getRFIDStatus(this.RFIDNumber);
// return tempData;
//}
//--------Constructors:
public RFIDData(string rfidNumber)
{
this.RFIDNumber = rfidNumber;
this.Status = myDBHelper.getRFIDStatus(this.RFIDNumber);
}
