Esempio n. 1
0
        public CustomerAcct(CustomerAcctRow pCustomerAcctRow)
        {
            customerAcctRow = pCustomerAcctRow;
            status          = (Status)customerAcctRow.Status;
            email           = string.Empty;

            //--
            using (var _db = new Rbr_Db()) {
                partnerRow = _db.PartnerCollection.GetByPrimaryKey(customerAcctRow.Partner_id);
            }
            if (partnerRow == null)
            {
                throw new Exception("Couldn't FIND PartnerRow for Customer: " + customerAcctRow.Customer_acct_id);
            }

            //--
            ServiceRow _serviceRow;

            using (var _db = new Rbr_Db()) {
                _serviceRow = _db.ServiceCollection.GetByPrimaryKey(customerAcctRow.Service_id);
            }
            if (_serviceRow == null)
            {
                throw new Exception("Couldn't FIND ServiceRow for Customer: " + customerAcctRow.Customer_acct_id);
            }
            serviceType     = _serviceRow.ServiceType;
            retailType      = _serviceRow.RetailType;
            isPrepaid       = customerAcctRow.IsPrepaid;
            isRatingEnabled = _serviceRow.IsRatingEnabled;
            callingPlanId   = _serviceRow.Calling_plan_id;

            //TODO: set max number of calls from db
            MaxNumberOfCalls = 1000;

            if (isPrepaid)                      //get email, so we can send balance warnings to Partners as well
            {
                using (var _db = new Rbr_Db()) {
                    var _partnerRow = _db.PartnerCollection.GetByPrimaryKey(customerAcctRow.Partner_id);
                    if (_partnerRow == null)
                    {
                        throw new Exception("Couldn't FIND PartnerRow for Customer: " + customerAcctRow.Customer_acct_id);
                    }
                    var _contactInfoRow = _db.ContactInfoCollection.GetByPrimaryKey(_partnerRow.Contact_info_id);
                    if (_contactInfoRow != null)
                    {
                        email = _contactInfoRow.Email;
                    }
                }
            }
        }
Esempio n. 2
0
        internal static ServiceDto[] GetSharedServices(Rbr_Db pDb, RetailType pRetailType)
        {
            var _list = new List <ServiceDto>();

            ServiceRow[] _serviceRows = pDb.ServiceCollection.GetSharedByRetailType(pRetailType);

            if (_serviceRows != null)
            {
                foreach (ServiceRow _serviceRow in _serviceRows)
                {
                    _list.Add(getService(pDb, _serviceRow, 0));
                }
            }
            return(_list.ToArray());
        }
Esempio n. 3
0
        public ServiceRow[] GetSharedByRetailType(RetailType pRetailType)
        {
            string _wherSql =
                ServiceRow.type_DbName + " = " + Database.CreateSqlParameterName(ServiceRow.type_PropName) +
                " AND " +
                ServiceRow.is_shared_DbName + " = " + Database.CreateSqlParameterName(ServiceRow.is_shared_PropName) +
                " AND " +
                ServiceRow.retail_type_DbName + " = " + Database.CreateSqlParameterName(ServiceRow.retail_type_PropName);
            IDbCommand _cmd = base.CreateGetCommand(_wherSql, ServiceRow.name_DbName);

            AddParameter(_cmd, ServiceRow.type_PropName, (byte)ServiceType.Retail);
            AddParameter(_cmd, ServiceRow.is_shared_PropName, 1);
            AddParameter(_cmd, ServiceRow.retail_type_PropName, (int)pRetailType);
            using (IDataReader _reader = _cmd.ExecuteReader()) {
                return(MapRecords(_reader));
            }
        }
Esempio n. 4
0
        public static void AddDialPeersForEndpoint(short pEndpointId, string pPrefix, short pCustomerAcctId, RetailType pRetailType)
        {
            using (var _db = new Rbr_Db()) {
                using (var _tx = new Transaction(_db, pEndpointId, pPrefix, pCustomerAcctId, pRetailType)) {
                    var _endpointRow = EndpointManager.Get(_db, pEndpointId);
                    if (_endpointRow == null)
                    {
                        throw new Exception(string.Format("Endpoint NOT FOUND, EndpointId={0}", pEndpointId));
                    }

                    var _dialPeerRow = CustomerAcctManager.GetDialPeerRow(_db, pEndpointId, pPrefix);
                    if (_dialPeerRow == null)
                    {
                        _dialPeerRow = new DialPeerRow
                        {
                            End_point_id     = pEndpointId,
                            Prefix_in        = pPrefix,
                            Customer_acct_id = pCustomerAcctId
                        };
                        CustomerAcctManager.AddDialPeer(_db, _dialPeerRow, _endpointRow);
                    }

                    //-- If Retail, add accessNumber DialPeers
                    if (pRetailType == RetailType.PhoneCard || pRetailType == RetailType.Residential)
                    {
                        var _accessNumberRows = ServiceManager.GetAccessNumbers(_db, pCustomerAcctId);
                        foreach (var _accessNumberRow in _accessNumberRows)
                        {
                            _dialPeerRow = new DialPeerRow
                            {
                                End_point_id     = pEndpointId,
                                Prefix_in        = _accessNumberRow.Access_number.ToString(),
                                Customer_acct_id = pCustomerAcctId
                            };
                            CustomerAcctManager.AddDialPeer(_db, _dialPeerRow, _endpointRow);
                        }
                    }
                    _tx.Commit();
                }
            }
        }
Esempio n. 5
0
 internal static ServiceRow[] GetAllShared(Rbr_Db pDb, RetailType pRetailType)
 {
     return(pDb.ServiceCollection.GetSharedByRetailType(pRetailType));
 }
Esempio n. 6
0
 public static ServiceDto[] GetShared(RetailType pRetailType)
 {
     using (Rbr_Db _db = new Rbr_Db()) {
         return(ServiceManager.GetSharedServices(_db, pRetailType));
     }
 }