USP_DATAFORMTEMPLATE_EDIT_MKTRECORDSOURCEFIELDMAPPINGS

The save procedure used by the edit dataform template "Record Source Field Mappings Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@FULLNAMEFIELD	nvarchar(255)	IN	Full name field
@FIRSTNAMEFIELD	nvarchar(255)	IN	First name field
@MIDDLENAMEFIELD	nvarchar(255)	IN	Middle name field
@LASTNAMEFIELD	nvarchar(255)	IN	Last name field
@TITLEFIELD	nvarchar(255)	IN	Title field
@SUFFIXFIELD	nvarchar(255)	IN	Suffix field
@COUNTRYFIELD	nvarchar(255)	IN	Country field
@ADDRESSLINE1FIELD	nvarchar(255)	IN	Address line 1 field
@ADDRESSLINE2FIELD	nvarchar(255)	IN	Address line 2 field
@CITYFIELD	nvarchar(255)	IN	City field
@STATEFIELD	nvarchar(255)	IN	State field
@POSTCODEFIELD	nvarchar(255)	IN	Post code field
@CARTFIELD	nvarchar(255)	IN	Carrier route field
@DPCFIELD	nvarchar(255)	IN	DPC field
@LOTFIELD	nvarchar(255)	IN	Lot number field
@PHONENUMBERFIELD	nvarchar(255)	IN	Phone number field
@EMAILADDRESSFIELD	nvarchar(255)	IN	Email address field
@FIRSTGIFTDATEFIELD	nvarchar(255)	IN	First gift date field

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTRECORDSOURCEFIELDMAPPINGS]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @FULLNAMEFIELD nvarchar(255),
  @FIRSTNAMEFIELD nvarchar(255),
  @MIDDLENAMEFIELD nvarchar(255),
  @LASTNAMEFIELD nvarchar(255),
  @TITLEFIELD nvarchar(255),
  @SUFFIXFIELD nvarchar(255),
  @COUNTRYFIELD nvarchar(255),
  @ADDRESSLINE1FIELD nvarchar(255),
  @ADDRESSLINE2FIELD 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)
)
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 @TITLEFIELD = isnull(@TITLEFIELD,'');
    set @SUFFIXFIELD = isnull(@SUFFIXFIELD,'');
    set @COUNTRYFIELD = isnull(@COUNTRYFIELD,'');
    set @ADDRESSLINE1FIELD = isnull(@ADDRESSLINE1FIELD,'');
    set @ADDRESSLINE2FIELD = isnull(@ADDRESSLINE2FIELD,'');
    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, '');

    if exists(select [ID] from dbo.[MKTRECORDSOURCEFIELDMAPPINGS] where [ID] = @ID)
    begin
      update
        dbo.[MKTRECORDSOURCEFIELDMAPPINGS]
      set
        [FULLNAMEFIELD] = @FULLNAMEFIELD,
        [FIRSTNAMEFIELD] = @FIRSTNAMEFIELD,
        [MIDDLENAMEFIELD] = @MIDDLENAMEFIELD,
        [LASTNAMEFIELD] = @LASTNAMEFIELD,
        [TITLEFIELD] = @TITLEFIELD,
        [SUFFIXFIELD] = @SUFFIXFIELD,
        [COUNTRYFIELD] = @COUNTRYFIELD,
        [ADDRESSLINE1FIELD] = @ADDRESSLINE1FIELD,
        [ADDRESSLINE2FIELD] = @ADDRESSLINE2FIELD,
        [CITYFIELD] = @CITYFIELD,
        [STATEFIELD] = @STATEFIELD,
        [POSTCODEFIELD] = @POSTCODEFIELD,
        [CARTFIELD] = @CARTFIELD,
        [DPCFIELD] = @DPCFIELD,
        [LOTFIELD] = @LOTFIELD,
        [PHONENUMBERFIELD] = @PHONENUMBERFIELD,
        [EMAILADDRESSFIELD] = @EMAILADDRESSFIELD,
        [FIRSTGIFTDATEFIELD] = @FIRSTGIFTDATEFIELD,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE
      where
        [ID] = @ID;
    end
    else
    begin
      insert into dbo.[MKTRECORDSOURCEFIELDMAPPINGS] (
        [ID],
        [FULLNAMEFIELD],
        [FIRSTNAMEFIELD],
        [MIDDLENAMEFIELD],
        [LASTNAMEFIELD],
        [TITLEFIELD],
        [SUFFIXFIELD],
        [COUNTRYFIELD],
        [ADDRESSLINE1FIELD],
        [ADDRESSLINE2FIELD],
        [CITYFIELD],
        [STATEFIELD],
        [POSTCODEFIELD],
        [CARTFIELD],
        [DPCFIELD],
        [LOTFIELD],
        [PHONENUMBERFIELD],
        [EMAILADDRESSFIELD],
        [FIRSTGIFTDATEFIELD],
        [ADDEDBYID],
        [DATEADDED],
        [CHANGEDBYID],
        [DATECHANGED]
      ) values (
        @ID,
        @FULLNAMEFIELD,
        @FIRSTNAMEFIELD,
        @MIDDLENAMEFIELD,
        @LASTNAMEFIELD,
        @TITLEFIELD,
        @SUFFIXFIELD,
        @COUNTRYFIELD,
        @ADDRESSLINE1FIELD,
        @ADDRESSLINE2FIELD,
        @CITYFIELD,
        @STATEFIELD,
        @POSTCODEFIELD,
        @CARTFIELD,
        @DPCFIELD,
        @LOTFIELD,
        @PHONENUMBERFIELD,
        @EMAILADDRESSFIELD,
        @FIRSTGIFTDATEFIELD,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE
      );
    end
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;