USP_DATAFORMTEMPLATE_EDIT_TEAMWIDGET

The save procedure used by the edit dataform template "Team 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
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN	TeamFundraisingTeamID
@DISPLAYTEXT	nvarchar(4000)	IN	DisplayText
@ISACTIVE	bit	IN	IsActive

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_TEAMWIDGET (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier = null,
                            @WIDGETID int,
                            @TEAMFUNDRAISINGTEAMID uniqueidentifier,
                            @DISPLAYTEXT nvarchar(4000),
                            @ISACTIVE 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.TEAMWIDGET set
                                    DISPLAYTEXT = @DISPLAYTEXT,
                                    ISACTIVE = @ISACTIVE,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where ID = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0;