USP_DATAFORMTEMPLATE_VIEW_MERCHANDISEVENDOR_PAGESUMMARY

The load procedure used by the view dataform template "Merchandise Vendor Page Summary View"

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.
@VENDORLOOKUPID	nvarchar(100)	INOUT	Lookup ID
@VENDORDESCRIPTION	nvarchar(255)	INOUT	Description
@VENDORWEBADDRESS	UDT_WEBADDRESS	INOUT	Website
@VENDORADDRESS	nvarchar(300)	INOUT	Address
@VENDORPHONE	nvarchar(100)	INOUT	Phone
@VENDOREMAIL	nvarchar(100)	INOUT	Email
@PICTURE	varbinary	INOUT	Image
@PRIMARYCONTACTNAME	nvarchar(154)	INOUT	Primary contact
@PRIMARYCONTACTADDRESS	nvarchar(300)	INOUT	Contact address
@PRIMARYCONTACTPHONE	nvarchar(100)	INOUT	Contact phone
@PRIMARYCONTACTEMAIL	nvarchar(100)	INOUT	Contact email
@ISACTIVE	bit	INOUT	Active

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MERCHANDISEVENDOR_PAGESUMMARY
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @VENDORLOOKUPID nvarchar(100) = null output,
                @VENDORDESCRIPTION nvarchar(255) = null output,
                @VENDORWEBADDRESS dbo.UDT_WEBADDRESS = null output,
                @VENDORADDRESS nvarchar(300) = null output,
                @VENDORPHONE nvarchar(100) = null output,
                @VENDOREMAIL nvarchar(100) = null output,
                @PICTURE varbinary(max) = null output,
                @PRIMARYCONTACTNAME nvarchar(154) = null output,
                @PRIMARYCONTACTADDRESS nvarchar(300) = null output,
                @PRIMARYCONTACTPHONE nvarchar(100) = null output,
                @PRIMARYCONTACTEMAIL nvarchar(100) = null output,
                @ISACTIVE bit = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select 
                    @DATALOADED = 1,
                    @VENDORLOOKUPID = C1.LOOKUPID,
                    @VENDORDESCRIPTION = V.DESCRIPTION,
                    @VENDORWEBADDRESS = C1.WEBADDRESS,
                    @VENDORADDRESS = A.DESCRIPTION,
                    @VENDORPHONE = P1.NUMBER,
                    @VENDOREMAIL = E1.EMAILADDRESS,
                    @PICTURE = C1.PICTURE,
                    @PRIMARYCONTACTNAME = C2.NAME,
                    @PRIMARYCONTACTADDRESS = A2.DESCRIPTION,
                    @PRIMARYCONTACTPHONE = P2.NUMBER,
                    @PRIMARYCONTACTEMAIL = E2.EMAILADDRESS,
                    @ISACTIVE = ~C1.ISINACTIVE
                from dbo.VENDOR V
                inner join dbo.CONSTITUENT C1 on C1.ID = V.ID
                left outer join dbo.RELATIONSHIP R on R.RELATIONSHIPCONSTITUENTID = V.ID and ISPRIMARYCONTACT = 1
                left outer join dbo.CONSTITUENT C2 on C2.ID = R.RECIPROCALCONSTITUENTID
                left outer join dbo.ADDRESS A on A.CONSTITUENTID = C1.ID and A.ISPRIMARY = 1
                left outer join dbo.ADDRESS A2 on A2.RELATIONSHIPID = R.ID
                left outer join dbo.PHONE P1 on P1.CONSTITUENTID = C1.ID and P1.ISPRIMARY = 1
                left outer join dbo.PHONE P2 on P2.RELATIONSHIPID = R.ID
                left outer join dbo.EMAILADDRESS E1 on E1.CONSTITUENTID = C1.ID and E1.ISPRIMARY = 1
                left outer join dbo.EMAILADDRESS E2 on E2.RELATIONSHIPID = R.ID
                where V.ID = @ID

                return 0;