USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTTIMESLOT_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@SEGMENTCATEGORYCODEID	uniqueidentifier	IN
@CODE	nvarchar(10)	IN
@CODEVALUEID	uniqueidentifier	IN
@PARENTMEDIAOUTLETSEGMENTID	uniqueidentifier	IN
@SCHEDULESTARTTIME	time	IN
@SCHEDULEENDTIME	time	IN
@SCHEDULEDURATIONHOURS	int	IN
@SCHEDULEDURATIONMINUTES	int	IN
@SCHEDULEDURATIONSECONDS	int	IN
@IMPRESSIONS	int	IN
@IMPRESSIONCALCULATIONMETHODCODE	tinyint	IN
@GROUPS	xml	IN
@ALLOWCODEUPDATE	bit	IN

Definition

Copy



create procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTTIMESLOT_1]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @QUERYVIEWCATALOGID uniqueidentifier,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @SEGMENTCATEGORYCODEID uniqueidentifier,
  @CODE nvarchar(10),
  @CODEVALUEID uniqueidentifier,
  @PARENTMEDIAOUTLETSEGMENTID uniqueidentifier,
  @SCHEDULESTARTTIME time(0),
  @SCHEDULEENDTIME time(0),
  @SCHEDULEDURATIONHOURS integer,
  @SCHEDULEDURATIONMINUTES integer,
  @SCHEDULEDURATIONSECONDS integer,
  @IMPRESSIONS integer,
  @IMPRESSIONCALCULATIONMETHODCODE tinyint,
  @GROUPS xml,
  @ALLOWCODEUPDATE bit  
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

    -- save the segment

    exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENT_2] @ID, @CHANGEAGENTID, @NAME, @DESCRIPTION, @SEGMENTCATEGORYCODEID, @CODE, @QUERYVIEWCATALOGID, null, null, @ALLOWCODEUPDATE, @CODEVALUEID;

    select 
      @CURRENTDATE = [DATECHANGED]
    from dbo.[MKTSEGMENT] 
    where [ID] = @ID;

    update dbo.[MKTSEGMENTPASSIVE] set
      [PARENTMEDIAOUTLETSEGMENTID]  = @PARENTMEDIAOUTLETSEGMENTID,
      [SCHEDULESTARTTIME] = @SCHEDULESTARTTIME,
      [SCHEDULEENDTIME] = @SCHEDULEENDTIME,
      [SCHEDULEDURATION] = (@SCHEDULEDURATIONHOURS * 3600) + (@SCHEDULEDURATIONMINUTES * 60) + @SCHEDULEDURATIONSECONDS,
      [IMPRESSIONS] = @IMPRESSIONS,
      [IMPRESSIONCALCULATIONMETHODCODE] = @IMPRESSIONCALCULATIONMETHODCODE
    where [ID] = @ID;

    delete from dbo.[MKTGROUPSEGMENTS] where [SEGMENTID] = @ID;

    insert into dbo.[MKTGROUPSEGMENTS]
    (
      [ID],
      [SEGMENTID],
      [SEGMENTGROUPID],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    )
    select
      newid(),
      @ID,
      T.c.value('(SEGMENTGROUPID)[1]', 'uniqueidentifier'),
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    from @GROUPS.nodes('/GROUPS/ITEM') T(c)
    where T.c.value('(SEGMENTGROUPSELECTED)[1]', 'bit') = 1;
  end try

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

  return 0;