USP_DATAFORMTEMPLATE_EDIT_INTERACTIONCATEGORY

The save procedure used by the edit dataform template "Interaction Category Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@SORTMETHODCODE	tinyint	IN	Sort Method
@ISINACTIVE	bit	IN	Inactive

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTIONCATEGORY
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @NAME nvarchar(100),
                    @SORTMETHODCODE tinyint,
                    @ISINACTIVE bit
                )
                as
                    set nocount on;

                    declare @CURRENTDATE datetime;

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    set @CURRENTDATE = getdate();

                    begin try
                        update
                            dbo.INTERACTIONCATEGORY
                        set
                            NAME = @NAME,
                            ISINACTIVE = @ISINACTIVE,
                            DATECHANGED = @CURRENTDATE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            SORTMETHODCODE = @SORTMETHODCODE
                        where 
                            ID = @ID;

                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;