/// <summary>
/// Gets all blocks from a specified switchboard panel.
/// </summary>
/// <param name="decoderId">The switchboard panel unique identifier (DB).</param>
/// <returns>The requested list of <see cref="BlockBase"/>.</returns>
public List <ModuleConnection> GetByDecoder(int decoderId)
{
string sql = string.Empty;
ModuleConnection item = null;
List <ModuleConnection> items = new List <ModuleConnection>();
Logger.LogDebug(this, "[CLASS].GetByDecoder({0})", decoderId);
try
{
Connect();
sql = @"SELECT
" + ModuleConnectionManager.SQL_FIELDS_SELECT + @"
FROM
" + ModuleConnectionManager.SQL_TABLE + @"
WHERE
panelid = @panelid";
SetParameter("panelid", decoderId);
using (SQLiteDataReader reader = ExecuteReader(sql))
{
while (reader.Read())
{
item = ModuleConnectionManager.ReadEntityRecord(reader);
if (item != null)
{
items.Add(item);
}
}
}
return(items);
}
catch (Exception ex)
{
Logger.LogError(this, ex);
throw;
}
finally
{
Disconnect();
}
}
/// <summary>
/// Recupera las propiedades de una Administración/Operadora.
/// </summary>
/// <param name="itemid">Identificador.</param>
/// <returns>Una instáncia de RCAdministration.</returns>
public ModuleConnection GetByID(Int64 id)
{
string sql = string.Empty;
Logger.LogDebug(this, "[CLASS].GetByID({0})", id);
try
{
Connect();
sql = @"SELECT
" + ModuleConnectionManager.SQL_FIELDS_SELECT + @"
FROM
" + ModuleConnectionManager.SQL_TABLE + @"
WHERE
id = @id";
SetParameter("id", id);
using (SQLiteDataReader reader = ExecuteReader(sql))
{
if (reader.Read())
{
return(ModuleConnectionManager.ReadEntityRecord(reader));
}
}
return(null);
}
catch (Exception ex)
{
Logger.LogError(this, ex);
throw;
}
finally
{
Disconnect();
}
}
