USP_MKTMEMBERSHIPRECORDSOURCE_EDITSAVE

Saves information for a membership record source.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@MEMBERSHIPSYSTEMIDFIELD	nvarchar(255)	IN
@MEMBERIDFIELD	nvarchar(255)	IN
@MEMBERFIELD	nvarchar(255)	IN
@GIVENBYIDFIELD	nvarchar(255)	IN
@GIVENBYFIELD	nvarchar(255)	IN
@EXPIRATIONDATEFIELD	nvarchar(255)	IN
@ISGIFTFIELD	nvarchar(255)	IN
@JOINDATEFIELD	nvarchar(255)	IN
@LASTRENEWEDONDATEFIELD	nvarchar(255)	IN
@LEVELFIELD	nvarchar(255)	IN
@PROGRAMFIELD	nvarchar(255)	IN
@SENDRENEWALFIELD	nvarchar(255)	IN
@STATUSFIELD	nvarchar(255)	IN
@TERMFIELD	nvarchar(255)	IN
@TYPEFIELD	nvarchar(255)	IN
@LOOKUPIDFIELD	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTMEMBERSHIPRECORDSOURCE_EDITSAVE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @QUERYVIEWCATALOGID uniqueidentifier,
  @MEMBERSHIPSYSTEMIDFIELD nvarchar(255),
  @MEMBERIDFIELD nvarchar(255),
  @MEMBERFIELD nvarchar(255),
  @GIVENBYIDFIELD nvarchar(255),
  @GIVENBYFIELD nvarchar(255),
  @EXPIRATIONDATEFIELD nvarchar(255),
  @ISGIFTFIELD nvarchar(255),
  @JOINDATEFIELD nvarchar(255),
  @LASTRENEWEDONDATEFIELD nvarchar(255),
  @LEVELFIELD nvarchar(255),
  @PROGRAMFIELD nvarchar(255),
  @SENDRENEWALFIELD nvarchar(255),
  @STATUSFIELD nvarchar(255),
  @TERMFIELD nvarchar(255),
  @TYPEFIELD nvarchar(255),
  @LOOKUPIDFIELD 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();

    if exists (select 1 from dbo.[MKTMEMBERSHIPRECORDSOURCE] where [ID] = @ID)
      update dbo.[MKTMEMBERSHIPRECORDSOURCE] set
        [QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID,
        [MEMBERSHIPSYSTEMIDFIELD] = @MEMBERSHIPSYSTEMIDFIELD,
        [MEMBERIDFIELD] = @MEMBERIDFIELD,
        [MEMBERFIELD] = @MEMBERFIELD,
        [GIVENBYIDFIELD] = @GIVENBYIDFIELD,
        [GIVENBYFIELD] = @GIVENBYFIELD,
        [EXPIRATIONDATEFIELD] = @EXPIRATIONDATEFIELD,
        [ISGIFTFIELD] = @ISGIFTFIELD,
        [JOINDATEFIELD] = @JOINDATEFIELD,
        [LASTRENEWEDONDATEFIELD] = @LASTRENEWEDONDATEFIELD,
        [LEVELFIELD] = @LEVELFIELD,
        [PROGRAMFIELD] = @PROGRAMFIELD,
        [SENDRENEWALFIELD] = @SENDRENEWALFIELD,
        [STATUSFIELD] = @STATUSFIELD,
        [TERMFIELD] = @TERMFIELD,
        [TYPEFIELD] = @TYPEFIELD,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE,
        [LOOKUPIDFIELD] = @LOOKUPIDFIELD
      where [ID] = @ID;
    else
      insert into dbo.[MKTMEMBERSHIPRECORDSOURCE] (
        [ID],
        [QUERYVIEWCATALOGID],
        [MEMBERSHIPSYSTEMIDFIELD],
        [MEMBERIDFIELD],
        [MEMBERFIELD],
        [GIVENBYIDFIELD],
        [GIVENBYFIELD],
        [EXPIRATIONDATEFIELD],
        [ISGIFTFIELD],
        [JOINDATEFIELD],
        [LASTRENEWEDONDATEFIELD],
        [LEVELFIELD],
        [PROGRAMFIELD],
        [SENDRENEWALFIELD],
        [STATUSFIELD],
        [TERMFIELD],
        [TYPEFIELD],
        [ADDEDBYID],
        [DATEADDED],
        [CHANGEDBYID],
        [DATECHANGED],
        [LOOKUPIDFIELD]
      ) values (
        @ID,
        @QUERYVIEWCATALOGID,
        @MEMBERSHIPSYSTEMIDFIELD,
        @MEMBERIDFIELD,
        @MEMBERFIELD,
        @GIVENBYIDFIELD,
        @GIVENBYFIELD,
        @EXPIRATIONDATEFIELD,
        @ISGIFTFIELD,
        @JOINDATEFIELD,
        @LASTRENEWEDONDATEFIELD,
        @LEVELFIELD,
        @PROGRAMFIELD,
        @SENDRENEWALFIELD,
        @STATUSFIELD,
        @TERMFIELD,
        @TYPEFIELD,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @LOOKUPIDFIELD
      );
  end try

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

  return 0;