USP_KPIDASHBOARDPAGE_CREATEORUPDATE

Creates or updates a user's KPI dashboard page.

Parameters

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

Definition

Copy



            create procedure dbo.USP_KPIDASHBOARDPAGE_CREATEORUPDATE(@ID uniqueidentifier = null output,
                @APPUSERID 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.KPIDASHBOARDPAGE where ID = @ID)
                begin
                    update dbo.KPIDASHBOARDPAGE set NAME = @NAME,
                        SEQUENCE = @SEQUENCE,
                        APPUSERID = @APPUSERID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = getdate()
                    where ID = @ID;
                end
                else
                begin
                    insert into dbo.KPIDASHBOARDPAGE (ID,
                        NAME,
                        SEQUENCE,
                        APPUSERID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED)
                    values (@ID,
                        @NAME,
                        @SEQUENCE,
                        @APPUSERID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        getdate(),
                        getdate());
                end;