spAddUpdate_ClientDonations

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientsID	int	IN
@Guid	uniqueidentifier	IN
@ConstitCodeID	int	IN
@EmailTemplateID	int	IN
@DonationOptions	int	IN
@TributeOptions	ntext	IN
@RedirectPageID	int	IN
@ContentID	int	IN
@MerchantAccount	int	IN
@NoMGPledges	bit	IN
@Attributes	ntext	IN
@DonateBtn	nvarchar(100)	IN
@RecurrenceOptions	ntext	IN
@RecurrenceOptionsTruePledge	ntext	IN
@ShoppingCartPageID	int	IN
@EReceiptPdfForCreditCard	bit	IN
@EReceiptPdfForDirectDebit	bit	IN
@MarkReceiptedForCreditCard	bit	IN
@MarkReceiptedForDirectDebit	bit	IN
@EReceiptContent	ntext	IN
@EReceiptPdfMargin	int	IN
@CartMessage	ntext	IN
@ECardPartID	int	IN
@ECardSendDateAttributeID	int	IN
@ECardRecipientFirstNameAttributeID	int	IN
@ECardRecipientLastNameAttributeID	int	IN
@CartSendDonationAcknowledgementAlways	bit	IN
@MinimumGiftAmount	numeric(30, 6)	IN
@MinimumPledgePaymentAmount	numeric(30, 6)	IN
@ShowPledgePaymentDueDate	bit	IN
@AcknowledgementBlock	nvarchar(max)	IN
@AllowSpouseInfo	bit	IN
@IncludeChallengeMatch	bit	IN
@ChallengeMatchIntro	nvarchar(max)	IN
@Challengematch	nvarchar(max)	IN
@ImpactStatementTypeID	uniqueidentifier	IN
@AppealHistoryQueryID	int	IN
@WelcomeEmailTemplateID	int	IN

Definition

Copy



  CREATE procedure dbo.spAddUpdate_ClientDonations 
  (
  @PKID int output,
  @CurrentUsersID int,
  @ClientsID      int,
  @Guid uniqueidentifier,
  @ConstitCodeID   int,
  @EmailTemplateID int,
  @DonationOptions int,
  @TributeOptions ntext,
  @RedirectPageID  int,
  @ContentID       int,
  @MerchantAccount int,
  @NoMGPledges     bit,
  @Attributes ntext,
  @DonateBtn nvarchar(100),
  @RecurrenceOptions ntext,
  @RecurrenceOptionsTruePledge ntext,
  @ShoppingCartPageID          int,
  @EReceiptPdfForCreditCard    bit,
  @EReceiptPdfForDirectDebit   bit,
  @MarkReceiptedForCreditCard  bit,
  @MarkReceiptedForDirectDebit bit,
  @EReceiptContent ntext,
  @EReceiptPdfMargin int,
  @CartMessage ntext,
  @ECardPartID int,
  @ECardSendDateAttributeID int,
  @ECardRecipientFirstNameAttributeID int,
  @ECardRecipientLastNameAttributeID int,
  @CartSendDonationAcknowledgementAlways bit,
  @MinimumGiftAmount numeric(30,6),
  @MinimumPledgePaymentAmount numeric(30,6),
  @ShowPledgePaymentDueDate bit,
  @AcknowledgementBlock     nvarchar(max),
  @AllowSpouseInfo          bit,
  @IncludeChallengeMatch    bit,
  @ChallengeMatchIntro      nvarchar(max),
  @Challengematch           nvarchar(max),
  @ImpactStatementTypeID uniqueidentifier,
  @AppealHistoryQueryID int,
  @WelcomeEmailTemplateID INT = null 
)
as
  set nocount ON;
  begin transaction;
  if (@PKID <= 0)
  begin
  insert into dbo.clientdonations
              (
      clientsid,
      guid,
      ownerid,
      constitcodeid ,
      emailtemplateid,
      donationoptions,
      tributeoptions,
      redirectpageid,
      contentid,
      merchantaccount,
      nomgpledges,
      attributes,
      donatebtn,
      recurrenceoptions,
      recurrenceoptionstruepledge,
      shoppingcartpageid,
      ereceiptpdfforcreditcard,
      ereceiptpdffordirectdebit,
      markreceiptedforcreditcard,
      markreceiptedfordirectdebit,
      ereceiptcontent,
      ereceiptpdfmargin,
      cartmessage,
      ecardpartid,
      ecardsenddateattributeid,
      ecardrecipientfirstnameattributeid,
      ecardrecipientlastnameattributeid,
      cartsenddonationacknowledgementalways,
      minimumgiftamount,
      minimumpledgepaymentamount,
      showpledgepaymentduedate,
      acknowledgementblock,
      allowspouseinfo,
      includechallengematch,
      challengematchintro,
      challengematch,
      impactstatementtypeid,
      appealhistoryqueryid,
          welcomeEmailTemplateID
              )
              VALUES
              (
      @ClientsID,
      @Guid,
      @CurrentUsersID,
      @ConstitCodeID ,
      @EmailTemplateID,
      @DonationOptions,
      @TributeOptions,
      @RedirectPageID,
      @ContentID,
      @MerchantAccount,
      @NoMGPledges,
      @Attributes,
      @DonateBtn,
      @RecurrenceOptions,
      @RecurrenceOptionsTruePledge,
      @ShoppingCartPageID,
      @EReceiptPdfForCreditCard,
      @EReceiptPdfForDirectDebit,
      @MarkReceiptedForCreditCard,
      @MarkReceiptedForDirectDebit,
      @EReceiptcontent,
      @EReceiptPdfMargin,
      @CartMessage,
      @ECardPartID,
      @ECardSendDateAttributeID,
      @ECardRecipientFirstNameAttributeID,
      @ECardRecipientLastNameAttributeID,
      @CartSendDonationAcknowledgementAlways,
      @Minimumgiftamount,
      @MinimumPledgePaymentAmount,
      @ShowPledgePaymentDueDate,
      @AcknowledgementBlock,
      @AllowSpouseInfo,
      @IncludeChallengeMatch,
      @ChallengeMatchIntro,
      @ChallengeMatch,
      @ImpactStatementTypeID,
      @Appealhistoryqueryid,
      @WelcomeEmailTemplateID
              );

  set @PKID = @@Identity;
  exec spAuditThis @CurrentUsersID, 1, @Guid, 10;
end
  else
  begin
    declare @oldECardPartID int;
      if @ECardPartID is null 
    begin
          select @oldECardPartID = ECardPartID from dbo.ClientDonations where ID = @PKID;
     end
  update dbo.clientdonations
  set    clientsid = @ClientsID,
         guid = @Guid,
         constitcodeid = @ConstitCodeID,
         emailtemplateid = @EmailTemplateID,
         donationoptions = @DonationOptions,
         tributeoptions = @TributeOptions,
         redirectpageid = @RedirectPageID,
         merchantaccount = @MerchantAccount,
         nomgpledges = @NoMGPledges,
         attributes = @Attributes,
         donatebtn = @DonateBtn,
         recurrenceoptions = @Recurrenceoptions,
         recurrenceoptionstruepledge = @RecurrenceOptionsTruePledge,
         shoppingcartpageid = @ShoppingCartPageID,
         ereceiptpdfforcreditcard = @EReceiptPdfForCreditCard,
         ereceiptpdffordirectdebit = @EReceiptPdfForDirectDebit,
         markreceiptedforcreditcard = @MarkReceiptedForCreditCard,
         markreceiptedfordirectdebit = @MarkReceiptedForDirectDebit,
         ereceiptcontent = @EReceiptContent,
         ereceiptpdfmargin = @EReceiptPdfMargin,
         cartmessage = @CartMessage,
         ecardpartid = @ECardPartID,
         ecardsenddateattributeid = @ECardSendDateAttributeID,
         ecardrecipientfirstnameattributeid = @ECardRecipientFirstNameAttributeID,
         ecardrecipientlastnameattributeid = @ECardRecipientLastNameAttributeID,
         cartsenddonationacknowledgementalways = @CartSendDonationAcknowledgementAlways,
         minimumgiftamount = @MinimumGiftAmount,
         minimumpledgepaymentamount = @MinimumPledgePaymentAmount,
         showpledgepaymentduedate = @ShowPledgePaymentDueDate,
         acknowledgementblock = @AcknowledgementBlock,
         allowspouseinfo = @AllowSpouseInfo,
         includechallengematch = @IncludeChallengeMatch,
         challengematchintro = @ChallengeMatchIntro,
         challengematch = @ChallengeMatch,
         impactstatementtypeid = @ImpactStatementTypeID,
         appealhistoryqueryid = @AppealHistoryQueryID,
         welcomeEmailTemplateID =  @WelcomeEmailTemplateID
  where  id = @PKID;

  exec spAuditThis @CurrentUsersID, 2, @Guid, 10;

  if @oldECardPartID > 0 
  begin
        delete from dbo.ECardPart where ID = @oldECardPartID;
  end
  end
  commit transaction;