spCustomFormElement_DeleteForm

Parameters

Parameter	Parameter Type	Mode	Description
@FormGuid	uniqueidentifier	IN
@CurrentUsersID	int	IN
Definition

Copy

        CREATE PROCEDURE [dbo].[spCustomFormElement_DeleteForm]
                (
                  @FormGuid            uniqueIdentifier,
                  @CurrentUsersID    int
              )
            AS
            DECLARE @ERROR INT
            BEGIN TRANSACTION

                SET @ERROR = @@ERROR
                IF @ERROR <> 0 GOTO ERR_HANDLER

                exec dbo.spCustomFormAutoSavedForms_Delete @FormGuid

                SET @ERROR = @@ERROR
                IF @ERROR <> 0 GOTO ERR_HANDLER

                exec dbo.spCustomFormPaymentSetting_Delete @FormGuid

                SET @ERROR = @@ERROR
                IF @ERROR <> 0 GOTO ERR_HANDLER
                exec dbo.spCustomFormSettings_Delete @FormGuid, @CurrentUsersID

                SET @ERROR = @@ERROR
                IF @ERROR <> 0 GOTO ERR_HANDLER

                exec dbo.spCustomFormElement_DeleteByGuid @FormGuid

                SET @ERROR = @@ERROR
                IF @ERROR <> 0 GOTO ERR_HANDLER

                -- Form Mapping Schema
                Delete
                from
                    dbo.CustomFormMappingSchema
                where
                    [FormGuid] = @FormGuid

                SET @ERROR = @@ERROR
                IF @ERROR <> 0 GOTO ERR_HANDLER


            ERR_HANDLER:
            IF @ERROR = 0
                COMMIT TRANSACTION

            ELSE
                ROLLBACK TRANSACTION

            RETURN @ERROR