spCustomFormSettings_Delete

Parameters

Parameter	Parameter Type	Mode	Description
@FormGUID	uniqueidentifier	IN
@CurrentUsersID	int	IN

Definition

Copy


      CREATE procedure [dbo].[spCustomFormSettings_Delete]
            (
                @FormGUID        uniqueidentifier,
                @CurrentUsersID int
            )
            as

            begin transaction

                declare @emailTemplateID int;
                select @emailTemplateID = ConfirmationEmailTemplateID
                from dbo.CustomFormSettings
                where FormGUID = @FormGUID

                exec dbo.spDelete_EmailTemplate @PKID = @emailTemplateID, @CurrentUsersID = @CurrentUsersID

                delete from dbo.CustomFormSettings where FormGUID = @FormGUID

            commit transaction