USP_DATAFORMTEMPLATE_EDITLOAD_COUNTRY_4

The load procedure used by the edit dataform template "Country Edit Form 4"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DESCRIPTION	nvarchar(100)	INOUT	Description
@ABBREVIATION	nvarchar(5)	INOUT	Abbreviation
@COUNTRYADDRESSFORMATID	uniqueidentifier	INOUT	Address format
@INACTIVE	bit	INOUT	Inactive
@ALLOWVALIDATION	bit	INOUT	Allow address validation
@VALIDATIONCOUNTRYCODE	tinyint	INOUT	Validate as
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@ADDRESSLABEL	nvarchar(25)	INOUT	Address label
@CITYLABEL	nvarchar(25)	INOUT	City label
@REGIONLABEL	nvarchar(25)	INOUT	State label
@POSTCODELABEL	nvarchar(25)	INOUT	Postcode label
@DPCLABEL	nvarchar(25)	INOUT	DPC label
@CARTLABEL	nvarchar(25)	INOUT	CART label
@LOTLABEL	nvarchar(25)	INOUT	LOT label
@COUNTYLABEL	nvarchar(25)	INOUT	County label
@CONGRESSIONALDISTRICTLABEL	nvarchar(25)	INOUT	Congressional district label
@STATEHOUSEDISTRICTLABEL	nvarchar(25)	INOUT	State house district label
@STATESENATEDISTRICTLABEL	nvarchar(25)	INOUT	State senate district label
@LOCALPRECINCTLABEL	nvarchar(25)	INOUT	Local precinct label
@DEFAULT	bit	INOUT	Default
@PHONEFORMATCODE	tinyint	INOUT	Phone format
@COUNTRYCODE	nvarchar(10)	INOUT	Phone country code
@ISO3166	nvarchar(2)	INOUT	ISO 3166 two-letter code

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COUNTRY_4 (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @DESCRIPTION nvarchar(100)  = null output,
    @ABBREVIATION nvarchar(5)  = null output,
    @COUNTRYADDRESSFORMATID uniqueidentifier = null output,
    @INACTIVE bit = null output,
    @ALLOWVALIDATION bit = null output,
    @VALIDATIONCOUNTRYCODE tinyint = null output,
    @TSLONG bigint = 0 output,
    @ADDRESSLABEL nvarchar(25) = null output,
    @CITYLABEL nvarchar(25) = null output,
    @REGIONLABEL nvarchar(25) = null output,
    @POSTCODELABEL nvarchar(25) = null output,
    @DPCLABEL nvarchar(25) = null output,
    @CARTLABEL nvarchar(25) = null output,
    @LOTLABEL nvarchar(25) = null output,
    @COUNTYLABEL nvarchar(25) = null output,
    @CONGRESSIONALDISTRICTLABEL nvarchar(25) = null output,
    @STATEHOUSEDISTRICTLABEL nvarchar(25) = null output,
    @STATESENATEDISTRICTLABEL nvarchar(25) = null output,
    @LOCALPRECINCTLABEL nvarchar(25) = null output,
    @DEFAULT bit = null output,
    @PHONEFORMATCODE tinyint = null output,
    @COUNTRYCODE nvarchar(10) = null output,
    @ISO3166 nvarchar(2) = null output
)
as

set nocount on;

set @DATALOADED = 0
set @TSLONG = 0

select
    @DATALOADED = 1,
    @DESCRIPTION = dbo.COUNTRY.DESCRIPTION,
    @ABBREVIATION = dbo.COUNTRY.ABBREVIATION,
    @COUNTRYADDRESSFORMATID = dbo.COUNTRY.COUNTRYADDRESSFORMATID,
    @INACTIVE = ~ dbo.COUNTRY.ACTIVE,
    @ALLOWVALIDATION = dbo.COUNTRYVALIDATIONINFO.ALLOWVALIDATION,
    @VALIDATIONCOUNTRYCODE = dbo.COUNTRYVALIDATIONINFO.VALIDATIONCOUNTRYCODE,
    @TSLONG = dbo.COUNTRY.TSLONG,
    @ADDRESSLABEL = coalesce(COUNTRYADDRESSLABEL.ADDRESSLABEL,'Address'),
    @CITYLABEL = coalesce(COUNTRYADDRESSLABEL.CITYLABEL,'City'),
    @REGIONLABEL = coalesce(COUNTRYADDRESSLABEL.REGIONLABEL,'Province'),
    @POSTCODELABEL = coalesce(COUNTRYADDRESSLABEL.POSTCODELABEL,'Postcode'),
    @DPCLABEL = COUNTRYADDRESSLABEL.DPCLABEL,
    @CARTLABEL = COUNTRYADDRESSLABEL.CARTLABEL,
    @LOTLABEL = COUNTRYADDRESSLABEL.LOTLABEL,
    @COUNTYLABEL = COUNTRYADDRESSLABEL.COUNTYLABEL,
    @CONGRESSIONALDISTRICTLABEL = COUNTRYADDRESSLABEL.CONGRESSIONALDISTRICTLABEL,
    @STATEHOUSEDISTRICTLABEL = COUNTRYADDRESSLABEL.STATEHOUSEDISTRICTLABEL,
    @STATESENATEDISTRICTLABEL = COUNTRYADDRESSLABEL.STATESENATEDISTRICTLABEL,
    @LOCALPRECINCTLABEL = COUNTRYADDRESSLABEL.LOCALPRECINCTLABEL,
    @DEFAULT = case when [INTERNATIONALIZATIONINFO].[ID] is null then 0 else 1 end,
    @PHONEFORMATCODE = COUNTRY.PHONEFORMATCODE,
    @COUNTRYCODE = COUNTRY.COUNTRYCODE,
    @ISO3166 = COUNTRY.ISO3166
from dbo.COUNTRY
    left join dbo.COUNTRYADDRESSLABEL on COUNTRYADDRESSLABEL.COUNTRYID=COUNTRY.ID
    left outer join dbo.COUNTRYVALIDATIONINFO on COUNTRY.ID = COUNTRYVALIDATIONINFO.ID
    left outer join dbo.[INTERNATIONALIZATIONINFO] on [COUNTRY].[ID] = [INTERNATIONALIZATIONINFO].[DEFAULTCOUNTRYID]
where 
    COUNTRY.ID = @ID

if @ALLOWVALIDATION = 0 or @ALLOWVALIDATION is null 
    set @VALIDATIONCOUNTRYCODE = 1;

return 0;