public TaxonomyReportModel[] GetTaxonomyReportsByTaxonomyId(string taxonomyId)
{
string query = @"SELECT *
FROM XMS_TAXONOMY_REPORTS
WHERE TAXONOMY_ID = :TaxonomyId
ORDER BY ID";
return(Connection.Query(query, new
{
TaxonomyId = taxonomyId
}).Select(dbRow => new TaxonomyReportModel()
{
Currency = dbRow.CURRENCY,
Decimals = dbRow.DECIMALS,
DecimalDecimals = dbRow.DECIMAL_DECIMALS,
Description = dbRow.DESCRIPTION,
EntityIdentifier = dbRow.ENTITY_IDENTIFIER,
EntitySchema = dbRow.ENTITY_SCHEMA,
EntryUri = dbRow.ENTRY_URI,
FileName = dbRow.FILE_NAME,
Id = dbRow.ID,
IntegerDecimals = dbRow.INTEGER_DECIMALS,
MonetaryDecimals = dbRow.MONETARY_DECIMALS,
PeriodType = OracleHelpers.StringToPeriodType(dbRow.PERIOD_TYPE),
PureDecimals = dbRow.PURE_DECIMALS,
SharesDecimals = dbRow.SHARES_DECIMALS,
TaxonomyId = dbRow.TAXONOMY_ID,
TnProcessorId = dbRow.TN_PROCESSOR_ID,
TnRevisionId = dbRow.TN_REVISION_ID,
}).ToArray());
}
public PeriodTypeModel[] GetPeriodTypes()
{
return(Connection.Query("SELECT ID, DESCRIPTION FROM XMS_PERIOD_TYPES").Select(
q => new PeriodTypeModel()
{
PeriodType = OracleHelpers.StringToPeriodType(q.ID),
Description = q.DESCRIPTION
}
).ToArray());
}