This is an implementation of the Long-Term Services and Supports referral service. The web service utilizes a NIEM 3.0 (National Information Exchange Model) schema.
- Visual Studio 2015+
- IIS 7.5+
- SQL Server 2008+
- Configure keys containing ******** in the app.config.
- Generate referral database.
Within the package manager console run either
to directly generate the database or
update-database
to generate a create script for the database starting from the initial migration.update-database -Script -SourceMigration:0
- Right-click on LTSSWebService in the Solution Explorer and choose to publish to a website hosted on either a local or remote IIS instance. If you choose to publish to a local instance, simply copy the files to your desired remote IIS website folder.
- Populate your Email table with your desired configuration data for summary notifications. It would be prudent to validate your configuration data with
EmailHelper.SendEmail.
When a referral id is sent from LTSS, its associated SendReferralRequestPayloadType is persisted to a database common to the various TxACE centers. After it is persisted, the service immediately responds with a referral acknowledgement and makes a retrieveReferralInfo request for the data associated with the referral id. Once the data is received we persist it to the database and validate that it can be deserialized. Then we call updateReferralInfo with "AC" (acknowledgement) if we successfully retrieved valid XML and "PF" (process failure) otherwise.
- Backup your production database.
- Run the following commands against your production database (possibly twice for constraint violations):
delete ContactEntity delete Enrollment delete EntityContactEntity delete EntityEvent delete Location delete Organization delete Referral delete Screening update Request SET IsProcessed = 0, Exception = NULL
- Deploy the updated code making sure to preserve your existing app.config file.
- Assuming your app.config file is pointing to your production database, run
to make sure your database has the latest schema.
update-database
- Push desired referral data into center specific databases.
- Create useful forms and/or an application that enables centers to effectively use the referral data.