USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGEPAGEEXPRESSION

The load procedure used by the view dataform template "Donor Challenge Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	NAME
@ALLOWSMEMBERSHIPS	bit	INOUT	ALLOWSMEMBERSHIPS
@STATUSTYPECODE	int	INOUT	STATUSTYPECODE
@LUMPSUMMATCHREVENUEID	uniqueidentifier	INOUT	LUMPSUMMATCHREVENUEID
@HASLUMPSUMMATCHREVENUE	bit	INOUT	HASLUMPSUMMATCHREVENUE
@TYPECODE	int	INOUT	TYPECODE
@HASENCUMBEREDFUNDS	bit	INOUT	HASENCUMBEREDFUNDS

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DONORCHALLENGEPAGEEXPRESSION
    (
        @ID uniqueidentifier,
        @DATALOADED bit = 0 output,
        @NAME nvarchar(100) = null output,
        @ALLOWSMEMBERSHIPS bit = null output,
        @STATUSTYPECODE int = null output,
        @LUMPSUMMATCHREVENUEID uniqueidentifier = null output,
        @HASLUMPSUMMATCHREVENUE bit = null output,
        @TYPECODE int = null output,
        @HASENCUMBEREDFUNDS bit = null output
    )
as
begin
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @NAME = NAME,
        @STATUSTYPECODE = STATUSTYPECODE,
        @LUMPSUMMATCHREVENUEID = LUMPSUMMATCHREVENUEID,
        @HASLUMPSUMMATCHREVENUE = case when LUMPSUMMATCHREVENUEID is null then 0 else 1 end,
        @TYPECODE = TYPECODE,
        @HASENCUMBEREDFUNDS = case when exists (select 1 from dbo.DONORCHALLENGEENCUMBERED where DONORCHALLENGEID = @ID) then 1 else 0 end
    from 
        dbo.DONORCHALLENGE
    where
        DONORCHALLENGE.ID = @ID

    set @ALLOWSMEMBERSHIPS = case 
        when exists(select ID from dbo.DONORCHALLENGEEXCLUDEDAPPLICATIONTYPE where APPLICATIONCODE = 5 and DONORCHALLENGEID = @ID) then 0
        else 1 end;

    return 0;
end