private void LoadSelectedTuitionpay()
        {
            if (billId != 0)
            {
                loadPartialPay = new PartialPaymentCollection();
                loadPartialPay.LoadPartialPaymentWithIdsFromDb(billId, selectedId);

                gridTuition.Rows.Count = 1;

                foreach (var popPartial in loadPartialPay.pubOtherFeesCollect)
                {
                    gridTuition.Rows.Count++;
                    gridTuition[gridTuition.Rows.Count - 1, 1] = popPartial.PartPay_Id;
                    gridTuition[gridTuition.Rows.Count - 1, 2] = popPartial.PartPay_Partition;
                    gridTuition[gridTuition.Rows.Count - 1, 3] = popPartial.PartPay_Amount;
                    gridTuition[gridTuition.Rows.Count - 1, 4] = popPartial.PartPay_Balance;
                    gridTuition[gridTuition.Rows.Count - 1, 5] = popPartial.PartPay_DueDate;
                    gridTuition[gridTuition.Rows.Count - 1, 6] = popPartial.PartPay_PaymentMade;
                    gridTuition[gridTuition.Rows.Count - 1, 7] = popPartial.PartPay_Status;
                    gridTuition[gridTuition.Rows.Count - 1, 8] = popPartial.PartPay_DatePaid;
                }
            }
            else
            {
                gridTuition.Rows.Count = 1;
            }
        }
        private void LoadStdPartition()
        {
            if (stop == true)
            {
                gridTuition.Rows.Count = 1;
                return;
            }
            loadPartialPay = new PartialPaymentCollection();
            loadPartialPay.LoadPartialPaymentWithIdsFromDb(billId, Int32.Parse(LoginUser.stdLogStudentId));

            gridTuition.Rows.Count = 1;

            foreach (var popPartial in loadPartialPay.pubOtherFeesCollect)
            {
                gridTuition.Rows.Count++;

                gridTuition[gridTuition.Rows.Count - 1, 1] = popPartial.PartPay_Partition;
                gridTuition[gridTuition.Rows.Count - 1, 2] = popPartial.PartPay_Amount;
                gridTuition[gridTuition.Rows.Count - 1, 3] = popPartial.PartPay_Balance;
                gridTuition[gridTuition.Rows.Count - 1, 4] = popPartial.PartPay_DueDate;
                gridTuition[gridTuition.Rows.Count - 1, 5] = popPartial.PartPay_PaymentMade;
                if (popPartial.PartPay_Status.ToString() == "true")
                {
                    gridTuition[gridTuition.Rows.Count - 1, 6] = "Paid";
                }
                else
                {
                    gridTuition[gridTuition.Rows.Count - 1, 6] = "Not Paid";
                }
                gridTuition[gridTuition.Rows.Count - 1, 7] = popPartial.PartPay_DatePaid;
                gridTuition[gridTuition.Rows.Count - 1, 8] = popPartial.PartPay_Id;
            }
        }
        private void LoadOldPart()
        {
            loadPartialPay = new PartialPaymentCollection();
            loadPartialPay.LoadOldPartWithStdIdFromDb(selectedId);

            foreach (var popOld in loadPartialPay.pubOtherFeesCollect)
            {
                totalOldBal = totalOldBal + popOld.PartPay_Balance;
                oldBillId   = popOld.PartPay_Bill_Id;
                oldStdId    = popOld.PartPay_Std_Id;
            }
            myOldCollect = new OldTuitionCollection();
            myOldCollect.LoadOldTuitionFromDb();
            if (myOldCollect.pubOldCollect.All(x => (x.OldTuition_Bill_Id != oldBillId && x.OldTuition_Std_Id != oldStdId)))
            {
                if (totalOldBal != 0)
                {
                    InsertToOldTable();
                    totalOldBal = 0;
                }
            }
        }
        private void SetOldPart()
        {
            loadPartialPay = new PartialPaymentCollection();
            loadPartialPay.LoadOldPartWithStdIdFromDb(Int32.Parse(LoginUser.stdLogStudentId));

            foreach (var popOld in loadPartialPay.pubOtherFeesCollect)
            {
                totalOldBal = totalOldBal + popOld.PartPay_Balance;
                billId      = popOld.PartPay_Bill_Id;
                stdId       = popOld.PartPay_Std_Id;
            }
            myOldCollect = new OldTuitionCollection();
            myOldCollect.LoadOldTuitionFromDb();
            if (myOldCollect.pubOldCollect.All(x => (x.OldTuition_Bill_Id != billId && x.OldTuition_Std_Id != stdId)))
            {
                if (totalOldBal != 0)
                {
                    InsertToOldTable();
                    totalOldBal = 0;
                }
            }
        }