USP_DATAFORMTEMPLATE_EDIT_DESIGNATIONLEVEL_3

Stored procedure used for editing a Fundraising Purpose.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@DESIGNATIONLEVELCATEGORYCODEID	uniqueidentifier	IN	Category
@ADMINISTRATORID	uniqueidentifier	IN	Administrator
@STEWARDSHIPPACKAGEPROCESSID	uniqueidentifier	IN	Package
@LOOKUPID	nvarchar(100)	IN	Lookup ID
@DESIGNATIONREPORTCODE1ID	uniqueidentifier	IN	Report code 1
@DESIGNATIONREPORTCODE2ID	uniqueidentifier	IN	Report code 2
@SITEID	uniqueidentifier	IN	Site
@VANITYNAME	nvarchar(512)	IN	Public name
@TIMEPERIODCODE	tinyint	IN	Frequency
@ISENDOWED	bit	IN	Endowed
@ISFULLYFUNDED	bit	IN	Fully funded
@ISINCOMETOPRINCIPAL	bit	IN	Income to principal
@INCOMETOPRINCIPALPERCENT	decimal(5, 2)	IN	Income to principal %
@STATEMENTWORDING	nvarchar(1024)	IN	Statement wording

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DESIGNATIONLEVEL_3
            (
                @ID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,                
                @NAME nvarchar(100),
                @DESCRIPTION nvarchar(255),
                @DESIGNATIONLEVELCATEGORYCODEID uniqueidentifier,
                @ADMINISTRATORID uniqueidentifier,
                @STEWARDSHIPPACKAGEPROCESSID uniqueidentifier,                                                 
                @LOOKUPID nvarchar(100),
                @DESIGNATIONREPORTCODE1ID uniqueidentifier,
                @DESIGNATIONREPORTCODE2ID uniqueidentifier,
                @SITEID uniqueidentifier,
                @VANITYNAME nvarchar(512),
                @TIMEPERIODCODE tinyint,
                @ISENDOWED bit,
                @ISFULLYFUNDED bit,
                @ISINCOMETOPRINCIPAL bit,
                @INCOMETOPRINCIPALPERCENT decimal(5,2),
                @STATEMENTWORDING nvarchar(1024)                                                 
            )
        as                
        begin                
            set nocount on;
            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            declare @ENDOWMENTMINAMOUNT money
            declare @ENDOWMENTTARGETDATE date
            declare @ENDOWMENTMINAMOUNTDATEMET date

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DESIGNATIONLEVEL_3 
                @ID=@ID, 
                @CURRENTAPPUSERID=@CURRENTAPPUSERID, 
                @ENDOWMENTMINAMOUNT=@ENDOWMENTMINAMOUNT output, 
                @ENDOWMENTTARGETDATE=@ENDOWMENTTARGETDATE output, 
                @ENDOWMENTMINAMOUNTDATEMET=@ENDOWMENTMINAMOUNTDATEMET output

            if @SITEID is null
                begin 
                if dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID) = 1 
                    begin
                    raiserror('Site is required.',13,1)
                    return
                    end
                end

            if COALESCE(@ISINCOMETOPRINCIPAL, 0) = 0
                set @INCOMETOPRINCIPALPERCENT = 0.00;

            begin try
                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_DESIGNATIONLEVEL_4
                @ID,
                @CURRENTAPPUSERID,
                @CHANGEAGENTID,                
                @NAME,
                @DESCRIPTION,
                @DESIGNATIONLEVELCATEGORYCODEID,
                @ADMINISTRATORID,
                @STEWARDSHIPPACKAGEPROCESSID,                                                 
                @LOOKUPID,
                @DESIGNATIONREPORTCODE1ID,
                @DESIGNATIONREPORTCODE2ID,
                @SITEID,
                @VANITYNAME,
                @TIMEPERIODCODE,
                @ISENDOWED,
                @ISFULLYFUNDED,
                @ISINCOMETOPRINCIPAL,
                @INCOMETOPRINCIPALPERCENT,
                @STATEMENTWORDING,
                @ENDOWMENTMINAMOUNT,
                @ENDOWMENTTARGETDATE,
                @ENDOWMENTMINAMOUNTDATEMET

            end try

            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

            return 0
        end