Versions Compared

Old Version 3

changes.mady.by.user Samy Touabi

Saved on

compared with

New Version Current

changes.mady.by.user Saman Khan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

Info

System Profile

System Full Name

Delegations Information System

Version 2

System Full Name (French)

Système Informatique des Délégations

Business Administrator

Alan Ritchie

Business Owner

Alan Ritchie

Director

David Turnbull

Philippe Nsgassam

Subject Matter Expert

Chris Boivin

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

CivAv/CAS-SAC/

Source Code Location - DIS -SID Intranet

http://tfsprod:8080/tfs/civav/

_dashboards

DIS-SID_Intranet

Source Code Location - DIS -SIDInternet

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

/branches

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

UNC

WWWFILES

URL

DB

DEV

TTSXD

TTSXD18

PREACC

ACC

TTSXA

\\tctestmaster\tcappsroot\saf-sec-sur\2

http://tcappstest/saf-sec-sur/2/DIS-SID

TTSXA18

PROD

http://tcapps/Saf-Sec-Sur/2/DIS-SID

TTSXPP

TTSXP18

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

...

Info

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

Expand
titleIn 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)

Info

View button (on APs and DARs) menu can not open a file attachment to view.

It is i required to run DIS on EDGE with IE mode, then we need to add these pages under the Default Browser. Please follow the link MS Edge in IE Mode. Related task is #253812 -Unable to open Attachments and #239075 -Fix the View Attachment button

Then please look at the below screenshot and use these links to add the pages.

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

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

...

Info

Where to find the DIS attachments?

All the file attachments are stored on the shared network

For example,

Acc environment : \\webdatatest\wwwdocs\DETAILS

In order to get access to AD group an email is needed to be sent to the Web group to get the user added to the AD group.

Prod environment: asking the dev team or an administrator to give the access to the attachments