USP_DATAFORMTEMPLATE_VIEW_CAMPAIGN

The load procedure used by the view dataform template "Campaign Summary View 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.
@NAME	nvarchar(100)	INOUT	Name
@USERID	nvarchar(100)	INOUT	Lookup ID
@DESCRIPTION	nvarchar(300)	INOUT	Description
@SITE	nvarchar(max)	INOUT	Site
@TYPECODEID	uniqueidentifier	INOUT	Type code ID
@TYPEDESCRIPTION	nvarchar(100)	INOUT	Type
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@GIFTAIDQUALIFICATIONSTATUS	nvarchar(25)	INOUT	Gift Aid status
@CURRENCY	nvarchar(110)	INOUT	Currency
@ISACTIVE	bit	INOUT	ISACTIVE

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CAMPAIGN (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output,
    @USERID nvarchar(100) = null output,
    @DESCRIPTION nvarchar(300) = null output,
    @SITE nvarchar(max) = null output,
    @TYPECODEID uniqueidentifier = null output,
    @TYPEDESCRIPTION nvarchar(100) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @GIFTAIDQUALIFICATIONSTATUS nvarchar(25) = null output,
    @CURRENCY nvarchar(110) = null output,
  @ISACTIVE bit = null output
) as begin
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @NAME = CAMPAIGN.NAME,
        @DESCRIPTION = CAMPAIGN.DESCRIPTION,
        @SITE = (select
                    dbo.UDA_BUILDLIST(SITE.NAME)
                from
                    dbo.SITE
                    inner join dbo.CAMPAIGNSITE on CAMPAIGNSITE.SITEID = SITE.ID
                where
                    CAMPAIGNSITE.CAMPAIGNID = @ID
                ),
        @USERID = CAMPAIGN.USERID,
        @TYPECODEID = CAMPAIGNTYPECODE.ID,
        @TYPEDESCRIPTION = CAMPAIGNTYPECODE.DESCRIPTION,
        @STARTDATE = STARTDATE,
        @ENDDATE = ENDDATE,
        @CURRENCY = dbo.UFN_CURRENCY_GETDESCRIPTION(CAMPAIGN.BASECURRENCYID),
    @ISACTIVE = ISACTIVE

    from
        dbo.CAMPAIGN
    left outer join
        dbo.CAMPAIGNTYPECODE on CAMPAIGN.CAMPAIGNTYPECODEID = CAMPAIGNTYPECODE.ID
    where
        CAMPAIGN.ID = @ID;

     --Gift Aid is for UK only

    if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45fd-8F54-21FE9654EE2D') = 1
        set @GIFTAIDQUALIFICATIONSTATUS = dbo.UFN_CAMPAIGNQUALIFICATIONSTATUS(@ID)

    return 0;
end