USP_NOTIFICATION_ADD

Adds a new notification.

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
@VALIDUNTIL	datetime	IN
@ISSYSTEMGENERATED	bit	IN

Definition

Copy



CREATE procedure dbo.USP_NOTIFICATION_ADD
(
    @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, 
    @ISSYSTEMGENERATED bit = 0
)
as
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    if @ID is null
        set @ID = newid();

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

    begin try
        insert into dbo.NOTIFICATION
            (ID,
                NAME,
                MESSAGE, 
                RECORDTYPEID, 
                RECORDIDSETREGISTERID, 
                APPUSERIDSETREGISTERID, 
                APPLYTOCODE, 
                DISPLAYNOTIFICATIONWINDOW, 
                VALIDUNTIL, 
                ISSYSTEMGENERATED, 
                DATEADDED, 
                DATECHANGED, 
                ADDEDBYID, 
                CHANGEDBYID)
        values
            (@ID, 
                @NAME, 
                @MESSAGE, 
                @RECORDTYPEID, 
                @RECORDIDSETREGISTERID, 
                @APPUSERIDSETREGISTERID, 
                @APPLYTOCODE, 
                @DISPLAYNOTIFICATIONWINDOW, 
                @VALIDUNTIL, 
                @ISSYSTEMGENERATED, 
                @CURRENTDATE, 
                @CURRENTDATE, 
                @CHANGEAGENTID, 
                @CHANGEAGENTID)                                
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;