Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

Targeted Environment

- MTOA-INT, MTOA-TEST

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.132 (2021-01-28) (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
ENTITY_ID_TYPE

SERVICE_REGULATED_ENTITY_ID_TYPE_ID

Drop column and PK

TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD

New PK

YY213_SVC_REQUEST_
REGULATED_ENTITY_VALUE

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.

 

 

 

  • No labels