spAddUpdate_FundraiserEmail

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@FundraisersID	int	IN
@Type	tinyint	IN
@EmailTEmplateID	int	IN
@DisplayName	nvarchar(255)	IN

Definition

Copy



CREATE   PROCEDURE dbo.spAddUpdate_FundraiserEmail
(
    @PKID        int output,
    @FundraisersID    int,        
    @Type        tinyint,
    @EmailTEmplateID    int,
    @DisplayName    nvarchar(255)
)
AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO FundraiserEmail
        (
            [FundraisersID],
            [Type],
            [EmailTEmplateID],
            [DisplayName]
        )VALUES(
            @FundraisersID,
            @Type,
            @EmailTEmplateID,
            @DisplayName
        )

        SELECT
            @PKID = @@Identity

    end else begin

        UPDATE FundraiserEmail SET
            [FundraisersID]    = @FundraisersID,
            [Type]         = @Type,
            [EmailTEmplateID]     = @EmailTEmplateID,
            [UpdateDate]    = getutcdate(),
            [DisplayName]    = @DisplayName
        WHERE ID=@PKID

    end

    commit transaction