USP_DATAFORMTEMPLATE_EDIT_NOTIFICATION

The save procedure used by the edit dataform template "Notification Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@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_EDIT_NOTIFICATION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @NAME nvarchar(100),
    @MESSAGE nvarchar(max),
    @RECORDTYPEID uniqueidentifier,
    @RECORDIDSETREGISTERID uniqueidentifier,
    @APPUSERIDSETREGISTERID uniqueidentifier,
    @APPLYTOCODE tinyint,
    @DISPLAYNOTIFICATIONWINDOW bit,
    @VALIDUNTIL datetime
)
as
begin
    set nocount on;

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    begin try
        update
            dbo.NOTIFICATION
        set
            NOTIFICATION.NAME = @NAME, 
            NOTIFICATION.MESSAGE = @MESSAGE, 
            NOTIFICATION.RECORDTYPEID = @RECORDTYPEID, 
            NOTIFICATION.RECORDIDSETREGISTERID = @RECORDIDSETREGISTERID, 
            NOTIFICATION.APPLYTOCODE = @APPLYTOCODE, 
            NOTIFICATION.APPUSERIDSETREGISTERID = @APPUSERIDSETREGISTERID, 
            NOTIFICATION.DISPLAYNOTIFICATIONWINDOW = @DISPLAYNOTIFICATIONWINDOW, 
            NOTIFICATION.VALIDUNTIL = @VALIDUNTIL,
            NOTIFICATION.DATECHANGED = @CURRENTDATE,
            NOTIFICATION.CHANGEDBYID = @CHANGEAGENTID
        where
            NOTIFICATION.ID = @ID;                                                        
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0
end