USP_DATAFORMTEMPLATE_EDIT_PROSPECTPLANREQUEST

The save procedure used by the edit dataform template "Prospect Plan Request Edit Data 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.
@PROSPECTID	uniqueidentifier	IN
@PROSPECTPLANTYPECODEID	uniqueidentifier	IN	Plan type
@NARRATIVE	nvarchar(1000)	IN	Narrative
@PROSPECTPLAN_NAME	nvarchar(100)	IN	Plan name
@PROSPECTPLAN_PARTICIPANTS	xml	IN	Plan participants
@SECONDARYFUNDRAISERS	xml	IN	Secondary solicitors
@PRIMARYMANAGERFUNDRAISERID	uniqueidentifier	IN	Primary manager
@SECONDARYMANAGERFUNDRAISERID	uniqueidentifier	IN	Secondary manager
@SITES	xml	IN	Sites
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PRIMARYMANAGERDATEFROM	datetime	IN	Start date
@SECONDARYMANAGERDATEFROM	datetime	IN	Start date

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PROSPECTPLANREQUEST (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @PROSPECTID uniqueidentifier,
    @PROSPECTPLANTYPECODEID uniqueidentifier,
    @NARRATIVE nvarchar(1000),
    @PROSPECTPLAN_NAME nvarchar(100),
    @PROSPECTPLAN_PARTICIPANTS xml,
    @SECONDARYFUNDRAISERS xml,
    @PRIMARYMANAGERFUNDRAISERID uniqueidentifier,
    @SECONDARYMANAGERFUNDRAISERID uniqueidentifier,
    @SITES xml,
    @CURRENTAPPUSERID uniqueidentifier,
    @PRIMARYMANAGERDATEFROM datetime,
    @SECONDARYMANAGERDATEFROM datetime
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        exec dbo.USP_DATAFORMTEMPLATE_PROSPECTPLAN_ADD
        null,
        @CHANGEAGENTID,
        @PROSPECTID,
        @PROSPECTPLANTYPECODEID,
        @NARRATIVE,
        null,
        @PROSPECTPLAN_NAME,
        @PROSPECTPLAN_PARTICIPANTS,
        @SECONDARYFUNDRAISERS,
        @PRIMARYMANAGERFUNDRAISERID,
        @SECONDARYMANAGERFUNDRAISERID,
        @SITES,
        @CURRENTAPPUSERID,
        @PRIMARYMANAGERDATEFROM,
        @SECONDARYMANAGERDATEFROM;

      update dbo.PROSPECTPLANREQUEST set 
            STATUSCODE = 1,
            REVIEWDATE = @CURRENTDATE,
            REVIEWEDBYID = @CURRENTAPPUSERID,
            DATECHANGED = @CURRENTDATE,
            CHANGEDBYID = @CHANGEAGENTID,
            PROSPECTPLANTYPECODEID = @PROSPECTPLANTYPECODEID,
            NARRATIVE = @NARRATIVE,
            NAME = @PROSPECTPLAN_NAME,
            PRIMARYMANAGERFUNDRAISERID = @PRIMARYMANAGERFUNDRAISERID,
            PRIMARYMANAGERSTARTDATE = @PRIMARYMANAGERDATEFROM,
            SECONDARYMANAGERFUNDRAISERID = @SECONDARYMANAGERFUNDRAISERID,
            SECONDARYMANAGERSTARTDATE = @SECONDARYMANAGERDATEFROM,
            PROSPECTPLAN_PARTICIPANTS = @PROSPECTPLAN_PARTICIPANTS,
            SECONDARYFUNDRAISERS = @SECONDARYFUNDRAISERS,
            SITES = @SITES
        where ID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;