EA7_spAddUpdateCustomFormApplicationChecklistSettings

Parameters

Parameter	Parameter Type	Mode
@CustomFormID	int	IN
@ItemsSelectedValues	nvarchar(2000)	IN
@ItemsSelectedText	nvarchar(4000)	IN
@StatusSelectedValues	nvarchar(200)	IN
@StatusSelectedText	nvarchar(500)	IN
Definition

Copy

            CREATE PROCEDURE [dbo].[EA7_spAddUpdateCustomFormApplicationChecklistSettings]
                -- Add the parameters for the stored procedure here

                @CustomFormID int,
                @ItemsSelectedValues nvarchar(2000),
                @ItemsSelectedText nvarchar(4000),
                @StatusSelectedValues nvarchar(200),
                @StatusSelectedText nvarchar(500)

            AS
            BEGIN
                -- SET NOCOUNT ON added to prevent extra result sets from

                -- interfering with SELECT statements.

                SET NOCOUNT ON;

                DECLARE @PKID int
                SET @PKID = 0
                SELECT @PKID = [ID] FROM EA7_CustomFormApplicationChecklistSetting WHERE [CustomFormID] = @CustomFormID

                begin transaction
                if (@PKID<=0)
                    begin

                    INSERT INTO EA7_CustomFormApplicationChecklistSetting
                    (
                        [CustomFormID],
                        [ItemsSelectedValues],
                        [ItemsSelectedText],
                        [StatusSelectedValues],
                        [StatusSelectedText]
                    )VALUES(
                        @CustomFormID,
                        @ItemsSelectedValues,
                        @ItemsSelectedText,
                        @StatusSelectedValues,
                        @StatusSelectedText
                    )

                    SELECT
                        @PKID = @@Identity

                    end 
                else 
                    begin
                        UPDATE EA7_CustomFormApplicationChecklistSetting SET
                            [CustomFormID]            = @CustomFormID,
                            [ItemsSelectedValues]    = @ItemsSelectedValues,
                            [ItemsSelectedText]     = @ItemsSelectedText,
                            [StatusSelectedValues]     = @StatusSelectedValues,
                            [StatusSelectedText]     = @StatusSelectedText
                        WHERE ID=@PKID
                    end
                commit transaction

            END