USP_DATAFORMTEMPLATE_EDIT_MKTCOMMUNICATIONNAMESCHEME

CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTCOMMUNICATIONNAMESCHEME]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @NAME nvarchar(100),
  @SITEID uniqueidentifier,
  @NAMEPARTS xml
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();

  begin try

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

    -- Edit the name pattern parts...

    exec dbo.[USP_MKTCOMMUNICATIONNAMESCHEME_GETNAMEPARTS_UPDATEFROMXML] @ID, @NAMEPARTS, @CHANGEAGENTID, @CURRENTDATE;

    /* update changed table */
    if exists(select 1 from dbo.[MKTCOMMUNICATIONNAMESCHEMEEXAMPLE] where [ID] = @ID and [HASCHANGED] = 0)
      update
        dbo.[MKTCOMMUNICATIONNAMESCHEMEEXAMPLE]
      set
        [HASCHANGED] = 1
      where
        [ID] = @ID;

  end try

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

  return 0;