USP_AMPROIMPORT_COMMITPACKAGE

Commits package updates imported from AuctionMaestro Pro.
Parameters

Parameter	Parameter Type	Mode
@PACKAGEID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@CATEGORYID	uniqueidentifier	IN
@SUBCATEGORYID	uniqueidentifier	IN
@MINIMUMBID	money	IN
@EXPIRATIONDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_AMPROIMPORT_COMMITPACKAGE
            (
                @PACKAGEID uniqueidentifier,
                @NAME nvarchar(100),
                @DESCRIPTION nvarchar(255),
                @CATEGORYID uniqueidentifier,
                @SUBCATEGORYID uniqueidentifier,
                @MINIMUMBID money,
                @EXPIRATIONDATE datetime,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

            if @NAME is null
                set @NAME = '';
            if @DESCRIPTION is null
                set @DESCRIPTION = '';
            if @MINIMUMBID is null
                set @MINIMUMBID = 0;


            declare @EVENTAUCTIONID uniqueidentifier;

            select top 1 
                @EVENTAUCTIONID = AUCTIONITEM.EVENTAUCTIONID
            from dbo.AUCTIONITEM
            inner join dbo.AMPROIMPORTCONFIG on AMPROIMPORTCONFIG.ID = AUCTIONITEM.EVENTAUCTIONID
            where AUCTIONITEM.ID = @PACKAGEID;

            declare @ORGANIZATIONCURRENCYID uniqueidentifier;
            declare @BASECURRENCYID uniqueidentifier;
            declare @TRANSACTIONCURRENCYID uniqueidentifier;
            declare @BASEEXCHANGERATEID uniqueidentifier; 
            declare @ORIGINTOORGANIZATIONEXCHANGERATEID uniqueidentifier;

            select 
                @TRANSACTIONCURRENCYID = EVENT.BASECURRENCYID,
                @BASECURRENCYID = EVENT.BASECURRENCYID
            from dbo.EVENT where EVENT.ID = @EVENTAUCTIONID;

            declare @CURRENTDATE datetime = getdate();

            --TODO This should probably be a configuration option

            select @BASEEXCHANGERATEID = dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST(@TRANSACTIONCURRENCYID, @BASECURRENCYID, @CURRENTDATE, 1, null);

            declare @BASEMINIMUMBID money;
            declare @ORGANIZATIONMINIMUMBID money;
            exec dbo.USP_CURRENCY_GETCURRENCYVALUES @MINIMUMBID, @CURRENTDATE, @BASECURRENCYID, @BASEEXCHANGERATEID output, @TRANSACTIONCURRENCYID output, @BASEMINIMUMBID output, @ORGANIZATIONCURRENCYID output, @ORGANIZATIONMINIMUMBID output, @ORIGINTOORGANIZATIONEXCHANGERATEID output, 1;

            update dbo.AUCTIONITEM
                set NAME = @NAME,
                    DESCRIPTION = @DESCRIPTION,
                    AUCTIONITEMCATEGORYID = @CATEGORYID,
                    AUCTIONITEMSUBCATEGORYID = @SUBCATEGORYID,
                    MINIMUMBID = @BASEMINIMUMBID,
                    TRANSACTIONMINIMUMBID = @MINIMUMBID,
                    ORGANIZATIONMINIMUMBID = @ORGANIZATIONMINIMUMBID,
                    BASECURRENCYID = @BASECURRENCYID,
                    TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                    EXPIRATIONDATE = EXPIRATIONDATE,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CHANGEDATE
            where ID = @PACKAGEID and TYPECODE = 1;