USP_STEWARDSHIPPLANSTEWARD_ADD

This stored procedure handles adding a steward 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
@STARTDATE	date	IN
@ENDDATE	date	IN

Definition

Copy



CREATE procedure dbo.USP_STEWARDSHIPPLANSTEWARD_ADD(
    @STEWARDSHIPPLANID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHANGEDATE datetime = null,
    @STARTDATE date = null,
    @ENDDATE date = 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.STEWARDSHIPPLANSTEWARD where PLANID = @STEWARDSHIPPLANID and CONSTITUENTID = @CONSTITUENTID)
            insert into dbo.STEWARDSHIPPLANSTEWARD
                (ID, PLANID, CONSTITUENTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, STARTDATE, ENDDATE)
            values
                (newID(), @STEWARDSHIPPLANID, @CONSTITUENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE, @STARTDATE, @ENDDATE)
    end try

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