USP_DATAFORMTEMPLATE_ADD_DAILYSALESNOTIFICATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@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_ADD_DAILYSALESNOTIFICATION
(
    @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,
    @DISPLAYINDAILYSALES bit = 0,
    @VALIDUNTIL datetime = null
)
as
    set nocount on;

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

    insert into dbo.ALTRUNOTIFICATION
        (ID, DISPLAYINDAILYSALES)
    values
        (@ID, @DISPLAYINDAILYSALES);

    return 0;