spAddUpdate_EmailConditionBlock

Parameters

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

Copy


            CREATE PROCEDURE [dbo].[spAddUpdate_EmailConditionBlock]
            (
                @PKID int output,
                @Name nvarchar(50),
                @Deleted bit,
                @EmailID 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].[EmailConditionBlock]
                    WHERE
                        [ConditionBlockID] = @PKID
                        AND [EmailID] = @EmailID
                )
                BEGIN
                    INSERT INTO [dbo].[EmailConditionBlock]
                        ([ConditionBlockID], [EmailID])
                    VALUES
                        (@PKID, @EmailID)
                END
            END TRY
            BEGIN CATCH
                IF @@TRANCOUNT > 0
                    ROLLBACK TRANSACTION;

                EXEC usp_RethrowError;
            END CATCH

            IF @@TRANCOUNT > 0
                COMMIT;
            END