USP_MKTCONSTITUENTFILEIMPORT_ADD_SAVE

Adds a new constituent file import.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@SEGMENTATIONID	uniqueidentifier	IN
@CONSTITUENTFILECATEGORYCODEID	uniqueidentifier	IN
@QUANTITY	int	IN
@LISTLAYOUTID	uniqueidentifier	IN
@FILENAME	nvarchar(255)	IN
@RECORDSOURCEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTCONSTITUENTFILEIMPORT_ADD_SAVE]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @SEGMENTATIONID uniqueidentifier = null,
  @CONSTITUENTFILECATEGORYCODEID uniqueidentifier = null,
  @QUANTITY int = null,
  @LISTLAYOUTID uniqueidentifier = null,
  @FILENAME nvarchar(255) = '',
  @RECORDSOURCEID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;
  declare @RECORDTYPEID uniqueidentifier;

  begin try  
    set @CURRENTDATE = getdate();

    if @ID is null
      set @ID = newid();

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

    select @RECORDTYPEID = [RECORDTYPEID] from dbo.[QUERYVIEWCATALOG] where [ID] = @RECORDSOURCEID;

    insert into dbo.[MKTCONSTITUENTFILEIMPORTPROCESS] (
      [ID],
      [SEGMENTATIONID],
      [RECORDTYPEID],
      [LISTLAYOUTID],
      [CATEGORYCODEID],
      [FILENAME],
      [QUANTITY],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @SEGMENTATIONID,
      @RECORDTYPEID,
      @LISTLAYOUTID,
      @CONSTITUENTFILECATEGORYCODEID,
      @FILENAME,
      @QUANTITY,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );

  end try

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

  return 0;