USP_MKTAPPEALRECORDSOURCE_SAVEFIELDS

Saves the appeal record source's field mappings.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@APPEALIDFIELD	nvarchar(255)	IN
@DESCRIPTIONFIELD	nvarchar(255)	IN
@INACTIVEFIELD	nvarchar(255)	IN
@STARTDATEFIELD	nvarchar(255)	IN
@ENDDATEFIELD	nvarchar(255)	IN
@SEARCHLISTCATALOGID	uniqueidentifier	IN
@TRANSLATIONFUNCTIONCATALOGID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MKTAPPEALRECORDSOURCE_SAVEFIELDS
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @QUERYVIEWCATALOGID uniqueidentifier,
  @APPEALIDFIELD nvarchar(255),
  @DESCRIPTIONFIELD nvarchar(255),
  @INACTIVEFIELD nvarchar(255) = '',
  @STARTDATEFIELD nvarchar(255) = '',
  @ENDDATEFIELD nvarchar(255) = '',
  @SEARCHLISTCATALOGID uniqueidentifier,
  @TRANSLATIONFUNCTIONCATALOGID uniqueidentifier
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = GetDate();

    if @INACTIVEFIELD is null
      set @INACTIVEFIELD = '';

    if @STARTDATEFIELD is null
      set @STARTDATEFIELD = '';

    if @ENDDATEFIELD is null
      set @ENDDATEFIELD = '';

    if exists(select [ID] from dbo.[MKTAPPEALRECORDSOURCE] where [ID] = @ID)
    begin
      update
        dbo.[MKTAPPEALRECORDSOURCE]
      set
        [QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID,
        [APPEALIDFIELD] = @APPEALIDFIELD,
        [DESCRIPTIONFIELD] = @DESCRIPTIONFIELD,
        [INACTIVEFIELD] = @INACTIVEFIELD,
        [STARTDATEFIELD] = @STARTDATEFIELD,
        [ENDDATEFIELD] = @ENDDATEFIELD,
        [SEARCHLISTCATALOGID] = @SEARCHLISTCATALOGID,
        [TRANSLATIONFUNCTIONCATALOGID] = @TRANSLATIONFUNCTIONCATALOGID,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE
      where
        [ID] = @ID;
    end
    else
    begin
      insert into dbo.[MKTAPPEALRECORDSOURCE] (
        [ID],
        [QUERYVIEWCATALOGID],
        [APPEALIDFIELD],
        [DESCRIPTIONFIELD],
        [INACTIVEFIELD],
        [STARTDATEFIELD],
        [ENDDATEFIELD],
        [SEARCHLISTCATALOGID],
        [TRANSLATIONFUNCTIONCATALOGID],
        [ADDEDBYID],
        [DATEADDED],
        [CHANGEDBYID],
        [DATECHANGED]
      ) values (
        @ID,
        @QUERYVIEWCATALOGID,
        @APPEALIDFIELD,
        @DESCRIPTIONFIELD,
        @INACTIVEFIELD,
        @STARTDATEFIELD,
        @ENDDATEFIELD,
        @SEARCHLISTCATALOGID,
        @TRANSLATIONFUNCTIONCATALOGID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CHANGEAGENTID,
        @CURRENTDATE
      );
    end
  end try

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

  return 0;