spAddUpdate_ECardPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SiteContentID	int	IN
@MaxHeight	int	IN
@MaxWidth	int	IN
@MaxRecipients	int	IN
@TemplatesXml	ntext	IN
@EmailTemplateID	int	IN
@BrowseCategories	bit	IN
@ClientDonationsID	int	IN
@UseRichTextMessage	bit	IN
@DisplayAllAsSingleFields	bit	IN
@RequireRecipientName	bit	IN

Definition

Copy


CREATE procedure [dbo].[spAddUpdate_ECardPart] (
    @PKID int output,
    @SiteContentID int,
    @MaxHeight int,
    @MaxWidth int,
    @MaxRecipients int,
    @TemplatesXml ntext,
    @EmailTemplateID int,
    @BrowseCategories bit,
    @ClientDonationsID int,
    @UseRichTextMessage bit,
    @DisplayAllAsSingleFields bit,
    @RequireRecipientName bit = 0
) as
    set nocount on;
    declare @Error int;
    set @Error = 0;
    begin transaction spAddUpdate_ECardPart;
    if (@PKID <= 0) begin
        insert into dbo.ECardPart
        (
            SiteContentID,
            MaxHeight,
            MaxWidth,
            MaxRecipients,
            EmailTemplateID,
            BrowseCategories,
            ClientDonationsID,
            UseRichTextMessage,
            DisplayAllAsSingleFields,
            RequireRecipientName
        )
        values
        (
            @SiteContentID,
            @MaxHeight,
            @MaxWidth,
            @MaxRecipients,
            @EmailTemplateID,
            @BrowseCategories,
            @ClientDonationsID,
            @UseRichTextMessage,
            @DisplayAllAsSingleFields,
            @RequireRecipientName
        );
        set @Error = @@ERROR;
        set @PKID = @@Identity;
    end else begin
        update dbo.ECardPart set
            SiteContentID = @SiteContentID,
            MaxHeight = @MaxHeight,
            MaxWidth = @MaxWidth,
            MaxRecipients = @MaxRecipients,
            EmailTemplateID = @EmailTemplateID,
            BrowseCategories  = @BrowseCategories,
            ClientDonationsID = @ClientDonationsID,
            UseRichTextMessage = @UseRichTextMessage,
            DisplayAllAsSingleFields = @DisplayAllAsSingleFields,
            RequireRecipientName = @RequireRecipientName
        where 
            ID = @PKID;
        set @Error = @@ERROR;
    end

    if @Error = 0 begin
        exec dbo.spAddUpdate_ECardPartTemplates @PKID, @TemplatesXml;
        set @Error = @@ERROR;
    end

    if @Error = 0
        commit transaction spAddUpdate_ECardPart;
    else
        rollback transaction spAddUpdate_ECardPart;