/// <summary>
/// Gets all bracelets from the database and also counts their number
/// the number is returned via the out parameter nmbr
/// </summary>
/// <param name="nmbr"></param>
/// <returns></returns>
static public List <Bracelet> GetAllBracelets(out int nmbr)
{
String sql = "SELECT * FROM rfids";
MySqlCommand command = new MySqlCommand(sql, DBConnectionDll.Connection.connection);
nmbr = 0;
List <Bracelet> temp;
temp = new List <Bracelet>();
try
{
DBConnectionDll.Connection.connection.Open();
MySqlDataReader reader = command.ExecuteReader();
// data to build a new product upon
string id;
BracStatusType status = BracStatusType.NOT_VALID;
while (reader.Read())
{
id = Convert.ToString(reader["bracelet_id"]);
nmbr++;
try
{
// converts a string retrieved from db to the enum type
status = (BracStatusType)Enum.Parse(typeof(BracStatusType), reader["status"].ToString());
}
catch
{
Console.WriteLine("damn");
}
temp.Add(new Bracelet(id, status));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
DBConnectionDll.Connection.connection.Close();
}
return(temp);
}
/// <summary>
/// Creates an instance of a bracelet with the set parameters
/// </summary>
/// <param name="id"></param>
/// <param name="status"></param>
public Bracelet(string id, BracStatusType status)
{
this.Id = id;
this.Status = status;
}
