USP_DATAFORMTEMPLATE_EDIT_AUCTIONITEMADJUST

Adjusts an auction item record.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESIGNATIONID	uniqueidentifier	IN	Designation
@EVENTAUCTIONID	uniqueidentifier	IN	Auction
@DESCRIPTION	nvarchar(255)	IN	Description
@AUCTIONITEMCATEGORYID	uniqueidentifier	IN	Category
@AUCTIONITEMSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@DONORID	uniqueidentifier	IN	Donor
@DONATIONDATE	date	IN	Donation date
@EXPIRATIONDATE	date	IN	Expiration date
@VALUE	money	IN	Value
@MINIMUMBID	money	IN	Minimum bid
@REVENUEAUCTIONDONATIONID	uniqueidentifier	IN	Revenue ID
@ISANONYMOUS	bit	IN	Donation is anonymous
@ISPOSTED	bit	IN	Is posted
@ADJUSTMENTDATE	datetime	IN	Adjusted date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjusted post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment description
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@POSTDATE	datetime	IN	Post date
@POSTSTATUSCODE	tinyint	IN	Post status

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONITEMADJUST 
            (
                @ID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100),
                @DESIGNATIONID uniqueidentifier,
                @EVENTAUCTIONID uniqueidentifier,
                @DESCRIPTION nvarchar(255),
                @AUCTIONITEMCATEGORYID uniqueidentifier,
                @AUCTIONITEMSUBCATEGORYID uniqueidentifier,
                @DONORID uniqueidentifier,
                @DONATIONDATE date,
                @EXPIRATIONDATE date,
                @VALUE money,
                @MINIMUMBID money,
                @REVENUEAUCTIONDONATIONID uniqueidentifier,
                @ISANONYMOUS bit,
                @ISPOSTED bit,
                @ADJUSTMENTDATE datetime,
                @ADJUSTMENTPOSTDATE datetime,
                @ADJUSTMENTREASON nvarchar(300),
                @ADJUSTMENTREASONCODEID uniqueidentifier,
                @POSTDATE datetime,
                @POSTSTATUSCODE tinyint
            )
            as
            set nocount on;

            declare @DATALOADED bit = 0;
            declare @BASECURRENCYID uniqueidentifier = null;
            declare @TRANSACTIONCURRENCYID uniqueidentifier = null;
            declare @BASEEXCHANGERATEID uniqueidentifier = null;
            declare @EXCHANGERATE decimal(20,8) = null;
            declare @HADSPOTRATE bit = null;
            declare @RATECHANGED bit = null;

            begin try 
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_AUCTIONITEMADJUST
                    @ID = @ID,
                    @DATALOADED = @DATALOADED output,
                    @BASECURRENCYID = @BASECURRENCYID output,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                    @EXCHANGERATE = @EXCHANGERATE output,
                    @HADSPOTRATE = @HADSPOTRATE output,
                    @RATECHANGED = @RATECHANGED output;

                if not @DATALOADED = 1
                    raiserror('Could not load original data from backwards-compatible SP.', 13, 1);

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONITEMADJUST_2
                        @ID = @ID,
                        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                        @CHANGEAGENTID = @CHANGEAGENTID,
                        @NAME = @NAME,
                        @DESIGNATIONID = @DESIGNATIONID,
                        @EVENTAUCTIONID = @EVENTAUCTIONID,
                        @DESCRIPTION = @DESCRIPTION,
                        @AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID,
                        @AUCTIONITEMSUBCATEGORYID = @AUCTIONITEMSUBCATEGORYID,
                        @DONORID = @DONORID,
                        @DONATIONDATE = @DONATIONDATE,
                        @EXPIRATIONDATE = @EXPIRATIONDATE,
                        @VALUE = @VALUE,
                        @MINIMUMBID = @MINIMUMBID,
                        @REVENUEAUCTIONDONATIONID = @REVENUEAUCTIONDONATIONID,
                        @ISANONYMOUS = @ISANONYMOUS,
                        @ISPOSTED = @ISPOSTED,
                        @ADJUSTMENTDATE = @ADJUSTMENTDATE,
                        @ADJUSTMENTPOSTDATE = @ADJUSTMENTPOSTDATE,
                        @ADJUSTMENTREASON = @ADJUSTMENTREASON,
                        @ADJUSTMENTREASONCODEID = @ADJUSTMENTREASONCODEID,
                        @POSTDATE = @POSTDATE,
                        @POSTSTATUSCODE = @POSTSTATUSCODE,

                        @BASECURRENCYID = @BASECURRENCYID,
                        @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                        @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                        @EXCHANGERATE = @EXCHANGERATE,
                        @HADSPOTRATE = @HADSPOTRATE,
                        @RATECHANGED = @RATECHANGED,

                        @BASECURRENCYID = @BASECURRENCYID,
                        @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                        @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                        @EXCHANGERATE = @EXCHANGERATE,
                        @HADSPOTRATE = @HADSPOTRATE,
                        @RATECHANGED = @RATECHANGED;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch