USP_DATAFORMTEMPLATE_EDITLOAD_FAFNFG

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@NAME	nvarchar(200)	INOUT
@NFGTYPECODEID	uniqueidentifier	INOUT
@SITEREQUIRED	bit	INOUT
@ORGANIZATIONCONSTITUENTID	uniqueidentifier	INOUT
@CONTACTID	uniqueidentifier	INOUT
@SITES	xml	INOUT
@ALLOWOTHERSJOINFROMGROUPPAGE	bit	INOUT
@ALLOWCOMPANIESJOINFROMGROUPPAGE	bit	INOUT
@ALLOWGROUPSCHOOSEHIERARCHYLEVEL	bit	INOUT
@TOTALREVENUEGOAL	money	INOUT
@TOTALDONORSGOAL	int	INOUT
@PARTICIPANTSRECRECRUITMENTGOAL	int	INOUT
@PARTICIPANTSRETAINEDGOAL	decimal(18, 0)	INOUT
@FAFGROUPSRECRUITMENTGOAL	int	INOUT
@FAFGROUPSRETAINEDGOAL	decimal(18, 0)	INOUT
@COMMUNICATIONSTOSEND	int	INOUT
@GROUPCONSTITUENTID	uniqueidentifier	INOUT
@ROOTLEVELID	uniqueidentifier	INOUT
@NOTMATCH	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FAFNFG(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
     @TSLONG bigint = 0 output,
    @CURRENTAPPUSERID uniqueidentifier,
    @NAME nvarchar(200) = null output,
    @NFGTYPECODEID uniqueidentifier = null output,
    @SITEREQUIRED bit = null output,
    @ORGANIZATIONCONSTITUENTID uniqueidentifier = null output,
    @CONTACTID uniqueidentifier = null output,
    @SITES xml = null output,
    @ALLOWOTHERSJOINFROMGROUPPAGE bit = null output,
    @ALLOWCOMPANIESJOINFROMGROUPPAGE bit = null output,
    @ALLOWGROUPSCHOOSEHIERARCHYLEVEL bit = null output,
   --- @ALLOWOTHERSJOINFROMLOCALWEBSITE bit = null output,
   --- @ALLOWCOMPANIESJOINFROMLOCALWEBSITE bit = null output,
    @TOTALREVENUEGOAL    money = null output,
    @TOTALDONORSGOAL     int = null output,
    @PARTICIPANTSRECRECRUITMENTGOAL  int = null output,
    @PARTICIPANTSRETAINEDGOAL  decimal = null output,
    @FAFGROUPSRECRUITMENTGOAL  int = null output,
    @FAFGROUPSRETAINEDGOAL     decimal = null output,
    @COMMUNICATIONSTOSEND      int = null output,
    @GROUPCONSTITUENTID           uniqueidentifier = null output,
  @ROOTLEVELID uniqueidentifier = null output,
  @NOTMATCH bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 0
  set @NOTMATCH = 0
    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency
    -- can be considered.

  set @ROOTLEVELID = (select FAFNFGCAMPAIGNLEVEL.ID from FAFNFGCAMPAIGNLEVEL where FAFNFGCAMPAIGNLEVEL.NFGCAMPAIGNID = @ID and FAFNFGCAMPAIGNLEVEL.HIERARCHYPATH.GetLevel() = 1)

    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
select @DATALOADED = 1,
           @NAME = a.NAME,
           @ALLOWOTHERSJOINFROMGROUPPAGE = a.ALLOWOTHERSJOINFROMGROUPPAGE,
    --       @ALLOWOTHERSJOINFROMLOCALWEBSITE = a.ALLOWOTHERSJOINFROMLOCALWEBSITE,
           @ALLOWCOMPANIESJOINFROMGROUPPAGE = a.ALLOWCOMPANIESJOINFROMGROUPPAGE,
    --       @ALLOWCOMPANIESJOINFROMLOCALWEBSITE = a.ALLOWCOMPANIESJOINFROMLOCALWEBSITE,
           @ALLOWGROUPSCHOOSEHIERARCHYLEVEL = a.ALLOWGROUPSCHOOSEHIERARCHYLEVEL,
           @TOTALDONORSGOAL = a.TOTALDONORSGOAL,
           @PARTICIPANTSRECRECRUITMENTGOAL = a.PARTICIPANTSRECRECRUITMENTGOAL,
           @PARTICIPANTSRETAINEDGOAL = a.PARTICIPANTSRETAINEDGOAL,
           @TOTALREVENUEGOAL = a.TOTALREVENUEGOAL,
           @NFGTYPECODEID = a.NFGTYPECODEID,
           @ORGANIZATIONCONSTITUENTID = a.ORGANIZATIONCONSTITUENTID,
           @CONTACTID = a.CONTACTID    ,
           @FAFGROUPSRECRUITMENTGOAL = a.FAFGROUPSRECRUITMENTGOAL,
           @FAFGROUPSRETAINEDGOAL   = a.FAFGROUPSRETAINEDGOAL,
           @COMMUNICATIONSTOSEND  = a.COMMUNICATIONSTOSEND,
           @GROUPCONSTITUENTID = a.GROUPCONSTITUENTID
    FROM dbo.FAFNFGCampaign a (NOLOCK)
    LEFT JOIN dbo.CONSTITUENT b (NOLOCK)
        ON a.ORGANIZATIONCONSTITUENTID = b.ID
    LEFT JOIN dbo.FAFNFGTYPECODE c
        ON a.NFGTYPECODEID = c.ID
    LEFT JOIN dbo.CONSTITUENT d (NOLOCK)
        on a.CONTACTID = d.ID
    where a.ID = @ID


    declare @DEFAULTSITEID uniqueidentifier,
          @USERDEFAULTSITEID uniqueidentifier        

    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

     SELECT @SITES =
     (
        SELECT FS.[ID], FS.[SITEID], S.NAME
        FROM dbo.[UFN_FAFNATIONALFUNDRAISINGGROUP_GETSITES](@ID) FS
        JOIN dbo.[SITE] S on S.ID = FS.SITEID
        for xml raw('ITEM'), type, elements, root('SITES'), BINARY BASE64 
     )


    return 0;