spAddUpdate_FundraiserSolicitorEmail

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@FundraiserSolicitorsID	int	IN
@Type	tinyint	IN
@Subject	nvarchar(255)	IN
@Message	ntext	IN
@Closing	nvarchar(1000)	IN
@EmailJobID	int	IN

Definition

Copy



CREATE   PROCEDURE dbo.spAddUpdate_FundraiserSolicitorEmail
(
    @PKID                int output,
    @FundraiserSolicitorsID        int,
    @Type                tinyint,
    @Subject            nvarchar(255),
    @Message            ntext,
    @Closing            nvarchar(1000),
    @EmailJobID            int

)
AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO FundraiserSolicitorEmail
        (
            [FundraiserSolicitorsID],
            [Type],
            [Subject],
            [Message],
            [Closing],
            [EmailJobID]
        )VALUES(
            @FundraiserSolicitorsID,
            @Type,
            @Subject,
            @Message,
            @Closing,
            @EmailJobID
        )

        SELECT
            @PKID = @@Identity

    end else begin

        UPDATE FundraiserSolicitorEmail SET
            [FundraiserSolicitorsID]     = @FundraiserSolicitorsID,
            [Type]                 = @Type,
            [Subject]             = @Subject,
            [Message]             = @Message,
            [Closing]             = @Closing,
            [EmailJobID]         = @EmailJobID


        WHERE ID=@PKID

    end

    commit transaction