public static VehicleDS ViewDriverVehicles() { //Get a list of driver vehicles VehicleDS vehicles = new VehicleDS(); try { DataSet ds = Mediator.FillDataset("", "VehicleListTable", null); if (ds != null) { vehicles.Merge(ds.Tables["VehicleListTable"].Select("", "Description", DataViewRowState.CurrentRows)); } } catch (Exception ex) { throw ex; } return(vehicles); }
public static VehicleDS GetDriverVehicle(int vehicleID, string vehicleType) { //Get a new or existing vehicle VehicleDS vehicle = new VehicleDS(); try { if (vehicleID == 0) { //New VehicleDS.VehicleDetailTableRow row = vehicle.VehicleDetailTable.NewVehicleDetailTableRow(); row.VehicleID = vehicleID; row.Description = ""; row.VehicleType = vehicleType; row.LicPlateNumber = ""; //row.State = ""; row.CarrierID = EnterpriseFactory.CompanyID; //row.DriverID = 0; row.IsActive = true; row.LastUpdated = DateTime.Now; row.UserID = System.Environment.UserName; row.RowVersion = ""; vehicle.VehicleDetailTable.AddVehicleDetailTableRow(row); } else { //Existing DataSet ds = Mediator.FillDataset("", "VehicleDetailTable", new object[] { vehicleID, vehicleType }); if (ds != null) { vehicle.Merge(ds); } } } catch (Exception ex) { throw ex; } return(vehicle); }