/// <summary>
/// Selects all rows from the Riviera code table.
/// </summary>
/// <param name="conn">The current connection.</param>
/// <returns></returns>
public static IEnumerable <RivieraCodeRow> SelectAll(DB_Connector conn)
{
try
{
QueryBuilder qB = new QueryBuilder(TABLENAME, conn);
qB.AddSelectionColumn();
String query = qB.GetQuery();
var result = conn.SelectView <RivieraCodeRow>(query);
return(result);
}
catch (Exception exc)
{
throw exc.CreateNamelessException <RivieraException>(ERR_LOAD_RIV_CODES);
}
}
/// <summary>
/// Selects all.
/// </summary>
/// <param name="conn">The database connection</param>
/// <param name="tableName">The table name</param>
/// <typeparam name="T">The type of selected row</typeparam>
/// <returns>The selected rows</returns>
public static IEnumerable <T> SelectAll <T>(string tableName, DB_Connector conn) where T : RivieraMeasureRow
{
try
{
QueryBuilder qb = new QueryBuilder(tableName, conn);
qb.AddSelectionColumn();
String query = qb.GetQuery();
var result = conn.SelectView <T>(query);
return(result);
}
catch (Exception)
{
return(new T[0]);
}
}
