USP_DATAFORMTEMPLATE_VIEW_VOLUNTEERPROFILE_CALENDAR

The load procedure used by the view dataform template "Volunteer Profile Calendar 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.
@PHONENUMBER	nvarchar(100)	INOUT	Phone
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email
@DONOTEMAIL	bit	INOUT	DONOTEMAIL
@DONOTPHONE	bit	INOUT	DONOTPHONE
@PHONEISCONFIDENTIAL	bit	INOUT	PHONEISCONFIDENTIAL

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_VOLUNTEERPROFILE_CALENDAR
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PHONENUMBER nvarchar(100) = null output,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @DONOTEMAIL bit = null output,
    @DONOTPHONE bit = null output,
    @PHONEISCONFIDENTIAL bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @PHONENUMBER = dbo.UFN_PHONE_GETINTERNATIONALNUMBER(PHONE.COUNTRYID, PHONE.NUMBER),
        @EMAILADDRESS = EMAILADDRESS.EMAILADDRESS,       
        @DONOTPHONE = PHONE.DONOTCALL,
        @PHONEISCONFIDENTIAL = PHONE.ISCONFIDENTIAL,
        @DONOTEMAIL = EMAILADDRESS.DONOTEMAIL
    from dbo.CONSTITUENT
    left join dbo.PHONE
        on PHONE.CONSTITUENTID = CONSTITUENT.ID and
        PHONE.ISPRIMARY = 1
    left join dbo.EMAILADDRESS
        on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID and
        EMAILADDRESS.ISPRIMARY = 1
    where CONSTITUENT.ID = @ID;

    return 0;