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);
}
}