USP_RECORDOPERATION_REGISTRANTSTATUS_UPDATEPROMPT
Provides the prompt for the "Registrant Status Update" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @STATUS | nvarchar(150) | INOUT | |
| @MESSAGE | nvarchar(300) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_REGISTRANTSTATUS_UPDATEPROMPT
(
@ID uniqueidentifier,
@STATUS nvarchar(150) output,
@MESSAGE nvarchar(300) output
)
as
set nocount on;
if (select ISCANCELLED from dbo.REGISTRANT where ID = @ID) = 1
select @STATUS = 'activate', @MESSAGE = '';
else
select @STATUS = 'cancel', @MESSAGE = 'To refund the registration fee you must delete the payment after you cancel the registration.';
return 0;