USP_DATAFORMTEMPLATE_EDIT_MKTMARKETINGPLANMAILINGDETAILS_2

The save procedure used by the edit dataform template "Marketing Plan Marketing Effort Details Edit Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@CODE	nvarchar(10)	IN	Code
@GOALS	nvarchar(max)	IN	Goals
@PLANITEMCATEGORYCODEID	uniqueidentifier	IN	Category
@STARTDATE	UDT_FUZZYDATE	IN	Start date
@ENDDATE	UDT_FUZZYDATE	IN	End date
@SOURCECODEID	uniqueidentifier	IN	Source code
@ITEMLIST	xml	IN	Items
@CHANNELCODE	tinyint	IN	Channel
@MAILDATE	datetime	IN	Mail date

Definition

Copy



          CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTMARKETINGPLANMAILINGDETAILS_2]
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @NAME nvarchar(100),
            @CODE nvarchar(10) ,
            @GOALS nvarchar(max) ,
            @PLANITEMCATEGORYCODEID uniqueidentifier,
            @STARTDATE dbo.UDT_FUZZYDATE,
            @ENDDATE dbo.UDT_FUZZYDATE,
            @SOURCECODEID uniqueidentifier,
            @ITEMLIST xml,
            @CHANNELCODE tinyint,
            @MAILDATE datetime
          )
          as
            set NOCOUNT on;

            declare @CURRENTDATE datetime;

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

              set @CURRENTDATE = getdate();

              -- save the template items

              update
                dbo.[MKTMARKETINGPLANITEM]
              set
                [NAME] = @NAME,
                [CODE] = @CODE,
                [GOALS] = @GOALS,
                [PLANITEMCATEGORYCODEID] = @PLANITEMCATEGORYCODEID,
                [STARTDATE] = @STARTDATE,
                [ENDDATE] = @ENDDATE,
                [SOURCECODEID] = @SOURCECODEID,
                [MAILDATE] = @MAILDATE,
                [CHANGEDBYID] = @CHANGEAGENTID,
                [DATECHANGED] = @CURRENTDATE
              where
                [ID] = @ID;

              exec dbo.USP_MKTPLANSOURCECODEPART_GETITEMLIST_UPDATEFROMXML @id, @ITEMLIST, @CHANGEAGENTID, @CURRENTDATE;

              --update the name on mailings based on this plan item

              update 
                dbo.[MKTSEGMENTATION]
              set 
                [NAME] = @NAME,
                [CHANGEDBYID] = @CHANGEAGENTID,
                [DATECHANGED] = @CURRENTDATE
              where
                [MARKETINGPLANITEMID] = @ID;

            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

            return 0;