spAddUpdate_EventItems

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientEventsID	int	IN
@BackOfficeID	int	IN
@LimitCapacity	bit	IN
@PageLink	nvarchar(1024)	IN
@DisplayName	nvarchar(1024)	IN
@DisplayDesc	ntext	IN
@ShowRelations	bit	IN
@Attributes	ntext	IN
@LinkTarget	nvarchar(256)	IN
@LinkPageTabID	int	IN
@BaseCurrencyID	uniqueidentifier	IN
@DisplayOrder	int	IN
@DocLinkID	int	IN
@MaxRegPerCheckout	int	IN
@SoldOutMessage	ntext	IN
Definition

Copy

                CREATE procedure [dbo].[spAddUpdate_EventItems]
                    (
                        @PKID        int output,
                        @CurrentUsersID    int,        
                        @ClientEventsID    int,
                        @BackOfficeID    int,
                        @LimitCapacity     bit,
                        @PageLink     nvarchar(1024),
                        @DisplayName     nvarchar(1024),
                        @DisplayDesc     ntext,
                        @ShowRelations     bit,
                        @Attributes ntext,
                        @LinkTarget nvarchar(256),
                        @LinkPageTabID int,
                        @BaseCurrencyID uniqueidentifier, 
                        @DisplayOrder int,
                        @DocLinkID int = 0,
                        @MaxRegPerCheckout int = 99,
                        @SoldOutMessage ntext = ''
                    )
                as

                if (@PKID<=0) begin

                insert into dbo.EventItems
                (
                    ClientEventsID,
                    BackOfficeID,
                    LimitCapacity,
                    PageLink,
                    DisplayName,
                    DisplayDesc,
                    ShowRelations,
                    Attributes,
                    Target,
                    PageTabID,
                    BaseCurrencyID, 
                    DisplayOrder,
                    DocLinkID,
                    MaxRegPerCheckout,
                    SoldOutMessage
                )

                values
                (
                    @ClientEventsID,
                    @BackOfficeID,
                    @LimitCapacity,
                    @PageLink,
                    @DisplayName,
                    @DisplayDesc,
                    @ShowRelations,
                    @Attributes,
                    @LinkTarget,
                    @LinkPageTabID,
                    @BaseCurrencyID, 
                    @DisplayOrder,
                    @DocLinkID,
                    @MaxRegPerCheckout,
                    @SoldOutMessage
                )

                select
                    @PKID = @@Identity

                /*    exec spAuditThis @CurrentUsersID, 1, @Guid, 16*/

                end else begin

                    update dbo.EventItems set
                        ClientEventsID = @ClientEventsID,
                        BackOfficeID = @BackOfficeID,
                        LimitCapacity = @LimitCapacity,
                        PageLink = @PageLink,
                        DisplayName = @DisplayName,
                        DisplayDesc = @DisplayDesc,
                        ShowRelations = @ShowRelations,
                        Attributes = @Attributes,
                        Target = @LinkTarget,
                        PageTabID = @LinkPageTabID,
                        BaseCurrencyID = @BaseCurrencyID, 
                        DisplayOrder = @DisplayOrder,
                        DocLinkID = @DocLinkID,
                        MaxRegPerCheckout = @MaxRegPerCheckout,
                        SoldOutMessage = @SoldOutMessage

                    where ID=@PKID

                /*    exec spAuditThis @CurrentUsersID, 2, @Guid, 16*/
                end