USP_DATAFORMTEMPLATE_VIEW_VOLUNTEERSCREENPLANPAGEDATA

The load procedure used by the view dataform template "Volunteer Screening Plan Page Expression 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.
@VOLUNTEERNAME	nvarchar(400)	INOUT	Active
@SCREENPLANNAME	nvarchar(100)	INOUT	Active
@VOLUNTEERID	uniqueidentifier	INOUT	Active
@SHOWMARKALL	bit	INOUT	SHOWMARKALL
@ISORG	bit	INOUT	ISORG
@CURRENTAPPUSERID	uniqueidentifier	IN
@USER_GRANTED_CONSTITPERSONALINFO_EDIT	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_VOLUNTEERSCREENPLANPAGEDATA
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @VOLUNTEERNAME nvarchar(400) = null output,
    @SCREENPLANNAME nvarchar(100) = null output,
    @VOLUNTEERID uniqueidentifier = null output,
    @SHOWMARKALL bit = null output,
  @ISORG bit = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @USER_GRANTED_CONSTITPERSONALINFO_EDIT bit = null output
) as
    set nocount on;

    set @DATALOADED = 0;

    select    @DATALOADED = 1,
            @VOLUNTEERNAME = C.[NAME],
            @SCREENPLANNAME = SP.NAME,
            @VOLUNTEERID = VSP.VOLUNTEERID,
            @ISORG = C.ISORGANIZATION
    from VOLUNTEERSCREENPLAN VSP 
    inner join dbo.CONSTITUENT C
        on C.ID = VSP.VOLUNTEERID
    inner join dbo.SCREENPLAN SP
        on SP.ID = VSP.SCREENPLANID
    where VSP.ID = @ID;

    if (select count(*) from dbo.VOLUNTEERSCREENPLANSTEP
            where SCREENPLANID = @ID and STATUSCODE <> 1) > 0
        set @SHOWMARKALL = 1
    else
        set @SHOWMARKALL = 0


    if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 
  begin
    set @USER_GRANTED_CONSTITPERSONALINFO_EDIT = 1;
    end
    else 
  begin
    set @USER_GRANTED_CONSTITPERSONALINFO_EDIT = 
        case 
          when @ISORG = 1 then dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'a9954902-ea62-48ae-8e6f-4e2ed3c3f4f9')
          else dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'788AB947-26ED-40C4-865E-8FE29577E593')
        end;
    end

    return 0;