USP_DATAFORMTEMPLATE_EDIT_AUCTIONITEMBATCHROW

Saves changes to an auction item batch row.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@SEQUENCE	int	IN	Sequence
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@CONSTITUENTLOOKUPID	uniqueidentifier	IN	Lookup ID
@NEWCONSTITUENT	xml	IN	New constituent
@NAME	nvarchar(100)	IN	Item name
@AUCTIONITEMCATEGORYID	uniqueidentifier	IN	Category
@AUCTIONITEMSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@DESCRIPTION	nvarchar(255)	IN	Description
@EVENTAUCTIONID	uniqueidentifier	IN	Auction
@DESIGNATIONID	uniqueidentifier	IN	Designation
@VALUE	money	IN	Value
@MINIMUMBID	money	IN	Minimum bid
@DONATIONDATE	date	IN	Donation date
@EXPIRATIONDATE	date	IN	Expiration date
@GIVENANONYMOUSLY	bit	IN	Given anonymously
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@POSTDATE	datetime	IN	Post date
@POSTSTATUSCODE	tinyint	IN	Post status
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONITEMBATCHROW
                    (
                        @ID uniqueidentifier,
                        @SEQUENCE int,

                        @CONSTITUENTID uniqueidentifier,
                        @CONSTITUENTLOOKUPID uniqueidentifier,
                        @NEWCONSTITUENT xml,

                        @NAME nvarchar(100),
                        @AUCTIONITEMCATEGORYID uniqueidentifier,
                        @AUCTIONITEMSUBCATEGORYID uniqueidentifier,
                        @DESCRIPTION nvarchar(255),
                        @EVENTAUCTIONID uniqueidentifier,
                        @DESIGNATIONID uniqueidentifier,
                        @VALUE money,
                        @MINIMUMBID money,
                        @DONATIONDATE date,
                        @EXPIRATIONDATE date,
                        @GIVENANONYMOUSLY bit, 
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @POSTDATE datetime,
                        @POSTSTATUSCODE tinyint,

                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                    set nocount on;

                    begin try
                        declare @TRANSACTIONCURRENCYID uniqueidentifier;
                        declare @BASECURRENCYID uniqueidentifier;
                        declare @BASEEXCHANGERATEID uniqueidentifier;
                        declare @EXCHANGERATE decimal(20,8);

                        exec dbo.USP_DATAFORMTEMPLATE_LOAD_AUCTIONITEMBATCHROW @ID = @ID, @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output, 
                                                                               @BASECURRENCYID = @BASECURRENCYID output, @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                                                                               @EXCHANGERATE = @EXCHANGERATE output;

                        exec dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONITEMBATCHROW_2
                            @ID = @ID, 
                            @SEQUENCE = @SEQUENCE,
                            @CONSTITUENTID = @CONSTITUENTID,
                            @CONSTITUENTLOOKUPID = @CONSTITUENTLOOKUPID,
                            @NEWCONSTITUENT = @NEWCONSTITUENT,
                            @NAME = @NAME,
                            @AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID,
                            @AUCTIONITEMSUBCATEGORYID = @AUCTIONITEMSUBCATEGORYID,
                            @DESCRIPTION = @DESCRIPTION,
                            @EVENTAUCTIONID = @EVENTAUCTIONID,
                            @DESIGNATIONID = @DESIGNATIONID,
                            @VALUE = @VALUE,
                            @MINIMUMBID = @MINIMUMBID,
                            @DONATIONDATE = @DONATIONDATE,
                            @EXPIRATIONDATE = @EXPIRATIONDATE,
                            @GIVENANONYMOUSLY = @GIVENANONYMOUSLY, 
                            @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
                            @POSTDATE = @POSTDATE,
                            @POSTSTATUSCODE = @POSTSTATUSCODE,
                            @CHANGEAGENTID = @CHANGEAGENTID,
                            @CURRENTAPPUSERID = null, --Don't have anything to pass in for this.

                            @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID, 
                            @BASECURRENCYID = @BASECURRENCYID,
                            @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                            @EXCHANGERATE = @EXCHANGERATE;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch
                    return 0;