spAddUpdate_FormDisplayForms

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@DisplayName	nvarchar(250)	IN
@FormID	int	IN
@Sequence	int	IN
@ContentID	int	IN
@FormGuid	uniqueidentifier	IN

Definition

Copy


    CREATE PROCEDURE [dbo].[spAddUpdate_FormDisplayForms] 
        (
           @ID int output,
           @DisplayName nvarchar(250),
           @FormID int,
           @Sequence int,
           @ContentID int,
           @FormGuid uniqueidentifier
         )

        AS
            BEGIN
            SET NOCOUNT ON;

              begin transaction

                declare @ExistingID int
                 set @ExistingID = '0'

                select @ExistingID = [ID]
                from FormDisplayForms where [ID] = @ID

            if (@ExistingID = 0)
                begin

            insert into [FormDisplayForms]
            (
                [DisplayName], [FormID], [Sequence], [ContentID], [FormGuid]
            )
            values
            (
                @DisplayName, @FormID, @Sequence, @ContentID, @FormGuid
            )

            end

            else begin

               update [FormDisplayForms] set

                [DisplayName] = @DisplayName, 
                [FormID] = @FormID, 
                [Sequence] = @Sequence, 
                [ContentID] = @ContentID,
                [FormGuid] = @FormGuid

               where [ID] = @ID
            end

        commit transaction

        End