/// <summary>
/// Recupera las propiedades de un decodificador.
/// </summary>
/// <param name="itemid">Identificador del decodificador.</param>
/// <returns>Una instáncia de RCDecoder.</returns>
public Decoder GetByName(string name)
{
string sql = string.Empty;
try
{
Connect();
sql = @"SELECT
" + DecoderDAO.SQL_FIELDS_SELECT + @"
FROM
" + DecoderDAO.SQL_TABLE + @"
WHERE
decname = @decname";
SetParameter("decname", name);
using (SQLiteDataReader reader = ExecuteReader(sql))
{
if (reader.Read())
{
return(DecoderDAO.ReadEntityRecord(reader));
}
reader.Close();
}
return(null);
}
catch (Exception ex)
{
Logger.LogError(this, ex);
throw;
}
finally
{
Disconnect();
}
}
/// <summary>
/// Get all decoders.
/// </summary>
/// <returns>The requested list of decoders.</returns>
public List <Decoder> GetAll()
{
string sql = string.Empty;
List <Decoder> items = new List <Decoder>();
try
{
Connect();
sql = @"SELECT
" + DecoderDAO.SQL_FIELDS_SELECT + @"
FROM
" + DecoderDAO.SQL_TABLE + @"
ORDER BY
decname Asc";
using (SQLiteDataReader reader = ExecuteReader(sql))
{
while (reader.Read())
{
items.Add(DecoderDAO.ReadEntityRecord(reader));
}
reader.Close();
}
return(items);
}
catch (Exception ex)
{
Logger.LogError(this, ex);
throw;
}
finally
{
Disconnect();
}
}