spAddUpdate_EmailTemplateConditionBlock

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Name	nvarchar(50)	IN
@Deleted	bit	IN
@EmailTemplateID	int	IN
@ConditionBlockConditions	xml	IN
@ConditionBlockEmailConditions	xml	IN
Definition

Copy


            CREATE PROCEDURE [dbo].[spAddUpdate_EmailTemplateConditionBlock]
            (
                @PKID int output,
                @Name nvarchar(50),
                @Deleted bit,
                @EmailTemplateID int,
                @ConditionBlockConditions XML,
                @ConditionBlockEmailConditions XML
            )
            AS
            BEGIN
            BEGIN TRANSACTION
            BEGIN TRY
                EXEC [dbo].[spAddUpdate_EmailListConditionBlock]
                    @PKID output,
                    @Name,
                    @Deleted,
                    @ConditionBlockConditions,
                    @ConditionBlockEmailConditions;

                IF NOT EXISTS
                (
                    SELECT *
                        FROM [dbo].[EmailTemplateConditionBlock]
                    WHERE
                        [ConditionBlockID] = @PKID
                        AND [EmailTemplateID] = @EmailTemplateID
                )
                BEGIN
                    INSERT INTO [dbo].[EmailTemplateConditionBlock]
                        ([ConditionBlockID], [EmailTemplateID])
                    VALUES
                        (@PKID, @EmailTemplateID)
                END
            END TRY
            BEGIN CATCH
                IF @@TRANCOUNT > 0
                    ROLLBACK TRANSACTION;

                EXEC usp_RethrowError;
            END CATCH

            IF @@TRANCOUNT > 0
                COMMIT;
            END