USP_DATAFORMTEMPLATE_EDIT_ORGANIZATIONHIERARCHY
The save procedure used by the edit dataform template "Organization Hierarchy Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @ORGANIZATIONHIERARCHY | xml | IN | Hierarchy |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ORGANIZATIONHIERARCHY
(
@CHANGEAGENTID uniqueidentifier,
@ORGANIZATIONHIERARCHY xml
)
as
begin
set nocount on;
begin try
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CURRENTDATE datetime = getdate();
exec dbo.USP_ORGANIZATIONHIERARCHY_UPDATEFROMXML_2 @ORGANIZATIONHIERARCHY, @CHANGEAGENTID, @CURRENTDATE;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;
end