spAddUpdate_EmailList_UserDefined

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@EmailListID	int	IN
@EmailDisplayName	nvarchar(255)	IN
@EmailAddress	nvarchar(255)	IN
@Enabled	bit	IN
@GlobalOptOut	bit	IN
@UpdateDate	datetime	IN

Definition

Copy


CREATE PROCEDURE [dbo].[spAddUpdate_EmailList_UserDefined]
    @PKID int OUTPUT,
    @EmailListID int,
    @EmailDisplayName nvarchar(255),
    @EmailAddress nvarchar(255),
    @Enabled bit,
    @GlobalOptOut bit,
    @UpdateDate Datetime

    as

        IF @PKID <= 0
            BEGIN
                INSERT INTO [dbo].[EmailList_UserDefined]
                ([EmailListID]
                ,[EmailDisplayName]
                ,[EmailAddress]
                ,[Enabled]
                ,[GlobalOptOut]
                ,[UpdateDate])
                VALUES
                (@EmailListID
                ,@EmailDisplayName
                ,@EmailAddress
                ,@Enabled
                ,@GlobalOptOut
                ,@UpdateDate)

                SET @PKID = @@Identity
                IF @PKID > 0
                    UPDATE EmailList SET AcquiredRecordCount = (AcquiredRecordCount + 1) WHERE ID = @EmailListID
            END
        ELSE
            BEGIN
                UPDATE [dbo].[EmailList_UserDefined]
                SET [EmailListID] = @EmailListID
                ,[EmailDisplayName] = @EmailDisplayName
                ,[EmailAddress] = @EmailAddress
                ,[Enabled] = @Enabled
                ,[GlobalOptOut] = @GlobalOptOut
                ,[UpdateDate] = @UpdateDate
                WHERE ID = @PKID
            END