GALRO Admin

System Profile

System Full Name	General Aviation Licensing and Registration On-line
Business Administrator	Christopher McCue
Business Owner	Jeff Phipps
Director	Felix Meunier
Subject Matter Expert	Xia Wang, Nikolay Melnik
Division
NTARS Code	CA26
Source Location
Source Code Location	http://tfsprod:8080/tfs/CivAv/GALRO-AGLIE-SEC
Migration to DevOps	✅
New Source Code Location (DevOps)	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/GALRO-AGLIE-SEC

Technology Assessment

Platform Type	Web (Internal)
Database Platform and Version	Oracle 18c
Development Language and Framework	.NET 4.0, VB.NET, Web Forms, “Intranet“ GoC CLF
Operating System and Version	Windows Server 2016
Additional Dependencies	Crystal Report
Authentication	Windows/AD

Environment Access Information

ENV

UNC

WWWFILES

URL

DB

DEV

\\ncrws499\catcappsx\Saf-Sec-Sur\2\GALRO-AGLIE-SEC

N/A

http://catcappsx/Saf-Sec-Sur/2/Galro-aglie-sec/client_2.aspx

CCARCSD

HQRDEV

ftaed

ACC

\\Tctestmaster\tcappsroot\Saf-Sec-Sur\2\GALRO-AGLIE-SEC

N/A

http://tcappstest/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx

CCARCSA

HQRACC

FTAEA

PROD

consult with Web Group

N/A

http://tcapps/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx

CCARCSP

HQR

FTAE

System Overview

GALRO Admin is an internal admin website that uses Oracle (CCARCS, FTAE, DAPLS database); It used by TC personnel (GALRO administrators) to manage internal user access and external user registration, activation

Good To Know

Developer’s note

This solution can run on VS2019.

In order to run the GALRO Admin web page, we need to be added as the administrators (Team leaders can provide you the access)

Compile errors and fixes:

If there is any error about CrystalDecisions

, check the References and have to reinstall the actual Dlls for these libraries

On VS2019->Tool-> Nuget Packet Manager-> Manage Nuget Packages for Solution, and search for the library to install if that library is not existed, and reinstall if that is already existed.

When we added the library “CrystalDecisions.ReportAppServer.ClientDoc”, we have to install the specific version “13.0.3500.0” since these info are required in the web.config

Build the solution and run it. The banner is still not displaying correctly. How to fix it?

How-To and Fixes

User requests access to GALRO online

New users, can request an “activation-key” directly from the Web by providing name and address information. The request is sent to CCARCS-E as a BF entry (client server system) where an Administrator reviews it. If there is a client match (existing client with same name and address) the client’s activation key is mailed to the client’s address. If there is no client match, a new client is created, and a new “activation-key” is assigned. The “activation-key” is then sent to the client’s address.

The request is stored in the CCARCS-E database as a BF entry. The entry is assigned to the appropriate region based on province.
The administrator reviews the request
The administrator searches the CCARCS-E database to see if a client with the same name/address already exists in the database
If a client already exists, a client letter is generated and mailed to the client
If there is not existing client found the Administrator:
- Creates a new client in CCARCS-E database and an activation key is generated
- The administrator generates the letter and mails it to the client
The administrator closes the BF entry

Unable to issue an activation key in GALRO for the user

No account exists in CCARCE. Not issue an activation key in GALRO for a user because there is no such record in CCARCE. For example, when searching the individual details for that user, we do not find any record in CCARCE

Please send the email to Service Team Support to close all “pending registration action” and have that user re-apply as New Request-License.

References

Document	RDIMS #
GALRO_PHASE_I_CONSOLIDATED_ANALYSIS	4672886
GALRO_PHASE_II_III_CONSOLIDATED_ANALYSIS	4693669
GALRO_PHASE_II_III_SS2_SECURITY_DETAIL_DESIGN	4719638
GALRO_ENVIRONMENT_SUMMARY Some of information in this document is out of date	16772158