USP_DATAFORMTEMPLATE_EDITLOAD_ORDERDELIVERYMETHOD

The load procedure used by the edit dataform template "Order Delivery Method Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@ORDERID	uniqueidentifier	INOUT
@FEES	xml	INOUT
@DELIVERYMETHODID	uniqueidentifier	INOUT	Method
@RECIPIENTID	uniqueidentifier	INOUT	Recipient
@ADDRESSID	uniqueidentifier	INOUT	Address
@PHONEID	uniqueidentifier	INOUT	Phone number
@EMAILADDRESSID	uniqueidentifier	INOUT	Email address
@SAMEASPATRON	bit	INOUT	Use patron primary information
@CONSTITUENTSELECTED	bit	INOUT	Constituent Selected
@CONSTITUENTID	uniqueidentifier	INOUT
@CONSTITUENTNAME	nvarchar(154)	INOUT
@CONSTITUENTADDRESSID	uniqueidentifier	INOUT
@CONSTITUENTPHONEID	uniqueidentifier	INOUT
@CONSTITUENTEMAILID	uniqueidentifier	INOUT
@DELIVERYREQUIREDFIELDS	xml	INOUT
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.

Definition

Copy



              CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ORDERDELIVERYMETHOD
              (
                @ID uniqueidentifier,
                @ORDERID uniqueidentifier = null output,
                @FEES xml = null output,
                @DELIVERYMETHODID uniqueidentifier = null output,
                @RECIPIENTID uniqueidentifier = null output,
                @ADDRESSID uniqueidentifier = null output,
                @PHONEID uniqueidentifier = null output,
                @EMAILADDRESSID uniqueidentifier = null output,
                @SAMEASPATRON bit = null output,
                @CONSTITUENTSELECTED bit = null output,
                @CONSTITUENTID uniqueidentifier = null output,
                @CONSTITUENTNAME nvarchar(154) = null output,
                @CONSTITUENTADDRESSID uniqueidentifier = null output,
                @CONSTITUENTPHONEID uniqueidentifier = null output,
                @CONSTITUENTEMAILID uniqueidentifier = null output,
                @DELIVERYREQUIREDFIELDS xml = null output,
                @TSLONG bigint = 0 output,
                @DATALOADED bit = 0 output
              )
              as

              set nocount on;
              set @DATALOADED = 0;
              set @TSLONG = 0;

              select
                @ORDERID = S.ID,
                @FEES = dbo.UFN_ORDERDELIVERYMETHOD_GETFEESBYSALESMETHOD_TOITEMLISTXML(S.SALESMETHODTYPECODE),
                @DELIVERYREQUIREDFIELDS = dbo.UFN_ORDERDELIVERYMETHOD_GETREQUIREDFIELDS_TOITEMLISTXML(),
                @DELIVERYMETHODID = S.DELIVERYMETHODID,
                @RECIPIENTID = S.RECIPIENTID,
                @ADDRESSID = S.ADDRESSID,
                @PHONEID = S.PHONEID,
                @EMAILADDRESSID = S.EMAILADDRESSID,
                @SAMEASPATRON = S.SAMEASPATRON,
                @CONSTITUENTID = S.CONSTITUENTID,
                @TSLONG = S.TSLONG,
                @DATALOADED = 1
            from dbo.SALESORDER S
            where S.ID = @ID;

        if @CONSTITUENTID is not null
          begin
          select 
            @CONSTITUENTNAME = coalesce(dbo.UFN_CONSTITUENT_BUILDNAME(@CONSTITUENTID), C.NAME),
            @CONSTITUENTSELECTED = 1,
            @CONSTITUENTPHONEID = P.ID,
            @CONSTITUENTEMAILID = E.ID,
            @CONSTITUENTADDRESSID = A.ID
          from dbo.CONSTITUENT as C 
          left outer join dbo.PHONE as P on P.CONSTITUENTID = C.ID
          left outer join dbo.EMAILADDRESS as E on E.CONSTITUENTID = C.ID
          left outer join dbo.ADDRESS as A on A.CONSTITUENTID = C.ID
          where C.ID = @CONSTITUENTID and (P.ID is null or P.ISPRIMARY = 1) and (E.ID is null or E.ISPRIMARY = 1) and (A.ID is null or A.ISPRIMARY = 1)
          end

              return 0