USP_MKTEXPORTDEFINITION2_SAVE

CREATE procedure dbo.[USP_MKTEXPORTDEFINITION2_SAVE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @POSTALTEMPLATEID uniqueidentifier,
  @PREVIEWDATALISTCATALOGID uniqueidentifier,
  @NETCOMMUNITYDATASOURCEID integer
)
as
  begin
    set nocount on;

    declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = getdate();

    if exists (select top 1 1 from dbo.[MKTEXPORTDEFINITION] where [EXPORTDEFINITIONID] = @ID)
      update dbo.[MKTEXPORTDEFINITION] set
        [POSTALTEMPLATEID] = @POSTALTEMPLATEID,
        [PREVIEWDATALISTCATALOGID] = @PREVIEWDATALISTCATALOGID,
        [NETCOMMUNITYDATASOURCEID] = isnull(@NETCOMMUNITYDATASOURCEID, 0),
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE
      where [EXPORTDEFINITIONID] = @ID
    else
      insert into dbo.[MKTEXPORTDEFINITION]
      (
        [ID],
        [NAME],
        [EXPORTDEFINITIONID],
        [MAILINGTYPECODE],
        [POSTALTEMPLATEID],
        [PREVIEWDATALISTCATALOGID],
        [NETCOMMUNITYDATASOURCEID],
        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED]
      )
      values
      (
        newid(),
        convert(nvarchar(36), @ID),
        @ID,
        dbo.[UFN_MKTEXPORTDEFINITION_GETMAILINGTYPECODEFROMID](@ID),
        @POSTALTEMPLATEID,
        @PREVIEWDATALISTCATALOGID,
        isnull(@NETCOMMUNITYDATASOURCEID, 0),
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
      );

    if not @PREVIEWDATALISTCATALOGID is null
      exec dbo.[USP_MKTEXPORTDEFINITION_ADDTOSYSTEMROLEPERM_DATALIST] @ID, @PREVIEWDATALISTCATALOGID, @CHANGEAGENTID;

    return 0;
  end