public static List <TripData> GetList()
{
List <TripData> items = new List <TripData>();
foreach (var item in TripBl.GetList())
{
TripData tripData = new TripData();
tripData.Id = item.Id;
tripData.DateStart = item.DateTimeStart.ToString("dddd dd MMM yyyy");
tripData.TimeStart = item.DateTimeStart.ToString("hh:mm tt");
tripData.DateEnd = item.DateTimeEnd.ToString("dddd dd MMM yyyy");
tripData.TimeEnd = item.DateTimeEnd.ToString("hh:mm tt");
tripData.DriverId = item.DriverId;
tripData.DriverName = new DriverBl().GetById(item.DriverId).FullName;
tripData.VehicleId = item.VehicleId;
tripData.VehicleName = string.Format("{0}({1})", new VehicleBl().GetById(item.VehicleId).Name, new VehicleBl().GetById(item.VehicleId).RegistrationNumber);
tripData.RefillDate = new RefillBl().GetById(item.RefillId).DateAndTime.ToString("dddd dd MMM yyyy");
tripData.MileageStart = item.MileageStart;
tripData.MileageEnd = item.MileageEnd;
tripData.TripDetails = item.TripDetails;
tripData.ExpenseAccount = item.ExpenseAccount;
items.Add(tripData);
}
return(items);
}
private void RefreshGrid()
{
_dataTable = Utility.ToDataTable(TripData.GetList());
bindingSource.DataSource = _dataTable;
dataGridView.DataSource = bindingSource;
dataGridView.Update();
dataGridView.Refresh();
dataGridView.Columns[0].Visible = false;
dataGridView.Columns[1].HeaderText = "Start Date";
dataGridView.Columns[2].HeaderText = "Start Time";
dataGridView.Columns[3].HeaderText = "End Date";
dataGridView.Columns[4].HeaderText = "End Time";
dataGridView.Columns[5].Visible = false;
dataGridView.Columns[6].HeaderText = "Driver";
dataGridView.Columns[7].Visible = false;
dataGridView.Columns[8].HeaderText = "Vehicle";
dataGridView.Columns[9].HeaderText = "Refill Date";
dataGridView.Columns[10].HeaderText = "Start Mileage";
dataGridView.Columns[11].HeaderText = "End Mileage";
dataGridView.Columns[12].HeaderText = "Trip Details";
dataGridView.Columns[13].HeaderText = "Expense Account";
dataGridViewSearch.SetColumns(dataGridView.Columns);
}
public static List<TripData> GetList()
{
List<TripData> items = new List<TripData>();
foreach(var item in TripBl.GetList())
{
TripData tripData = new TripData();
tripData.Id = item.Id;
tripData.DateStart = item.DateTimeStart.ToString("dddd dd MMM yyyy");
tripData.TimeStart = item.DateTimeStart.ToString("hh:mm tt");
tripData.DateEnd = item.DateTimeEnd.ToString("dddd dd MMM yyyy");
tripData.TimeEnd = item.DateTimeEnd.ToString("hh:mm tt");
tripData.DriverId = item.DriverId;
tripData.DriverName = new DriverBl().GetById(item.DriverId).FullName;
tripData.VehicleId = item.VehicleId;
tripData.VehicleName = string.Format("{0}({1})", new VehicleBl().GetById(item.VehicleId).Name, new VehicleBl().GetById(item.VehicleId).RegistrationNumber);
tripData.RefillDate = new RefillBl().GetById(item.RefillId).DateAndTime.ToString("dddd dd MMM yyyy");
tripData.MileageStart = item.MileageStart;
tripData.MileageEnd = item.MileageEnd;
tripData.TripDetails = item.TripDetails;
tripData.ExpenseAccount = item.ExpenseAccount;
items.Add(tripData);
}
return items;
}
