USP_MEMBERSHIPRENEWALEFFORTMAILINGPROCESS_SAVE

Saves information about membership renewal effort process.

Parameters

Parameter	Parameter Type	Mode
@MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID	uniqueidentifier	IN
@MEMBERSHIPMAILINGPROCESSSTATUSID	uniqueidentifier	IN
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MEMBERSHIPRENEWALEFFORTMAILINGPROCESS_SAVE
(
  @MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID uniqueidentifier,
  @MEMBERSHIPMAILINGPROCESSSTATUSID uniqueidentifier,
  @MEMBERSHIPPROGRAMID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = getdate();

    declare @SEGMENTATIONEXPORTPROCESSSTATUSID uniqueidentifier

    select top 1 @SEGMENTATIONEXPORTPROCESSSTATUSID = [MKTSEGMENTATIONEXPORTPROCESSSTATUS].[ID]
    from dbo.[BUSINESSPROCESSSTATUS]
    inner join dbo.[APPUSER] 
        on [APPUSER].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
    inner join dbo.[MKTSEGMENTATIONEXPORTPROCESSSTATUS] 
        on [MKTSEGMENTATIONEXPORTPROCESSSTATUS].[ID] = [BUSINESSPROCESSSTATUS].[ID]
    inner join dbo.[MKTSEGMENTATIONEXPORTPROCESS] 
        on [MKTSEGMENTATIONEXPORTPROCESS].[ID] = [MKTSEGMENTATIONEXPORTPROCESSSTATUS].[PARAMETERSETID] 
    inner join dbo.[MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION] 
        on [MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION].[SEGMENTATIONID] = [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID] 
    where [MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION].[MEMBERSHIPMAILINGPROCESSSTATUSID] = @MEMBERSHIPMAILINGPROCESSSTATUSID
        and [APPUSER].[ID] = @CURRENTAPPUSERID
    order by [BUSINESSPROCESSSTATUS].[STARTEDON] desc;

    insert into dbo.[MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS] (
      [ID],
      [MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID],
      [MEMBERSHIPMAILINGPROCESSSTATUSID],
      [SEGMENTATIONEXPORTPROCESSSTATUSID],
      [MEMBERSHIPPROGRAMID],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      newid(),
      @MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID,
      @MEMBERSHIPMAILINGPROCESSSTATUSID,
      @SEGMENTATIONEXPORTPROCESSSTATUSID,
      @MEMBERSHIPPROGRAMID,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );
  end try

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

  return 0;