USP_DATAFORMTEMPLATE_EDIT_NOTIFICATION_SYSTEMGENERATED

The save procedure used by the edit dataform template "System Generated 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.
@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_SYSTEMGENERATED
(
    @ID uniqueidentifier,
    @CHANGEAGENTID 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.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