USP_DATAFORMTEMPLATE_ADD_DESIGNATIONLEVELFINANCIALINFORMATIONBATCHROW

The save procedure used by the add dataform template "Fundraising Purpose Financial Information Batch Row Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DESIGNATIONLEVELID	uniqueidentifier	IN	Fundraising purpose
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@BOOKVALUESTART	money	IN	Book value start
@BOOKVALUEEND	money	IN	Book value end
@MARKETVALUESTART	money	IN	Market value start
@MARKETVALUEEND	money	IN	Market value end
@TOTALGIFTREVENUE	money	IN	Total gift revenue
@TOTALDISBURSEMENTS	money	IN	Total disbursements
@PLEDGEBALANCE	money	IN	Pledge balance
@SEQUENCE	int	IN	Sequence

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DESIGNATIONLEVELFINANCIALINFORMATIONBATCHROW
                    (
                        @ID uniqueidentifier output,
                        @CHANGEAGENTID uniqueidentifier,    
                        @BATCHID uniqueidentifier,                                          
                        @DESIGNATIONLEVELID uniqueidentifier = null,
                        @STARTDATE datetime = null,                                          
                        @ENDDATE datetime = null,                                          
                        @BOOKVALUESTART money = 0,
                        @BOOKVALUEEND money = 0,                                          
                        @MARKETVALUESTART money = 0,
                        @MARKETVALUEEND money = 0,
                        @TOTALGIFTREVENUE money = 0,
                        @TOTALDISBURSEMENTS money = 0,
                        @PLEDGEBALANCE money = 0,
                        @SEQUENCE int = null
                    )
                    as
                    begin
                        set nocount on;

                        declare @CURRENTDATE datetime                                        

                        if @ID is null
                            set @ID = newid()

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

                        set @CURRENTDATE = getdate()

                        begin try        

                            declare @BASECURRENCYID uniqueidentifier;

                            select
                                @BASECURRENCYID = DESIGNATIONLEVEL.BASECURRENCYID
                            from
                                dbo.DESIGNATIONLEVEL
                            where
                                DESIGNATIONLEVEL.ID = @DESIGNATIONLEVELID

                            insert into dbo.BATCHDESIGNATIONLEVELFINANCIALINFO
                                (ID,BATCHID,DESIGNATIONLEVELID,STARTDATE,ENDDATE,BOOKVALUESTART,BOOKVALUEEND,MARKETVALUESTART,MARKETVALUEEND,TOTALGIFTREVENUE,PLEDGEBALANCE,TOTALDISBURSEMENTS,BASECURRENCYID,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
                            VALUES
                                (@ID,@BATCHID,@DESIGNATIONLEVELID,@STARTDATE,@ENDDATE,@BOOKVALUESTART,@BOOKVALUEEND,@MARKETVALUESTART,@MARKETVALUEEND,@TOTALGIFTREVENUE,@PLEDGEBALANCE,@TOTALDISBURSEMENTS,@BASECURRENCYID,@SEQUENCE,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE)
                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                        return 0

                    end