spAddUpdate_ClientEvents

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientsID	int	IN
@Guid	uniqueidentifier	IN
@FundID	int	IN
@ConstitCodeID	int	IN
@EmailTemplateID	int	IN
@RedirectPageID	int	IN
@ContentID	int	IN
@MerchantAccount	int	IN
@NoMGPledges	bit	IN
@ShoppingCartPageID	int	IN
@CartMessage	ntext	IN
@AllowCreditCard	bit	IN
@AllowPledge	bit	IN
@CartSendRegistrationAcknowledgementAlways	bit	IN
@AcknowledgementBlock	nvarchar(max)	IN
@DisplayEventConflictNotification	bit	IN
@AppealID	int	IN
Definition

Copy


CREATE procedure [dbo].[spAddUpdate_ClientEvents]
            (
                @PKID int output,
                @CurrentUsersID    int,        
                @ClientsID    int,
                @Guid    uniqueidentifier,
                @FundID    int,
                @ConstitCodeID    int,         
                @EmailTemplateID    int,
                @RedirectPageID int,
                @ContentID int,
                @MerchantAccount int,
                @NoMGPledges bit,
                @ShoppingCartPageID int,
                @CartMessage ntext,
                @AllowCreditCard bit,
                @AllowPledge bit,
                @CartSendRegistrationAcknowledgementAlways bit,
                @AcknowledgementBlock nvarchar(max),
                @DisplayEventConflictNotification bit,
                @AppealID int =null
            )
            as
            begin transaction;

            if (@PKID<=0) begin

     insert INTO ClientEvents
                (
                    ClientsID,
                    Guid,
                    OwnerID,
                    FundID ,
                    ConstitCodeID ,
                    EmailTemplateID ,
                    RedirectPageID,
                    ContentID,
                    MerchantAccount,    
                    NoMGPledges,
                    ShoppingCartPageID,
                    CartMessage,
                    AllowCreditCard,
                    AllowPledge,
                    CartSendRegistrationAcknowledgementAlways,
                    AcknowledgementBlock,
                    DisplayEventConflictNotification,
                    AppealID
                )

                values
                (
                    @ClientsID,
                    @Guid,
                    @CurrentUsersID,
                    @FundID ,
                    @ConstitCodeID ,
                    @EmailTemplateID ,
                    @RedirectPageID,
                    @ContentID,                 
                    @MerchantAccount,
                    @NoMGPledges,
                    @ShoppingCartPageID,
                    @CartMessage,
                    @AllowCreditCard,
                    @AllowPledge,
                    @CartSendRegistrationAcknowledgementAlways,
                    @AcknowledgementBlock,                  
                    @DisplayEventConflictNotification,
                    @AppealID
                )

                select @PKID = @@Identity;
                exec spAuditThis @CurrentUsersID, 1, @Guid, 16;

            end else begin

                update ClientEvents set
                    ClientsID = @ClientsID,
                    [Guid] = @Guid,
                    FundID = @FundID,
                    ConstitCodeID = @ConstitCodeID,
                    EmailTemplateID = @EmailTemplateID,
                    RedirectPageID = @RedirectPageID,
                    MerchantAccount = @MerchantAccount,
                    NoMGPledges = @NoMGPledges,
                    ShoppingCartPageID = @ShoppingCartPageID,
                    CartMessage = @CartMessage,
                    AllowCreditCard = @AllowCreditCard,
                    AllowPledge = @AllowPledge,
                    CartSendRegistrationAcknowledgementAlways = @CartSendRegistrationAcknowledgementAlways,
                    AcknowledgementBlock = @AcknowledgementBlock,
                    DisplayEventConflictNotification = @DisplayEventConflictNotification,
                    AppealID= @AppealID
                where ID = @PKID;

                exec spAuditThis @CurrentUsersID, 2, @Guid, 16;
            end
            commit transaction;