//Wrapper method for GetDevice, returns bool depending on if a device is found. public bool Exists(string Device_Val, DatabaseGetMode mode) { FeederDevice res = GetDevice(Device_Val, mode); if (res == null) { return(false); } else { return(true); } }
//Uses the enum to find and return a device by searching via UUID or Name public FeederDevice GetDevice(string Device_Val, DatabaseGetMode mode) { FeederDevice retval = null; using (MySqlConnection conn = GetConnection()) { try { conn.Open(); MySqlCommand cmd = null; if (mode == DatabaseGetMode.UUID) { cmd = new MySqlCommand("select * from Connected_Devices where UUID = @_UUID;", conn); cmd.Parameters.AddWithValue("_UUID", Device_Val); } else if (mode == DatabaseGetMode.Name) { cmd = new MySqlCommand("select * from Connected_Devices where Device_Name = @Name;", conn); cmd.Parameters.AddWithValue("Name", Device_Val); } cmd.Prepare(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { retval = new FeederDevice { DeviceID = Convert.ToInt32(reader["DeviceID"]), Device_Name = reader["Device_Name"].ToString(), UUID = reader["UUID"].ToString() }; } } conn.Close(); } catch { retval = null; Console.WriteLine("Error when searching"); } } return(retval); }