spAddUpdate_CustomTransactionTypes

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@TransactionTypeGuid	uniqueidentifier	IN
@Name	nvarchar(255)	IN
@ProcessorGuid	uniqueidentifier	IN

Definition

Copy




    CREATE  PROCEDURE dbo.spAddUpdate_CustomTransactionTypes
    (
        @PKID            int output    ,
        @TransactionTypeGuid    uniqueidentifier    ,
        @Name            nvarchar(255),
        @ProcessorGuid    uniqueidentifier    
    )
    AS

    SELECT @PKID = ISNULL((SELECT [ID] FROM dbo.CustomTransactionTypes WHERE [TransactionTypeGuid] = @TransactionTypeGuid),0)

    begin transaction

    if (@PKID<1)

    begin

        INSERT INTO dbo.CustomTransactionTypes
        (
        [TransactionTypeGuid]    ,
        [ProcessorGuid]    ,
        [Name]
        )

        VALUES
        (
        @TransactionTypeGuid,
        @ProcessorGuid,
        @Name
        )


        SELECT @PKID = @@Identity

    end 
    else 
    begin

        UPDATE dbo.CustomTransactionTypes SET
            [Name]    =@Name,
            [ProcessorGuid]    =@ProcessorGuid

        WHERE ID=@PKID

    end

    commit transaction