spAddUpdate_GivingHistory2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @SiteContentID | int | IN | |
| @GiftTypes | nvarchar(max) | IN | |
| @Campaigns | nvarchar(max) | IN | |
| @Funds | nvarchar(max) | IN | |
| @Appeals | nvarchar(max) | IN | |
| @GiftQueryID | int | IN | |
| @IncludeSoftCredit | bit | IN | |
| @ResultsPerPage | int | IN | |
| @UseCustomFilter | bit | IN | |
| @UseCustomColumn | bit | IN | |
| @IncludePending | bit | IN | |
| @IncludeSummary | bit | IN | |
| @IncludeGiftTotal | bit | IN | |
| @IncludeGiftAidTotal | bit | IN | |
| @IncludePendingTotal | bit | IN | |
| @IncludePledgeTotal | bit | IN | |
| @IncludeBalanceTotal | bit | IN | |
| @IncludeTotalsCurrency | bit | IN | |
| @PledgePaymentPageID | int | IN | |
| @RecGiftEditAllowAmtUpdate | bit | IN | |
| @RecGiftEditAllowFreqUpdates | bit | IN | |
| @RecGiftEditAllowPmntTypeUpdate | bit | IN | |
| @RecGiftEditMinUpdateAmt | money | IN | |
| @RecGiftEditFilterFunds | nvarchar(max) | IN | |
| @RecGiftEditFilterAppeals | nvarchar(max) | IN | |
| @RecGiftEditFilterQueryID | int | IN | |
| @RecGiftEditFilterUseCustomFilter | bit | IN | |
| @RecGiftEditFreqUseGeneralRecurrence | bit | IN | |
| @RecGiftEditFreqAllowStartDateUpdates | bit | IN | |
| @RecGiftEditFreqAllowEndDateUpdates | bit | IN | |
| @RecGiftEditFreqSpecifics | nvarchar(max) | IN | |
| @RecGiftAdditionalDonationPageID | int | IN | |
| @IncludeSoftCreditsTotal | bit | IN | |
| @IncludeHardCreditsTotal | bit | IN | |
| @RecurringGiftPaymentPageID | int | IN | |
| @IncludeUnpaidEvents | bit | IN | |
| @UnpaidEventsPaymentPageID | int | IN | |
| @MerchantAccountId | int | IN | |
| @CheckoutThemeUseSitedefault | bit | IN | |
| @CheckoutThemePrimaryColor | nvarchar(100) | IN | |
| @CheckoutThemeSecondaryColor | nvarchar(100) | IN | |
| @CheckoutThemeFontType | nvarchar(100) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_GivingHistory2]
(
@PKID int output,
@SiteContentID int,
@GiftTypes nvarchar(max),
@Campaigns nvarchar(max),
@Funds nvarchar(max),
@Appeals nvarchar(max),
@GiftQueryID int,
@IncludeSoftCredit bit,
@ResultsPerPage int,
@UseCustomFilter bit,
@UseCustomColumn bit,
@IncludePending bit,
@IncludeSummary bit,
@IncludeGiftTotal bit,
@IncludeGiftAidTotal bit,
@IncludePendingTotal bit,
@IncludePledgeTotal bit,
@IncludeBalanceTotal bit,
@IncludeTotalsCurrency bit,
@PledgePaymentPageID int,
@RecGiftEditAllowAmtUpdate bit,
@RecGiftEditAllowFreqUpdates bit,
@RecGiftEditAllowPmntTypeUpdate bit,
@RecGiftEditMinUpdateAmt money,
@RecGiftEditFilterFunds nvarchar(MAX),
@RecGiftEditFilterAppeals nvarchar(MAX),
@RecGiftEditFilterQueryID int,
@RecGiftEditFilterUseCustomFilter bit,
@RecGiftEditFreqUseGeneralRecurrence bit,
@RecGiftEditFreqAllowStartDateUpdates bit,
@RecGiftEditFreqAllowEndDateUpdates bit,
@RecGiftEditFreqSpecifics nvarchar(MAX),
@RecGiftAdditionalDonationPageID int,
@IncludeSoftCreditsTotal bit = 0,
@IncludeHardCreditsTotal bit = 0,
@RecurringGiftPaymentPageID int,
@IncludeUnpaidEvents bit = 0,
@UnpaidEventsPaymentPageID int,
@MerchantAccountId int = 0,
@CheckoutThemeUseSitedefault bit = 0,
@CheckoutThemePrimaryColor nvarchar(100) = NULL,
@CheckoutThemeSecondaryColor nvarchar(100) = NULL,
@CheckoutThemeFontType nvarchar(100) = NULL
)
AS
BEGIN
IF NOT EXISTS(Select SiteContentID From GivingHistory2 Where SiteContentID = @SiteContentID)
BEGIN
INSERT INTO [GivingHistory2]
(
[SiteContentID],
[GiftTypes],
[Campaigns],
[Funds],
[Appeals],
[GiftQueryID],
[IncludeSoftCredit],
[ResultsPerPage],
[UseCustomFilter],
[UseCustomColumn],
[IncludePending],
[IncludeSummary],
[IncludeGiftTotal],
[IncludeGiftAidTotal],
[IncludePendingTotal],
[IncludePledgeTotal],
[IncludeBalanceTotal],
[IncludeTotalsCurrency],
[PledgePaymentPageID],
[RecGiftEditAllowAmtUpdate],
[RecGiftEditAllowFreqUpdates],
[RecGiftEditAllowPmntTypeUpdate],
[RecGiftEditMinUpdateAmt],
[RecGiftEditFilterFunds],
[RecGiftEditFilterAppeals],
[RecGiftEditFilterQueryID],
[RecGiftEditFilterUseCustomFilter],
[RecGiftEditFreqUseGeneralRecurrence],
[RecGiftEditFreqAllowStartDateUpdates],
[RecGiftEditFreqAllowEndDateUpdates],
[RecGiftEditFreqSpecifics],
[RecGiftAdditionalDonationPageID],
[IncludeSoftCreditsTotal],
[IncludeHardCreditsTotal],
[RecurringGiftPaymentPageID],
[IncludeUnpaidEvents],
[UnpaidEventsPaymentPageID],
[MerchantAccountID],
[CheckoutThemeUseSiteDefault],
[CheckoutThemePrimaryColor],
[CheckoutThemeSecondaryColor],
[CheckoutThemeFontType]
)
VALUES
(
@SiteContentID,
@GiftTypes,
@Campaigns,
@Funds,
@Appeals,
@GiftQueryID,
@IncludeSoftCredit,
@ResultsPerPage,
@UseCustomFilter,
@UseCustomColumn,
@IncludePending,
@IncludeSummary,
@IncludeGiftTotal,
@IncludeGiftAidTotal,
@IncludePendingTotal,
@IncludePledgeTotal,
@IncludeBalanceTotal,
@IncludeTotalsCurrency,
@PledgePaymentPageID,
@RecGiftEditAllowAmtUpdate,
@RecGiftEditAllowFreqUpdates,
@RecGiftEditAllowPmntTypeUpdate,
@RecGiftEditMinUpdateAmt,
@RecGiftEditFilterFunds,
@RecGiftEditFilterAppeals,
@RecGiftEditFilterQueryID,
@RecGiftEditFilterUseCustomFilter,
@RecGiftEditFreqUseGeneralRecurrence,
@RecGiftEditFreqAllowStartDateUpdates,
@RecGiftEditFreqAllowEndDateUpdates,
@RecGiftEditFreqSpecifics,
@RecGiftAdditionalDonationPageID,
@IncludeSoftCreditsTotal,
@IncludeHardCreditsTotal,
@RecurringGiftPaymentPageID,
@IncludeUnpaidEvents,
@UnpaidEventsPaymentPageID,
@MerchantAccountId,
@CheckoutThemeUseSitedefault,
@CheckoutThemePrimaryColor,
@CheckoutThemeSecondaryColor,
@CheckoutThemeFontType
)
SELECT @PKID = SCOPE_IDENTITY()
END
ELSE
BEGIN
UPDATE [dbo].[GivingHistory2] SET
[GiftTypes] = @GiftTypes,
[Campaigns] = @Campaigns,
[Funds] = @Funds,
[Appeals] = @Appeals,
[GiftQueryID] = @GiftQueryID,
[IncludeSoftCredit] = @IncludeSoftCredit,
[ResultsPerPage] = @ResultsPerPage,
[UseCustomFilter] = @UseCustomFilter,
[UseCustomColumn] = @UseCustomColumn,
[IncludePending] = @IncludePending,
[IncludeSummary] = @IncludeSummary,
[IncludeGiftTotal] = @IncludeGiftTotal,
[IncludeGiftAidTotal] = @IncludeGiftAidTotal,
[IncludePendingTotal] = @IncludePendingTotal,
[IncludePledgeTotal] = @IncludePledgeTotal,
[IncludeBalanceTotal] = @IncludeBalanceTotal,
[IncludeTotalsCurrency] = @IncludeTotalsCurrency,
[PledgePaymentPageID] = @PledgePaymentPageID,
[RecGiftEditAllowAmtUpdate] = @RecGiftEditAllowAmtUpdate,
[RecGiftEditAllowFreqUpdates] = @RecGiftEditAllowFreqUpdates,
[RecGiftEditAllowPmntTypeUpdate] = @RecGiftEditAllowPmntTypeUpdate,
[RecGiftEditMinUpdateAmt] = @RecGiftEditMinUpdateAmt ,
[RecGiftEditFilterFunds] = @RecGiftEditFilterFunds,
[RecGiftEditFilterAppeals] = @RecGiftEditFilterAppeals,
[RecGiftEditFilterQueryID] = @RecGiftEditFilterQueryID,
[RecGiftEditFilterUseCustomFilter] = @RecGiftEditFilterUseCustomFilter,
[RecGiftEditFreqUseGeneralRecurrence] = @RecGiftEditFreqUseGeneralRecurrence,
[RecGiftEditFreqAllowStartDateUpdates] = @RecGiftEditFreqAllowStartDateUpdates,
[RecGiftEditFreqAllowEndDateUpdates] = @RecGiftEditFreqAllowEndDateUpdates,
[RecGiftEditFreqSpecifics] = @RecGiftEditFreqSpecifics,
[RecGiftAdditionalDonationPageID] = @RecGiftAdditionalDonationPageID,
[IncludeSoftCreditsTotal] = @IncludeSoftCreditsTotal,
[IncludeHardCreditsTotal] = @IncludeHardCreditsTotal,
[RecurringGiftPaymentPageID] = @RecurringGiftPaymentPageID,
[IncludeUnpaidEvents] = @IncludeUnpaidEvents,
[UnpaidEventsPaymentPageID] = @UnpaidEventsPaymentPageID,
[MerchantAccountID] = @MerchantAccountId,
[CheckoutThemeUseSiteDefault] = @CheckoutThemeUseSitedefault,
[CheckoutThemePrimaryColor] = @CheckoutThemePrimaryColor,
[CheckoutThemeSecondaryColor] = @CheckoutThemeSecondaryColor,
[CheckoutThemeFontType] = @CheckoutThemeFontType
WHERE [SiteContentID] = @SiteContentID
END
END