USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW

The save procedure used by the edit dataform template "BatchEventSponsorship Edit Data Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@EVENTID	uniqueidentifier	IN	Event
@SEQUENCE	int	IN	Sequence
@USERID	nvarchar(100)	IN	Username
@PASSWORD	nvarchar(510)	IN	Password
@LASTNAME	nvarchar(100)	IN	Last name
@FIRSTNAME	nvarchar(100)	IN	First name
@MIDDLENAME	nvarchar(100)	IN	Middle name
@TITLECODEID	uniqueidentifier	IN	Title
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@NICKNAME	nvarchar(100)	IN	Nickname
@MAIDENNAME	nvarchar(200)	IN	Maiden name
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@GENDERCODE	int	IN	Gender
@MARITALSTATUSCODEID	uniqueidentifier	IN	Marital status
@ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS	nvarchar(300)	IN	Address
@CITY	nvarchar(100)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(24)	IN	Postcode
@DONOTMAIL	bit	IN	Do not send mail to this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Do not mail reason
@PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONENUMBER	nvarchar(200)	IN	Phone number
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@SUBSCRIBEDNEWSLETTERIDS	xml	IN	eNewsletter
@MERCHANTACCOUNTID	uniqueidentifier	IN	Merchant Account ID
@ISCOMPANYSPONSOR	bit	IN	This is an organization sponsor
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	IN	Search existing organization constituents
@COMPANYNAME	nvarchar(200)	IN	Organization name
@COMPANYURL	UDT_WEBADDRESS	IN	Organization URL
@COMPANY_ADDRESSTYPECODEID	uniqueidentifier	IN	Organization address type
@COMPANY_COUNTRYID	uniqueidentifier	IN	Organization country
@COMPANY_ADDRESS	nvarchar(300)	IN	Organization address
@COMPANY_CITY	nvarchar(100)	IN	Organization city
@COMPANY_STATEID	uniqueidentifier	IN	Organization state
@COMPANY_POSTCODE	nvarchar(24)	IN	Organization postcode
@COMPANY_DONOTMAIL	bit	IN	Organization: Do not send mail to this address
@COMPANY_DONOTMAILREASONCODEID	uniqueidentifier	IN	Organization: Reason
@COMPANY_PHONETYPECODEID	uniqueidentifier	IN	Organization phone type
@COMPANY_PHONENUMBER	nvarchar(200)	IN	Organization phone number
@COMPANY_EMAILADDRESS	UDT_EMAILADDRESS	IN	Organization email address
@SPONSORSHIPTYPEID	uniqueidentifier	IN	Sponsorship options
@DECLINEBENEFITS	bit	IN	Waive benefits
@SPONSORSHIPURL	UDT_WEBADDRESS	IN	Sponsor URL
@SPONSORSHIPMESSAGE	nvarchar(2000)	IN	Sponsor message
@ADDITIONALDONATIONAMOUNT	money	IN	Additional donation amount
@PAYMENTMETHODCODE	nvarchar(20)	IN	Payment method
@CREDITCARDHOLDER	nvarchar(200)	IN	Card holder name
@CREDITCARDNUMBER	nvarchar(200)	IN	Credit card number
@CREDITCARDTYPE	uniqueidentifier	IN	Credit card type
@EXPIRATIONDATE	UDT_FUZZYDATE	IN	Credit card expiration
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit card token
@CREDITCARDID	uniqueidentifier	IN	Credit card ID
@AUTHORIZATIONCODE	nvarchar(20)	IN	Authorization code
@TRANSACTIONID	uniqueidentifier	IN	Transaction ID
@REJECTIONMESSAGE	nvarchar(250)	IN	Rejection message
@TYPECODE	tinyint	IN	Type code
@AMOUNT	money	IN	Amount
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@CHECKNUMBER	nvarchar(20)	IN	Check number
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@BANKACCOUNTTYPECODE	nvarchar(20)	IN	Bank account type
@BANKACCOUNTHOLDER	nvarchar(200)	IN	Bank account holder
@BANKACCOUNTNUMBER	nvarchar(200)	IN	Bank account number
@BANKACCOUNTROUTINGCODE	nvarchar(200)	IN	Bank account routing code
@SAMEASPRIMARYADDRESS	bit	IN	Billing address same as primary
@BILLING_ADDRESSTYPECODEID	uniqueidentifier	IN	Billing address type
@BILLING_COUNTRYID	uniqueidentifier	IN	Billing country
@BILLING_ADDRESSBLOCK	nvarchar(300)	IN	Billing address
@BILLING_CITY	nvarchar(50)	IN	Billing city
@BILLING_STATEID	uniqueidentifier	IN	Billing state
@BILLING_POSTCODE	nvarchar(24)	IN	Billing postcode
@BILLING_STATE	nvarchar(10)	IN	Billing state
@BILLING_COUNTRY	nvarchar(4)	IN	Billing country
@ORIGINALCLIENTUSERID	int	IN	Original client user id
@ORIGINALCONSTITUENTID	uniqueidentifier	IN	Search existing constituents
@PHONEID	uniqueidentifier	IN	Phone id
@ADDRESSID	uniqueidentifier	IN	Address id
@EMAILADDRESSID	uniqueidentifier	IN	Email address id
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW (
    @ID uniqueidentifier,
  @EVENTID uniqueidentifier,
  @SEQUENCE int,
  @USERID nvarchar(100),
  @PASSWORD nvarchar(510),
  @LASTNAME nvarchar(100),
  @FIRSTNAME nvarchar(100),
  @MIDDLENAME nvarchar(100),
  @TITLECODEID uniqueidentifier,
  @SUFFIXCODEID uniqueidentifier,
  @NICKNAME nvarchar(100),
  @MAIDENNAME nvarchar(200),
  @BIRTHDATE UDT_FUZZYDATE,
  @GENDERCODE int,
  @MARITALSTATUSCODEID uniqueidentifier,
  @ADDRESSTYPECODEID uniqueidentifier,
  @COUNTRYID uniqueidentifier,
  @ADDRESS nvarchar(300),
  @CITY nvarchar(100),
  @STATEID uniqueidentifier,
  @POSTCODE nvarchar(24),
  @DONOTMAIL bit,
  @DONOTMAILREASONCODEID uniqueidentifier,
  @PHONETYPECODEID uniqueidentifier,
  @PHONENUMBER nvarchar(200),
  @EMAILADDRESS UDT_EMAILADDRESS,

  @SUBSCRIBEDNEWSLETTERIDS xml,
  @MERCHANTACCOUNTID uniqueidentifier,

  @ISCOMPANYSPONSOR bit,
  @ORGANIZATIONCONSTITUENTID uniqueidentifier,
  @COMPANYNAME nvarchar(200),
  @COMPANYURL UDT_WEBADDRESS,
  @COMPANY_ADDRESSTYPECODEID uniqueidentifier,
  @COMPANY_COUNTRYID uniqueidentifier,
  @COMPANY_ADDRESS nvarchar(300),
  @COMPANY_CITY nvarchar(100),
  @COMPANY_STATEID uniqueidentifier,
  @COMPANY_POSTCODE nvarchar(24),
  @COMPANY_DONOTMAIL bit,
  @COMPANY_DONOTMAILREASONCODEID uniqueidentifier,
  @COMPANY_PHONETYPECODEID uniqueidentifier,
  @COMPANY_PHONENUMBER nvarchar(200),
  @COMPANY_EMAILADDRESS UDT_EMAILADDRESS,

  @SPONSORSHIPTYPEID uniqueidentifier,
  @DECLINEBENEFITS bit,
  @SPONSORSHIPURL UDT_WEBADDRESS,
  @SPONSORSHIPMESSAGE nvarchar(2000),

  @ADDITIONALDONATIONAMOUNT money,
  @PAYMENTMETHODCODE nvarchar(20),  
  @CREDITCARDHOLDER nvarchar(200),
  @CREDITCARDNUMBER nvarchar(200),
  @CREDITCARDTYPE uniqueidentifier,
  @EXPIRATIONDATE UDT_FUZZYDATE,
  @CREDITCARDTOKEN uniqueidentifier,
  @CREDITCARDID uniqueidentifier,
  @AUTHORIZATIONCODE nvarchar(20),
  @TRANSACTIONID uniqueidentifier,
  @REJECTIONMESSAGE nvarchar(250),
  @TYPECODE tinyint,
  @AMOUNT money,
  @CONSTITUENTID uniqueidentifier,

  @CHECKNUMBER nvarchar(20),
  @CHECKDATE UDT_FUZZYDATE,
  @BANKACCOUNTTYPECODE nvarchar(20),
  @BANKACCOUNTHOLDER nvarchar(200),
  @BANKACCOUNTNUMBER nvarchar(200),
  @BANKACCOUNTROUTINGCODE nvarchar(200),

  @SAMEASPRIMARYADDRESS bit,
  @BILLING_ADDRESSTYPECODEID uniqueidentifier,
  @BILLING_COUNTRYID uniqueidentifier,
  @BILLING_ADDRESSBLOCK nvarchar(300),
  @BILLING_CITY nvarchar(50),
  @BILLING_STATEID uniqueidentifier,
  @BILLING_POSTCODE nvarchar(24),
  @BILLING_STATE nvarchar(10),
  @BILLING_COUNTRY nvarchar(4),

  @ORIGINALCLIENTUSERID integer,
  @ORIGINALCONSTITUENTID uniqueidentifier,
  @PHONEID uniqueidentifier,
  @ADDRESSID uniqueidentifier,
  @EMAILADDRESSID uniqueidentifier,

  @CHANGEAGENTID uniqueidentifier
)
as
begin
  set nocount on;

  declare @SENDNOTIFICATIONS bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEVENTSPONSORSHIPROW
        @ID = @ID,
        @SENDNOTIFICATIONS = @SENDNOTIFICATIONS output

exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_2
  @ID,
  @EVENTID,
  @SEQUENCE,
  @USERID,
  @PASSWORD,
  @LASTNAME,
  @FIRSTNAME,
  @MIDDLENAME,
  @TITLECODEID,
  @SUFFIXCODEID,
  @NICKNAME,
  @MAIDENNAME,
  @BIRTHDATE,
  @GENDERCODE,
  @MARITALSTATUSCODEID,
  @ADDRESSTYPECODEID,
  @COUNTRYID,
  @ADDRESS,
  @CITY,
  @STATEID,
  @POSTCODE,
  @DONOTMAIL,
  @DONOTMAILREASONCODEID,
  @PHONETYPECODEID,
  @PHONENUMBER,
  @EMAILADDRESS,

  @SUBSCRIBEDNEWSLETTERIDS,
  @MERCHANTACCOUNTID,

  @ISCOMPANYSPONSOR,
  @ORGANIZATIONCONSTITUENTID,
  @COMPANYNAME,
  @COMPANYURL,
  @COMPANY_ADDRESSTYPECODEID,
  @COMPANY_COUNTRYID,
  @COMPANY_ADDRESS,
  @COMPANY_CITY,
  @COMPANY_STATEID,
  @COMPANY_POSTCODE,
  @COMPANY_DONOTMAIL,
  @COMPANY_DONOTMAILREASONCODEID,
  @COMPANY_PHONETYPECODEID,
  @COMPANY_PHONENUMBER,
  @COMPANY_EMAILADDRESS,

  @SPONSORSHIPTYPEID,
  @DECLINEBENEFITS,
  @SPONSORSHIPURL,
  @SPONSORSHIPMESSAGE,

  @ADDITIONALDONATIONAMOUNT,
  @PAYMENTMETHODCODE,  
  @CREDITCARDHOLDER,
  @CREDITCARDNUMBER,
  @CREDITCARDTYPE,
  @EXPIRATIONDATE,
  @CREDITCARDTOKEN,
  @CREDITCARDID,
  @AUTHORIZATIONCODE,
  @TRANSACTIONID,
  @REJECTIONMESSAGE,
  @TYPECODE,
  @AMOUNT,
  @CONSTITUENTID,

  @CHECKNUMBER,
  @CHECKDATE,
  @BANKACCOUNTTYPECODE,
  @BANKACCOUNTHOLDER,
  @BANKACCOUNTNUMBER,
  @BANKACCOUNTROUTINGCODE,

  @SAMEASPRIMARYADDRESS,
  @BILLING_ADDRESSTYPECODEID,
  @BILLING_COUNTRYID,
  @BILLING_ADDRESSBLOCK,
  @BILLING_CITY,
  @BILLING_STATEID,
  @BILLING_POSTCODE,
  @BILLING_STATE,
  @BILLING_COUNTRY,

  @ORIGINALCLIENTUSERID,
  @ORIGINALCONSTITUENTID,
  @PHONEID,
  @ADDRESSID,
  @EMAILADDRESSID,

  @CHANGEAGENTID,

  @SENDNOTIFICATIONS
end