USP_CMSSECURITYASSIGNMENT_ADDBYID

The save procedure used by the add dataform template "CMS Security Assignment Add By ID".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@SourceClientSitesID	int	IN
@TargetClientSitesID	int	IN

Definition

Copy



                    CREATE PROCEDURE dbo.USP_CMSSECURITYASSIGNMENT_ADDBYID
                (
                @ID uniqueidentifier = null output,
                @SourceClientSitesID int,
                @TargetClientSitesID int
                )
                AS

                declare @CURRENTDATE datetime = getdate();
                declare @CHANGEAGENTID uniqueidentifier;
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                insert into dbo.CMSSECURITYGROUPCLIENTROLECLIENTSITE(CLIENTROLESID, CLIENTSITESID, CMSSECURITYGROUPID, APPLYTOCHILDREN, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                select CLIENTROLESID,
                       @TargetClientSitesID,
                       CMSSECURITYGROUPID,
                       APPLYTOCHILDREN,
                       @CHANGEAGENTID,
                       @CHANGEAGENTID,
                       @CURRENTDATE,
                       @CURRENTDATE
                from dbo.CMSSECURITYGROUPCLIENTROLECLIENTSITE
                where CLIENTSITESID = @SourceClientSitesID