USP_DATAFORMTEMPLATE_EDIT_SYSTEMROLE_FEATUREPERMS4

The save procedure used by the edit dataform template "System Role Feature Permissions 4 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.
@RECORDOPERATIONLIST	xml	IN	Record Operation Permission List
@FORMLIST	xml	IN	Form Permission List
@DATALISTLIST	xml	IN	Datalist Permission List
@BUSINESSPROCESSLIST	xml	IN	Business Process Permission List
@DASHBOARDLIST	xml	IN	Dashboard Permission List
@SMARTQUERYLIST	xml	IN	Smart Query Permission List
@KPILIST	xml	IN	KPI Permission List
@QUERYVIEWLIST	xml	IN	Query View Permission List
@REPORTLIST	xml	IN	Report Permission List
@SYSTEMPRIVILEGELIST	xml	IN	Report Permission List
@SEARCHLISTLIST	xml	IN	Search List Permission List
@MAPENTITYLIST	xml	IN	Map Entity Permission List
@RECORDOPERATIONLIST_DELETED	xml	IN	Deleted Record Operation Permission List
@FORMLIST_DELETED	xml	IN	Deleted Form Permission List
@DATALISTLIST_DELETED	xml	IN	Deleted Datalist Permission List
@BUSINESSPROCESSLIST_DELETED	xml	IN	Deleted Business Process Permission List
@DASHBOARDLIST_DELETED	xml	IN	Deleted Dashboard Permission List
@SMARTQUERYLIST_DELETED	xml	IN	Deleted Smart Query Permission List
@KPILIST_DELETED	xml	IN	Deleted KPI Permission List
@QUERYVIEWLIST_DELETED	xml	IN	Deleted Query View Permission List
@REPORTLIST_DELETED	xml	IN	Deleted Report Permission List
@SYSTEMPRIVILEGELIST_DELETED	xml	IN	Deleted System Privilege List
@SEARCHLISTLIST_DELETED	xml	IN	Deleted Search List Permission List
@MAPENTITYLIST_DELETED	xml	IN	Deleted Map Entity Permission List

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SYSTEMROLE_FEATUREPERMS4
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @RECORDOPERATIONLIST xml ,
    @FORMLIST xml,  
    @DATALISTLIST xml,
    @BUSINESSPROCESSLIST xml,
    @DASHBOARDLIST xml,
    @SMARTQUERYLIST xml,
    @KPILIST xml,
    @QUERYVIEWLIST xml,
    @REPORTLIST xml,
    @SYSTEMPRIVILEGELIST xml,
    @SEARCHLISTLIST xml,
    @MAPENTITYLIST xml,
    @RECORDOPERATIONLIST_DELETED xml,
    @FORMLIST_DELETED xml,
    @DATALISTLIST_DELETED xml,
    @BUSINESSPROCESSLIST_DELETED xml,
    @DASHBOARDLIST_DELETED xml,
    @SMARTQUERYLIST_DELETED xml,
    @KPILIST_DELETED xml,
    @QUERYVIEWLIST_DELETED xml,
    @REPORTLIST_DELETED xml,
    @SYSTEMPRIVILEGELIST_DELETED xml,
    @SEARCHLISTLIST_DELETED xml,
    @MAPENTITYLIST_DELETED xml

) AS

set nocount on;

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

declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();

begin try
    update dbo.SYSTEMROLE set
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID;

    exec dbo.USP_SYSTEMROLE_UPDATEFROMRECORDOPLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @RECORDOPERATIONLIST, @RECORDOPERATIONLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMFORMLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @FORMLIST, @FORMLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMDATALISTLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @DATALISTLIST, @DATALISTLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMBUSINESSPROCESSLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @BUSINESSPROCESSLIST, @BUSINESSPROCESSLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMDASHBOARDLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @DASHBOARDLIST, @DASHBOARDLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMSMARTQUERYLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @SMARTQUERYLIST, @SMARTQUERYLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMKPILIST @ID, @CHANGEAGENTID, @CURRENTDATE, @KPILIST, @KPILIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMQUERYVIEWLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @QUERYVIEWLIST, @QUERYVIEWLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMREPORTLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @REPORTLIST, @REPORTLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMSYSTEMPRIVILEGELIST @ID, @CHANGEAGENTID, @CURRENTDATE, @SYSTEMPRIVILEGELIST, @SYSTEMPRIVILEGELIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMSEARCHLISTLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @SEARCHLISTLIST, @SEARCHLISTLIST_DELETED;
    exec dbo.USP_SYSTEMROLE_UPDATEFROMMAPENTITYLIST @ID, @CHANGEAGENTID, @CURRENTDATE, @MAPENTITYLIST, @MAPENTITYLIST_DELETED;

    return 0;

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