USP_DATAFORMTEMPLATE_VIEW_SYSTEMSETTINGS

The load procedure used by the view dataform template "System Settings Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@STATUSMEMBERSHIPS	nvarchar(3)	INOUT	membership programs available
@STATUSCONSTITUENCIES	nvarchar(3)	INOUT	user-defined constituencies available
@STATUSLOCATIONS	nvarchar(3)	INOUT	locations available
@STATUSPROGRAMCATAGORIES	nvarchar(3)	INOUT	program categories available
@STATUSMEMBERSHIPLEVELS	nvarchar(3)	INOUT	membership levels available

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SYSTEMSETTINGS
(
    @DATALOADED bit = 0 output,
    @STATUSMEMBERSHIPS nvarchar(3) = null output,
    @STATUSCONSTITUENCIES nvarchar(3) = null output,
    @STATUSLOCATIONS nvarchar(3) = null output,
    @STATUSPROGRAMCATAGORIES nvarchar(3) = null output,
    @STATUSMEMBERSHIPLEVELS nvarchar(3) = null output
)
as
    set nocount on;

    --Many variables are nvarchar instead of int; this is to facilitate string replacement in the UI


    set @DATALOADED = 1
    set @STATUSMEMBERSHIPS = (select count(*) from dbo.MEMBERSHIPPROGRAM where ISACTIVE = 1);
    set @STATUSMEMBERSHIPLEVELS = (select count(*) from dbo.MEMBERSHIPLEVEL where ISACTIVE = 1);
    set @STATUSCONSTITUENCIES = (select count(*) from dbo.CONSTITUENCYCODE where ACTIVE = 1);
    set @STATUSLOCATIONS = (select count(*) from dbo.EVENTLOCATION);
    set @STATUSPROGRAMCATAGORIES = (select count(*) from dbo.PROGRAMCATEGORYCODE where ACTIVE = 1);

    return 0;