USP_MKTFINDERFILE_ADD_SAVE

Adds a new finder file.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@SEGMENTATIONID	uniqueidentifier	IN
@VENDORID	uniqueidentifier	IN
@FINDERFILECATEGORYCODEID	uniqueidentifier	IN
@ORDERDATE	datetime	IN
@EXPIRATIONDATE	datetime	IN
@QUANTITY	int	IN
@LISTLAYOUTID	uniqueidentifier	IN
@FILENAME	nvarchar(255)	IN

Definition

Copy



create procedure dbo.[USP_MKTFINDERFILE_ADD_SAVE]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @SEGMENTATIONID uniqueidentifier = null,
  @VENDORID uniqueidentifier = null,
  @FINDERFILECATEGORYCODEID uniqueidentifier = null,
  @ORDERDATE datetime = null,
  @EXPIRATIONDATE datetime = null,
  @QUANTITY int = null,
  @LISTLAYOUTID uniqueidentifier = null,
  @FILENAME nvarchar(255) = ''
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

  begin try  
    set @CURRENTDATE = getdate();

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

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

    insert into dbo.[MKTFINDERFILEIMPORTPROCESS] (
      [ID],
      [SEGMENTATIONID],
      [VENDORID],
      [CATEGORYCODEID],
      [ORDERDATE],
      [EXPIRATIONDATE],
      [LISTLAYOUTID],
      [FILENAME],
      [QUANTITY],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @SEGMENTATIONID,
      @VENDORID,
      @FINDERFILECATEGORYCODEID,
      @ORDERDATE,
      @EXPIRATIONDATE,
      @LISTLAYOUTID,
      @FILENAME,
      @QUANTITY,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );

  end try

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

  return 0;