USP_DATAFORMTEMPLATE_EDIT_SIMPLEACKNOWLEDGEMENTLETTER

This procedure saves the communication letters associated with a simple acknowledgement.

Parameters

Parameter	Parameter Type	Mode
@SIMPLEACKNOWLEDGEMENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN
@LETTERS	xml	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SIMPLEACKNOWLEDGEMENTLETTER(
    @SIMPLEACKNOWLEDGEMENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MAILEXPORTDEFINITIONID uniqueidentifier = null,
    @EMAILEXPORTDEFINITIONID uniqueidentifier = null,
    @LETTERS xml = null
)
as
begin
    declare @CURRENTDATE datetime = getDate();
    declare @ACTIVE bit = 0;

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

    select
        @ACTIVE = ACTIVE
    from
        dbo.MKTSEGMENTATION
    where
        ID = @SIMPLEACKNOWLEDGEMENTID;

    -- Rollback active mailings before you can update move segmentation segments around

    if @ACTIVE = 1 or dbo.UFN_MKTSEGMENTATION_HASACTIVESEGMENTS(@SIMPLEACKNOWLEDGEMENTID) = 1
        exec dbo.USP_MKTSEGMENTATIONACTIVATE_ROLLBACK @SIMPLEACKNOWLEDGEMENTID, @CHANGEAGENTID, 1, 1;

  if exists(select ID from dbo.SIMPLEACKNOWLEDGEMENT where ID = @SIMPLEACKNOWLEDGEMENTID) 
    begin
        update 
        dbo.SIMPLEACKNOWLEDGEMENT 
      set
            EXPORTDEFINITIONID = @MAILEXPORTDEFINITIONID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where
            ID = @SIMPLEACKNOWLEDGEMENTID;
      end 
  else
    begin
      insert into 
        dbo.SIMPLEACKNOWLEDGEMENT (ID, EXPORTDEFINITIONID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
      values
        (@SIMPLEACKNOWLEDGEMENTID, @MAILEXPORTDEFINITIONID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
    end

    exec dbo.USP_COMMUNICATIONS_CREATEORUPDATE_LETTERS @SIMPLEACKNOWLEDGEMENTID, @CURRENTAPPUSERID, @CHANGEAGENTID, 0, @MAILEXPORTDEFINITIONID, @EMAILEXPORTDEFINITIONID, @LETTERS;
end