static PartnerDto getInfo(Rbr_Db pDb, PartnerRow pPartnerRow) { if (pPartnerRow == null) { return(null); } ScheduleDto _billingSchedule = ScheduleManager.Get(pDb, pPartnerRow.Billing_schedule_id); ContactInfoDto _contactInfo = ContactInfoManager.Get(pDb, pPartnerRow.Contact_info_id); PersonDto[] _employees = PersonManager.GetByPartnerId(pDb, pPartnerRow.Partner_id); return(MapToPartner(pPartnerRow, _billingSchedule, _contactInfo, _employees)); }
RetailAccountDto get(Rbr_Db pDb, short pServiceId, RetailAccountRow pRetailAccountRow) { if (pRetailAccountRow != null) { ServiceRow _serviceRow = ServiceManager.Get(pDb, pServiceId); RetailAccountDto _retailAccount = mapToRetailAccount(pRetailAccountRow); _retailAccount.ServiceId = pServiceId; _retailAccount.RetailType = _serviceRow.RetailType; _retailAccount.Person = PersonManager.GetByRetailAcctId(pDb, pRetailAccountRow.Retail_acct_id); PhoneCardDto[] _phoneCards = mapToPhoneCards(pDb.PhoneCardCollection.GetByRetail_acct_id(_retailAccount.RetailAcctId)); if (_phoneCards != null && _phoneCards.Length > 0) { _retailAccount.PhoneCards = _phoneCards; foreach (PhoneCardDto _phoneCard in _phoneCards) { if (_retailAccount.ServiceId != _phoneCard.ServiceId) { throw new Exception("Retail Account has a card from a different Service. [RetailAcctId=" + _retailAccount.RetailAcctId + "] [RetailAccount.ServiceId=" + _retailAccount.ServiceId + "] [PhoneCard.ServiceId=" + _phoneCard.ServiceId + "]"); } } } ResidentialPSTNDto[] _residentialPSTNs = mapToResidentialPSTNs(pDb.ResidentialPSTNCollection.GetByRetail_acct_id(_retailAccount.RetailAcctId)); if (_residentialPSTNs != null && _residentialPSTNs.Length > 0) { _retailAccount.ResidentialPSTNs = _residentialPSTNs; foreach (ResidentialPSTNDto _residentialPSTN in _residentialPSTNs) { if (_retailAccount.ServiceId != _residentialPSTN.ServiceId) { throw new Exception("Retail Account has a ResidentialPSTN from a different Service. [RetailAcctId=" + _retailAccount.RetailAcctId + "] [RetailAccount.ServiceId=" + _retailAccount.ServiceId + "] [ResidentialPSTN.ServiceId=" + _residentialPSTN.ServiceId + "]"); } } } //ResidentialVoIP[] _residentialVoIPs = mapToResidentialVoIPs(pDb.ResidentialVoIPCollection.GetByRetail_acct_id(_retailAccount.RetailAcctId)); //if (_residentialVoIPs != null && _residentialVoIPs.Length > 0) { // _retailAccount.ResidentialVoIPs = _residentialVoIPs; // foreach (ResidentialVoIP _residentialVoIP in _residentialVoIPs) { // if (_retailAccount.ServiceId != _residentialVoIP.ServiceId) { // throw new Exception("Retail Account has a ResidentialVoIP from a different Service. [RetailAcctId=" + _retailAccount.RetailAcctId + "] [RetailAccount.ServiceId=" + _retailAccount.ServiceId + "] [ResidentialVoIP.ServiceId=" + _residentialVoIP.ServiceId + "]"); // } // } //} return(_retailAccount); } return(null); }
internal static RetailAccountPaymentDto[] GetByRetailAcctId(Rbr_Db pDb, int pRetailAcctId) { var _list = new ArrayList(); RetailAccountPaymentRow[] _retailAccountPaymentRows = pDb.RetailAccountPaymentCollection.GetByRetail_acct_id(pRetailAcctId); foreach (RetailAccountPaymentRow _retailAccountPaymentRow in _retailAccountPaymentRows) { BalanceAdjustmentReasonDto _balanceAdjustmentReason = BalanceAdjustmentReasonManager.Get(pDb, _retailAccountPaymentRow.Balance_adjustment_reason_id); PersonDto _person = PersonManager.Get(pDb, _retailAccountPaymentRow.Person_id); _list.Add(mapToRetailAccountPayment(_retailAccountPaymentRow, _person, _balanceAdjustmentReason)); } if (_list.Count > 1) { _list.Sort(new GenericComparer(RetailAccountPaymentDto.DateTime_PropName, ListSortDirection.Descending)); } return((RetailAccountPaymentDto[])_list.ToArray(typeof(RetailAccountPaymentDto))); }
internal static CustomerAcctPaymentDto[] GetByPersonId(Rbr_Db pDb, int pPersonId) { var _list = new ArrayList(); var _customerAcctPaymentRows = pDb.CustomerAcctPaymentCollection.GetByPerson_id(pPersonId); foreach (var _customerAcctPaymentRow in _customerAcctPaymentRows) { var _balanceAdjustmentReason = BalanceAdjustmentReasonManager.Get(pDb, _customerAcctPaymentRow.Balance_adjustment_reason_id); var _person = PersonManager.Get(pDb, _customerAcctPaymentRow.Person_id); var _customerAcctRow = Get(pDb, _customerAcctPaymentRow.Customer_acct_id); _list.Add(mapToCustomerAcctPayment(_customerAcctPaymentRow, _customerAcctRow.Name, _person, _balanceAdjustmentReason)); } if (_list.Count > 1) { _list.Sort(new GenericComparer(CustomerAcctPaymentDto.DateTime_PropName, ListSortDirection.Descending)); } return((CustomerAcctPaymentDto[])_list.ToArray(typeof(CustomerAcctPaymentDto))); }