public void AddRoutes(short pAccountId, int[] pBaseRouteIds, ViewContext pContext)
{
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pAccountId, pBaseRouteIds, pContext)) {
if (pContext == ViewContext.Carrier)
{
var _carrierAcct = CarrierAcctManager.GetAcct(_db, pAccountId);
CarrierRouteManager.Add(_db, _carrierAcct, pBaseRouteIds);
}
else if (pContext == ViewContext.Customer)
{
//NOTE: same as ServiceDialPlan
CustomerRouteManager.Add(_db, pAccountId, pBaseRouteIds);
}
else if (pContext == ViewContext.Service)
{
//NOTE: same as CustomerDialPlan
CustomerRouteManager.Add(_db, pAccountId, pBaseRouteIds);
}
else
{
throw new NotImplementedException("ViewContext: " + pContext);
}
_tx.Commit();
}
}
}
//public static RatingInfoDto[] GetRates(short pAcctId, int pCountryId, RouteType pRouteType, DateTime pDate) {
// using (var _db = new Rbr_Db()) {
// if (pRouteType == RouteType.Carrier) {
// throw new NotImplementedException();
// }
// if (pRouteType == RouteType.Wholesale) {
// return getWholesaleRates(_db, pAcctId, pRouteType, pCountryId, pDate);
// }
// //else if (pRouteType == RouteType.Retail) {
// // //TODO:
// //}
// throw new ArgumentException(string.Format("UNSUPPORTED Type : {0}", pRouteType), "pRouteType");
// }
//}
public static RatingHistoryEntry GetNewRatingHistoryEntry(int pRatedRouteId, RouteType pRouteType)
{
using (var _db = new Rbr_Db()) {
RatedRouteDto _route = null;
if (pRouteType == RouteType.Carrier)
{
_route = CarrierRouteManager.Get(_db, pRatedRouteId);
}
else if (pRouteType == RouteType.Wholesale)
{
_route = CustomerRouteManager.Get(_db, pRatedRouteId);
}
else if (pRouteType == RouteType.Retail)
{
}
if (_route != null)
{
var _ratingInfo = _route.DefaultRatingInfo.Clone();
if (_ratingInfo != null)
{
var _ratingHistoryEntry = new RatingHistoryEntry(pRouteType, pRatedRouteId, DateTime.Today, Configuration.Instance.Db.SqlSmallDateTimeMaxValue, _ratingInfo.Clone());
_ratingHistoryEntry.HasChanged = true;
return(_ratingHistoryEntry);
}
}
return(null);
}
}
public RatedRouteDto[] GetByAccountIdCountryId(short pAccountId, int pCountryId, ViewContext pContext)
{
using (var _db = new Rbr_Db()) {
if (pContext == ViewContext.Carrier)
{
return(CarrierRouteManager.GetByCarrierAcctIdCountryId(_db, pAccountId, pCountryId));
}
if (pContext == ViewContext.Customer || pContext == ViewContext.Service)
{
return(CustomerRouteManager.Get(_db, pAccountId, pCountryId));
}
throw new NotImplementedException("ViewContext: " + pContext);
}
}
public static void AddAcct(CarrierAcctDto pCarrierAcct, int[] pSelectedBaseRouteIds)
{
using (Rbr_Db _db = new Rbr_Db()) {
using (Transaction _tx = new Transaction(_db, pCarrierAcct, pSelectedBaseRouteIds)) {
CarrierAcctManager.AddCarrierAcct(_db, pCarrierAcct);
//Create Default Route
int _defaultCarrierRouteId;
CarrierRouteManager.Add(_db, pCarrierAcct, 0, out _defaultCarrierRouteId);
pCarrierAcct.DefaultRoute.RatedRouteId = _defaultCarrierRouteId;
CarrierRouteManager.Add(_db, pCarrierAcct, pSelectedBaseRouteIds);
_tx.Commit();
}
}
}
protected int getCarrierRouteId(Rbr_Db pDb, short pCarrierAcctId, int pBaseRouteId)
{
try {
RatedRouteDto _carrierRoute = CarrierRouteManager.Get(pDb, pCarrierAcctId, pBaseRouteId);
if (_carrierRoute == null)
{
string _msg = string.Format("Skipping Route, doesn't exists in DialPlan. {0}, {1}.", pCarrierAcctId, pBaseRouteId);
TimokLogger.Instance.LogRbr(LogSeverity.Error, "ServiceController.getCarrierRouteId", string.Format("ServiceController.importRatesOnly | {0}", _msg));
Host.ReportStatus(_msg);
return(0);
}
return(_carrierRoute.RatedRouteId);
}
catch (Exception _ex) {
string _msg = string.Format("ERROR: {0}, getCarrierRouteId: {1}, {2}", pCarrierAcctId, pBaseRouteId, _ex.Message);
Host.ReportStatus(_msg);
TimokLogger.Instance.LogRbr(LogSeverity.Error, "RatesImporter.getCarrierRouteId", string.Format("{0}\r\n{1}", _msg, _ex));
throw;
}
}
public RatedRouteDto Get(int pRouteId, ViewContext pContext)
{
using (var _db = new Rbr_Db()) {
if (pContext == ViewContext.Carrier)
{
return(CarrierRouteManager.Get(_db, pRouteId));
}
if (pContext == ViewContext.Customer)
{
//NOTE: same as ServiceDialPlan
return(CustomerRouteManager.Get(_db, pRouteId));
}
if (pContext == ViewContext.Service)
{
//NOTE: same as CustomerDialPlan
return(CustomerRouteManager.Get(_db, pRouteId));
}
throw new NotImplementedException("ViewContext: " + pContext);
}
}
public void DeleteRoute(RatedRouteDto pRoute, ViewContext pContext)
{
using (var _db = new Rbr_Db()) {
using (var _tx = new Transaction(_db, pRoute, pContext)) {
if (pContext == ViewContext.Carrier)
{
CarrierRouteManager.Delete(_db, pRoute);
}
else if (pContext == ViewContext.Customer)
{
CustomerRouteManager.Delete(_db, pRoute);
}
else if (pContext == ViewContext.Service)
{
CustomerRouteManager.Delete(_db, pRoute);
}
else
{
throw new NotImplementedException("ViewContext: " + pContext);
}
_tx.Commit();
}
}
}
