spAddUpdate_NotificationSubscription

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@UserID	int	IN
@NotificationID	int	IN
@ContextID	int	IN
@Status	int	IN
@BackOfficeSystemPeopleID	int	IN
@BackOfficeSystemsID	int	IN

Definition

Copy




CREATE PROCEDURE [dbo].[spAddUpdate_NotificationSubscription]
    (
    @PKID int output,
    @UserID int,
    @NotificationID int,
    @ContextID int,
    @Status int,
    @BackOfficeSystemPeopleID int,
    @BackOfficeSystemsID int
    )
    AS
    BEGIN
        IF (@PKID<=0) 
        BEGIN
            INSERT INTO NotificationSubscription
            (
            UserID,
            NotificationID,
            ContextID,
            [Status],
            BackOfficeSystemPeopleID,
            BackOfficeSystemsID
            )
            VALUES
            (
            @UserID,
            @NotificationID,
            @ContextID,
            @Status,
            @BackOfficeSystemPeopleID,
            @BackOfficeSystemsID
            )

            SELECT @PKID = @@Identity

        END
        ELSE 

            UPDATE NotificationSubscription SET
            UserID = @UserID,
            NotificationID =@NotificationID,
            ContextID = @ContextID,
            [Status] = @Status,
            BackOfficeSystemPeopleID = @BackOfficeSystemPeopleID,
            BackOfficeSystemsID = @BackOfficeSystemsID
            WHERE [ID]=@PKID

    END