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