public static List <CdrDto> GetByStartRetailAcctId(DateTime pDate, int pRetailAcctId) { var _cdrViewRows = new CDRViewRow[0]; if (Cdr_Db.Exists(pDate)) { using (var db = new Cdr_Db(pDate)) { _cdrViewRows = db.CDRViewCollection.GetByStartRetailAcctId(pDate, pRetailAcctId); } } return(mapToCDRs(_cdrViewRows)); }
public static List <CdrDto> GetCDRsByCarrierAcctIdEndpointId(int pStartTimokDate, int pEndTimokDate, short pCarrierAcctId, short pEndpointId) { var _cdrViewRows = new CDRViewRow[0]; if (Cdr_Db.Exists(TimokDate.ToDateTime(pStartTimokDate))) { using (var db = new Cdr_Db(TimokDate.ToDateTime(pStartTimokDate))) { _cdrViewRows = db.CDRViewCollection.GetByCarrierAcctIdEndpointId(pStartTimokDate, pEndTimokDate, pCarrierAcctId, pEndpointId); } } return(mapToCDRs(_cdrViewRows)); }
public static List <CdrDto> GetRetailAcctCDRs(int pStartTimokDate, int pEndTimokDate, int pRetailAcctId) { var _cdrViewRows = new CDRViewRow[0]; if (Cdr_Db.Exists(TimokDate.ToDateTime(pStartTimokDate))) { using (var db = new Cdr_Db(TimokDate.ToDateTime(pStartTimokDate))) { _cdrViewRows = db.CDRViewCollection.GetByRetailAcctId(pStartTimokDate, pEndTimokDate, pRetailAcctId); } } return(mapToCDRs(_cdrViewRows)); }
public static List <CdrDto> GetCDRsByRetailAcctId(int pStartTimokDate, int pEndTimokDate, int pRetailAcctId, int pPageNumber, int pPageSize, out int pTotalCount) { pTotalCount = 0; var _cdrViewRows = new CDRViewRow[0]; if (Cdr_Db.Exists(TimokDate.ToDateTime(pStartTimokDate))) { using (var _db = new Cdr_Db(TimokDate.ToDateTime(pStartTimokDate))) { _cdrViewRows = _db.CDRViewCollection.GetByRetailAcctIdPaged(pStartTimokDate, pEndTimokDate, pRetailAcctId, pPageNumber, pPageSize, out pTotalCount); } } return(mapToCDRs(_cdrViewRows)); }
public static List <CdrDto> GetCDRsByCustomerAcctId(DateTime pDate, short pCustomerAcctId) { var _cdrViewRows = new CDRViewRow[0]; int _startTimokDate = TimokDate.Parse(pDate, TimokDate.MinHour); int _endTimokDate = TimokDate.Parse(pDate, TimokDate.MaxHour); if (Cdr_Db.Exists(pDate)) { using (var _db = new Cdr_Db(pDate)) { _cdrViewRows = _db.CDRViewCollection.GetByCustomer_acct_id(_startTimokDate, _endTimokDate, pCustomerAcctId); } } return(mapToCDRs(_cdrViewRows)); }
public static List <CdrDto> GetCDRsByCustomerAcctIdPaged(DateTime pDate, short pCustomerAcctId, int pPageNumber, int pPageSize, out int pTotalCount) { pTotalCount = 0; var _cdrViewRows = new CDRViewRow[0]; int _startTimokDate = TimokDate.Parse(pDate, TimokDate.MinHour); int _endTimokDate = TimokDate.Parse(pDate, TimokDate.MaxHour); if (Cdr_Db.Exists(pDate)) { using (var _db = new Cdr_Db(pDate)) { _cdrViewRows = _db.CDRViewCollection.GetByCustomerAcctIdPaged(_startTimokDate, _endTimokDate, pCustomerAcctId, pPageNumber, pPageSize, out pTotalCount); } } return(mapToCDRs(_cdrViewRows)); }
static string mapToExportedRecord(CDRViewRow pCDRViewRow, CdrExportMapDto pCdrExportMap) { var _record = new StringBuilder(); foreach (var _field in pCdrExportMap.CdrExportMapDetails) { if (_field.IsDateTimeField && _field.FormatType != null && _field.FormatType.Trim().Length > 0) { var _date = DateTime.Parse(pCDRViewRow[_field.FieldName]); _record.Append(_date.ToString(_field.DateTimeFormat)); } else { _record.Append(pCDRViewRow[_field.FieldName]); } _record.Append((char)pCdrExportMap.CdrExportDelimeter); } return(_record.ToString()); }
private static CdrDto mapToCDRDto(CDRViewRow pCDRViewRow) { var _cdr = new CdrDto(); _cdr.Guid = pCDRViewRow.Id; _cdr.ANI = pCDRViewRow.ANI; _cdr.CarrierAcctId = pCDRViewRow.Carrier_acct_id; _cdr.CarrierAcctName = pCDRViewRow.Carrier_acct_name; _cdr.CarrierRouteId = pCDRViewRow.Carrier_route_id; _cdr.CarrierRouteName = pCDRViewRow.Carrier_route_name; _cdr.CarrierDuration = pCDRViewRow.Carrier_duration; _cdr.CarrierMinutes = pCDRViewRow.Carrier_minutes; _cdr.Ccode = pCDRViewRow.Ccode; _cdr.CarrierCost = pCDRViewRow.Cost; _cdr.CustomerAcctId = pCDRViewRow.Customer_acct_id; _cdr.CustomerAcctName = pCDRViewRow.Customer_acct_name; _cdr.CustomerDuration = pCDRViewRow.Customer_duration; _cdr.CustomerMinutes = pCDRViewRow.Minutes; //customer minutes _cdr.CustomerRouteId = pCDRViewRow.Customer_route_id; _cdr.CustomerRouteName = pCDRViewRow.Customer_route_name; _cdr.DateLogged = pCDRViewRow.Date_logged; _cdr.DialedNumber = pCDRViewRow.Dialed_number; _cdr.DisconnectCauseNumber = pCDRViewRow.Disconnect_cause; _cdr.DisconnectSourceNumber = pCDRViewRow.Disconnect_source; _cdr.DNIS = pCDRViewRow.DNIS; _cdr.InfoDigits = pCDRViewRow.Info_digits; _cdr.Leg2Duration = pCDRViewRow.Duration; _cdr.Leg1Duration = (short)pCDRViewRow.Date_logged.Subtract(pCDRViewRow.Start).TotalSeconds; if (_cdr.Leg1Duration < 0) { TimokLogger.Instance.LogRbr(LogSeverity.Error, "", string.Format("Negative Leg1 Duration, callID: {0}", pCDRViewRow.Id)); _cdr.Leg1Duration = (short)(_cdr.Leg2Duration + 2); } if (_cdr.Leg1Duration < _cdr.Leg2Duration) { TimokLogger.Instance.LogRbr(LogSeverity.Error, "", string.Format("Leg1 Duration < Leg2 Duration, callID: {0}", pCDRViewRow.Id)); _cdr.Leg1Duration = (short)(_cdr.Leg2Duration + 3); } _cdr.EndUserPrice = pCDRViewRow.End_user_price; _cdr.LocalNumber = pCDRViewRow.Local_number; _cdr.MappedDisconnectCauseNumber = pCDRViewRow.Mapped_disconnect_cause; _cdr.NodeId = pCDRViewRow.Node_id; _cdr.NodeName = pCDRViewRow.Node_name; _cdr.OrigAlias = pCDRViewRow.Orig_alias; _cdr.OrigDotIPAddress = pCDRViewRow.Orig_dot_IP_address; _cdr.OrigEndpointId = pCDRViewRow.Orig_end_point_id; _cdr.OrigIPAddress = pCDRViewRow.Orig_IP_address; _cdr.OrigPartnerId = pCDRViewRow.Orig_partner_id; _cdr.OrigPartnerName = pCDRViewRow.Orig_partner_name; _cdr.PrefixIn = pCDRViewRow.Prefix_in; _cdr.PrefixOut = pCDRViewRow.Prefix_out; _cdr.CustomerPrice = pCDRViewRow.Price; _cdr.RbrResultNumber = pCDRViewRow.Rbr_result; _cdr.RetailAcctId = pCDRViewRow.Retail_acct_id; _cdr.RetailDuration = pCDRViewRow.Retail_duration; _cdr.RetailMinutes = pCDRViewRow.Retail_minutes; _cdr.SerialNumber = pCDRViewRow.Serial_number; _cdr.Start = pCDRViewRow.Start; _cdr.TermAlias = pCDRViewRow.Term_alias; _cdr.TermEndpointId = pCDRViewRow.Term_end_point_id; _cdr.TermIPAddressRange = pCDRViewRow.Term_ip_address_range; _cdr.TermPartnerId = pCDRViewRow.Term_partner_id; _cdr.TermPartnerName = pCDRViewRow.Term_partner_name; _cdr.TimokDate = pCDRViewRow.Timok_date; _cdr.UsedBonusMinutes = pCDRViewRow.Used_bonus_minutes; _cdr.ResellerPrice = pCDRViewRow.Reseller_price; return(_cdr); }