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