USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_4

The save procedure used by the edit dataform template "NetCommunity Default Code Map Edit Form 3.0".

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.
@BUSINESSPHONECODEID	uniqueidentifier	IN	Business phone
@FAXPHONECODEID	uniqueidentifier	IN	Fax phone
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Spouse relationship type
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Removed spouse relationship type
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Organization relationship type
@PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN	Individual relationship type
@PRIMARYADDRESSTYPECODEID	uniqueidentifier	IN	Primary address type
@BUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@ORGANIZATIONPRIMARYADDRESSTYPECODEID	uniqueidentifier	IN	Organization primary address type
@MGCONDITIONTYPECODEID	uniqueidentifier	IN	Matching gift condition type
@REVENUENOTETYPECODEID	uniqueidentifier	IN	Donation note type
@CONSTITUENTLINKPAGEID	uniqueidentifier	IN	Blackbaud Internet Solutions link page
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact relationship type
@CHANNELCODEID	uniqueidentifier	IN	Channel
@MGALIASTYPECODEID	uniqueidentifier	IN	Matchfinder Online alias type
@DONOTEMAILSOLICITCODEID	uniqueidentifier	IN	Do not email solicit code
@AUTOMATCHUSELASTNAME	bit	IN	Last name/Organization name/Educational institution
@AUTOMATCHUSEFIRSTNAME	bit	IN	First name
@AUTOMATCHUSEMAIDENNAME	bit	IN	Maiden name
@AUTOMATCHUSEBIRTHDATE	bit	IN	Birth date
@AUTOMATCHUSEGENDER	bit	IN	Gender
@AUTOMATCHUSEMIDDLENAME	bit	IN	Middle name
@AUTOMATCHUSEADDRESS	bit	IN	Address
@AUTOMATCHUSECITY	bit	IN	City
@AUTOMATCHUSECOUNTRY	bit	IN	Country
@AUTOMATCHUSECOUNTY	bit	IN	County
@AUTOMATCHUSENZCITY	bit	IN	NZ City
@AUTOMATCHUSENZSUBURB	bit	IN	NZ Suburb
@AUTOMATCHUSESTATE	bit	IN	State
@AUTOMATCHUSEZIP	bit	IN	ZIP
@AUTOMATCHUSEPHONE	bit	IN	Any phone
@AUTOMATCHUSELOOKUPID	bit	IN	Lookup ID
@AUTOMATCHEXACTMATCHONLY	bit	IN	Exact match only
@AUTOMATCHINCLUDEINACTIVE	bit	IN	Include inactive
@AUTOMATCHINCLUDEDECEASED	bit	IN	Include deceased
@PLUGINSERVICEURL	UDT_WEBADDRESS	IN	Plugin service URL
@INFOSOURCECODEID	uniqueidentifier	IN	Contact information source

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_4]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @BUSINESSPHONECODEID uniqueidentifier,
  @FAXPHONECODEID uniqueidentifier,
  @RELATIONSHIPTYPECODEID uniqueidentifier,
  @SPOUSEREMOVEDRELATIONSHIPTYPECODEID uniqueidentifier,
  @PRIMARYBUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
  @PRIMARYBUSINESSRECIPROCALTYPECODEID uniqueidentifier,
  @PRIMARYADDRESSTYPECODEID uniqueidentifier,
  @BUSINESSADDRESSTYPECODEID uniqueidentifier,
  @ORGANIZATIONPRIMARYADDRESSTYPECODEID uniqueidentifier,
  @MGCONDITIONTYPECODEID uniqueidentifier,
  @REVENUENOTETYPECODEID uniqueidentifier,
  @CONSTITUENTLINKPAGEID uniqueidentifier,
  @CONTACTTYPECODEID uniqueidentifier,
  @CHANNELCODEID uniqueidentifier,
  @MGALIASTYPECODEID uniqueidentifier,
  @DONOTEMAILSOLICITCODEID uniqueidentifier,

  @AUTOMATCHUSELASTNAME bit,
  @AUTOMATCHUSEFIRSTNAME bit,
  @AUTOMATCHUSEMAIDENNAME bit,
  @AUTOMATCHUSEBIRTHDATE bit,
  @AUTOMATCHUSEGENDER bit,
  @AUTOMATCHUSEMIDDLENAME bit,
  @AUTOMATCHUSEADDRESS bit,
  @AUTOMATCHUSECITY bit,
  @AUTOMATCHUSECOUNTRY bit,
  @AUTOMATCHUSECOUNTY bit,
  @AUTOMATCHUSENZCITY bit,
  @AUTOMATCHUSENZSUBURB bit,
  @AUTOMATCHUSESTATE bit,
  @AUTOMATCHUSEZIP bit,
  @AUTOMATCHUSEPHONE bit,
  @AUTOMATCHUSELOOKUPID bit,
  @AUTOMATCHEXACTMATCHONLY bit,
  @AUTOMATCHINCLUDEINACTIVE bit,
  @AUTOMATCHINCLUDEDECEASED bit,

  @PLUGINSERVICEURL dbo.UDT_WEBADDRESS,
  @INFOSOURCECODEID uniqueidentifier
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

  set @CURRENTDATE = getdate();

  begin try
    if not exists (select top 1 1 from dbo.[NETCOMMUNITYPLUGINSERVICE])
      insert into dbo.[NETCOMMUNITYPLUGINSERVICE]
      (
        [ID],
        [URL],
        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED]
      )
      values
      (
        newid(),
        @PLUGINSERVICEURL,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
      );
    else
      update dbo.[NETCOMMUNITYPLUGINSERVICE] set
        [URL] = @PLUGINSERVICEURL,
        [DATECHANGED] = @CURRENTDATE,
        [CHANGEDBYID] = @CHANGEAGENTID;

    if not exists (select top 1 1 from dbo.[NETCOMMUNITYDEFAULTCODEMAP] where [ID] = @ID)
      insert into dbo.[NETCOMMUNITYDEFAULTCODEMAP]
      (
        [ID],
        [BUSINESSPHONECODEID],
        [FAXPHONECODEID],
        [RELATIONSHIPTYPECODEID],
        [SPOUSEREMOVEDRELATIONSHIPTYPECODEID],
        [PRIMARYBUSINESSRELATIONSHIPTYPECODEID],
        [PRIMARYBUSINESSRECIPROCALTYPECODEID],
        [PRIMARYADDRESSTYPECODEID],
        [BUSINESSADDRESSTYPECODEID],
        [ORGANIZATIONPRIMARYADDRESSTYPECODEID],
        [MGCONDITIONTYPECODEID],
        [REVENUENOTETYPECODEID],
        [CONSTITUENTLINKPAGEID],
        [CONTACTTYPECODEID],
        [CHANNELCODEID],
        [MGALIASTYPECODEID],
        [DONOTEMAILSOLICITCODEID],
        [INFOSOURCECODEID],

        [AUTOMATCHUSELASTNAME],
        [AUTOMATCHUSEFIRSTNAME],
        [AUTOMATCHUSEMAIDENNAME],
        [AUTOMATCHUSEBIRTHDATE],
        [AUTOMATCHUSEGENDER],
        [AUTOMATCHUSEMIDDLENAME],
        [AUTOMATCHUSEADDRESS],
        [AUTOMATCHUSECITY],
        [AUTOMATCHUSECOUNTRY],
        [AUTOMATCHUSECOUNTY],
        [AUTOMATCHUSENZCITY],
        [AUTOMATCHUSENZSUBURB],
        [AUTOMATCHUSESTATE],
        [AUTOMATCHUSEZIP],
        [AUTOMATCHUSEPHONE],
        [AUTOMATCHUSELOOKUPID],
        [AUTOMATCHEXACTMATCHONLY],
        [AUTOMATCHINCLUDEINACTIVE],
        [AUTOMATCHINCLUDEDECEASED],

        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED]
      )
      values
      (
        @ID,
        @BUSINESSPHONECODEID,
        @FAXPHONECODEID,
        @RELATIONSHIPTYPECODEID,
        @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESSRECIPROCALTYPECODEID,
        @PRIMARYADDRESSTYPECODEID,
        @BUSINESSADDRESSTYPECODEID,
        @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
        @MGCONDITIONTYPECODEID,
        @REVENUENOTETYPECODEID,
        @CONSTITUENTLINKPAGEID,
        @CONTACTTYPECODEID,
        @CHANNELCODEID,
        @MGALIASTYPECODEID,
        @DONOTEMAILSOLICITCODEID,
        @INFOSOURCECODEID,

        @AUTOMATCHUSELASTNAME,
        @AUTOMATCHUSEFIRSTNAME,
        @AUTOMATCHUSEMAIDENNAME,
        @AUTOMATCHUSEBIRTHDATE,
        @AUTOMATCHUSEGENDER,
        @AUTOMATCHUSEMIDDLENAME,
        @AUTOMATCHUSEADDRESS,
        @AUTOMATCHUSECITY,
        @AUTOMATCHUSECOUNTRY,
        @AUTOMATCHUSECOUNTY,
        @AUTOMATCHUSENZCITY,
        @AUTOMATCHUSENZSUBURB,
        @AUTOMATCHUSESTATE,
        @AUTOMATCHUSEZIP,
        @AUTOMATCHUSEPHONE,
        @AUTOMATCHUSELOOKUPID,
        @AUTOMATCHEXACTMATCHONLY,
        @AUTOMATCHINCLUDEINACTIVE,
        @AUTOMATCHINCLUDEDECEASED,

        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
      );
    else
      update 
        dbo.[NETCOMMUNITYDEFAULTCODEMAP]
      set
        [BUSINESSPHONECODEID] = @BUSINESSPHONECODEID,
        [FAXPHONECODEID] = @FAXPHONECODEID,
        [RELATIONSHIPTYPECODEID] = @RELATIONSHIPTYPECODEID,
        [SPOUSEREMOVEDRELATIONSHIPTYPECODEID] = @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
        [PRIMARYBUSINESSRELATIONSHIPTYPECODEID] = @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
        [PRIMARYBUSINESSRECIPROCALTYPECODEID] = @PRIMARYBUSINESSRECIPROCALTYPECODEID,
        [PRIMARYADDRESSTYPECODEID] = @PRIMARYADDRESSTYPECODEID,
        [BUSINESSADDRESSTYPECODEID] = @BUSINESSADDRESSTYPECODEID,
        [ORGANIZATIONPRIMARYADDRESSTYPECODEID] = @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
        [MGCONDITIONTYPECODEID] = @MGCONDITIONTYPECODEID,
        [REVENUENOTETYPECODEID] = @REVENUENOTETYPECODEID,
        [CONSTITUENTLINKPAGEID] = @CONSTITUENTLINKPAGEID,
        [CONTACTTYPECODEID] = @CONTACTTYPECODEID,
        [CHANNELCODEID] = @CHANNELCODEID,
        [MGALIASTYPECODEID] = @MGALIASTYPECODEID,
        [DONOTEMAILSOLICITCODEID] = @DONOTEMAILSOLICITCODEID,
        [INFOSOURCECODEID] = @INFOSOURCECODEID,

        [AUTOMATCHUSELASTNAME] = @AUTOMATCHUSELASTNAME,
        [AUTOMATCHUSEFIRSTNAME] = @AUTOMATCHUSEFIRSTNAME,
        [AUTOMATCHUSEMAIDENNAME] = @AUTOMATCHUSEMAIDENNAME,
        [AUTOMATCHUSEBIRTHDATE] = @AUTOMATCHUSEBIRTHDATE,
        [AUTOMATCHUSEGENDER] = @AUTOMATCHUSEGENDER,
        [AUTOMATCHUSEMIDDLENAME] = @AUTOMATCHUSEMIDDLENAME,
        [AUTOMATCHUSEADDRESS] = @AUTOMATCHUSEADDRESS,
        [AUTOMATCHUSECITY] = @AUTOMATCHUSECITY,
        [AUTOMATCHUSECOUNTRY] = @AUTOMATCHUSECOUNTRY,
        [AUTOMATCHUSECOUNTY] = @AUTOMATCHUSECOUNTY,
        [AUTOMATCHUSENZCITY] = @AUTOMATCHUSENZCITY,
        [AUTOMATCHUSENZSUBURB] = @AUTOMATCHUSENZSUBURB,
        [AUTOMATCHUSESTATE] = @AUTOMATCHUSESTATE,
        [AUTOMATCHUSEZIP] = @AUTOMATCHUSEZIP,
        [AUTOMATCHUSEPHONE] = @AUTOMATCHUSEPHONE,
        [AUTOMATCHUSELOOKUPID] = @AUTOMATCHUSELOOKUPID,
        [AUTOMATCHEXACTMATCHONLY] = @AUTOMATCHEXACTMATCHONLY,
        [AUTOMATCHINCLUDEINACTIVE] = @AUTOMATCHINCLUDEINACTIVE,
        [AUTOMATCHINCLUDEDECEASED] = @AUTOMATCHINCLUDEDECEASED,

        [DATECHANGED] = @CURRENTDATE,
        [CHANGEDBYID] = @CHANGEAGENTID
      where 
        [NETCOMMUNITYDEFAULTCODEMAP].ID = @ID;
  end try

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

  return 0;