USP_DATAFORMTEMPLATE_ADD_AUCTIONITEMCOPY_PRELOAD

The load procedure used by the edit dataform template "Auction Item Copy Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@AUCTIONITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAME	nvarchar(100)	INOUT	Name
@AUCTIONITEMCATEGORYID	uniqueidentifier	INOUT	Category
@AUCTIONITEMSUBCATEGORYID	uniqueidentifier	INOUT	Subcategory
@DESCRIPTION	nvarchar(255)	INOUT	Description
@VALUE	money	INOUT	Value
@MINIMUMBID	money	INOUT	Minimum bid
@DONATIONDATE	date	INOUT	Donation date
@EXPIRATIONDATE	date	INOUT	Expiration date
@DONORID	uniqueidentifier	INOUT	Donor
@EVENTAUCTIONID	uniqueidentifier	INOUT	Auction
@DESIGNATIONID	uniqueidentifier	INOUT	Designation
@QUANTITY	int	INOUT	Number of copies
@ISANONYMOUS	bit	INOUT	Donation is anonymous
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	PD account system
@POSTDATE	datetime	INOUT	Post date
@POSTSTATUSCODE	tinyint	INOUT	Post status
@DISPLAYNAME	nvarchar(100)	INOUT	Auction item
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@BASEEXCHANGERATEID	uniqueidentifier	INOUT	Exchange rate ID
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@ALLOWGLDISTRIBUTIONS	bit	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_AUCTIONITEMCOPY_PRELOAD
                    (
                        @AUCTIONITEMID uniqueidentifier,
                        @NAME nvarchar(100) = null output,
                        @AUCTIONITEMCATEGORYID uniqueidentifier = null output,
                        @AUCTIONITEMSUBCATEGORYID uniqueidentifier = null output,
                        @DESCRIPTION nvarchar(255) = null output,
                        @VALUE money = null output,
                        @MINIMUMBID money = null output,
                        @DONATIONDATE date = null output,
                        @EXPIRATIONDATE date = null output,
                        @DONORID uniqueidentifier = null output,
                        @EVENTAUCTIONID uniqueidentifier = null output,
                        @DESIGNATIONID uniqueidentifier = null output,
                        @QUANTITY integer = null output,
                        @ISANONYMOUS bit = null output,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                        @POSTDATE datetime = null output,
                        @POSTSTATUSCODE tinyint = null output,
                        @DISPLAYNAME nvarchar(100) = null output,
                        @BASECURRENCYID uniqueidentifier = null output,
                        @BASEEXCHANGERATEID uniqueidentifier = null output,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                        @ALLOWGLDISTRIBUTIONS bit = null output
                    )
                    as

                        set nocount on;

                        set @QUANTITY = 1;

                        select
                            @NAME = AUCTIONITEM.NAME,
                            @DISPLAYNAME = AUCTIONITEM.NAME,
                            @AUCTIONITEMCATEGORYID = AUCTIONITEM.AUCTIONITEMCATEGORYID,
                            @AUCTIONITEMSUBCATEGORYID = AUCTIONITEM.AUCTIONITEMSUBCATEGORYID,
                            @DESCRIPTION = AUCTIONITEM.DESCRIPTION,
                            @VALUE = AUCTIONITEM.TRANSACTIONVALUE,
                            @MINIMUMBID = AUCTIONITEM.TRANSACTIONMINIMUMBID,
                            @DONATIONDATE = REVENUE.DATE,
                            @EXPIRATIONDATE = AUCTIONITEM.EXPIRATIONDATE,
                            @DONORID = REVENUE.CONSTITUENTID,
                            @EVENTAUCTIONID = AUCTIONITEM.EVENTAUCTIONID,
                            @DESIGNATIONID = REVENUESPLIT.DESIGNATIONID,
                            @ISANONYMOUS = REVENUE.GIVENANONYMOUSLY,
                            @PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMFORREVENUE.PDACCOUNTSYSTEMID,
                            @POSTDATE = REVENUE.POSTDATE,
                            @POSTSTATUSCODE = case when REVENUE.DONOTPOST = 1 then 2 else 1 end,
                            @BASECURRENCYID = AUCTIONITEM.BASECURRENCYID,
                            @BASEEXCHANGERATEID = AUCTIONITEM.BASEEXCHANGERATEID,
                            @TRANSACTIONCURRENCYID = AUCTIONITEM.TRANSACTIONCURRENCYID
                        from dbo.AUCTIONITEM
                        inner join dbo.REVENUE
                            on REVENUE.ID = AUCTIONITEM.REVENUEAUCTIONDONATIONID
                        inner join dbo.REVENUESPLIT
                            on REVENUESPLIT.REVENUEID = AUCTIONITEM.REVENUEAUCTIONDONATIONID
                        left join dbo.PDACCOUNTSYSTEMFORREVENUE
                            on REVENUE.ID = PDACCOUNTSYSTEMFORREVENUE.ID
                        left join dbo.REVENUEPOSTED on REVENUE.ID = REVENUEPOSTED.ID
                        where AUCTIONITEM.ID = @AUCTIONITEMID

                        set @ALLOWGLDISTRIBUTIONS = dbo.UFN_PDACCOUNTSYSTEM_ALLOWGLDISTRIBUTIONS(@PDACCOUNTSYSTEMID);

                        return 0;