USP_DATAFORMTEMPLATE_EDIT_PROCESSORTRANSACTIONCOLUMNMAPPING2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@TRANSACTIONDATEHEADER	nvarchar(100)	IN
@CARDTYPEHEADER	nvarchar(100)	IN
@CARDHOLDERNAMEHEADER	nvarchar(100)	IN
@CREDITCARDPARTIALNUMBERHEADER	nvarchar(100)	IN
@AUTHORIZATIONCODEHEADER	nvarchar(100)	IN
@TRANSACTIONAMOUNTHEADER	nvarchar(100)	IN
@VENDORIDHEADER	nvarchar(100)	IN
@CURRENCYHEADER	nvarchar(100)	IN

Definition

Copy


                create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PROCESSORTRANSACTIONCOLUMNMAPPING2 (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @NAME nvarchar(100),
                    @TRANSACTIONDATEHEADER nvarchar(100),
                    @CARDTYPEHEADER nvarchar(100),
                    @CARDHOLDERNAMEHEADER nvarchar(100),
                    @CREDITCARDPARTIALNUMBERHEADER nvarchar(100),
                    @AUTHORIZATIONCODEHEADER nvarchar(100),
                    @TRANSACTIONAMOUNTHEADER nvarchar(100),
                    @VENDORIDHEADER nvarchar(100),
                    @CURRENCYHEADER nvarchar(100)
                )
                as

                    set nocount on;

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    begin try
                        update dbo.PROCESSORTRANSACTIONCOLUMNMAPPING set
                            NAME = @NAME,
                            TRANSACTIONDATEHEADER = @TRANSACTIONDATEHEADER,
                            CARDTYPEHEADER = coalesce(@CARDTYPEHEADER, ''),
                            CARDHOLDERNAMEHEADER = coalesce(@CARDHOLDERNAMEHEADER, ''),
                            CREDITCARDPARTIALNUMBERHEADER = coalesce(@CREDITCARDPARTIALNUMBERHEADER, ''),
                            AUTHORIZATIONCODEHEADER = coalesce(@AUTHORIZATIONCODEHEADER, ''),
                            TRANSACTIONAMOUNTHEADER = coalesce(@TRANSACTIONAMOUNTHEADER, ''),
                            VENDORIDHEADER = isnull(@VENDORIDHEADER, ''),
                            CURRENCYHEADER = isnull(@CURRENCYHEADER, ''),
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                return 0;