USP_DATAFORMTEMPLATE_EDIT_EVENTWIDGET

The save procedure used by the edit dataform template "Event Widget Edit Data 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.
@WIDGETID	int	IN	WidgetID
@EVENTID	uniqueidentifier	IN	EventID
@DISPLAYTEXT	nvarchar(4000)	IN	DisplayText
@ROLECODE	tinyint	IN	Role code
@ISACTIVE	bit	IN	IsActive
@ALLOWEDIT	bit	IN	AllowEdit
@ALLOWMOVE	bit	IN	AllowMove
@ALLOWREMOVE	bit	IN	AllowRemove

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTWIDGET (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @WIDGETID int,
    @EVENTID uniqueidentifier,
    @DISPLAYTEXT nvarchar(4000),
    @ROLECODE tinyint,
    @ISACTIVE bit,
    @ALLOWEDIT bit,
    @ALLOWMOVE bit,
    @ALLOWREMOVE bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data
        update dbo.EVENTWIDGET set
        --    WIDGETID = @WIDGETID,
        --    EVENTID = @EVENTID,
            DISPLAYTEXT = ISNULL(@DISPLAYTEXT,DISPLAYTEXT),
            ROLECODE = ISNULL(@ROLECODE, ROLECODE),
            ISACTIVE = ISNULL(@ISACTIVE, ISACTIVE),
            ALLOWEDIT = ISNULL(@ALLOWEDIT, ALLOWEDIT),
            ALLOWMOVE = ISNULL(@ALLOWMOVE, ALLOWMOVE),
            ALLOWREMOVE = ISNULL(@ALLOWREMOVE, ALLOWREMOVE),

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

  -- clear cache for front end data caching
  exec dbo.USP_FAFDATACACHE_CLEAR @EVENTID=@EVENTID  

return 0;