USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_4

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_4 
(
    @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(20),
    @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,

  @SENDNOTIFICATIONS bit,
  @BNUMBER nvarchar(100),
  @VENDORID nvarchar(50)

)
as

    set nocount on;

  if @NUMPAYMENTS is null
    set @NUMPAYMENTS=0

  if (@GIFTTYPE = 'recurring_gift' and @INFINITEGIFT = 0) or (@GIFTTYPE = 'pledge' and @FREQUENCY <> 'single_payment')
  begin
    if @NUMPAYMENTS < 1
    begin
      raiserror('NUMBEROFPAYMENTSMINVALUE', 13, 1)
      return 1
    end
  end

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

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

    @ORGANIZATIONCONSTITUENTID = @ORGANIZATIONCONSTITUENTID,

    @CHANGEAGENTID = @CHANGEAGENTID,

    @SENDNOTIFICATIONS = @SENDNOTIFICATIONS,
    @VENDORID=@VENDORID

    -- exec dbo.USP_DONATIONBATCH_GETEMAILLIST_UPDATEFROMXML @ID, @SUBSCRIBEDNEWSLETTERIDS, @CHANGEAGENTID;

return 0