USP_DATAFORMTEMPLATE_ADD_AUCTIONPACKAGE

The save procedure used by the add dataform template "Auction Package Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@AUCTIONITEMCATEGORYID	uniqueidentifier	IN	Category
@AUCTIONITEMSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@MINIMUMBID	money	IN	Minimum bid
@EXPIRATIONDATE	datetime	IN	Expiration
@EVENTAUCTIONID	uniqueidentifier	IN	Auction
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_AUCTIONPACKAGE
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @NAME nvarchar(100) = '',
                        @DESCRIPTION nvarchar(255) = '',
                        @AUCTIONITEMCATEGORYID uniqueidentifier = null,
                        @AUCTIONITEMSUBCATEGORYID uniqueidentifier = null,
                        @MINIMUMBID money = null,
                        @EXPIRATIONDATE datetime = null,
                        @EVENTAUCTIONID uniqueidentifier = null,
                        @BASECURRENCYID uniqueidentifier = null,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null
                    )
                    as

                    set nocount on;

                    if @ID is null
                        set @ID = newid()

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

                    if @MINIMUMBID is null
                        set @MINIMUMBID = 0

                    if @TRANSACTIONCURRENCYID is null
                        if @EVENTAUCTIONID is not null
                            select 
                                @TRANSACTIONCURRENCYID = EVENT.BASECURRENCYID
                            from dbo.EVENT
                            where EVENT.ID = @EVENTAUCTIONID

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    begin try

                        exec dbo.USP_AUCTIONITEM_ADD 
                            @ID = @ID, 
                            @CHANGEAGENTID = @CHANGEAGENTID, 
                            @NAME = @NAME, 
                            @AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID, 
                            @AUCTIONITEMSUBCATEGORYID = @AUCTIONITEMSUBCATEGORYID, 
                            @DESCRIPTION = @DESCRIPTION,
                            @VALUE = 0, --Value

                            @MINIMUMBID = @MINIMUMBID,
                            @DONATIONDATE = null,  --DonationDate

                            @EXPIRATIONDATE = @EXPIRATIONDATE,
                            @DONORID = null,  --ConstituentID

                            @EVENTAUCTIONID = @EVENTAUCTIONID,
                            @PACKAGEID = null, --PackageID

                            @TYPECODE = 1, -- TypeCode 1=Package,

                            @COPIEDFROMID = null,  --Copied From ID

                            @DESIGNATIONID = null, --Designation ID

                            @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID

                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0