spAddUpdate_EmailJob_Recipient

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@EmailID	int	IN
@EmailJobID	int	IN
@UserID	int	IN
@EmailAddress	nvarchar(255)	IN
@MessageDate	datetime	IN
@SentDate	datetime	IN
@UpdateDate	datetime	IN
@Sent	bit	IN
@Opened	bit	IN
@OpenedDate	datetime	IN
@DSNed	bit	IN
@RecentDSNDate	datetime	IN
@RecentDSNSignatureID	int	IN
@RecentDSNCategory	int	IN
@StatusReport	ntext	IN
@Completed	bit	IN
@AddressBookID	int	IN
@PeopleID	int	IN

Definition

Copy



CREATE PROCEDURE [dbo].[spAddUpdate_EmailJob_Recipient]
(
@PKID int OUTPUT,
/* @CurrentUsersID int, */
@EmailID int,
@EmailJobID int,
@UserID int,
@EmailAddress nvarchar(255),
@MessageDate datetime,
@SentDate datetime,
@UpdateDate datetime,
@Sent bit,
@Opened bit,
@OpenedDate datetime,
@DSNed bit,
@RecentDSNDate datetime,
@RecentDSNSignatureID int,
@RecentDSNCategory int,
@StatusReport ntext,
@Completed bit,
@AddressBookID as int,
@PeopleID int
)
AS

set nocount on

BEGIN TRANSACTION
IF (@PKID<=0) BEGIN
    INSERT INTO EmailJob_Recipient
    (
        [EmailID],
        [EmailJobID],
        [UserID],
        [EmailAddress],
        [MessageDate],
        [SentDate],
        [UpdateDate],
        [Sent],
        [Opened],
        [OpenedDate],
        [DSNed],
        [RecentDSNDate],
        [RecentDSNSignatureID],
        [RecentDSNCategory],
        [StatusReport],
        [Completed],
        [AddressBookID],
        [BackOfficeSystemPeopleID]
    )
    VALUES
    (
        @EmailID,
        @EmailJobID,
        @UserID,
        @EmailAddress,
        @MessageDate,
        @SentDate,
        @UpdateDate,
        @Sent,
        @Opened,
        @OpenedDate,
        @DSNed,
        @RecentDSNDate,
        @RecentDSNSignatureID,
        @RecentDSNCategory,
        @StatusReport,
        @Completed,
        @AddressBookID,
        @PeopleID
    )
    SELECT @PKID = @@Identity

    END ELSE BEGIN
    UPDATE EmailJob_Recipient
    SET
        [EmailID]=@EmailID,
        [EmailJobID]=@EmailJobID,
        [UserID]=@UserID,
        [EmailAddress]=@EmailAddress,
        [MessageDate]=@MessageDate,
        [SentDate]=@SentDate,
        [UpdateDate]=@UpdateDate,
        [Sent]=@Sent,
        [Opened]=@Opened,
        [OpenedDate]=@OpenedDate,
        [DSNed]=@DSNed,
        [RecentDSNDate]=@RecentDSNDate,
        [RecentDSNSignatureID]=@RecentDSNSignatureID,
        [RecentDSNCategory]=@RecentDSNCategory,
        [StatusReport]=@StatusReport,
        [Completed]=@Completed,
        [AddressBookID]=@AddressBookID,
        [BackOfficeSystemPeopleID]=@PeopleID
    WHERE ID=@PKID
    END
    COMMIT TRANSACTION