USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@EVENTID	uniqueidentifier	IN	Event
@CONSTITUENTID	uniqueidentifier	IN	Registrant
@DATEPURCHASED	datetime	IN	Date
@EVENTPRICEID	uniqueidentifier	IN	Registration option
@REGISTRANTSTATUSCODE	tinyint	IN	Status
@WAIVEBENEFITS	bit	IN	Waive benefits
@QUANTITY	int	IN	Quantity
@GUESTS	xml	IN	Guests
@REGISTRANTLOOKUPID	nvarchar(100)	IN	Registrant ID
@DESIGNATIONID	uniqueidentifier	IN	Designation

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @EVENTID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @DATEPURCHASED datetime,
    @EVENTPRICEID uniqueidentifier,
    @REGISTRANTSTATUSCODE tinyint,
    @WAIVEBENEFITS bit,
    @QUANTITY int,
    @GUESTS xml,
  @REGISTRANTLOOKUPID nvarchar(100),
  @DESIGNATIONID uniqueidentifier
)
as
set nocount on;

declare @REGISTRATIONTYPECODE tinyint,
          @REGISTRATIONSTATUSCODE tinyint,
          @REGISTRATIONATTENDEDCODE tinyint;

exec USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEVENTREGISTRANTBATCHROW
  @ID = @ID,
  @REGISTRATIONTYPECODE = @REGISTRATIONTYPECODE output,
  @REGISTRATIONSTATUSCODE = @REGISTRATIONSTATUSCODE output,
  @REGISTRATIONATTENDEDCODE = @REGISTRATIONATTENDEDCODE output;

exec USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_2
    @ID,
    @CHANGEAGENTID,
    @SEQUENCE,
    @EVENTID,
    @CONSTITUENTID,
    @DATEPURCHASED,
    @EVENTPRICEID,
    @REGISTRANTSTATUSCODE,
    @WAIVEBENEFITS,
    @QUANTITY,
    @GUESTS,
  @REGISTRANTLOOKUPID,
  @DESIGNATIONID,
  @REGISTRATIONTYPECODE,
    @REGISTRATIONSTATUSCODE,
    @REGISTRATIONATTENDEDCODE;

return 0;