USP_DATAFORMTEMPLATE_EDITSAVE_DESIGNATIONLEVELFINANCIALINFORMATIONBATCHROW

The save procedure used by the edit dataform template "Designation Level Financial Information Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DESIGNATIONLEVELID	uniqueidentifier	IN	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_EDITSAVE_DESIGNATIONLEVELFINANCIALINFORMATIONBATCHROW
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @DESIGNATIONLEVELID uniqueidentifier,
                        @STARTDATE datetime,                                          
                        @ENDDATE datetime,
                        @BOOKVALUESTART money,
                        @BOOKVALUEEND money,                                          
                        @MARKETVALUESTART money,
                        @MARKETVALUEEND money,
                        @TOTALGIFTREVENUE money,
                        @TOTALDISBURSEMENTS money,
                        @PLEDGEBALANCE money,                        
                        @SEQUENCE int
                    )
                    as 
                    set nocount on;

                    declare @CHANGEDATE datetime

                    if @ID is null
                        set @ID = NewID();

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

                    set @CHANGEDATE = getdate();

                    begin try

                        declare @BASECURRENCYID uniqueidentifier;

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

                        update dbo.BATCHDESIGNATIONLEVELFINANCIALINFO
                            set DESIGNATIONLEVELID = @DESIGNATIONLEVELID,
                                STARTDATE = @STARTDATE,
                                ENDDATE = @ENDDATE,
                                BOOKVALUESTART = @BOOKVALUESTART,
                                BOOKVALUEEND = @BOOKVALUEEND,
                                MARKETVALUESTART = @MARKETVALUESTART,
                                MARKETVALUEEND = @MARKETVALUEEND,
                                TOTALGIFTREVENUE = @TOTALGIFTREVENUE,
                                TOTALDISBURSEMENTS = @TOTALDISBURSEMENTS,
                                PLEDGEBALANCE = @PLEDGEBALANCE,
                                BASECURRENCYID = @BASECURRENCYID,
                                SEQUENCE = @SEQUENCE,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CHANGEDATE
                        where ID = @ID;

                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;