USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANINCOMEFORECASTPREFERENCES

The save procedure used by the add dataform template "Marketing Plan Income Forecast Preferences Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@MONTH1RETURN	nvarchar(6)	IN	Month 1 Return
@MONTH2RETURN	nvarchar(6)	IN	Month 2 Return
@MONTH3RETURN	nvarchar(6)	IN	Month 3 Return
@MONTH4RETURN	nvarchar(6)	IN	Month 4 Return
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



create procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANINCOMEFORECASTPREFERENCES]
(
  @ID uniqueidentifier output,
  @MONTH1RETURN nvarchar(6) = '50.0',
  @MONTH2RETURN nvarchar(6) = '35.0',
  @MONTH3RETURN nvarchar(6) = '10.0',
  @MONTH4RETURN nvarchar(6) = '5.0',
  @CURRENTAPPUSERID uniqueidentifier
)
as
  set nocount on;

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

  set @ID = NEWID();

  declare @CHANGEAGENTID uniqueidentifier;
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @EXISTS int;
  select
    @EXISTS = P.[MONTH1RETURN]
  from
    dbo.[MKTMARKETINGPLANINCOMEFORECASTPREFERENCES] P
  where
    P.[APPUSERID] = @CURRENTAPPUSERID;

  if @EXISTS is null
  begin
    insert into dbo.[MKTMARKETINGPLANINCOMEFORECASTPREFERENCES] (
      [ID],
      [APPUSERID],
      [MONTH1RETURN],
      [MONTH2RETURN],
      [MONTH3RETURN],
      [MONTH4RETURN],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @CURRENTAPPUSERID,
      @MONTH1RETURN,
      @MONTH2RETURN,
      @MONTH3RETURN,
      @MONTH4RETURN,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );
  end
  else
  begin
    update
      dbo.[MKTMARKETINGPLANINCOMEFORECASTPREFERENCES]
    set
      [MONTH1RETURN] = @MONTH1RETURN,
      [MONTH2RETURN] = @MONTH2RETURN,
      [MONTH3RETURN] = @MONTH3RETURN,
      [MONTH4RETURN] = @MONTH4RETURN,
      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = @CURRENTDATE
    where
      [APPUSERID] = @CURRENTAPPUSERID;
  end

  return 0;