spAddUpdate_Email_Recipient

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@EmailID	int	IN
@UserID	int	IN
@AddressBookID	int	IN
@DisplayName	nvarchar(255)	IN
@EmailAddress	nvarchar(255)	IN
@PeopleID	int	IN
@DataSourceID	int	IN

Definition

Copy



CREATE  PROCEDURE [dbo].[spAddUpdate_Email_Recipient]
    (
        @PKID int OUTPUT,
        @EmailID int,
        @UserID int,
        @AddressBookID int,
        @DisplayName nvarchar(255),
        @EmailAddress nvarchar(255),
        @PeopleID as int,
        @DataSourceID int
    )
    AS
BEGIN

set nocount on

    BEGIN TRANSACTION
    IF (@PKID<=0) BEGIN
    INSERT INTO Email_Recipient
    (
        [EmailID],
        [USerID],
        [AddressBookID],
        [DisplayName],
        [EmailAddress],
        [BackOfficeSystemPeopleID],
        [DataSourceID]
    )
    VALUES
    (
        @EmailID,
        @userid,
        @addressbookid,
        @DisplayName,
        @EmailAddress,
        @PeopleID,
        @DataSourceID

    )
    SELECT @PKID = @@Identity

    END ELSE BEGIN
    UPDATE Email_Recipient
    SET
        [EmailID]=@EmailID,
        [userid]=@userid,
        [addressBookid]=@AddressBookid,
        [DisplayName]=@DisplayName,
        [EmailAddress]=@EmailAddress,
        [BackOfficeSystemPeopleID]=@PeopleID,
        [DataSourceID] = @DataSourceID

    WHERE ID=@PKID
    END
    COMMIT TRANSACTION

END