Targeted Environment
- MTOA-INT, MTOA-TEST, and MTOA-ACC
myTC Account documentation now available through TC confluence : https://tcmarin.atlassian.net/wiki/spaces/MA
PBI #8848 - Regulated entity enhancement - CRSM would like to use TC226_REGULATED_ENTITY_ID_TYPE.REGULATED_ENTITY_ID_TYPE_CD for regulated entities Post and Put.
BUG #8881: CRSM setting time back one minute immediately after a status update throws an error.
BUG #8717: Fix for issue where coordinates were removed when re-generating coordinates with id = 0
BUG #8750: DbContext threading issue: Error when dbcontext is used by two threads at the same time
BUG #7946: GET /organizations and GET /organizations/{id} not returning correct value in OrganizationType
BUG # 8720: PUT /api/v1/organizations - should check DB and include the right ids in response body
BUG #8743: GET /api/v1/permissions/{permissionId}/services/{serviceId}/users/{userId} - need to change responses for various permutations
BUG #8741: DELETE /api/v1/notification-template/{templateName} - unexpected change in status code and response when providing a random name
BUG #6863: POST /api/v1/service-settings can create RTMR settings using SVMMS API key/token
BUG #7326: SVMMS api key & app jwt can access service settings and service preferences of RTMR
Technical works
Security improvement to the service settings apis to ensure a service can only maintain its own service settings.
Service Regulated Entities (PBI #8848)
Updates January 28 – 2021
GET - /api/v1/services/{id}/regulated-entities
Due to a database update the service regulated entity id has been removed and will no longer be displayed in the response body.
Previously the id was displayed.
[ { "Id": 1, "ServiceId": 1230, "RegulatedEntityTypeCode": "VESSEL", "RegulatedEntityIdTypeCode": "VESSEL_NM", "SortOrder": 1, "EnglishDisplayName": "Vessel Name", "FrenchDisplayName": "Nom du bâtiment" } ]
Now with the update the id is no longer displayed.
[ { "ServiceId": 1230, "RegulatedEntityTypeCode": "VESSEL", "RegulatedEntityIdTypeCode": "VESSEL_NM", "SortOrder": 1, "EnglishDisplayName": "Vessel Name", "FrenchDisplayName": "Nom du bâtiment" } ]
GET - /api/v1/regulated-entities?serviceRequestId={id}
Due to a database update the service regulated entity id has been removed and will no longer be displayed in the response body.
Previously the id was displayed.
[ { "Id": 1, "ServiceId": 1230, "RegulatedEntityTypeCode": "VESSEL", "RegulatedEntityIdTypeCode": "VESSEL_NM", "SortOrder": 1, "EnglishDisplayName": "Vessel Name", "FrenchDisplayName": "Nom du bâtiment" } ]
Now with the update the id is no longer displayed.
[ { "ServiceId": 1230, "RegulatedEntityTypeCode": "VESSEL", "RegulatedEntityIdTypeCode": "VESSEL_NM", "SortOrder": 1, "EnglishDisplayName": "Vessel Name", "FrenchDisplayName": "Nom du bâtiment" } ]
POST - /api/v1/regulated-entities
Due to a database update the service regulated entity id has been removed it will no longer be used to create regulated entity values.
Previously the id which is a number was used.
[ { "Id": 1, "Value": "string" }, { "Id": 2, "Value": "string" }, { "Id": 3, "Value": "string" }, { "Id": 4, "Value": "string" } ]
Now the id used is the regulated entity type code which is now a string and no longer a number.
[ { "Id": "VESSEL_NM", "Value": "test" }, { "Id": "CDN_SHIP_IND", "Value": "test" }, { "Id": "IMO", "Value": "test" }, { "Id": "OFFICIAL_NO", "Value": "test" } ]
PUT - /api/v1/regulated-entities
Due to a database update the service regulated entity id has been removed it will no longer be used to create regulated entity values.
Previously the id which is a number was used.
[ { "Id": 1, "Value": "string" }, { "Id": 2, "Value": "string" }, { "Id": 3, "Value": "string" }, { "Id": 4, "Value": "string" } ]
Now the id used is the regulated entity type code which is now a string and no longer a number.
[ { "Id": "VESSEL_NM", "Value": "test" }, { "Id": "CDN_SHIP_IND", "Value": "test" }, { "Id": "IMO", "Value": "test" }, { "Id": "OFFICIAL_NO", "Value": "test" } ]
MTOA NuGet packages Release Notes
Version 0.15.20.131 (2021-01-29) (based on the dev branch)
ServiceRegulatedEntityIdType
Id property has been removed.
ServiceRegulatedEntity
Id has been changed from an int to a string.
Breaking change
N/A
MTOA Database – Release Note for Version (v1.13.0)
Schema Structure Changes
Table | Column | Comments |
---|---|---|
YY201_SERVICE_REQUEST | SERVICE_REQUEST_ID, TC_SERVICE_CD | New AK to be used as FK by table YY213_SVC_REQUEST_REGULATED_ENTITY_VALUE |
TC227_SERVICE_REGULATED | SERVICE_REGULATED_ENTITY_ID_TYPE_ID | Drop column and PK |
TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD | New PK | |
YY213_SVC_REQUEST_ | SERVICE_REGULATED_ENTITY_ID_TYPE_ID | Drop column and FK to TC227_SERVICE_REGULATED_ENTITY_ID_TYPE |
TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD | New columns and FK to table TC227_SERVICE_REGULATED_ENTITY_ID_TYPE | |
SERVICE_REQUEST_ID, TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD | New AK to enforce uniqueness per service request | |
SERVICE_REQUEST_ID, TC_SERVICE_CD | New FK to table YY201_SERVICE_REQUEST to make sure the regulated entities are for the same service. |
Data Changes
No data change in this release.