USP_DATAFORMTEMPLATE_ADD_TRANSACTIONTOGROUP_PRELOAD

The load procedure used by the edit dataform template "Add a Transaction to a Group Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@CHARGEDATE	date	INOUT	Charge date
@DUEDATE	date	INOUT	Due date
@POSTDATE	date	INOUT	Post date
@SCHOOLS	xml	INOUT	Add charges for

Definition

Copy



    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_TRANSACTIONTOGROUP_PRELOAD
    (
        @RECORDTYPEID uniqueidentifier = null output,
        @CHARGEDATE date = null output,
        @DUEDATE date = null output,
        @POSTDATE date = null output,
        @SCHOOLS xml = null output
    )
    as
    set nocount on;

    select @RECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'STUDENT'

    set @CHARGEDATE = getdate()
    set @DUEDATE = dbo.UFN_CHARGE_GETDEFAULTDUEDATE(@CHARGEDATE)
    set @POSTDATE=@CHARGEDATE

    set @SCHOOLS = (
        select newID() as ID,
            CONSTITUENT.KEYNAME as NAME,
            SCHOOL.ID as SCHOOLID
        from dbo.SCHOOL
            inner join dbo.CONSTITUENT
                on SCHOOL.ID = CONSTITUENT.ID
        order by NAME
        for xml raw('ITEM'),type,elements,root('SCHOOLS'),BINARY BASE64
    )

    return 0;