USP_DATAFORMTEMPLATE_ADD_PROSPECTPLANREQUEST_PRELOAD

The load procedure used by the edit dataform template "Prospect Plan Request Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PROSPECT	nvarchar(700)	INOUT	Prospect
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required
@SITES	xml	INOUT	Sites
@PRIMARYMANAGERFUNDRAISERID	uniqueidentifier	INOUT	Primary manager

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROSPECTPLANREQUEST_PRELOAD
  (
        @PROSPECTID uniqueidentifier,
        @PROSPECT nvarchar(700) = null output,
        @CURRENTAPPUSERID uniqueidentifier,
        @SITEREQUIRED bit = null output,
        @SITES xml = null output,
    @PRIMARYMANAGERFUNDRAISERID uniqueidentifier = null output
    ) as
        set nocount on;

        select @PROSPECT = NAME
        from dbo.UFN_CONSTITUENT_DISPLAYNAME(@PROSPECTID);

        declare @CURRENTDATE datetime = getdate();
    declare @CURRENTDATEEARLIESTTIME datetime = dbo.UFN_DATE_GETEARLIESTTIME(@CURRENTDATE);

        set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)

        declare @USERSITEID uniqueidentifier = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
        if @USERSITEID is not null
        begin
            set @SITES = (
                select newid() ID, @USERSITEID SITEID
                for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
            )
        end

    select @PRIMARYMANAGERFUNDRAISERID = CONSTITUENT.ID
    from dbo.APPUSER
    inner join dbo.CONSTITUENT on APPUSER.CONSTITUENTID = CONSTITUENT.ID
    inner join dbo.FUNDRAISERDATERANGE on CONSTITUENT.ID = FUNDRAISERDATERANGE.CONSTITUENTID
    where APPUSER.ID = @CURRENTAPPUSERID
    and (FUNDRAISERDATERANGE.DATEFROM <= @CURRENTDATEEARLIESTTIME or FUNDRAISERDATERANGE.DATEFROM is null) 
    and (@CURRENTDATEEARLIESTTIME <= FUNDRAISERDATERANGE.DATETO or FUNDRAISERDATERANGE.DATETO is null)

        return 0;