USP_IMPORTDELIMITEDFILETEMPLATE_EDIT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(250)	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@FILENAME	nvarchar(255)	IN
@SITEID	uniqueidentifier	IN
@DETAILCOLUMNMAP	xml	IN
@HASHEADERROW	bit	IN
@DETAILROWPREFIX	nvarchar(50)	IN
@BATCHSUMMARYPREFIX	nvarchar(50)	IN
@FILESUMMARYPREFIX	nvarchar(50)	IN
@FILEDELIMITER	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BATCHRECORDCOUNTCOLUMNNAME	nvarchar(250)	IN
@BATCHREVENUETOTALCOLUMNNAME	nvarchar(250)	IN
@FILERECORDCOUNTCOLUMNNAME	nvarchar(250)	IN
@FILEREVENUETOTALCOLUMNNAME	nvarchar(250)	IN
@DELIMITEDHEADERROW	nvarchar(max)	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTDELIMITEDFILETEMPLATE_EDIT
(
    @ID uniqueidentifier = null,
  @NAME nvarchar(250) = '',
    @BATCHTEMPLATEID uniqueidentifier = null,        
    @FILENAME nvarchar(255) = '',
  @SITEID uniqueidentifier = null,    
  @DETAILCOLUMNMAP xml = null,            
    @HASHEADERROW bit = 1,
  @DETAILROWPREFIX nvarchar(50) = '',
  @BATCHSUMMARYPREFIX nvarchar(50) = '',
  @FILESUMMARYPREFIX nvarchar(50) = '',
  @FILEDELIMITER nvarchar(50) = '',
  @CHANGEAGENTID uniqueidentifier = null,
  @BATCHRECORDCOUNTCOLUMNNAME nvarchar(250) = '',
  @BATCHREVENUETOTALCOLUMNNAME nvarchar(250) = '',
  @FILERECORDCOUNTCOLUMNNAME nvarchar(250) = '',
  @FILEREVENUETOTALCOLUMNNAME nvarchar(250) = '',
  @DELIMITEDHEADERROW nvarchar(max) = ''
)
with execute as caller
as

    set nocount on;

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

  declare @CURRENTDATE datetime = getdate()

    begin try
        update  
      dbo.IMPORTFILETEMPLATE 
    set            
            NAME = @NAME,
        BATCHTEMPLATEID = @BATCHTEMPLATEID,        
        FILENAME = @FILENAME,
      SITEID = @SITEID,    
      DETAILCOLUMNMAP = @DETAILCOLUMNMAP,            
        HASHEADERROW = @HASHEADERROW,
      DETAILROWPREFIX = @DETAILROWPREFIX,
      BATCHSUMMARYPREFIX = @BATCHSUMMARYPREFIX,
      FILESUMMARYPREFIX = @FILESUMMARYPREFIX,
      FILEDELIMITER = @FILEDELIMITER,
      BATCHRECORDCOUNTCOLUMNNAME = @BATCHRECORDCOUNTCOLUMNNAME,
      BATCHREVENUETOTALCOLUMNNAME = @BATCHREVENUETOTALCOLUMNNAME,
      FILERECORDCOUNTCOLUMNNAME = @FILERECORDCOUNTCOLUMNNAME,
      FILEREVENUETOTALCOLUMNNAME = @FILEREVENUETOTALCOLUMNNAME,
      DELIMITEDHEADERROW = @DELIMITEDHEADERROW,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE
    where
      ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;