Minor To Adult Waiver Reset
Introduction:
Each day minors are becoming adults. Venues are requesting that club speed provides a
solution where our software forces the customer to resign the waiver when a child transitions
into to an adult. In most cases this will occur when a child turns eighteen, but this age can be
configurable. Our solution is to provide a console application that will run once a day. It will find
all the customers that turned eighteen for that particular day, and it will reset their customer
status from “Waiver1 Signed” to “New Customer”.
Here are the instructions on deploying the service:
1. If it doesn’t already exist, create a folder called “clubspeedcustomapps” on the C drive.
2. Inside of that folder create another folder called “waiver-reset”.
3. Download the WaiverReset.7z files that are attached to this article and extract them in the “waiver-reset” folder.
4. Next, open Firedaemon and click the “new” button.
5. Provide a short name of “Waiver Reset” and a Display Name of “Waiver Reset”.
6. The executable path should be “C:\clubspeedcustomapps\waiver-
reset\WaiverReset.exe”.
7. Click the schedule tab and schedule it to run every day at 2 am.
8. Click OK and ensure that the application is running.
Configuration:
To view the configurable settings of the application, right-click on WaiverReset.exe.config and
select edit. If any of these settings are changed, then a firedaemon restart may be necessary.
There are a few settings for the service located in the resetwaiver.exe.config:
- Age:
- This is the age that the venue wants the customer status to be changed to new customer (generally what the venue considers an adult).
- Default Value: 18
- customerStatus1From
- The app will look at the age setting (see above). If the age of the customer is that age and the birthday is today then it will look to see if the customer has a status1 of this status. (For the majority of cases this value should be Waiver1 Signed. If they are a foreign track, then this value may need to be looked up on the CustomerStatus table. This can also be seen in the Status1 drop-down list in the customer’s profile.
- Default Value: Waiver1 Signed
- customerStatus1To
- If the customer profile fills the criteria for age and customerStatus1From then the status1 for the customer will be set to this waiver status. This should be set to New Customer to force the customer account to be flagged to sign their waiver
- Default Value: New Customer
- ClubspeedV8ConnectionString
- The connection string to the ClubSpeedV8 database
- Default Value: data source=.;initialcatalog=ClubspeedV8;integratedsecurity=TRUE
- ClubSpeedLogConnectionString
- The connection string to the ClubSpeedLog database
- Default Value: data source=.;initialcatalog=ClubspeedLog;integratedsecurity=TRUE
Logging:
If you wish to see more information about what occurred while the application runs, then you can view the logs in the logs table. It will log when the application runs, and it will display which customer’s statuses changed.