USP_KPIDASHBOARDPAGETAB_CREATEORUPDATE

Creates or updates a tab for a user's KPI dashboard page.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@KPIDASHBOARDPAGEID	uniqueidentifier	IN
@NAME	nvarchar(50)	IN
@SEQUENCE	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_KPIDASHBOARDPAGETAB_CREATEORUPDATE(@ID uniqueidentifier = null output,
                @KPIDASHBOARDPAGEID uniqueidentifier,
                @NAME nvarchar(50),
                @SEQUENCE int,
                @CHANGEAGENTID uniqueidentifier)
            as
                set nocount on;

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

                if exists(select ID from dbo.KPIDASHBOARDPAGETAB where ID = @ID)
                begin
                    update dbo.KPIDASHBOARDPAGETAB set KPIDASHBOARDPAGEID = @KPIDASHBOARDPAGEID,
                        NAME = @NAME,
                        SEQUENCE = @SEQUENCE,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = getdate()
                    where ID = @ID;                    
                end
                else
                begin
                    insert into dbo.KPIDASHBOARDPAGETAB (ID,
                        KPIDASHBOARDPAGEID,
                        NAME,
                        SEQUENCE,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED)
                    values (@ID,
                        @KPIDASHBOARDPAGEID,
                        @NAME,
                        @SEQUENCE,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        getdate(),
                        getdate());
                end;