public static void Update(CdrExportMapDto pCdrExportMap) { using (var _db = new Rbr_Db()) { using (var _tx = new Transaction(_db, pCdrExportMap)) { CdrExportMapRow _cdrExportMapRow = MapToCdrExportMapRow(pCdrExportMap); _db.CdrExportMapCollection.Update(_cdrExportMapRow); //delete existing details _db.CdrExportMapDetailCollection.DeleteByMap_id(_cdrExportMapRow.Map_id); CdrExportMapDetailRow[] _cdrExportMapDetailRows = MapToCdrExportMapDetailRows(pCdrExportMap.CdrExportMapDetails); int _sequence = 0; //insert new foreach (CdrExportMapDetailRow _cdrExportMapDetailRow in _cdrExportMapDetailRows) { _sequence++; _cdrExportMapDetailRow.Map_detail_id = 0; _cdrExportMapDetailRow.Map_id = _cdrExportMapRow.Map_id; _cdrExportMapDetailRow.Sequence = _sequence; _db.CdrExportMapDetailCollection.Insert(_cdrExportMapDetailRow); } pCdrExportMap.CdrExportMapDetails = MapToCdrExportMapDetails(_cdrExportMapDetailRows); _tx.Commit(); } } }
public static void Add(CdrExportMapDto pCdrExportMap) { using (var _db = new Rbr_Db()) { using (var _tx = new Transaction(_db, pCdrExportMap)) { try { CdrExportMapRow _cdrExportMapRow = MapToCdrExportMapRow(pCdrExportMap); CdrExportMapDetailRow[] _cdrExportMapDetailRows = MapToCdrExportMapDetailRows(pCdrExportMap.CdrExportMapDetails); _db.CdrExportMapCollection.Insert(_cdrExportMapRow); pCdrExportMap.MapId = _cdrExportMapRow.Map_id; int _sequence = 0; foreach (CdrExportMapDetailRow _cdrExportMapDetailRow in _cdrExportMapDetailRows) { _sequence++; _cdrExportMapDetailRow.Map_id = _cdrExportMapRow.Map_id; _cdrExportMapDetailRow.Sequence = _sequence; _db.CdrExportMapDetailCollection.Insert(_cdrExportMapDetailRow); } pCdrExportMap.CdrExportMapDetails = MapToCdrExportMapDetails(_cdrExportMapDetailRows); _tx.Commit(); } catch { pCdrExportMap.MapId = 0; throw; } } } }
public CdrExportInfo(string pExportDirectory, DateTime pDateStart, DateTime pDateEnd, CdrExportMapDto pCdrExportMap, string pDecimalFormatString, ViewContext pContext, bool pWithRerating) { DateStart = pDateStart; DateEnd = pDateEnd; cdrExportMap = pCdrExportMap; ExportDirectory = pExportDirectory; DecimalFormatString = pDecimalFormatString; Context = pContext; WithRerating = pWithRerating; }
static CdrExportMapDto getMap(Rbr_Db_Base pDb, CdrExportMapRow pCdrExportMapRow) { if (pCdrExportMapRow == null) { return(null); } CdrExportMapDetailRow[] _cdrExportMapDetailRows = pDb.CdrExportMapDetailCollection.GetByMap_id(pCdrExportMapRow.Map_id); CdrExportMapDto _cdrExportMap = MapToCdrExportMap(pCdrExportMapRow); _cdrExportMap.CdrExportMapDetails = MapToCdrExportMapDetails(_cdrExportMapDetailRows); return(_cdrExportMap); }
internal static CdrExportMapDto MapToCdrExportMap(CdrExportMapRow pCdrExportMapRow) { if (pCdrExportMapRow == null) { return(null); } var _cdrExportMap = new CdrExportMapDto(); _cdrExportMap.MapId = pCdrExportMapRow.Map_id; _cdrExportMap.Name = pCdrExportMapRow.Name; _cdrExportMap.CdrExportDelimeter = pCdrExportMapRow.CdrExportDelimeter; //NOTE: not in use yet //_cdrExportMap.TargetDestFolder = pCdrExportMapRow.Target_dest_folder; return(_cdrExportMap); }
internal static CdrExportMapRow MapToCdrExportMapRow(CdrExportMapDto pCdrExportMap) { if (pCdrExportMap == null) { return(null); } var _cdrExportMapRow = new CdrExportMapRow(); _cdrExportMapRow.Map_id = pCdrExportMap.MapId; _cdrExportMapRow.Name = pCdrExportMap.Name; _cdrExportMapRow.CdrExportDelimeter = pCdrExportMap.CdrExportDelimeter; //NOTE: not in use yet _cdrExportMapRow.Target_dest_folder = string.Empty; // pCdrExportMap.TargetDestFolder; return(_cdrExportMapRow); }
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()); }
public OrigEndpointCdrExportInfo(short pOrigEndpointId, string pExportDirectory, DateTime pDateStart, DateTime pDateEnd, CdrExportMapDto pCdrExportMap, string pDecimalFormatString, ViewContext pContext, bool pWithRerating) : base(pExportDirectory, pDateStart, pDateEnd, pCdrExportMap, pDecimalFormatString, pContext, pWithRerating) { OrigEndpointId = pOrigEndpointId; }
public CarrierCdrExportInfo(CarrierAcctDto pCarrierAcct, string pExportDirectory, DateTime pDateStart, DateTime pDateEnd, CdrExportMapDto pCdrExportMap, string pDecimalFormatString, ViewContext pContext, bool pWithRerating) : base(pExportDirectory, pDateStart, pDateEnd, pCdrExportMap, pDecimalFormatString, pContext, pWithRerating) { CarrierAcctDto = pCarrierAcct; }