public void InsertOtherFees()
        {
            OtherFeesManager otherFeesManage = new OtherFeesManager();

            RegisterOtherFees();
            otherFeesManage.SaveOtherFees(otherFeesList);
        }
        private void LoadStdOtherPay()
        {
            loadOther = new OtherFeesCollection();
            loadOther.LoadOtherFeesWithStdIdFromDb(Int32.Parse(LoginUser.stdLogStudentId));

            gridOther.Rows.Count = 1;

            foreach (var popOther in loadOther.pubOtherFeesCollect)
            {
                if (DateTime.Parse(popOther.OtherFees_CutOffDate) < DateTime.Today)
                {
                    var setOldOtherManage = new OtherFeesManager();
                    setOldOtherManage.SetOtherToOld(popOther.OtherFees_Id);
                    stop = true;
                }
                else
                {
                    gridOther.Rows.Count++;
                    gridOther[gridOther.Rows.Count - 1, 9] = popOther.OtherFees_Id;
                    gridOther[gridOther.Rows.Count - 1, 1] = popOther.OtherFees_Description;
                    gridOther[gridOther.Rows.Count - 1, 2] = popOther.OtherFees_Amount;
                    gridOther[gridOther.Rows.Count - 1, 3] = popOther.OtherFees_Balance;
                    gridOther[gridOther.Rows.Count - 1, 4] = popOther.OtherFees_DueDate;
                    gridOther[gridOther.Rows.Count - 1, 5] = popOther.OtherFees_PaymentMade;
                    gridOther[gridOther.Rows.Count - 1, 6] = popOther.OtherFees_Status;
                    gridOther[gridOther.Rows.Count - 1, 7] = popOther.OtherFees_DatePaid;
                    gridOther[gridOther.Rows.Count - 1, 8] = popOther.OtherFees_CutOffDate;
                }
            }
        }
        private void DeleteOther()
        {
            var otherManage = new OtherFeesManager();
            var result      = MessageBox.Show("Do you want to delete this record?", "Are you sure?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                otherManage.DeleteOther(selectedOtherId);
            }
        }
        private void UpdateOtherFees()
        {
            using (EditOther editOther = new EditOther())
            {
                editOther.txtDescription.text = gridOther[gridOther.RowSel, 2].ToString();
                editOther.txtAmount.text      = gridOther[gridOther.RowSel, 3].ToString();
                editOther.txtBalance.text     = gridOther[gridOther.RowSel, 4].ToString();
                editOther.txtPaymade.text     = gridOther[gridOther.RowSel, 6].ToString();
                editOther.calDueDate.Value    = DateTime.Parse(gridOther[gridOther.RowSel, 5].ToString());
                editOther.calCutOff.Value     = DateTime.Parse(gridOther[gridOther.RowSel, 9].ToString());
                string comp = gridOther[gridOther.RowSel, 7].ToString();
                if (comp == "false")
                {
                    editOther.cmbStatus.selectedIndex = 1;
                    editOther.calDatePaid.Enabled     = false;
                }
                else
                {
                    editOther.calDatePaid.Value       = DateTime.Parse(gridOther[gridOther.RowSel, 8].ToString());
                    editOther.cmbStatus.selectedIndex = 0;
                    editOther.calDatePaid.Enabled     = true;
                }
                editOther.ShowDialog();
                if (editOther.isConfirmed == true)
                {
                    var otherManage = new OtherFeesManager();
                    var item        = new OtherFeesItem();

                    item.OtherFees_Description = editOther.txtDescription.text;
                    item.OtherFees_Amount      = Decimal.Parse(editOther.txtAmount.text);
                    item.OtherFees_Balance     = Decimal.Parse(editOther.txtBalance.text);
                    item.OtherFees_PaymentMade = Decimal.Parse(editOther.txtPaymade.text);
                    item.OtherFees_DueDate     = editOther.calDueDate.Value.ToString("MM/dd/yyyy");
                    item.OtherFees_CutOffDate  = editOther.calCutOff.Value.ToString("MM/dd/yyyy");
                    item.OtherFees_Id          = selectedOtherId;
                    if (editOther.cmbStatus.selectedIndex == 0)
                    {
                        item.OtherFees_Status   = "true";
                        item.OtherFees_DatePaid = editOther.calDatePaid.Value.ToString("MM/dd/yyyy");
                    }
                    else
                    {
                        item.OtherFees_Status   = "false";
                        item.OtherFees_DatePaid = "N/A";
                    }

                    otherManage.UpdateOther(item);
                }
            }
            StdClick();
        }
        private void DeleteOld()
        {
            var otherManage = new OtherFeesManager();
            var oldManage   = new OldTuitionManager();
            var result      = MessageBox.Show("Do you want to delete this record?", "Are you sure?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                if (gridOld[gridOld.RowSel, 2].ToString() == "Tuition Fee")
                {
                    oldManage.DeleteOld(selectedOldId);
                }
                else
                {
                    otherManage.DeleteOther(selectedOldId);
                }
            }
        }
        private void UpdateOldBalance()
        {
            using (EditOld editOld = new EditOld())
            {
                editOld.txtDescription.text = gridOld[gridOld.RowSel, 2].ToString();
                editOld.txtAmount.text      = gridOld[gridOld.RowSel, 3].ToString();
                editOld.txtBalance.text     = gridOld[gridOld.RowSel, 4].ToString();
                editOld.txtPaymade.text     = gridOld[gridOld.RowSel, 5].ToString();
                string comp = gridOld[gridOld.RowSel, 6].ToString();
                if (comp == "false")
                {
                    editOld.cmbStatus.selectedIndex = 1;
                    editOld.calDatePaid.Enabled     = false;
                }
                else
                {
                    editOld.calDatePaid.Value       = DateTime.Parse(gridOld[gridOld.RowSel, 7].ToString());
                    editOld.cmbStatus.selectedIndex = 0;
                    editOld.calDatePaid.Enabled     = true;
                }
                editOld.ShowDialog();
                if (editOld.isConfirmed == true)
                {
                    if (gridOld[gridOld.RowSel, 2].ToString() == "Tuition Fee")
                    {
                        var oldManage = new OldTuitionManager();
                        var item      = new OldTuitionItem();

                        item.OldTuition_Description = editOld.txtDescription.text;
                        item.OldTuition_Amount      = Decimal.Parse(editOld.txtAmount.text);
                        item.OldTuition_Balance     = Decimal.Parse(editOld.txtBalance.text);
                        item.OldTuition_PayMade     = Decimal.Parse(editOld.txtPaymade.text);
                        item.OldTuition_Id          = selectedOldId;
                        if (editOld.cmbStatus.selectedIndex == 0)
                        {
                            item.OldTuition_Status   = "true";
                            item.OldTuition_DatePaid = editOld.calDatePaid.Value.ToString("MM/dd/yyyy");
                        }
                        else
                        {
                            item.OldTuition_Status   = "false";
                            item.OldTuition_DatePaid = "N/A";
                        }

                        oldManage.UpdatOld(item);
                    }
                    else
                    {
                        var oldOtherManage = new OtherFeesManager();
                        var item           = new OtherFeesItem();

                        item.OtherFees_Description = editOld.txtDescription.text;
                        item.OtherFees_Amount      = Decimal.Parse(editOld.txtAmount.text);
                        item.OtherFees_Balance     = Decimal.Parse(editOld.txtBalance.text);
                        item.OtherFees_PaymentMade = Decimal.Parse(editOld.txtPaymade.text);
                        item.OtherFees_Id          = selectedOldId;
                        if (editOld.cmbStatus.selectedIndex == 0)
                        {
                            item.OtherFees_Status   = "true";
                            item.OtherFees_DatePaid = editOld.calDatePaid.Value.ToString("MM/dd/yyyy");
                        }
                        else
                        {
                            item.OtherFees_Status   = "false";
                            item.OtherFees_DatePaid = "N/A";
                        }

                        oldOtherManage.UpdateOldOther(item);
                    }
                }
            }
            StdClick();
        }