USP_MKTSEGMENTATIONEXCLUSION_ADDEDIT

Edits/Adds a marketing effort's updated exclusions.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SEGMENTATIONID	uniqueidentifier	IN
@FILENAME	nvarchar(250)	IN
@SELECTIONNAME	nvarchar(250)	IN
@STATUSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MKTSEGMENTATIONEXCLUSION_ADDEDIT
(
  @ID uniqueidentifier = null output,
  @SEGMENTATIONID uniqueidentifier,
  @FILENAME nvarchar(250),
  @SELECTIONNAME nvarchar(250),
  @STATUSID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

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

  set @CURRENTDATE = GetDate();

  if exists(select 1 from dbo.[MKTSEGMENTATIONEXCLUSION] where [ID] = @ID)
  begin
    update 
      dbo.[MKTSEGMENTATIONEXCLUSION]
    set 
      [SEGMENTATIONID] = @SEGMENTATIONID,
      [FILENAME] = @FILENAME, 
      [SELECTIONNAME] = @SELECTIONNAME,
      [STATUSID] = @STATUSID,
      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = @CURRENTDATE
    where 
      [ID] = @ID;    
  end 
  else
  begin
    insert into dbo.[MKTSEGMENTATIONEXCLUSION] (
      [ID],
      [SEGMENTATIONID],
      [FILENAME],
      [SELECTIONNAME],
      [STATUSID],
      [ORIGINALQUANTITY],
      [DELETEDQUANTITY],
      [EXCEPTIONQUANTITY],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @SEGMENTATIONID,
      @FILENAME,
      @SELECTIONNAME,
      @STATUSID,
      0,
      0,
      0,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );
  end

  return 0;