DIS - SID

System Profile

System Full Name	Delegations Information System
System Full Name (French)	Système Informatique des Délégations
Business Administrator	Alan Ritchie
Business Owner	Alan Ritchie
Director	Philippe Nsgassam
Subject Matter Expert	Sylvie Blais
Division
NTARS Code	CA19
Source Location
Source Code Location - CAS -SAC (contains all DIS-internet and intranet codes)		http://tfsprod:8080/tfs/CivAv/CAS-SAC/
Source Code Location - DIS -SID Intranet	http://tfsprod:8080/tfs/civav/DIS-SID_Intranet
Source Code Location - DIS -SID Internet	http://tfsprod:8080/tfs/CivAv/DIS-SID_Internet/
Migration to DevOps
New Source Code Location (DevOps)
CAS-SAC	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAS-SAC
Net version (currently using) -DIS-SID Intranet	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/DIS-SID_Intranet_NetVersion
ASP version (one sub branch contains the Net version but that branch is not the default dev) - DIS-SID Intranet	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/DIS-SID_Intranet
DIS-SID Internet	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/DIS-SID_Internet

Technology Assessment

Platform Type	Web (Internal/External)
Database Platform and Version
Development Language and Framework	ASP.NET
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication	Windows/AD

Environment Access Information

ENV	WWWFILES	URL	DB
DEV			TTSXD
PREACC
ACC	\\tctestmaster\tcappsroot\saf-sec-sur\2	http://tcappstest/saf-sec-sur/2/DIS-SID	TTSXA
PROD		http://tcapps/Saf-Sec-Sur/2/DIS-SID	TTSXPP
TRAINING

System Overview

The Delegations Information System (DIS V2) allows Transport Canada Civil Aviation Headquarters and Regional Aircraft Certification staff to enter and edit information for their Delegates via the Web, and to create statistical reports. DIS V2 has been built with an Oracle back end and a Web front end.

DIS V2 is used as a database for all DE (Designated Engineer), DAR (Design Approval Representative) and DAO (Design Approval Organization)/AEO (Airworthiness Engineering Organization) information. It is also used to track applications for delegation and provide statistical reports and other delegation information.

Good To Know

There are two distinct repositories. DIS-SID_Internet and DIS-SID_Intranet. The Internet version will provide information to the public in read only format (i.e no information will be uploaded or changed in the database by the external user). The Intranet version will have the administration features that will allow changes to be made to the information in the database.

Since they both fall under CAS-SAC, the links provided for the source code locations direct the user to CAS-SAC

Web.config needs to connect to two databases : DIS and DACP. DACP is used for to access ‘ACP’ tab on DIS application

Currently (Jan-2023), DIS-SIS Intranet has migrated to use these following references:

AjaxControlTookKit (3.5.40412.0)

Oracle.ManagedDataAccess (4.122.21.1)

CLFPage (4.0.0.0)

TCMailerNet (2.0.0.0)

Net Framework 4.7.2

How-To and Fixes

Modify an access : allow the user to have access level to "Modify"

In this case, any DIS administrator can add a user on DIS. If there is case they need developer team to it, then following below steps:

-verify with DIS team to ask whether this user can allow to have that access level

-insert a record to DIS.TBLUSERS with ‘'user_access’ level as 6. ‘User Access’ level is 6 (modify), 9 (admin)

View button (on APs and DARs) menu can not open a file attachment to view. It is required an EDGE web browser should be allow to run with IE mode and have to include pages which are requiring running IE. Please look at the screenshot

Click here to expand...

http://tcappstest/saf-sec-sur/2/DIS-SID/apcru.aspx

http://tcappstest/saf-sec-sur/2/DIS-SID/darcru.aspx

Where to find the attachments

All the file attachments are store on the shared network

For example,

Acc environment : \\webdatatest\wwwdocs\DETAILS

Prod environment: asking the dev team or an administrator