USP_DATAFORMTEMPLATE_ADD_ASSIGNVOLUNTEER_MULTIPLEDAYS_PRELOAD

The load procedure used by the edit dataform template "Volunteer Assign Job Multiple Days Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ADD_MULTIPLE_ACTION	nvarchar(73)	IN	Input parameter indicating the context ID for the record being added.
@VOLUNTEERID	uniqueidentifier	INOUT
@VOLUNTEER_OCCURRENCEID	nvarchar(73)	INOUT
@JOBOCCURRENCEID	uniqueidentifier	INOUT
@VOLUNTEERNAME	nvarchar(700)	INOUT	For
@OCCURRENCENAME	nvarchar(50)	INOUT	Occurrence
@STARTTIME	UDT_HOURMINUTE	INOUT
@ENDTIME	UDT_HOURMINUTE	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ASSIGNVOLUNTEER_MULTIPLEDAYS_PRELOAD
(
    @ADD_MULTIPLE_ACTION nvarchar(73), 
    @VOLUNTEERID uniqueidentifier = null output,
    @VOLUNTEER_OCCURRENCEID nvarchar(73) = null output,
    @JOBOCCURRENCEID uniqueidentifier = null output,
    @VOLUNTEERNAME nvarchar(700) = null output,
    @OCCURRENCENAME nvarchar(50) = null output,
    @STARTTIME dbo.UDT_HOURMINUTE = null output,
    @ENDTIME dbo.UDT_HOURMINUTE = null output
)
 as
    set nocount on;

    set @VOLUNTEER_OCCURRENCEID = @ADD_MULTIPLE_ACTION;
    set @VOLUNTEERID = cast(left(@ADD_MULTIPLE_ACTION, 36) as uniqueidentifier);
    set @JOBOCCURRENCEID = cast(substring(@ADD_MULTIPLE_ACTION, 37, 36) as uniqueidentifier);

    select
        @VOLUNTEERNAME = NF.NAME
    from dbo.UFN_CONSTITUENT_DISPLAYNAME(@VOLUNTEERID) NF;

    select 
        @OCCURRENCENAME = JOBOCCURRENCE.DESCRIPTION,
        @STARTTIME = JOBOCCURRENCE.STARTTIME,
        @ENDTIME = JOBOCCURRENCE.ENDTIME
    from dbo.JOBOCCURRENCE
    where JOBOCCURRENCE.ID = @JOBOCCURRENCEID;

    return 0;