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