USP_DATAFORMTEMPLATE_EDIT_ALTRUNOTIFICATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@MESSAGE	nvarchar(max)	IN
@RECORDTYPEID	uniqueidentifier	IN
@RECORDIDSETREGISTERID	uniqueidentifier	IN
@APPUSERIDSETREGISTERID	uniqueidentifier	IN
@APPLYTOCODE	tinyint	IN
@DISPLAYNOTIFICATIONWINDOW	bit	IN
@DISPLAYINDAILYSALES	bit	IN
@VALIDUNTIL	datetime	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ALTRUNOTIFICATION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @NAME nvarchar(100),
    @MESSAGE nvarchar(max),
    @RECORDTYPEID uniqueidentifier,
    @RECORDIDSETREGISTERID uniqueidentifier,
    @APPUSERIDSETREGISTERID uniqueidentifier,
    @APPLYTOCODE tinyint,
    @DISPLAYNOTIFICATIONWINDOW bit,
    @DISPLAYINDAILYSALES 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;

        update dbo.ALTRUNOTIFICATION
        set DISPLAYINDAILYSALES = @DISPLAYINDAILYSALES
        where ID = @ID;

    end try

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0
end