USP_MKTGIFTRECORDSOURCE_EDITSAVE

Saves information for a gift record source.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@APPEALSYSTEMIDFIELD	nvarchar(255)	IN
@APPEALIDFIELD	nvarchar(255)	IN
@APPEALDESCRIPTIONFIELD	nvarchar(255)	IN
@AMOUNTFIELD	nvarchar(255)	IN
@DONORIDFIELD	nvarchar(255)	IN
@SOURCECODEFIELD	nvarchar(255)	IN
@MAILINGIDFIELD	nvarchar(255)	IN
@DATEFIELD	nvarchar(255)	IN
@FINDERNUMBERFIELD	nvarchar(255)	IN
@DATEADDEDFIELD	nvarchar(255)	IN
@DONOTACKNOWLEDGEFIELD	nvarchar(255)	IN
@DONOTRECEIPTFIELD	nvarchar(255)	IN
@MARKETINGINFOQUERYVIEWCATALOGID	uniqueidentifier	IN
@DATECHANGEDFIELD	nvarchar(255)	IN
@LOOKUPIDFIELD	nvarchar(255)	IN
@BASECURRENCYIDFIELD	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTGIFTRECORDSOURCE_EDITSAVE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @QUERYVIEWCATALOGID uniqueidentifier,
  @APPEALSYSTEMIDFIELD nvarchar(255),
  @APPEALIDFIELD nvarchar(255),
  @APPEALDESCRIPTIONFIELD nvarchar(255),
  @AMOUNTFIELD nvarchar(255),
  @DONORIDFIELD nvarchar(255),
  @SOURCECODEFIELD nvarchar(255),
  @MAILINGIDFIELD nvarchar(255),
  @DATEFIELD nvarchar(255),
  @FINDERNUMBERFIELD nvarchar(255),
  @DATEADDEDFIELD nvarchar(255),
  @DONOTACKNOWLEDGEFIELD nvarchar(255),
  @DONOTRECEIPTFIELD nvarchar(255),
  @MARKETINGINFOQUERYVIEWCATALOGID uniqueidentifier,
  @DATECHANGEDFIELD nvarchar(255),
  @LOOKUPIDFIELD nvarchar(255) = NULL,
  @BASECURRENCYIDFIELD nvarchar(255) = NULL
)
as
  set nocount on;

  declare @SQL nvarchar(max);
  declare @CURRENTDATE datetime;

  begin try
    if @CHANGEAGENTID is null
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    set @CURRENTDATE = getdate();

    set @DATEADDEDFIELD = isnull(@DATEADDEDFIELD,'');
    set @DONOTACKNOWLEDGEFIELD = isnull(@DONOTACKNOWLEDGEFIELD,'');
    set @DONOTRECEIPTFIELD = isnull(@DONOTRECEIPTFIELD,'');
    set @DATECHANGEDFIELD = isnull(@DATECHANGEDFIELD,'');
    set @BASECURRENCYIDFIELD = isnull(@BASECURRENCYIDFIELD,'');
    set @LOOKUPIDFIELD = isnull(@LOOKUPIDFIELD,'');

    if exists(select 1 from dbo.[MKTGIFTRECORDSOURCE] where [ID] = @ID)
      update dbo.[MKTGIFTRECORDSOURCE] set
        [QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID,
        [APPEALSYSTEMIDFIELD] = @APPEALSYSTEMIDFIELD,
        [APPEALIDFIELD] = @APPEALIDFIELD,
        [APPEALDESCRIPTIONFIELD] = @APPEALDESCRIPTIONFIELD,
        [AMOUNTFIELD] = @AMOUNTFIELD,
        [DONORIDFIELD] = @DONORIDFIELD,
        [SOURCECODEFIELD] = @SOURCECODEFIELD,
        [MAILINGIDFIELD] = @MAILINGIDFIELD,
        [DATEFIELD] = @DATEFIELD,
        [FINDERNUMBERFIELD] = @FINDERNUMBERFIELD,
        [DATEADDEDFIELD] = @DATEADDEDFIELD,
        [DONOTACKNOWLEDGEFIELD] = @DONOTACKNOWLEDGEFIELD,
        [DONOTRECEIPTFIELD] = @DONOTRECEIPTFIELD,
        [MARKETINGINFOQUERYVIEWCATALOGID] = @MARKETINGINFOQUERYVIEWCATALOGID,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE,
        [DATECHANGEDFIELD] = @DATECHANGEDFIELD,
        [LOOKUPIDFIELD] = @LOOKUPIDFIELD,
        [BASECURRENCYIDFIELD] = @BASECURRENCYIDFIELD
      where [ID] = @ID;
    else
      insert into dbo.[MKTGIFTRECORDSOURCE] (
        [ID],
        [QUERYVIEWCATALOGID],
        [APPEALSYSTEMIDFIELD],
        [APPEALIDFIELD],
        [APPEALDESCRIPTIONFIELD],
        [AMOUNTFIELD],
        [DONORIDFIELD],
        [SOURCECODEFIELD],
        [MAILINGIDFIELD],
        [DATEFIELD],
        [FINDERNUMBERFIELD],
        [DATEADDEDFIELD],
        [DONOTACKNOWLEDGEFIELD],
        [DONOTRECEIPTFIELD],
        [MARKETINGINFOQUERYVIEWCATALOGID],
        [ADDEDBYID],
        [DATEADDED],
        [CHANGEDBYID],
        [DATECHANGED],
        [DATECHANGEDFIELD],
        [LOOKUPIDFIELD],
        [BASECURRENCYIDFIELD]
      ) values (
        @ID,
        @QUERYVIEWCATALOGID,
        @APPEALSYSTEMIDFIELD,
        @APPEALIDFIELD,
        @APPEALDESCRIPTIONFIELD,
        @AMOUNTFIELD,
        @DONORIDFIELD,
        @SOURCECODEFIELD,
        @MAILINGIDFIELD,
        @DATEFIELD,
        @FINDERNUMBERFIELD,
        @DATEADDEDFIELD,
        @DONOTACKNOWLEDGEFIELD,
        @DONOTRECEIPTFIELD,
        @MARKETINGINFOQUERYVIEWCATALOGID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @DATECHANGEDFIELD,
        @LOOKUPIDFIELD,
        @BASECURRENCYIDFIELD
      );

    --Grant rights to the MKTREVENUELETTER and MKTREVENUERECEIPT tables...

    exec dbo.[USP_MKTGIFTRECORDSOURCE_GRANTRIGHTSTOREVENUETABLES] @ID;
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

return 0;