USP_DATAFORMTEMPLATE_ADD_MKTMEMBERSHIPMAILINGTEMPLATEASKLADDEROVERRIDE

The save procedure used by the add dataform template "Membership Renewal Effort Template Ask Ladder Override Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@MEMBERSHIPMAILINGTEMPLATEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@ASKLADDERID	uniqueidentifier	IN	Ask ladder

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTMEMBERSHIPMAILINGTEMPLATEASKLADDEROVERRIDE]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier,
  @IDSETREGISTERID uniqueidentifier,
  @ASKLADDERID uniqueidentifier
)
as

set nocount on;

declare @CURRENTDATE datetime;
declare @SEQUENCE int;

begin try
  if @ID is null
    set @ID = NewID();

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

  set @CURRENTDATE = getdate();

  select 
    @SEQUENCE = isnull(max([SEQUENCE]),0) + 1
  from dbo.[MKTMEMBERSHIPMAILINGTEMPLATEASKLADDEROVERRIDE]
  where [MEMBERSHIPMAILINGTEMPLATEID] = @MEMBERSHIPMAILINGTEMPLATEID;

  insert into dbo.[MKTMEMBERSHIPMAILINGTEMPLATEASKLADDEROVERRIDE] (
    [ID],
    [MEMBERSHIPMAILINGTEMPLATEID],
    [IDSETREGISTERID],
    [ASKLADDERID],
    [SEQUENCE],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED]
  ) values (
    @ID,
    @MEMBERSHIPMAILINGTEMPLATEID,
    @IDSETREGISTERID,
    @ASKLADDERID,
    @SEQUENCE,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE
  );
end try

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

return 0;