Running CAPMS-SGPMC on localhost

Summary:

No updates were required for CAPMS-SGPMC for many years.
After cloning it from the repos in April 2024 the app would not run on localhost.
- The changes described below make it possible to run CAPMS-SGPMC on localhost

CAPMS-SGPMC uses .NET Framework 4 by default.
I attempted to upgrade it to the latest (4.8) but got errors when run the application after having resolved the other issues below.

Solution: install AjaxControlKit by CodePlex foundation version

Installed version 4.1.60919 as it is the latest version of Ajax 4.x available in NuGet.
- Version 4…. is in the “bin” folder on the development and acceptance servers.
- Installing to a newer version might be possible.
  - Steps for an upgrade would need to be followed to upgrade to a version newer than 4.x.

Note: TCMailer is in the process of being decommissioned
Temporary solution to solve the error BC30002 Type 'TCMailer.SmtpClient' is not defined:
- Remove and then re-add the existing reference for TCMailer.DLL

To resolve ORA28000 (Account locked) error that occurs on Line 103 of SQLHelper.sql:
updated the configuration string for development to the latest oracle information (see pins

change <add key="TCErrorEmailAddress" value="mike.d.clark@tc.gc.ca" />

to

Note: EmailErrors has to be set to true in order for the errors to be sent to the mailbox.

Other: updated the DateAppLastModified to current date.

update applicationhost.config:

add the two lines below as the last entries before </modules>
<add name="StreamTagFilter-2.0" type="Utility.IIS.StreamTagFilterModule, StreamTagFilter.NET.2.0, Version=1.0.6.2, Culture=neutral, PublicKeyToken=d3d707ec692e4024" preCondition="runtimeVersionv2.0" />
<add name="StreamTagFilter-4.0" type="Utility.IIS.StreamTagFilterModule, StreamTagFilter.NET.4.0, Version=1.0.6.2, Culture=neutral, PublicKeyToken=d3d707ec692e4024" preCondition="runtimeVersionv4.0" />

update the web.config

to