USP_DATAFORMTEMPLATE_EDIT_EVENTPREFERENCEGROUP
The save procedure used by the edit dataform template "Event Preference Group Edit Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @NAME | nvarchar(100) | IN | Name |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @PREFERENCES | xml | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTPREFERENCEGROUP
(
@ID uniqueidentifier,
@NAME nvarchar(100),
@CHANGEAGENTID uniqueidentifier = null,
@PREFERENCES xml
)
as
set nocount on;
declare @CURRENTDATE datetime;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
begin try
--exec dbo.USP_EVENTPREFERENCE_VALIDATEPREFERENCES @PREFERENCES, @ID;
update
dbo.EVENTPREFERENCEGROUP
set
NAME = @NAME,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
where
ID = @ID;
exec dbo.USP_EVENTPREFERENCE_GETPREFERENCES_UPDATEFROMXML @ID, @PREFERENCES, @CHANGEAGENTID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;