USP_EVENTREGISTRATIONEXPRESSPARTSETTINGS_UPDATE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SITECONTENTID	int	IN
@ORDERPAGEID	int	IN
@MAXIMUMQUANTITY	int	IN
@TIMEOUTMINUTES	int	IN
@LOWAVAILABILITYTHRESHOLD	int	IN
@ITEMDEFAULTIMAGEID	int	IN
@REGISTRATIONOPTIONSETTINGS	xml	IN
@ONSALEHORIZON	int	IN
Definition

Copy


            create procedure dbo.USP_EVENTREGISTRATIONEXPRESSPARTSETTINGS_UPDATE
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @SITECONTENTID int,
                @ORDERPAGEID int,
                @MAXIMUMQUANTITY int,
                @TIMEOUTMINUTES int,
                @LOWAVAILABILITYTHRESHOLD int,
                @ITEMDEFAULTIMAGEID int,
                @REGISTRATIONOPTIONSETTINGS xml,
                @ONSALEHORIZON integer = 185
            )
            as
            begin
                select @ID = [Guid] --Making sure we're using the right ID

                from dbo.[SiteContent] with (nolock)
                where ID = @SITECONTENTID

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

                declare @CURRENTDATE datetime = getdate();

                -- handle updating the data

                merge dbo.[EVENTREGISTRATIONEXPRESSPARTSETTINGS] as [TARGET]
                using (select @ID as ID) as [SOURCE]
                on (TARGET.ID = SOURCE.ID)
                when matched then
                    update 
                    set 
                        SITECONTENTID = @SITECONTENTID,
                        ORDERPAGEID = @ORDERPAGEID,
                        MAXIMUMQUANTITY = isnull(@MAXIMUMQUANTITY, 50),
                        TIMEOUTMINUTES = isnull(@TIMEOUTMINUTES, 15),
                        LOWAVAILABILITYTHRESHOLD = isnull(@LOWAVAILABILITYTHRESHOLD,0),
                        ITEMDEFAULTIMAGEID = @ITEMDEFAULTIMAGEID,
                        REGISTRATIONOPTIONSETTINGS = @REGISTRATIONOPTIONSETTINGS,
                        ONSALEHORIZON = isnull(@ONSALEHORIZON, 185),
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                when not matched then
                    insert (
                        ID, 
                        SITECONTENTID, 
                        ORDERPAGEID, 
                        MAXIMUMQUANTITY, 
                        TIMEOUTMINUTES, 
                        LOWAVAILABILITYTHRESHOLD, 
                        ITEMDEFAULTIMAGEID,
                        REGISTRATIONOPTIONSETTINGS,
                        ONSALEHORIZON,
                        ADDEDBYID, 
                        CHANGEDBYID, 
                        DATEADDED, 
                        DATECHANGED
                    )
                    values (
                        @ID, 
                        @SITECONTENTID, 
                        @ORDERPAGEID, 
                        isnull(@MAXIMUMQUANTITY, 50), 
                        isnull(@TIMEOUTMINUTES, 15), 
                        isnull(@LOWAVAILABILITYTHRESHOLD,0), 
                        @ITEMDEFAULTIMAGEID, 
                        isnull(@REGISTRATIONOPTIONSETTINGS, ''),
                        isnull(@ONSALEHORIZON, 185),
                        @CHANGEAGENTID, 
                        @CHANGEAGENTID, 
                        @CURRENTDATE, 
                        @CURRENTDATE
                    );
            end