internal static RatedRouteDto Get(Rbr_Db pDb, CarrierAcctDto pCarrierAcct, CarrierRouteRow pCarrierRouteRow)
{
if (pCarrierRouteRow == null)
{
return(null);
}
var _activeCarrierRouteEPMapCount = pDb.CarrierAcctEPMapCollection.GetActiveCountByCarrierRouteId(pCarrierRouteRow.Carrier_route_id);
var _carrierRouteState = (_activeCarrierRouteEPMapCount > 0) ? RouteState.Valid : RouteState.NoActiveEndpoints;
if (pCarrierAcct.IsRatingEnabled)
{
//get Rates status
bool _allRatesValid;
CarrierRateHistoryRow _carrierRateHistoryRow = pDb.CarrierRateHistoryCollection.GetByCarrierRouteIdDate(pCarrierRouteRow.Carrier_route_id, DateTime.Today);
if (_carrierRateHistoryRow == null)
{
_allRatesValid = false;
}
else
{
_allRatesValid = pDb.RateCollection.HasAllValidRates(_carrierRateHistoryRow.Rate_info_id);
}
_carrierRouteState = (_allRatesValid) ? _carrierRouteState | RouteState.Valid : _carrierRouteState | RouteState.NoRates;
}
var _baseRoute = RoutingManager.GetBaseRoute(pDb, pCarrierRouteRow.Route_id);
var _route = mapToRoute(pCarrierRouteRow, pCarrierAcct, _baseRoute, _carrierRouteState);
return(_route);
}
internal static RatedRouteDto GetDefaultRoute(Rbr_Db pDb, CarrierAcctDto pCarrierAcct, RouteState pValid)
{
var _defaultCarrierRouteRow = pDb.CarrierRouteCollection.GetByPrimaryKey(-pCarrierAcct.CarrierAcctId);
//if (pCarrierAcctRow.IsRatingEnabled) {
//NOTE: DefaultRatingInfo is always created no metter what
//and it should be loaded as well no metter what
//}
var _baseRoute = RoutingManager.GetBaseRoute(pDb, _defaultCarrierRouteRow.Route_id);
return(mapToRoute(_defaultCarrierRouteRow, pCarrierAcct, _baseRoute, pValid));
}
public static RatedRouteDto Get(Rbr_Db pDb, ServiceDto pService, int pRoutingPlanId, WholesaleRouteRow pWholesaleRouteRow)
{
try {
if (pWholesaleRouteRow == null)
{
return(null);
}
var _routingPlanDetailRow = pDb.RoutingPlanDetailCollection.GetByPrimaryKey(pRoutingPlanId, pWholesaleRouteRow.Route_id);
var _routingPlanId = 0;
var _routingAlgorithmType = RoutingAlgorithmType.Unknown;
if (_routingPlanDetailRow != null)
{
_routingPlanId = _routingPlanDetailRow.Routing_plan_id;
_routingAlgorithmType = _routingPlanDetailRow.Algorithm;
}
var _routeState = (_routingPlanDetailRow != null) ? RouteState.Valid : RouteState.NotInRoutingPlan;
if (pService.IsRatingEnabled)
{
//get Rates status
bool _allRatesValid;
var _wholesaleRateHistoryRow = pDb.WholesaleRateHistoryCollection.GetByWholesaleRouteIdDate(pWholesaleRouteRow.Wholesale_route_id, DateTime.Today);
if (_wholesaleRateHistoryRow == null)
{
_allRatesValid = false;
}
else
{
_allRatesValid = pDb.RateCollection.HasAllValidRates(_wholesaleRateHistoryRow.Rate_info_id);
}
_routeState = (_allRatesValid) ? _routeState | RouteState.Valid : _routeState | RouteState.NoRates;
}
var _baseRoute = RoutingManager.GetBaseRoute(pDb, pWholesaleRouteRow.Route_id);
return(mapToRoute(pWholesaleRouteRow, _routingPlanId, _routingAlgorithmType, pService, _baseRoute, _routeState));
}
catch (Exception _ex) {
var _exc = _ex;
}
return(null);
}
