USP_DATAFORMTEMPLATE_ADD_GROUPMEMBER

The save procedure used by the add dataform template "Group Member Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@GROUPID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@MEMBERID	uniqueidentifier	IN	Member
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@COMMENTS	nvarchar(300)	IN	Comments
@ADDTYPE	tinyint	IN
@IDSETREGISTERID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GROUPMEMBER
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @GROUPID uniqueidentifier,
  @MEMBERID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier,
  @STARTDATE date = null,
  @ENDDATE date = null,
  @COMMENTS nvarchar(300) = null,
  @ADDTYPE tinyint = 0,
  @IDSETREGISTERID uniqueidentifier = null
)
as
  set nocount on;

    if @ADDTYPE = 0 -- Add a single member
    begin
        if (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 0) and
            (dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORCONSTIT(@CURRENTAPPUSERID, 'BF1515BB-6950-479C-9B61-D6D9A2CFD8E6', @MEMBERID) = 0)
        begin
            raiserror('ERR_MEMBER_NOACCESS', 13, 1);
            return 1;
        end

        begin try
            exec dbo.USP_GROUPMEMBERADD @ID output, @CHANGEAGENTID, @GROUPID, @MEMBERID, default, @STARTDATE, 1, @ENDDATE, @COMMENTS;
        end try
        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch
    end
    else -- Add a selection of members
    begin
        begin try
            exec dbo.USP_GROUPMEMBERADDBULK @ID output, @CHANGEAGENTID, @GROUPID, @IDSETREGISTERID, default, @STARTDATE, 1, @ENDDATE, @COMMENTS, @CURRENTAPPUSERID;
        end try
        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch
    end

    return 0;