private void RefreshCommissionView()
        {
            try
            {
                DateTime?dtFrom = dtpFromDate.Value.ToDate();
                DateTime?dtTill = dtpTillDate.Value.ToDateTimeorNull();


                using (TaxiDataContext db = new TaxiDataContext())
                {
                    var list = db.stp_AddAllDriverCommission(dtFrom, dtTill).ToList();


                    int cnt = list.Count;
                    grdDriverCommission.RowCount = cnt;



                    for (int i = 0; i < cnt; i++)
                    {
                        grdDriverCommission.Rows[i].Cells["Check"].Value          = true;
                        grdDriverCommission.Rows[i].Cells[COLS.Id].Value          = list[i].Id;
                        grdDriverCommission.Rows[i].Cells[COLS.DriverNo].Value    = list[i].Driver;
                        grdDriverCommission.Rows[i].Cells[COLS.DriverEmail].Value = list[i].Email;

                        // grdDriverCommission.Rows[i].Cells[COLS.DriverCommission].Value = list[i].DriverMonthlyRent.ToDecimal();


                        // ADD PDA RENT
                        grdDriverCommission.Rows[i].Cells[COLS.DriverPDARent].Value = list[i].PDARent.ToDecimal();

                        if (list[i].CommissionId == 0)
                        {
                            grdDriverCommission.Rows[i].Cells[COLS.OldBalance].Value = list[i].InitialBalance;
                        }
                        else
                        {
                            grdDriverCommission.Rows[i].Cells[COLS.OldBalance].Value = list[i].OldBalance;
                        }
                        grdDriverCommission.Rows[i].Cells[COLS.InitialBalance].Value             = list[i].InitialBalance;
                        grdDriverCommission.Rows[i].Cells[COLS.DriverCommissionPerBooking].Value = list[i].DriverCommissionPerBooking;
                        grdDriverCommission.Rows[i].Cells[COLS.CashTotal].Value        = null;
                        grdDriverCommission.Rows[i].Cells[COLS.JobsTotal].Value        = null;
                        grdDriverCommission.Rows[i].Cells[COLS.AgentFees].Value        = null;
                        grdDriverCommission.Rows[i].Cells[COLS.CommissionId].Value     = null;
                        grdDriverCommission.Rows[i].Cells[COLS.CommissionPay].Value    = null;
                        grdDriverCommission.Rows[i].Cells[COLS.Owed].Value             = null;
                        grdDriverCommission.Rows[i].Cells[COLS.CurrBalance].Value      = (list[i].PDARent.ToDecimal() + grdDriverCommission.Rows[i].Cells[COLS.OldBalance].Value.ToDecimal());
                        grdDriverCommission.Rows[i].Cells[COLS.DriverCommission].Value = null;
                        grdDriverCommission.Rows[i].Cells[COLS.AccountsTotal].Value    = null;
                    }
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }