public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCBE GetVehicleClassId(CBE.VehicleClassCBE vehicleClassCBE)
{
return(VaaaN.MLFF.Libraries.CommonLibrary.DAL.VehicleClassDAL.GetVehicleClassId(vehicleClassCBE));
}
public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCBE GetVehicleClassId(CBE.VehicleClassCBE vehicleClass)
{
try
{
VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCollection vehicleClasses = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCollection();
string spName = VaaaN.MLFF.Libraries.CommonLibrary.Constants.oraclePackagePrefix + "VEHICLE_CLASS_GETBYID";
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_VEHICLE_CLASS_ID", DbType.Int32, vehicleClass.Id, ParameterDirection.Input));
DataSet ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName);
DataTable dt = ds.Tables[tableName];
vehicleClasses = ConvertDataTableToCollection(dt);
return(vehicleClasses[0]);
}
catch (Exception ex)
{
throw ex;
}
}
