USP_STEWARDSHIPPLANPARTICIPANT_ADD

This stored procedure handles adding a participant to a stewardship plan outside of the add dataform.

Parameters

Parameter	Parameter Type	Mode
@STEWARDSHIPPLANID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



CREATE procedure dbo.USP_STEWARDSHIPPLANPARTICIPANT_ADD(
    @STEWARDSHIPPLANID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHANGEDATE datetime = null
)
as begin
    set nocount on;

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

    if @CHANGEDATE is null
        set @CHANGEDATE = getdate();          

    begin try
        if not @CONSTITUENTID is null and not exists(select ID from dbo.STEWARDSHIPPLANPARTICIPANT where PLANID = @STEWARDSHIPPLANID and CONSTITUENTID = @CONSTITUENTID)
            insert into dbo.STEWARDSHIPPLANPARTICIPANT
                (ID, PLANID, CONSTITUENTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values
                (newID(), @STEWARDSHIPPLANID, @CONSTITUENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
    end try

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