USP_MKTRECORDSOURCEFIELDMAPPINGS_EDITSAVE

Saves the donor field mappings for a record source.

Parameters

Parameter	Parameter Type	Mode
@RECORDSOURCEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@FULLNAMEFIELD	nvarchar(255)	IN
@FIRSTNAMEFIELD	nvarchar(255)	IN
@MIDDLENAMEFIELD	nvarchar(255)	IN
@LASTNAMEFIELD	nvarchar(255)	IN
@ORGNAMEFIELD	nvarchar(255)	IN
@TITLEFIELD	nvarchar(255)	IN
@SUFFIXFIELD	nvarchar(255)	IN
@COUNTRYFIELD	nvarchar(255)	IN
@ADDRESSLINE1FIELD	nvarchar(255)	IN
@ADDRESSLINE2FIELD	nvarchar(255)	IN
@ADDRESSLINE3FIELD	nvarchar(255)	IN
@ADDRESSLINE4FIELD	nvarchar(255)	IN
@ADDRESSLINE5FIELD	nvarchar(255)	IN
@CITYFIELD	nvarchar(255)	IN
@STATEFIELD	nvarchar(255)	IN
@POSTCODEFIELD	nvarchar(255)	IN
@CARTFIELD	nvarchar(255)	IN
@DPCFIELD	nvarchar(255)	IN
@LOTFIELD	nvarchar(255)	IN
@PHONENUMBERFIELD	nvarchar(255)	IN
@EMAILADDRESSFIELD	nvarchar(255)	IN
@FIRSTGIFTDATEFIELD	nvarchar(255)	IN
@HOUSEHOLDIDFIELD	nvarchar(255)	IN
@HEADOFHOUSEHOLDFIELD	nvarchar(255)	IN
@ISHOUSEHOLDFIELD	nvarchar(255)	IN
@DATELASTCHANGEDFIELD	nvarchar(255)	IN
@ADDRESSEEFIELD	nvarchar(255)	IN
@SALUTATIONFIELD	nvarchar(255)	IN
@LOOKUPIDFIELD	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTRECORDSOURCEFIELDMAPPINGS_EDITSAVE]
(
  @RECORDSOURCEID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @FULLNAMEFIELD nvarchar(255),
  @FIRSTNAMEFIELD nvarchar(255),
  @MIDDLENAMEFIELD nvarchar(255),
  @LASTNAMEFIELD nvarchar(255),
  @ORGNAMEFIELD nvarchar(255),
  @TITLEFIELD nvarchar(255),
  @SUFFIXFIELD nvarchar(255),
  @COUNTRYFIELD nvarchar(255),
  @ADDRESSLINE1FIELD nvarchar(255),
  @ADDRESSLINE2FIELD nvarchar(255),
  @ADDRESSLINE3FIELD nvarchar(255),
  @ADDRESSLINE4FIELD nvarchar(255),
  @ADDRESSLINE5FIELD nvarchar(255),
  @CITYFIELD nvarchar(255),
  @STATEFIELD nvarchar(255),
  @POSTCODEFIELD nvarchar(255),
  @CARTFIELD nvarchar(255),
  @DPCFIELD nvarchar(255),
  @LOTFIELD nvarchar(255),
  @PHONENUMBERFIELD nvarchar(255),
  @EMAILADDRESSFIELD nvarchar(255),
  @FIRSTGIFTDATEFIELD nvarchar(255),
  @HOUSEHOLDIDFIELD nvarchar(255),
  @HEADOFHOUSEHOLDFIELD nvarchar(255),
  @ISHOUSEHOLDFIELD nvarchar(255),
  @DATELASTCHANGEDFIELD nvarchar(255),
  @ADDRESSEEFIELD nvarchar(255),
  @SALUTATIONFIELD nvarchar(255),
  @LOOKUPIDFIELD nvarchar(255) = NULL
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = GetDate();
    set @FULLNAMEFIELD = isnull(@FULLNAMEFIELD,'');
    set @FIRSTNAMEFIELD = isnull(@FIRSTNAMEFIELD,'');
    set @MIDDLENAMEFIELD = isnull(@MIDDLENAMEFIELD,'');
    set @LASTNAMEFIELD = isnull(@LASTNAMEFIELD,'');
    set @ORGNAMEFIELD = isnull(@ORGNAMEFIELD,'');
    set @TITLEFIELD = isnull(@TITLEFIELD,'');
    set @SUFFIXFIELD = isnull(@SUFFIXFIELD,'');
    set @COUNTRYFIELD = isnull(@COUNTRYFIELD,'');
    set @ADDRESSLINE1FIELD = isnull(@ADDRESSLINE1FIELD,'');
    set @ADDRESSLINE2FIELD = isnull(@ADDRESSLINE2FIELD,'');
    set @ADDRESSLINE3FIELD = isnull(@ADDRESSLINE3FIELD,'');
    set @ADDRESSLINE4FIELD = isnull(@ADDRESSLINE4FIELD,'');
    set @ADDRESSLINE5FIELD = isnull(@ADDRESSLINE5FIELD,'');
    set @CITYFIELD = isnull(@CITYFIELD,'');
    set @STATEFIELD = isnull(@STATEFIELD,'');
    set @POSTCODEFIELD = isnull(@POSTCODEFIELD,'');
    set @CARTFIELD = isnull(@CARTFIELD,'');
    set @DPCFIELD = isnull(@DPCFIELD,'');
    set @LOTFIELD = isnull(@LOTFIELD,'');
    set @PHONENUMBERFIELD = isnull(@PHONENUMBERFIELD,'');
    set @EMAILADDRESSFIELD = isnull(@EMAILADDRESSFIELD,'');
    set @FIRSTGIFTDATEFIELD = isnull(@FIRSTGIFTDATEFIELD,'');
    set @HOUSEHOLDIDFIELD = isnull(@HOUSEHOLDIDFIELD,'');
    set @HEADOFHOUSEHOLDFIELD = isnull(@HEADOFHOUSEHOLDFIELD,'');
    set @ISHOUSEHOLDFIELD = isnull(@ISHOUSEHOLDFIELD,'');
    set @DATELASTCHANGEDFIELD = isnull(@DATELASTCHANGEDFIELD,'');
    set @ADDRESSEEFIELD = isnull(@ADDRESSEEFIELD,'');
    set @SALUTATIONFIELD = isnull(@SALUTATIONFIELD,'');
    set @LOOKUPIDFIELD = isnull(@LOOKUPIDFIELD,'');

    if exists(select [ID] from dbo.[MKTRECORDSOURCEFIELDMAPPINGS] where [ID] = @RECORDSOURCEID)
      update dbo.[MKTRECORDSOURCEFIELDMAPPINGS] set
        [FULLNAMEFIELD] = @FULLNAMEFIELD,
        [FIRSTNAMEFIELD] = @FIRSTNAMEFIELD,
        [MIDDLENAMEFIELD] = @MIDDLENAMEFIELD,
        [LASTNAMEFIELD] = @LASTNAMEFIELD,
        [ORGNAMEFIELD] = @ORGNAMEFIELD,
        [TITLEFIELD] = @TITLEFIELD,
        [SUFFIXFIELD] = @SUFFIXFIELD,
        [COUNTRYFIELD] = @COUNTRYFIELD,
        [ADDRESSLINE1FIELD] = @ADDRESSLINE1FIELD,
        [ADDRESSLINE2FIELD] = @ADDRESSLINE2FIELD,
        [ADDRESSLINE3FIELD] = @ADDRESSLINE3FIELD,
        [ADDRESSLINE4FIELD] = @ADDRESSLINE4FIELD,
        [ADDRESSLINE5FIELD] = @ADDRESSLINE5FIELD,
        [CITYFIELD] = @CITYFIELD,
        [STATEFIELD] = @STATEFIELD,
        [POSTCODEFIELD] = @POSTCODEFIELD,
        [CARTFIELD] = @CARTFIELD,
        [DPCFIELD] = @DPCFIELD,
        [LOTFIELD] = @LOTFIELD,
        [PHONENUMBERFIELD] = @PHONENUMBERFIELD,
        [EMAILADDRESSFIELD] = @EMAILADDRESSFIELD,
        [FIRSTGIFTDATEFIELD] = @FIRSTGIFTDATEFIELD,
        [HOUSEHOLDIDFIELD] = @HOUSEHOLDIDFIELD,
        [HEADOFHOUSEHOLDFIELD] = @HEADOFHOUSEHOLDFIELD,
        [ISHOUSEHOLDFIELD] = @ISHOUSEHOLDFIELD,
        [DATELASTCHANGEDFIELD] = @DATELASTCHANGEDFIELD,
        [ADDRESSEEFIELD] = @ADDRESSEEFIELD,
        [SALUTATIONFIELD] = @SALUTATIONFIELD,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE,
        [LOOKUPIDFIELD] = @LOOKUPIDFIELD
      where [ID] = @RECORDSOURCEID;
    else
      insert into dbo.[MKTRECORDSOURCEFIELDMAPPINGS] (
        [ID],
        [FULLNAMEFIELD],
        [FIRSTNAMEFIELD],
        [MIDDLENAMEFIELD],
        [LASTNAMEFIELD],
        [ORGNAMEFIELD],
        [TITLEFIELD],
        [SUFFIXFIELD],
        [COUNTRYFIELD],
        [ADDRESSLINE1FIELD],
        [ADDRESSLINE2FIELD],
        [ADDRESSLINE3FIELD],
        [ADDRESSLINE4FIELD],
        [ADDRESSLINE5FIELD],
        [CITYFIELD],
        [STATEFIELD],
        [POSTCODEFIELD],
        [CARTFIELD],
        [DPCFIELD],
        [LOTFIELD],
        [PHONENUMBERFIELD],
        [EMAILADDRESSFIELD],
        [FIRSTGIFTDATEFIELD],
        [HOUSEHOLDIDFIELD],
        [HEADOFHOUSEHOLDFIELD],
        [ISHOUSEHOLDFIELD],
        [DATELASTCHANGEDFIELD],
        [ADDRESSEEFIELD],
        [SALUTATIONFIELD],
        [ADDEDBYID],
        [DATEADDED],
        [CHANGEDBYID],
        [DATECHANGED],
        [LOOKUPIDFIELD]
      ) values (
        @RECORDSOURCEID,
        @FULLNAMEFIELD,
        @FIRSTNAMEFIELD,
        @MIDDLENAMEFIELD,
        @LASTNAMEFIELD,
        @ORGNAMEFIELD,
        @TITLEFIELD,
        @SUFFIXFIELD,
        @COUNTRYFIELD,
        @ADDRESSLINE1FIELD,
        @ADDRESSLINE2FIELD,
        @ADDRESSLINE3FIELD,
        @ADDRESSLINE4FIELD,
        @ADDRESSLINE5FIELD,
        @CITYFIELD,
        @STATEFIELD,
        @POSTCODEFIELD,
        @CARTFIELD,
        @DPCFIELD,
        @LOTFIELD,
        @PHONENUMBERFIELD,
        @EMAILADDRESSFIELD,
        @FIRSTGIFTDATEFIELD,
        @HOUSEHOLDIDFIELD,
        @HEADOFHOUSEHOLDFIELD,
        @ISHOUSEHOLDFIELD,
        @DATELASTCHANGEDFIELD,
        @ADDRESSEEFIELD,
        @SALUTATIONFIELD,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @LOOKUPIDFIELD
      );
  end try

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

  return 0;