USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUPFUNDRAISERASSIGNMENT

The save procedure used by the edit dataform template "Research Group Fundraiser Assignment 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.
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN	Prospect manager
@OVERWRITEEXISTINGPROSPECTMANAGER	bit	IN	Overwrite existing prospect manager

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUPFUNDRAISERASSIGNMENT
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @PROSPECTMANAGERFUNDRAISERID uniqueidentifier,
                @OVERWRITEEXISTINGPROSPECTMANAGER bit
            )
            as
            set nocount on;

            declare @PREVIOUSMANAGERENDDATE date;
            declare @NEWMANAGERSTARTDATE date;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RESEARCHGROUPFUNDRAISERASSIGNMENT
                @ID = @ID,
                @PREVIOUSMANAGERENDDATE = @PREVIOUSMANAGERENDDATE output,
                @NEWMANAGERSTARTDATE = @NEWMANAGERSTARTDATE output;


            exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUPFUNDRAISERASSIGNMENT_2
                @ID = @ID,
                @CHANGEAGENTID = @CHANGEAGENTID,
                @PROSPECTMANAGERFUNDRAISERID = @PROSPECTMANAGERFUNDRAISERID,
                @OVERWRITEEXISTINGPROSPECTMANAGER = @OVERWRITEEXISTINGPROSPECTMANAGER,
                @PREVIOUSMANAGERENDDATE= @PREVIOUSMANAGERENDDATE,
                @NEWMANAGERSTARTDATE = @NEWMANAGERSTARTDATE;