USP_BUSINESSPROCESSINSTANCE_UPDATESITE

Updates a site of an instance of a business process.
Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            create procedure dbo.USP_BUSINESSPROCESSINSTANCE_UPDATESITE
            (
                @BUSINESSPROCESSCATALOGID uniqueidentifier,
                @BUSINESSPROCESSPARAMETERSETID uniqueidentifier,
                @SITEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            begin
                set nocount on;

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

                if exists(select ID from BUSINESSPROCESSINSTANCE 
                                    where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
                                    and BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID)
                begin
                    update dbo.BUSINESSPROCESSINSTANCE
                    set SITEID = @SITEID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
                    and BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID;
                end
                else
                begin
                    insert into dbo.BUSINESSPROCESSINSTANCE
                    (
                        BUSINESSPROCESSCATALOGID,
                        BUSINESSPROCESSPARAMETERSETID,
                        SITEID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values
                    (
                        @BUSINESSPROCESSCATALOGID,
                        @BUSINESSPROCESSPARAMETERSETID,
                        @SITEID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    )
                end
                return 0;

            end