USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW

The save procedure used by the edit dataform template "Donation Batch 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.
@SEQUENCE	int	IN	Sequence
@EVENTID	uniqueidentifier	IN	Event
@USERID	nvarchar(100)	IN	Username
@PASSWORD	nvarchar(500)	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	Nick name
@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/Province
@POSTCODE	nvarchar(24)	IN	Postcode
@DONOTMAIL	bit	IN	Do not send mail to this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONENUMBER	nvarchar(200)	IN	Phone number
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@ISCOMPANYGIFT	bit	IN	This is an organization donation
@COMPANYNAME	nvarchar(200)	IN	Organization name
@COMPANYURL	UDT_WEBADDRESS	IN	Organization website
@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
@GIFTTYPE	nvarchar(100)	IN	Gift type
@GIFTAMOUNT	money	IN	Gift amount
@NUMPAYMENTS	int	IN	Number of payments
@FREQUENCY	nvarchar(200)	IN	Frequency
@AUTOINSTALLMENTS	bit	IN	Automatic installments
@ANONYMOUS	bit	IN	Gift is anonymous
@STARTDATE	UDT_FUZZYDATE	IN	Start date
@INFINITEGIFT	bit	IN	Gift is infinite
@PAYMENTMETHODCODE	int	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	Expiration on date
@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
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@CHECKNUMBER	nvarchar(40)	IN	Check number
@BANKACCOUNTTYPECODE	int	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(100)	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
@SAVETRIBUTEEASCONSTITUENT	bit	IN	Save tributee as constituent
@SHOWTRIBUTE	bit	IN	I would like to make a donation to honor
@TRIBUTEFIRSTNAME	nvarchar(400)	IN	Tributee first name
@TRIBUTELASTNAME	nvarchar(400)	IN	Tributee last name
@TRIBUTEEMAIL	UDT_EMAILADDRESS	IN	Tributee email address
@TRIBUTEADDRESS	nvarchar(600)	IN	Tributee address
@TRIBUTECITY	nvarchar(200)	IN	Tributee city
@TRIBUTEPOSTCODE	nvarchar(48)	IN	Tributee postcode
@TRIBUTESTATEID	uniqueidentifier	IN	Tributee state
@TRIBUTETYPECODEID	uniqueidentifier	IN	Tribute type
@TRIBUTETEXT	nvarchar(500)	IN	Tribute message
@TRIBUTEANONYMOUS	bit	IN	Do not display tribute information
@ACKNOWLEDGEFIRSTNAME	nvarchar(400)	IN	Acknowledgee first name
@ACKNOWLEDGELASTNAME	nvarchar(400)	IN	Acknowledgee last name
@ACKNOWLEDGEEMAIL	UDT_EMAILADDRESS	IN	Acknowledgee email address
@MESSAGETOACKNOWLEDGE	nvarchar(2000)	IN	Message about my donation
@RECOGNITIONCREDIT	nvarchar(100)	IN	Recognition credit
@MATCHINGCOMPANYNAME	nvarchar(400)	IN	Matching gift company name
@MATCHINGAMOUNT	money	IN	Matching Amount
@RECIPIENTGROUPID	uniqueidentifier	IN	Recognition group
@RECIPIENTREGISTRANTID	uniqueidentifier	IN	Recognition individual
@RECIPIENTROLE	nvarchar(200)	IN	Recognition credit
@SENDTOACKNOWLEDGE	bit	IN	Send email to acknowledgee
@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
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	IN	Search existing organization constituents
@MERCHANTACCOUNTID	uniqueidentifier	IN	Merchant account ID
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SUBSCRIBEDNEWSLETTERIDS	xml	IN	eNewsletter

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW (
    @ID uniqueidentifier,
    @SEQUENCE int,
    @EVENTID uniqueidentifier,
    @USERID nvarchar(100),
    @PASSWORD nvarchar(500),
    @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,
    @ISCOMPANYGIFT bit,
    @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,
    @GIFTTYPE nvarchar(100),
    @GIFTAMOUNT money,
    @NUMPAYMENTS int,
    @FREQUENCY nvarchar(200),
    @AUTOINSTALLMENTS bit,
    @ANONYMOUS bit,
    @STARTDATE UDT_FUZZYDATE,
    @INFINITEGIFT bit,
    @PAYMENTMETHODCODE int,
    @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,
  @CHECKDATE UDT_FUZZYDATE,
  @CHECKNUMBER nvarchar(40),
    @BANKACCOUNTTYPECODE int,
    @BANKACCOUNTHOLDER nvarchar(200),
    @BANKACCOUNTNUMBER nvarchar(200),
    @BANKACCOUNTROUTINGCODE nvarchar(200),
    @SAMEASPRIMARYADDRESS bit,
    @BILLING_ADDRESSTYPECODEID uniqueidentifier,
    @BILLING_COUNTRYID uniqueidentifier,
    @BILLING_ADDRESSBLOCK nvarchar(300),
    @BILLING_CITY nvarchar(100),
    @BILLING_STATEID uniqueidentifier,
    @BILLING_POSTCODE nvarchar(24),
  @BILLING_STATE nvarchar(10),
  @BILLING_COUNTRY nvarchar(4),
  @SAVETRIBUTEEASCONSTITUENT bit,
    @SHOWTRIBUTE bit,
    @TRIBUTEFIRSTNAME nvarchar(400),
    @TRIBUTELASTNAME nvarchar(400),
    @TRIBUTEEMAIL UDT_EMAILADDRESS,
    @TRIBUTEADDRESS nvarchar(600),
    @TRIBUTECITY nvarchar(200),
    @TRIBUTEPOSTCODE nvarchar(48),
    @TRIBUTESTATEID uniqueidentifier,
    @TRIBUTETYPECODEID uniqueidentifier,
    @TRIBUTETEXT nvarchar(500),
    @TRIBUTEANONYMOUS bit,
    @ACKNOWLEDGEFIRSTNAME nvarchar(400),
    @ACKNOWLEDGELASTNAME nvarchar(400),
    @ACKNOWLEDGEEMAIL UDT_EMAILADDRESS,
    @MESSAGETOACKNOWLEDGE nvarchar(2000),
    @RECOGNITIONCREDIT nvarchar(100),
    @MATCHINGCOMPANYNAME nvarchar(400),
    @MATCHINGAMOUNT money,
    @RECIPIENTGROUPID uniqueidentifier,
  @RECIPIENTREGISTRANTID uniqueidentifier,
    @RECIPIENTROLE nvarchar(200),
    @SENDTOACKNOWLEDGE bit,

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

  @ORGANIZATIONCONSTITUENTID uniqueidentifier,

  @MERCHANTACCOUNTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = NULL,

  @SUBSCRIBEDNEWSLETTERIDS xml

)
as
begin
  set nocount on;

  declare @SENDNOTIFICATIONS bit;

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

exec dbo.USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_2
  @ID,
    @SEQUENCE,
    @EVENTID,
    @USERID,
    @PASSWORD,
    @LASTNAME,
    @FIRSTNAME,
    @MIDDLENAME,
    @TITLECODEID,
    @SUFFIXCODEID,
    @NICKNAME,
    @MAIDENNAME,
    @BIRTHDATE,
    @GENDERCODE,
    @MARITALSTATUSCODEID,
    @ADDRESSTYPECODEID,
    @COUNTRYID,
    @ADDRESS,
    @CITY,
    @STATEID,
    @POSTCODE,
    @DONOTMAIL,
    @DONOTMAILREASONCODEID,
    @PHONETYPECODEID,
    @PHONENUMBER,
    @EMAILADDRESS,
    @ISCOMPANYGIFT,
    @COMPANYNAME,
    @COMPANYURL,
    @COMPANY_ADDRESSTYPECODEID,
    @COMPANY_COUNTRYID,
    @COMPANY_ADDRESS,
    @COMPANY_CITY,
    @COMPANY_STATEID,
    @COMPANY_POSTCODE,
    @COMPANY_DONOTMAIL,
    @COMPANY_DONOTMAILREASONCODEID,
    @COMPANY_PHONETYPECODEID,
    @COMPANY_PHONENUMBER,
    @COMPANY_EMAILADDRESS,
    @GIFTTYPE,
    @GIFTAMOUNT,
    @NUMPAYMENTS,
    @FREQUENCY,
    @AUTOINSTALLMENTS,
    @ANONYMOUS,
    @STARTDATE,
    @INFINITEGIFT,
    @PAYMENTMETHODCODE,
    @CREDITCARDHOLDER,
    @CREDITCARDNUMBER,
    @CREDITCARDTYPE,
    @EXPIRATIONDATE,
  @CREDITCARDTOKEN,
  @CREDITCARDID,
  @AUTHORIZATIONCODE,
  @TRANSACTIONID,
  @REJECTIONMESSAGE,
  @TYPECODE,
  @AMOUNT,
  @CONSTITUENTID,
  @CHECKDATE,
  @CHECKNUMBER,
    @BANKACCOUNTTYPECODE,
    @BANKACCOUNTHOLDER,
    @BANKACCOUNTNUMBER,
    @BANKACCOUNTROUTINGCODE,
    @SAMEASPRIMARYADDRESS,
    @BILLING_ADDRESSTYPECODEID,
    @BILLING_COUNTRYID,
    @BILLING_ADDRESSBLOCK,
    @BILLING_CITY,
    @BILLING_STATEID,
    @BILLING_POSTCODE,
  @BILLING_STATE,
  @BILLING_COUNTRY,
  @SAVETRIBUTEEASCONSTITUENT ,
    @SHOWTRIBUTE ,
    @TRIBUTEFIRSTNAME,
    @TRIBUTELASTNAME,
    @TRIBUTEEMAIL,
    @TRIBUTEADDRESS,
    @TRIBUTECITY,
    @TRIBUTEPOSTCODE,
    @TRIBUTESTATEID,
    @TRIBUTETYPECODEID,
    @TRIBUTETEXT,
    @TRIBUTEANONYMOUS,
    @ACKNOWLEDGEFIRSTNAME,
    @ACKNOWLEDGELASTNAME,
    @ACKNOWLEDGEEMAIL,
    @MESSAGETOACKNOWLEDGE,
    @RECOGNITIONCREDIT,
    @MATCHINGCOMPANYNAME,
    @MATCHINGAMOUNT,
    @RECIPIENTGROUPID,
  @RECIPIENTREGISTRANTID,
    @RECIPIENTROLE,
    @SENDTOACKNOWLEDGE,

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

  @ORGANIZATIONCONSTITUENTID,

  @MERCHANTACCOUNTID,
  @CHANGEAGENTID,

  @SUBSCRIBEDNEWSLETTERIDS,

  @SENDNOTIFICATIONS
end