USP_DATAFORMTEMPLATE_EDIT_AUCTIONDONATION

Original stored procedure to edit an auction donation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@AMOUNT	money	IN	Value
@DATE	datetime	IN	Date
@EXPIRATIONDATE	datetime	IN	Expiration date
@DESIGNATIONID	uniqueidentifier	IN	Designation
@POSTDATE	datetime	IN	Post date
@POSTSTATUSCODE	tinyint	IN	Post status

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONDONATION
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @AMOUNT money,
                @DATE datetime,
                @EXPIRATIONDATE datetime,
                @DESIGNATIONID uniqueidentifier,
                @POSTDATE datetime,
                @POSTSTATUSCODE tinyint
            )
            as

                set nocount on;

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                declare @DONOTPOST bit;
                set @DONOTPOST = case @POSTSTATUSCODE when 2 then 1 else 0 end;

                declare @BASECURRENCYID uniqueidentifier;
                declare @TRANSACTIONCURRENCYID uniqueidentifier;
                declare @BASEEXCHANGERATEID uniqueidentifier;
                declare @EXCHANGERATE decimal(20,8);
                declare @HADSPOTRATE bit;
                declare @BASEDECIMALDIGITS tinyint;
                declare @BASEROUNDINGTYPECODE tinyint;
                declare @TRANSACTIONCURRENCYDESCRIPTION nvarchar(110);

                begin try

                    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_AUCTIONDONATION
                        @ID = @ID,
                        @BASECURRENCYID = @BASECURRENCYID output,
                        @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                        @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                        @EXCHANGERATE = @EXCHANGERATE output,
                        @HADSPOTRATE = @HADSPOTRATE output,
                        @BASEDECIMALDIGITS = @BASEDECIMALDIGITS output,
                        @BASEROUNDINGTYPECODE = @BASEROUNDINGTYPECODE output,
                        @TRANSACTIONCURRENCYDESCRIPTION = @TRANSACTIONCURRENCYDESCRIPTION output;

                    exec dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONDONATION_2
                        @ID = @ID,
                        @CHANGEAGENTID = @CHANGEAGENTID,
                        @AMOUNT = @AMOUNT,
                        @DATE = @DATE,
                        @EXPIRATIONDATE = @EXPIRATIONDATE,
                        @DESIGNATIONID = @DESIGNATIONID,
                        @POSTDATE = @POSTDATE,
                        @POSTSTATUSCODE = @POSTSTATUSCODE,
                        @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                        @EXCHANGERATE = @EXCHANGERATE;

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0;