USP_DATAFORMTEMPLATE_EDITLOAD_INDIVIDUALCONSTITUENT_GIFTDATAENTRY

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@LASTNAME	nvarchar(100)	INOUT
@FIRSTNAME	nvarchar(50)	INOUT
@MIDDLENAME	nvarchar(50)	INOUT
@TITLECODEID	uniqueidentifier	INOUT
@SUFFIXCODEID	uniqueidentifier	INOUT
@NICKNAME	nvarchar(50)	INOUT
@MAIDENNAME	nvarchar(100)	INOUT
@MARITALSTATUSCODEID	uniqueidentifier	INOUT
@BIRTHDATE	UDT_FUZZYDATE	INOUT
@AGE	int	INOUT
@GENDERCODE	tinyint	INOUT
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	INOUT
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT
@ADDRESS_ADDRESSBLOCK	nvarchar(max)	INOUT
@ADDRESS_CITY	nvarchar(50)	INOUT
@ADDRESS_STATEID	uniqueidentifier	INOUT
@ADDRESS_POSTCODE	nvarchar(12)	INOUT
@ADDRESS_DONOTMAIL	bit	INOUT
@ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	INOUT
@PHONE_PHONETYPECODEID	uniqueidentifier	INOUT
@PHONE_NUMBER	nvarchar(100)	INOUT
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	INOUT
@PRIMARYADDRESSID	uniqueidentifier	INOUT
@PRIMARYPHONEID	uniqueidentifier	INOUT
@PRIMARYEMAILADDRESSID	uniqueidentifier	INOUT
@GIVESANONYMOUSLY	bit	INOUT
@PICTURE	varbinary	INOUT
@PICTURETHUMBNAIL	varbinary	INOUT
@PICTURECHANGED	bit	INOUT
@WEBADDRESS	UDT_WEBADDRESS	INOUT
@TITLE2CODEID	uniqueidentifier	INOUT
@SUFFIX2CODEID	uniqueidentifier	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_INDIVIDUALCONSTITUENT_GIFTDATAENTRY(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @LASTNAME nvarchar(100) = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @MIDDLENAME nvarchar(50) = null output,
    @TITLECODEID uniqueidentifier = null output,
    @SUFFIXCODEID uniqueidentifier = null output,
    @NICKNAME nvarchar(50) = null output,  
    @MAIDENNAME nvarchar(100) = null output,
    @MARITALSTATUSCODEID uniqueidentifier = null output,
    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,  
    @AGE int = null output,
    @GENDERCODE tinyint = null output,
    @ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null output,
    @ADDRESS_COUNTRYID uniqueidentifier = null output,
    @ADDRESS_ADDRESSBLOCK nvarchar(max) = null output,  
    @ADDRESS_CITY nvarchar(50) = null output,
    @ADDRESS_STATEID uniqueidentifier = null output,
    @ADDRESS_POSTCODE nvarchar(12) = null output,  
    @ADDRESS_DONOTMAIL bit = null output,
    @ADDRESS_DONOTMAILREASONCODEID uniqueidentifier = null output,
    @PHONE_PHONETYPECODEID uniqueidentifier = null output,  
    @PHONE_NUMBER nvarchar(100) = null output,
    @EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier = null output,
    @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @PRIMARYADDRESSID uniqueidentifier = null output,
    @PRIMARYPHONEID uniqueidentifier = null output,
    @PRIMARYEMAILADDRESSID uniqueidentifier = null output,
    @GIVESANONYMOUSLY bit = null output,
    @PICTURE varbinary(max) = null output,
      @PICTURETHUMBNAIL varbinary(max) = null output,
      @PICTURECHANGED bit = null output,
      @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
      @TITLE2CODEID uniqueidentifier = null output,
    @SUFFIX2CODEID uniqueidentifier = null output,
        @ZIPLOOKUPCOUNTRIES xml = null output,
        @VALIDATIONCOUNTRIES xml = null output    
)
as

    set nocount on;

    -- moved original code in the USP bellow, which is shared with other areas other then individual edit (duplicate search resolution screen)
        exec dbo.USP_INDIVIDUAL_EDITLOAD @ID, @DATALOADED output, @LASTNAME output, @FIRSTNAME output, @MIDDLENAME output, @MAIDENNAME output, @NICKNAME output, 
                                     @TITLECODEID output, @SUFFIXCODEID output, @GENDERCODE output, @BIRTHDATE output, @AGE output, @GIVESANONYMOUSLY output, 
                                     @PICTURE output, @PICTURETHUMBNAIL output, @PICTURECHANGED output, @WEBADDRESS output, @TSLONG output, @MARITALSTATUSCODEID output,
                                     @TITLE2CODEID output, @SUFFIX2CODEID output, null;

    --get the primary address
    select
      @PRIMARYADDRESSID=ID,
      @ADDRESS_ADDRESSTYPECODEID=ADDRESSTYPECODEID,
      @ADDRESS_COUNTRYID=COUNTRYID,
      @ADDRESS_ADDRESSBLOCK=ADDRESSBLOCK,
      @ADDRESS_CITY=CITY,
      @ADDRESS_STATEID=STATEID,
      @ADDRESS_POSTCODE=POSTCODE,
      @ADDRESS_DONOTMAIL=DONOTMAIL,
      @ADDRESS_DONOTMAILREASONCODEID=DONOTMAILREASONCODEID
    from dbo.[ADDRESS]
    where CONSTITUENTID=@ID
    and ISPRIMARY=1

    --get the primary phone
    select
      @PRIMARYPHONEID=ID,
      @PHONE_PHONETYPECODEID=PHONETYPECODEID,
      @PHONE_NUMBER=NUMBER
    from dbo.[PHONE]
    where CONSTITUENTID=@ID
    and ISPRIMARY=1

    --get the primary email
    select
      @PRIMARYEMAILADDRESSID=ID,
      @EMAILADDRESS_EMAILADDRESSTYPECODEID=EMAILADDRESSTYPECODEID,
      @EMAILADDRESS_EMAILADDRESS=EMAILADDRESS
    from dbo.[EMAILADDRESS]
    where CONSTITUENTID=@ID
    and ISPRIMARY=1

    if @PRIMARYADDRESSID is null
          exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

        select @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
        select @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();

    return 0;