public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassMappingCollection GetAllAsCollection()
{
try
{
VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassMappingCollection vehicles = new CBE.VehicleClassMappingCollection();
string spName = Constants.oraclePackagePrefix + "VEHICLE_CLASS_MAPPING_GETALL";
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
vehicles = ConvertDataTableToCollection(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName).Tables[tableName]);
return(vehicles);
}
catch (Exception ex)
{
throw ex;
}
}
public static CBE.VehicleClassMappingCollection GetVehicleClassMappingByIdCollection(CBE.VehicleClassMappingCBE vehicle) // what user ???? CJS
{
try
{
CBE.VehicleClassMappingCollection vehicles = new CBE.VehicleClassMappingCollection();
string spName = Constants.oraclePackagePrefix + "VEHICLE_CLASS_MAPPING_GETBYID";
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_MAPPING_VEHICLE_CLASS_ID", DbType.Int32, vehicle.MappingVehicleClassId, ParameterDirection.Input));
vehicles = ConvertDataTableToCollection(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName).Tables[tableName]);
return(vehicles);
}
catch (Exception ex)
{
throw ex;
}
}
