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