Example #1
0
        public static Decimal GetPartPaidAmount(Int32 ApDocumentId)
        {
            Decimal PaidAmount = 0m;

            TDBTransaction ReadTransaction = null;

            DBAccess.GDBAccessObj.BeginAutoReadTransaction(ref ReadTransaction,
                                                           delegate
            {
                AApDocumentPaymentTable PreviousPayments =
                    AApDocumentPaymentAccess.LoadViaAApDocument(ApDocumentId, ReadTransaction);

                foreach (AApDocumentPaymentRow PrevPaymentRow in PreviousPayments.Rows)
                {
                    PaidAmount += PrevPaymentRow.Amount;
                }
            });     // End of BeginAutoReadTransaction

            return(PaidAmount);
        }
Example #2
0
        public static Decimal GetPartPaidAmount(Int32 ApDocumentId)
        {
            Decimal PaidAmount = 0m;

            TDBTransaction ReadTransaction = null;

            DBAccess.GDBAccessObj.GetNewOrExistingAutoReadTransaction(IsolationLevel.ReadCommitted,
                                                                      TEnforceIsolationLevel.eilMinimum,
                                                                      ref ReadTransaction,
                                                                      delegate
            {
                AApDocumentPaymentTable PreviousPayments =
                    AApDocumentPaymentAccess.LoadViaAApDocument(ApDocumentId, ReadTransaction);

                foreach (AApDocumentPaymentRow PrevPaymentRow in PreviousPayments.Rows)
                {
                    PaidAmount += PrevPaymentRow.Amount;
                }
            });     // End of BeginAutoReadTransaction

            return(PaidAmount);
        }
Example #3
0
        public static Decimal GetPartPaidAmount(Int32 ApDocumentId)
        {
            Decimal PaidAmount = 0m;

            TDBTransaction ReadTransaction = new TDBTransaction();
            TDataBase      db = DBAccess.Connect("GetPartPaidAmount");

            db.ReadTransaction(
                ref ReadTransaction,
                delegate
            {
                AApDocumentPaymentTable PreviousPayments =
                    AApDocumentPaymentAccess.LoadViaAApDocument(ApDocumentId, ReadTransaction);

                foreach (AApDocumentPaymentRow PrevPaymentRow in PreviousPayments.Rows)
                {
                    PaidAmount += PrevPaymentRow.Amount;
                }
            });     // End of ReadTransaction

            return(PaidAmount);
        }