spTransactions_InsertTransaction

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@TransactionID	int	IN
@TransactionType	nvarchar(100)	IN
@Data	ntext	IN
@UserID	int	IN
@BackOfficeID	int	IN
Definition

Copy


            CREATE   PROCEDURE dbo.spTransactions_InsertTransaction
                (
                @PKID int output,
                @TransactionID int,
                @TransactionType nvarchar (100),
                @Data ntext,
                @UserID int,
                @BackOfficeID int
                )
                AS

                if (@PKID<=0) begin

                    DECLARE @ExistingTransactionID int

                    SELECT @ExistingTransactionID = ID FROM [Transactions] WHERE TransactionID = @TransactionID AND TransactionType = @TransactionType

                    if (@ExistingTransactionID>0) begin

                        UPDATE [Transactions]
                        SET
                        Data = @Data,
                        BeginDownload = NULL,
                        EndDownload = NULL,
                        DownloadUserID = NULL,
                        BBNCUserID = @UserID,
                        BackOfficeID = @BackOfficeID    

                        WHERE
                        ID = @ExistingTransactionID

                        SET @PKID = @ExistingTransactionID

                    end else begin

                        INSERT into [Transactions]
                        (TransactionID, TransactionType, Data, BBNCUserID, BackOfficeID)
                        VALUES
                        (@TransactionID, @TransactionType, @Data, @UserID, @BackOfficeID)

                        SELECT @PKID = @@Identity 

                    end

                end else begin
                    UPDATE [Transactions]
                    SET
                    TransactionID = @TransactionID,
                    TransactionType = @TransactionType,
                    Data = @Data,
                    BeginDownload = NULL,
                    EndDownload = NULL,
                    DownloadUserID = NULL,
                    BBNCUserID = @UserID,
                    BackOfficeID = @BackOfficeID
                    WHERE
                    ID = @PKID

                end