public override void PopulateData()
{
try
{
using (TaxiDataContext db = new TaxiDataContext())
{
var list = db.stp_DriverRentLastStatement().ToList();
grdDriverRentLastStatement.BeginUpdate();
grdDriverRentLastStatement.RowCount = list.Count;
for (int i = 0; i < list.Count; i++)
{
grdDriverRentLastStatement.Rows[i].Cells[COLS.Id].Value = list[i].Id;
grdDriverRentLastStatement.Rows[i].Cells[COLS.DriverId].Value = list[i].DriverId;
grdDriverRentLastStatement.Rows[i].Cells[COLS.DriverNo].Value = list[i].DriverNo;
grdDriverRentLastStatement.Rows[i].Cells[COLS.DriverName].Value = list[i].DriverName;
grdDriverRentLastStatement.Rows[i].Cells[COLS.TransDate].Value = list[i].TransDate;
grdDriverRentLastStatement.Rows[i].Cells[COLS.TransNo].Value = list[i].TransNo;
grdDriverRentLastStatement.Rows[i].Cells[COLS.JobsTotal].Value = list[i].JobsTotal;
grdDriverRentLastStatement.Rows[i].Cells[COLS.OldBalance].Value = list[i].OldBalance;
grdDriverRentLastStatement.Rows[i].Cells[COLS.FromDate].Value = list[i].FromDate;
grdDriverRentLastStatement.Rows[i].Cells[COLS.ToDate].Value = list[i].ToDate;
grdDriverRentLastStatement.Rows[i].Cells[COLS.Balance].Value = list[i].Balance;
//grdDriverRentLastStatement.Rows[i].Cells[COLS.JobsTotal].Value = list[i].Id;
}
grdDriverRentLastStatement.EndUpdate();
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}