USP_DATAFORMTEMPLATE_EDIT_MKTSEED

The save procedure used by the edit dataform template "Seed Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@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	ZIP
@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

Definition

Copy



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

  declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = GetDate();

    /* Update the seed information */
    update
      dbo.[MKTSEED]
    set
      [FIRSTNAME] = @FIRSTNAME,
      [MIDDLENAME] = @MIDDLENAME,
      [LASTNAME] = @LASTNAME,
      [TITLECODEID] = @TITLECODEID,
      [SUFFIXCODEID] = @SUFFIXCODEID,
      [COUNTRYID] = @COUNTRYID,
      [ADDRESSBLOCK] = @ADDRESSBLOCK,
      [CITY] = @CITY,
      [STATEID] = @STATEID,
      [POSTCODE] = @POSTCODE,
      [CART] = @CART,
      [DPC] = @DPC,
      [LOT] = @LOT,
      [PHONENUMBER] = @PHONENUMBER,
      [EMAILADDRESS] = @EMAILADDRESS,
      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = @CURRENTDATE
    where
      [ID] = @ID;
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;