USP_DATAFORMTEMPLATE_ADD_PRELOAD_EVENTEXPENSE

The load procedure used by the edit dataform template "Event Expense Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SELECTEDEVENTID	uniqueidentifier	INOUT	Event
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_EVENTEXPENSE
(
    @EVENTID uniqueidentifier,
    @SELECTEDEVENTID uniqueidentifier = null output,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @BASECURRENCYID uniqueidentifier = null output
)
as

    set @SELECTEDEVENTID = @EVENTID;

    select 
        @BASECURRENCYID = EVENT.BASECURRENCYID 
    from dbo.EVENT
    where EVENT.ID = @EVENTID;

    if @BASECURRENCYID is null
        set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);

    return 0;