spGetBackOfficeSystemUsersID

Parameters

Parameter	Parameter Type	Mode
@ClientUsersID	int	IN
@BackOfficeSystemPeopleID	int	IN
@BackOfficeSystemUsersID	int	INOUT
Definition

Copy


            CREATE PROCEDURE [dbo].[spGetBackOfficeSystemUsersID](
            @ClientUsersID int,
            @BackOfficeSystemPeopleID int,
            @BackOfficeSystemUsersID int output
            )
            as
            begin
            set nocount on

            begin transaction

            set @BackOfficeSystemUsersID = null

            if @ClientUsersID > 0 and @BackOfficeSystemPeopleID > 0
            BEGIN
            select @BackOfficeSystemUsersID = ID
            from BackOfficeSystemUsers
            where BackOfficePeopleID = @BackOfficeSystemPeopleID
            and ClientUsersID = @ClientUsersID

            if @@rowcount = 0
            begin
                insert into BackOfficeSystemUsers (
                BackOfficePeopleID,
                ClientUsersID)
                values (
                @BackOfficeSystemPeopleID,
                @ClientUsersID
                )

                SELECT @BackOfficeSystemUsersID = @@Identity
            end
            else
            begin
                UPDATE BackOfficeSystemUsers SET [Current] = 1 where ID = @BackOfficeSystemUsersID
            end
            END

            commit
            end