internal static BaseRouteDto[] GetUnusedBaseRoutes(Rbr_Db pDb, short pAccountId, int pCallingPlanId, ViewContext pContext, int pRoutingPlanId) { var _callingPlan = CallingPlanManager.GetCallingPlan(pDb, pCallingPlanId); RouteRow[] _routeRows = null; if (pContext == ViewContext.Carrier) { _routeRows = pDb.RouteCollection.GetUnusedByCallingPlanIdCarrierAcctId(pCallingPlanId, pAccountId); } else if (pContext == ViewContext.Service) { _routeRows = pDb.RouteCollection.GetUnusedByCallingPlanIdRoutingPlanIdServiceId(pCallingPlanId, pRoutingPlanId, pAccountId); } if (_routeRows == null || _routeRows.Length == 0) { return(null); } var _baseRoutes = new List <BaseRouteDto>(); foreach (var _routeRow in _routeRows) { var _country = CallingPlanManager.GetCountry(pDb, _routeRow.Country_id); var _dialCodeCount = CallingPlanManager.GetDialCodeCount(pDb, _routeRow.Route_id); var _routeState = (_dialCodeCount > 0) ? RouteState.Valid : RouteState.NoDialCodes; _baseRoutes.Add(mapToBaseRoute(_routeRow, _country, _callingPlan, _routeState)); } return(sortBaseRoutes(_baseRoutes.ToArray())); }
static List <BaseRouteDto> getBaseRouteList(Rbr_Db pDb, CallingPlanDto pCallingPlan, IEnumerable <RouteRow> pRouteRows) { var _routeList = new List <BaseRouteDto>(); foreach (var _routeRow in pRouteRows) { var _country = CallingPlanManager.GetCountry(pDb, _routeRow.Country_id); var _dialCodeCount = CallingPlanManager.GetDialCodeCount(pDb, _routeRow.Route_id); var _routeState = (_dialCodeCount > 0) ? RouteState.Valid : RouteState.NoDialCodes; var _route = mapToBaseRoute(_routeRow, _country, pCallingPlan, _routeState); _routeList.Add(_route); } return(_routeList); }
internal static BaseRouteDto GetProperRoute(Rbr_Db pDb, int pCallingPlanId, int pCountryId) { var _properRouteRow = GetProper(pDb, pCallingPlanId, pCountryId); if (_properRouteRow == null) { return(null); } var _callingPlan = CallingPlanManager.GetCallingPlan(pDb, pCallingPlanId); var _country = CallingPlanManager.GetCountry(pDb, pCountryId); var _dialCodeCount = CallingPlanManager.GetDialCodeCount(pDb, _properRouteRow.Route_id); var _routeState = (_dialCodeCount > 0) ? RouteState.Valid : RouteState.NoDialCodes; return(mapToBaseRoute(_properRouteRow, _country, _callingPlan, _routeState)); }