/// <summary>
/// Fetches a specific operation role
/// </summary>
/// <param name="output"></param>
/// <param name="id"></param>
/// <returns></returns>
public static bool FetchById(ref OperationRole output, int id)
{
SQLiteDataReader reader = DBI.DoPreparedQuery(
"SELECT * FROM OperationRole WHERE id = @id LIMIT 1;",
new Tuple <string, object>("@id", id));
if (reader != null && reader.Read())
{
output = OperationRole.Factory(reader);
return(true);
}
return(false);
}
/// <summary>
/// Fetches all operation roles which can be assigned to a boat
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public static bool FetchAllBoats(ref List <OperationRole> output)
{
output = new List <OperationRole>();
SQLiteDataReader reader = DBI.DoQuery(
@"SELECT * FROM OperationRole
WHERE onBoats = 1
ORDER BY id ASC;" );
while (reader != null && reader.Read())
{
output.Add(OperationRole.Factory(reader));
}
return(true);
}
