USP_DATAFORMTEMPLATE_EDITLOAD_CRM_BBPAY_TEMPLATE

The load procedure used by the edit dataform template "CRM BBPay Template Edit Form"

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.
@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.
@HTMLSOURCE	nvarchar(max)	INOUT	Htmlsource
@CSSSOURCE	nvarchar(max)	INOUT	Csssource
@IMAGEPLACEHOLDERS	xml	INOUT	Imageplaceholders
@CLIENTSITESID	int	INOUT	Clientsites
@SITECONTENTID	int	INOUT
@SITEPAGEID	int	INOUT
@DELIVERYCHANNELID	uniqueidentifier	INOUT
@ENVIRONMENTTEMPLATEID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CRM_BBPAY_TEMPLATE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @HTMLSOURCE nvarchar(max) = null output,
    @CSSSOURCE nvarchar(max) = null output,
    @IMAGEPLACEHOLDERS xml = null output,
    @CLIENTSITESID integer = null output,
    @SITECONTENTID integer = null output,
    @SITEPAGEID integer = null output,
    @DELIVERYCHANNELID uniqueidentifier = null output,
    @ENVIRONMENTTEMPLATEID uniqueidentifier = null output

    )
as

set nocount on;

-- be sure to set these, in case the select returns no rows
set @DATALOADED = 0
set @TSLONG = 0

select
    @DATALOADED = 1,
    @TSLONG = C.TSLONG,
    @HTMLSOURCE = HTMLSOURCE,
    @CSSSOURCE = CSSSOURCE,
    @IMAGEPLACEHOLDERS = IMAGEPLACEHOLDERS,
    @CLIENTSITESID = CLIENTSITESID,
    @SITECONTENTID = SITECONTENTID,
    @SITEPAGEID = SITEPAGEID,
    @DELIVERYCHANNELID = DELIVERYCHANNELID,
    @ENVIRONMENTTEMPLATEID = E.ID
from 
    dbo.CRMBBPAYTEMPLATE C
    left join dbo.BBPAYENVIRONMENTTEMPLATE BBET on C.ID = BBET.TEMPLATEID
    left join dbo.CRMBBENVIRONMENT E on BBET.ENVIRONMENTID = E.ID and E.ISACTIVE = 1
where 
    C.ID = @ID

return 0;