USP_DATAFORMTEMPLATE_ADD_NOTIFICATION

The save procedure used by the add dataform template "Notification Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@MESSAGE	nvarchar(max)	IN	Message
@RECORDTYPEID	uniqueidentifier	IN	Record type
@RECORDIDSETREGISTERID	uniqueidentifier	IN	Selection
@APPUSERIDSETREGISTERID	uniqueidentifier	IN	Selection
@APPLYTOCODE	tinyint	IN	Displays for
@DISPLAYNOTIFICATIONWINDOW	bit	IN	Display in notification window
@VALIDUNTIL	datetime	IN	End date

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_NOTIFICATION
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100) = null,
    @MESSAGE nvarchar(max) = null,
    @RECORDTYPEID uniqueidentifier = null,
    @RECORDIDSETREGISTERID uniqueidentifier = null,
    @APPUSERIDSETREGISTERID uniqueidentifier = null,
    @APPLYTOCODE tinyint = 0,
    @DISPLAYNOTIFICATIONWINDOW bit = 0,
    @VALIDUNTIL datetime = null
)
as
    set nocount on;

    exec dbo.USP_NOTIFICATION_ADD 
        @ID, 
        @CHANGEAGENTID, 
        @NAME, 
        @MESSAGE, 
        @RECORDTYPEID, 
        @RECORDIDSETREGISTERID, 
        @APPUSERIDSETREGISTERID, 
        @APPLYTOCODE, 
        @DISPLAYNOTIFICATIONWINDOW, 
        @VALIDUNTIL

    return 0;