internal static int AddRoutingPlan(Rbr_Db pDb, RoutingPlanDto pRoutingPlan)
{
var _routingPlanRow = mapToRoutingPlanRow(pRoutingPlan);
pDb.RoutingPlanCollection.Insert(_routingPlanRow);
return(_routingPlanRow.Routing_plan_id);
}
static ServiceDto mapToService(ServiceRow pServiceRow, RoutingPlanDto pDefaultRoutingPlan, PayphoneSurchargeRow pPayphoneSurchargeRow, ICollection <AccessNumberListRow> pAccessNumberListRows, RatingInfoDto pDefaultRatingInfo)
{
if (pServiceRow == null)
{
return(null);
}
var _service = new ServiceDto
{
ServiceId = pServiceRow.Service_id,
Name = pServiceRow.Name,
Status = ((Status)pServiceRow.Status),
ServiceType = pServiceRow.ServiceType,
RetailType = pServiceRow.RetailType,
IsShared = pServiceRow.IsShared,
RatingType = pServiceRow.RatingType,
PinLength = pServiceRow.Pin_length,
DefaultRatingInfo = pDefaultRatingInfo,
DefaultRoutingPlan = pDefaultRoutingPlan,
AccessNumbers = mapToAccessNumbers(pAccessNumberListRows),
PayphoneSurcharge = RetailAccountManager.MapToPayphoneSurcharge(pPayphoneSurchargeRow),
SweepScheduleId = pServiceRow.Sweep_schedule_id,
SweepFee = pServiceRow.Sweep_fee,
SweepRule = pServiceRow.Sweep_rule,
BalancePromptType = pServiceRow.BalancePromptType,
BalancePromptPerUnit = pServiceRow.Balance_prompt_per_unit,
VirtualSwitchId = pServiceRow.Virtual_switch_id
};
return(_service);
}
public void DeleteRoutingPlan(RoutingPlanDto pRoutingPlan)
{
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pRoutingPlan)) {
RoutingManager.DeleteRoutingPlan(_db, pRoutingPlan);
_tx.Commit();
}
}
}
public void AddRoutingPlanDetails(RoutingPlanDto pRoutingPlan, int[] pSelectedBaseRouteIds, RoutingAlgorithmType pDefaultRoutingAlgorithmType)
{
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pRoutingPlan, pSelectedBaseRouteIds, pDefaultRoutingAlgorithmType)) {
RoutingManager.AddRoutingPlanDetails(_db, pRoutingPlan, pSelectedBaseRouteIds, pDefaultRoutingAlgorithmType);
_tx.Commit();
}
}
}
internal static void DeleteRoutingPlan(Rbr_Db pDb, RoutingPlanDto pRoutingPlan)
{
var _routingPlanRow = mapToRoutingPlanRow(pRoutingPlan);
//TODO: NEW DAL
//pDb.TerminationChoiceCollection.DeleteByRoutingPlanId(pRoutingPlan.RoutingPlanId);
pDb.RoutingPlanDetailCollection.DeleteByRouting_plan_id(_routingPlanRow.Routing_plan_id);
pDb.RoutingPlanCollection.Delete(_routingPlanRow);
}
public void CloneRoutingPlan(RoutingPlanDto pNewRoutingPlan, RoutingPlanDto pRoutingPlanToClone)
{
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pNewRoutingPlan, pRoutingPlanToClone)) {
//TODO: NEW DAL - VirtualSwitch
pNewRoutingPlan.VirtualSwitchId = AppConstants.DefaultVirtualSwitchId;
pNewRoutingPlan.RoutingPlanId = RoutingManager.AddRoutingPlan(_db, pNewRoutingPlan);
RoutingManager.CloneRoutingPlanDetails(_db, pNewRoutingPlan, pRoutingPlanToClone);
_tx.Commit();
}
}
}
public void AddRoutingPlan(RoutingPlanDto pRoutingPlan, int[] pSelectedBaseRouteIds, RoutingAlgorithmType pDefaultRoutingAlgorithmType)
{
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pRoutingPlan, pSelectedBaseRouteIds, pDefaultRoutingAlgorithmType)) {
//TODO: NEW DAL - VirtualSwitch
pRoutingPlan.VirtualSwitchId = AppConstants.DefaultVirtualSwitchId;
pRoutingPlan.RoutingPlanId = RoutingManager.AddRoutingPlan(_db, pRoutingPlan);
RoutingManager.AddRoutingPlanDetails(_db, pRoutingPlan, pSelectedBaseRouteIds, pDefaultRoutingAlgorithmType);
_tx.Commit();
}
}
}
internal static void AddRoutingPlanDetails(Rbr_Db pDb, RoutingPlanDto pRoutingPlan, int[] pSelectedBaseRouteIds, RoutingAlgorithmType pDefaultRoutingAlgorithmType)
{
if (pRoutingPlan != null && pSelectedBaseRouteIds != null && pSelectedBaseRouteIds.Length > 0)
{
foreach (var _baseRouteId in pSelectedBaseRouteIds)
{
var _routingPlanDetailRow = new RoutingPlanDetailRow();
_routingPlanDetailRow.Routing_plan_id = pRoutingPlan.RoutingPlanId;
_routingPlanDetailRow.Route_id = _baseRouteId;
_routingPlanDetailRow.Algorithm = pDefaultRoutingAlgorithmType;
AddRoutingPlanDetailRow(pDb, _routingPlanDetailRow);
}
}
}
static RoutingPlanRow mapToRoutingPlanRow(RoutingPlanDto pRoutingPlan)
{
if (pRoutingPlan == null)
{
return(null);
}
var _routingPlanRow = new RoutingPlanRow();
_routingPlanRow.Routing_plan_id = pRoutingPlan.RoutingPlanId;
_routingPlanRow.Name = pRoutingPlan.Name;
_routingPlanRow.Calling_plan_id = pRoutingPlan.CallingPlanId;
_routingPlanRow.Virtual_switch_id = pRoutingPlan.VirtualSwitchId;
return(_routingPlanRow);
}
static RoutingPlanDto mapToRoutingPlan(RoutingPlanRow_Base pRoutingPlanRow, CallingPlanDto pCallingPlan)
{
if (pRoutingPlanRow == null)
{
return(null);
}
var _routingPlan = new RoutingPlanDto();
_routingPlan.RoutingPlanId = pRoutingPlanRow.Routing_plan_id;
_routingPlan.Name = pRoutingPlanRow.Name;
_routingPlan.CallingPlan = pCallingPlan;
_routingPlan.VirtualSwitchId = pRoutingPlanRow.Virtual_switch_id;
return(_routingPlan);
}
public static void CloneRoutingPlanDetails(Rbr_Db pDb, RoutingPlanDto pNewRoutingPlan, RoutingPlanDto pRoutingPlanToClone)
{
//1. get Details for existing RoutingPlan
var _existingRoutingPlanDetailRows = pDb.RoutingPlanDetailCollection.GetByRouting_plan_id(pRoutingPlanToClone.RoutingPlanId);
foreach (var _existingRoutingPlanDetailRow in _existingRoutingPlanDetailRows)
{
//1.1 clone/insert RoutingPlanDetail for a new RoutingPlan
var _newRoutingPlanDetail = new RoutingPlanDetailRow();
_newRoutingPlanDetail.Routing_plan_id = pNewRoutingPlan.RoutingPlanId;
_newRoutingPlanDetail.Route_id = _existingRoutingPlanDetailRow.Route_id;
_newRoutingPlanDetail.Routing_algorithm = _existingRoutingPlanDetailRow.Routing_algorithm;
pDb.RoutingPlanDetailCollection.Insert(_newRoutingPlanDetail);
//1.2 get TermChoices for existing RoutingPlanDetail
var _existingTermChoiceRows = pDb.TerminationChoiceCollection.GetByRoutingPlanIdRouteId_OrderByPriority(_existingRoutingPlanDetailRow.Routing_plan_id, _existingRoutingPlanDetailRow.Route_id);
foreach (var _existingTermChoiceRow in _existingTermChoiceRows)
{
//1.2.1 clone/insert TermChoice for a new RoutingPlan
var _newTermChoiceRow = new TerminationChoiceRow();
_newTermChoiceRow.Routing_plan_id = _newRoutingPlanDetail.Routing_plan_id;
_newTermChoiceRow.Route_id = _newRoutingPlanDetail.Route_id;
_newTermChoiceRow.Priority = _existingTermChoiceRow.Priority;
_newTermChoiceRow.Carrier_route_id = _existingTermChoiceRow.Carrier_route_id;
pDb.TerminationChoiceCollection.Insert(_newTermChoiceRow);
}
////1.3 get LCRBlackList for existing RoutingPlanDetail
//LCRBlackListRow[] _existingLCRBlackListRows = pDb.LCRBlackListCollection.GetByRouting_plan_id_Route_id(_existingRoutingPlanDetailRow.Routing_plan_id, _existingRoutingPlanDetailRow.Route_id);
//foreach (LCRBlackListRow _existingLCRBlackListRow in _existingLCRBlackListRows) {
// //1.3.1 clone/insert LCRBlackList for a new RoutingPlan
// LCRBlackListRow _newLCRBlackListRow = new LCRBlackListRow();
// _newLCRBlackListRow.Routing_plan_id = _newRoutingPlanDetail.Routing_plan_id;
// _newLCRBlackListRow.Route_id = _newRoutingPlanDetail.Route_id;
// _newLCRBlackListRow.Carrier_acct_id = _existingLCRBlackListRow.Carrier_acct_id;
// pDb.LCRBlackListCollection.Insert(_newLCRBlackListRow);
//}
}
}
public static BaseRouteDto[] GetUnusedBaseRoutes(RoutingPlanDto pRoutingPlan)
{
using (var _db = new Rbr_Db()) {
return(RoutingManager.GetUnusedByCallingPlanIdRoutingPlanId(_db, pRoutingPlan.CallingPlanId, pRoutingPlan.RoutingPlanId));
}
}
static RoutingPlanDetailDto mapToRoutingPlanDetail(RoutingPlanDetailRow pRoutingPlanDetailRow, BaseRouteDto pBaseRoute, RoutingPlanDto pRoutingPlan, RouteState pRoutingPlanDetailRouteState)
{
if (pRoutingPlanDetailRow == null)
{
return(null);
}
var _routingPlanDetail = new RoutingPlanDetailDto();
_routingPlanDetail.RoutingPlan = pRoutingPlan;
_routingPlanDetail.BaseRoute = pBaseRoute;
_routingPlanDetail.Algorithm = pRoutingPlanDetailRow.Algorithm;
_routingPlanDetail.RouteState = pRoutingPlanDetailRouteState;
return(_routingPlanDetail);
}
internal static void UpdateRoutingPlan(Rbr_Db pDb, RoutingPlanDto pRoutingPlan)
{
var _routingPlanRow = mapToRoutingPlanRow(pRoutingPlan);
pDb.RoutingPlanCollection.Update(_routingPlanRow);
}
