USP_VENDOR_EMAIL_ADD

Wraps inserting initial Email addresses to Constituents as used by Vendors

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN

Definition

Copy



create procedure dbo.USP_VENDOR_EMAIL_ADD
(
  @ID uniqueidentifier
  ,@CHANGEAGENTID uniqueidentifier
  ,@CURRENTDATE datetime

  ,@EMAILADDRESSTYPECODEID uniqueidentifier = null
  ,@EMAILADDRESS dbo.UDT_EMAILADDRESS = ''
)
as
begin
    /*Start Primary Email Address */
    if (@EMAILADDRESSTYPECODEID is not null) or (coalesce(@EMAILADDRESS,'') <> '')
    begin
        insert into dbo.EMAILADDRESS
        (
      CONSTITUENTID
      ,EMAILADDRESSTYPECODEID
      ,EMAILADDRESS
      ,ISPRIMARY
      ,ADDEDBYID
      ,CHANGEDBYID
      ,DATEADDED
      ,DATECHANGED
        )
        values
        (
            @ID
            ,@EMAILADDRESSTYPECODEID
            ,@EMAILADDRESS
            ,1
            ,@CHANGEAGENTID
            ,@CHANGEAGENTID
            ,@CURRENTDATE
            ,@CURRENTDATE
        );
    end
    /*End Primary Email Address */
end