USP_DATAFORMTEMPLATE_ADD_MKTSEED

The save procedure used by the add dataform template "Seed 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.
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@LASTNAME	nvarchar(100)	IN	Last name
@TITLECODEID	uniqueidentifier	IN	Title
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@COUNTRYID	uniqueidentifier	IN	Country
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(12)	IN	Post code
@CART	nvarchar(10)	IN	CART
@DPC	nvarchar(8)	IN	DPC
@LOT	nvarchar(5)	IN	LOT
@PHONENUMBER	nvarchar(100)	IN	Phone number
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@SITEID	uniqueidentifier	IN	Site

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEED]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @FIRSTNAME nvarchar(50) = '',
  @MIDDLENAME nvarchar(50) = '',
  @LASTNAME nvarchar(100) = '',
  @TITLECODEID uniqueidentifier = null,
  @SUFFIXCODEID uniqueidentifier = null,
  @COUNTRYID uniqueidentifier = null,
  @ADDRESSBLOCK nvarchar(150) = '',
  @CITY nvarchar(50) = '',
  @STATEID uniqueidentifier = null,
  @POSTCODE nvarchar(12) = '',
  @CART nvarchar(10) = '',
  @DPC nvarchar(8) = '',
  @LOT nvarchar(5) = '',
  @PHONENUMBER nvarchar(100) = '',
  @EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
  @SITEID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

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

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

    set @CURRENTDATE = GetDate();

    /* Insert the seed information */
    insert into dbo.[MKTSEED] (
      [ID],
      [FIRSTNAME],
      [MIDDLENAME],
      [LASTNAME],
      [TITLECODEID],
      [SUFFIXCODEID],
      [COUNTRYID],
      [ADDRESSBLOCK],
      [CITY],
      [STATEID],
      [POSTCODE],
      [CART],
      [DPC],
      [LOT],
      [PHONENUMBER],
      [EMAILADDRESS],
      [SITEID],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @FIRSTNAME,
      @MIDDLENAME,
      @LASTNAME,
      @TITLECODEID,
      @SUFFIXCODEID,
      @COUNTRYID,
      @ADDRESSBLOCK,
      @CITY,
      @STATEID,
      @POSTCODE,
      @CART,
      @DPC,
      @LOT,
      @PHONENUMBER,
      @EMAILADDRESS,
      @SITEID,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;