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));
}
//internal static BaseRouteDto[] MapToBaseRoutes(Rbr_Db pDb, RouteRow[] pRouteRows, CountryRow[] pCountryRows, CallingPlanRow pCallingPlanRow) {
// ArrayList _list = new ArrayList();
// if (pRouteRows != null) {
// foreach (RouteRow _routeRow in pRouteRows) {
// CountryRow _countryRow = getCountry(_routeRow.Country_id, pCountryRows);
// int _dialCodeCount = pDb.DialCodeCollection.GetCount( /*_routeRow.Calling_plan_id,*/ _routeRow.Route_id);
// RouteState _routeState = ( _dialCodeCount > 0 ) ? RouteState.Valid : RouteState.NoDialCodes;
// BaseRouteDto _baseRoute = MapToBaseRoute(_routeRow, _countryRow, pCallingPlanRow, _routeState);
// _list.Add(_baseRoute);
// }
// }
// return (BaseRouteDto[])_list.ToArray(typeof(BaseRouteDto));
//}
public static BaseRouteDto MapToBaseRoute(Rbr_Db pDb, RouteRow pRouteRow) //}, CountryRow pCountryRow, CallingPlanRow pCallingPlanRow, RouteState pRouteState) {
{
if (pRouteRow == null)
{
return(null);
}
var _baseRoute = new BaseRouteDto();
_baseRoute.BaseRouteId = pRouteRow.Route_id;
_baseRoute.Name = pRouteRow.Name;
_baseRoute.BaseStatus = pRouteRow.RouteStatus;
_baseRoute.CallingPlan = CallingPlanManager.GetCallingPlan(pDb, pRouteRow.Calling_plan_id);
_baseRoute.Country = CallingPlanManager.GetCountry(pDb, pRouteRow.Country_id);
_baseRoute.RoutingNumber = pRouteRow.Routing_number;
_baseRoute.Version = pRouteRow.Version;
_baseRoute.RouteState = RouteState.Valid;
return(_baseRoute);
}
internal static BaseRouteDto GetBaseRoute(Rbr_Db pDb, int pBaseRouteId)
{
if (pBaseRouteId == 0)
{
return(null);
}
var _routeRow = Get(pDb, pBaseRouteId);
if (_routeRow == null)
{
return(null);
}
var _callingPlan = CallingPlanManager.GetCallingPlan(pDb, _routeRow.Calling_plan_id);
var _country = CallingPlanManager.GetCountry(pDb, _routeRow.Country_id);
var _dialCodeCount = pDb.DialCodeCollection.GetCount(_routeRow.Route_id);
var _routeState = (_dialCodeCount > 0) ? RouteState.Valid : RouteState.NoDialCodes;
return(mapToBaseRoute(_routeRow, _country, _callingPlan, _routeState));
}