USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPAPPEAL

The load procedure used by the view dataform template "Membership Appeal 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.
@DATESENT	datetime	INOUT	Date sent
@APPEAL	nvarchar(100)	INOUT	Appeal
@DESCRIPTION	nvarchar(255)	INOUT	Description
@COMMENTS	nvarchar(50)	INOUT	Comment
@RESPONSES	xml	INOUT	Responses

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPAPPEAL(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @DATESENT datetime = null output,
    @APPEAL nvarchar(100) = null output,
    @DESCRIPTION nvarchar(255) = null output,
    @COMMENTS nvarchar(50) = null output,
    @RESPONSES xml = null output
) as begin

    set nocount on;

    set @DATALOADED = 0;

    declare @MEMBERSHIPPROGRAMID uniqueidentifier;
    declare @CONSTITUENTID uniqueidentifier;

    select 
        @MEMBERSHIPPROGRAMID=MEMBERSHIP.MEMBERSHIPPROGRAMID,
        @CONSTITUENTID=MEMBER.CONSTITUENTID
    from 
        dbo.MEMBERSHIP
    left join 
        dbo.MEMBER on MEMBER.MEMBERSHIPID=MEMBERSHIP.ID
    where 
        MEMBER.ID = @ID;

    select
        @DATALOADED = 1,
        @DATESENT = CONSTITUENTAPPEAL.DATESENT,
        @APPEAL = APPEAL.NAME,
        @DESCRIPTION = APPEAL.DESCRIPTION,
        @COMMENTS = CONSTITUENTAPPEAL.COMMENTS,
        @RESPONSES = dbo.UFN_CONSTITUENTAPPEAL_GETRESPONSES_TOITEMLISTXML(@ID)
    from 
        dbo.CONSTITUENTAPPEAL
    inner join 
        dbo.APPEAL on APPEAL.ID = CONSTITUENTAPPEAL.APPEALID
    where
        APPEAL.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID
    and 
        CONSTITUENTAPPEAL.CONSTITUENTID = @CONSTITUENTID;

    return 0

end