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);
}
