public ActionResult AddTaxonomyReports([DataSourceRequest] DataSourceRequest request, TaxonomyReportViewModel model) { using (var repository = GetRepository()) { if (model != null && ModelState.IsValid) { if (!IsTaxonomyReportUniqueId(model.TaxonomyId, model.Id)) { return(new JsonHttpStatusResult(new { Message = UserMessages.TAXSONOMY_IS_NOT_UNIQ_ID }, HttpStatusCode.InternalServerError)); } var result = ValidateTaxonomyReportFields(model); if (result.ValidationMessages.Count > 0) { return(new JsonHttpStatusResult(new { Message = result.ValidationMessages }, HttpStatusCode.InternalServerError)); } var entity = new TaxonomyReportModel() { Currency = model.Currency, Decimals = model.Decimals, DecimalDecimals = model.DecimalDecimals, Description = model.Description, EntityIdentifier = model.EntityIdentifire, EntitySchema = model.EntitySchema, EntryUri = model.EntryUri, FileName = model.FileName, Id = model.Id, IntegerDecimals = model.IntegerDecimals, MonetaryDecimals = model.MonetaryDecimals, PeriodType = model.PeriodType.PeriodType.Value, PureDecimals = model.PureDecimals, SharesDecimals = model.SharesDecimals, TaxonomyId = model.TaxonomyId, TnProcessorId = model.TnProcessorId, TnRevisionId = model.TnRevisionId, }; try { repository.TaxonomyReportRepository.Add(entity); repository.Commit(); } catch (Exception e) { GetLogger().LogException(e, string.Format("AddTaxonomyReports({0})", model.TaxonomyId)); return(new JsonHttpStatusResult(new { Message = UserMessages.UNKNOWN_ERROR }, HttpStatusCode.InternalServerError)); } } } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public void Update(TaxonomyReportModel entity) { LogLine(string.Format("update {0} - {1} in database.", entity.Id, entity.Description)); int rowsAffected = Connection.Execute(@"UPDATE XMS_TAXONOMY_REPORTS SET DESCRIPTION =: Description, PERIOD_TYPE = :PeriodType, ENTRY_URI = :EntryUri, FILE_NAME = :FileName, ENTITY_IDENTIFIER = :EntityIdentifire, CURRENCY = :Currency, DECIMALS = :Decimals, ENTITY_SCHEMA = :EntitySchema, DECIMAL_DECIMALS = :DecimalDecimals, INTEGER_DECIMALS = :IntegerDecimals, MONETARY_DECIMALS = :MonetaryDecimals, PURE_DECIMALS = :PureDecimals, SHARES_DECIMALS = :SharesDecimals, TN_PROCESSOR_ID = :TnProcessorId, TN_REVISION_ID = :TnRevisonId WHERE TAXONOMY_ID = :TaxonomyId and ID = :Id", new { Description = entity.Description, PeriodType = OracleHelpers.PeriodTypeToString(entity.PeriodType), TaxonomyId = entity.TaxonomyId, Id = entity.Id, EntryUri = entity.EntryUri, FileName = entity.FileName, EntityIdentifire = entity.EntityIdentifier, Currency = entity.Currency, Decimals = entity.Decimals, EntitySchema = entity.EntitySchema, DecimalDecimals = entity.DecimalDecimals, IntegerDecimals = entity.IntegerDecimals, MonetaryDecimals = entity.MonetaryDecimals, PureDecimals = entity.PureDecimals, SharesDecimals = entity.SharesDecimals, TnProcessorId = entity.TnProcessorId, TnRevisonId = entity.TnRevisionId, } ); if (rowsAffected == 0) { throw new NoRowsAffectedException("Update TaxonomyReport failed rowsAffected :" + rowsAffected); } }
public void Remove(TaxonomyReportModel entity) { LogLine(string.Format("remove {0} - {1} from database.", entity.Id, entity.Description)); int rowsAffected = 0; rowsAffected = Connection.Execute(@"DELETE FROM XMS_TAXONOMY_REPORTS WHERE TAXONOMY_ID = :TaxonomyId AND ID = :Id", new { Id = entity.Id, TaxonomyId = entity.TaxonomyId }); if (rowsAffected == 0) { throw new NoRowsAffectedException("Remove TaxonomyReport failed rowsAffected :" + rowsAffected); } }
public void Add(TaxonomyReportModel entity) { LogLine(string.Format("adding {0} - {1} to database.", entity.Id, entity.Description)); int rowsAffected = Connection.Execute(@"INSERT INTO XMS_TAXONOMY_REPORTS (DESCRIPTION, PERIOD_TYPE, ENTRY_URI, FILE_NAME, ENTITY_IDENTIFIER, CURRENCY, DECIMALS, ENTITY_SCHEMA, DECIMAL_DECIMALS, INTEGER_DECIMALS, MONETARY_DECIMALS, PURE_DECIMALS, SHARES_DECIMALS, TN_PROCESSOR_ID, TN_REVISION_ID, TAXONOMY_ID, ID) VALUES (:Description, :PeriodType, :EntryUri, :FileName, :EntityIdentifire, :Currency, :Decimals, :EntitySchema, :DecimalDecimals, :IntegerDecimals, :MonetaryDecimals, :PureDecimals, :SharesDecimals, :TnProcessorId, :TnRevisonId, :TaxonomyId, :Id) ", new { Description = entity.Description, PeriodType = OracleHelpers.PeriodTypeToString(entity.PeriodType), TaxonomyId = entity.TaxonomyId, Id = entity.Id, EntryUri = entity.EntryUri, FileName = entity.FileName, EntityIdentifire = entity.EntityIdentifier, Currency = entity.Currency, Decimals = entity.Decimals, EntitySchema = entity.EntitySchema, DecimalDecimals = entity.DecimalDecimals, IntegerDecimals = entity.IntegerDecimals, MonetaryDecimals = entity.MonetaryDecimals, PureDecimals = entity.PureDecimals, SharesDecimals = entity.SharesDecimals, TnProcessorId = entity.TnProcessorId, TnRevisonId = entity.TnRevisionId, }); if (rowsAffected == 0) { throw new NoRowsAffectedException("Add TaxonomyReport failed rowsAffected :" + rowsAffected); } }