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(); } } }
/// <summary> /// Converts <see cref="System.Data.DataRow"/> to <see cref="CdrExportMapRow"/>. /// </summary> /// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param> /// <returns>A reference to the <see cref="CdrExportMapRow"/> object.</returns> protected virtual CdrExportMapRow MapRow(DataRow row) { CdrExportMapRow mappedObject = new CdrExportMapRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "Map_id" dataColumn = dataTable.Columns["Map_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Map_id = (int)row[dataColumn]; } // Column "Name" dataColumn = dataTable.Columns["Name"]; if (!row.IsNull(dataColumn)) { mappedObject.Name = (string)row[dataColumn]; } // Column "Delimiter" dataColumn = dataTable.Columns["Delimiter"]; if (!row.IsNull(dataColumn)) { mappedObject.Delimiter = (byte)row[dataColumn]; } // Column "Target_dest_folder" dataColumn = dataTable.Columns["Target_dest_folder"]; if (!row.IsNull(dataColumn)) { mappedObject.Target_dest_folder = (string)row[dataColumn]; } return(mappedObject); }
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; } } } }
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); }
/// <summary> /// Updates a record in the <c>CdrExportMap</c> table. /// </summary> /// <param name="value">The <see cref="CdrExportMapRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(CdrExportMapRow value) { string sqlStr = "UPDATE [dbo].[CdrExportMap] SET " + "[name]=" + _db.CreateSqlParameterName("Name") + ", " + "[delimiter]=" + _db.CreateSqlParameterName("Delimiter") + ", " + "[target_dest_folder]=" + _db.CreateSqlParameterName("Target_dest_folder") + " WHERE " + "[map_id]=" + _db.CreateSqlParameterName("Map_id"); IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "Name", value.Name); AddParameter(cmd, "Delimiter", value.Delimiter); AddParameter(cmd, "Target_dest_folder", value.Target_dest_folder); AddParameter(cmd, "Map_id", value.Map_id); return(0 != cmd.ExecuteNonQuery()); }
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); }
/// <summary> /// Reads data from the provided data reader and returns /// an array of mapped objects. /// </summary> /// <param name="reader">The <see cref="System.Data.IDataReader"/> object to read data from the table.</param> /// <param name="startIndex">The index of the first record to map.</param> /// <param name="length">The number of records to map.</param> /// <param name="totalRecordCount">A reference parameter that returns the total number /// of records in the reader object if 0 was passed into the method; otherwise it returns -1.</param> /// <returns>An array of <see cref="CdrExportMapRow"/> objects.</returns> protected virtual CdrExportMapRow[] MapRecords(IDataReader reader, int startIndex, int length, ref int totalRecordCount) { if (0 > startIndex) { throw new ArgumentOutOfRangeException("startIndex", startIndex, "StartIndex cannot be less than zero."); } if (0 > length) { throw new ArgumentOutOfRangeException("length", length, "Length cannot be less than zero."); } int map_idColumnIndex = reader.GetOrdinal("map_id"); int nameColumnIndex = reader.GetOrdinal("name"); int delimiterColumnIndex = reader.GetOrdinal("delimiter"); int target_dest_folderColumnIndex = reader.GetOrdinal("target_dest_folder"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { CdrExportMapRow record = new CdrExportMapRow(); recordList.Add(record); record.Map_id = Convert.ToInt32(reader.GetValue(map_idColumnIndex)); record.Name = Convert.ToString(reader.GetValue(nameColumnIndex)); record.Delimiter = Convert.ToByte(reader.GetValue(delimiterColumnIndex)); record.Target_dest_folder = Convert.ToString(reader.GetValue(target_dest_folderColumnIndex)); if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((CdrExportMapRow[])(recordList.ToArray(typeof(CdrExportMapRow)))); }
/// <summary> /// Adds a new record into the <c>CdrExportMap</c> table. /// </summary> /// <param name="value">The <see cref="CdrExportMapRow"/> object to be inserted.</param> public virtual void Insert(CdrExportMapRow value) { string sqlStr = "INSERT INTO [dbo].[CdrExportMap] (" + "[map_id], " + "[name], " + "[delimiter], " + "[target_dest_folder]" + ") VALUES (" + _db.CreateSqlParameterName("Map_id") + ", " + _db.CreateSqlParameterName("Name") + ", " + _db.CreateSqlParameterName("Delimiter") + ", " + _db.CreateSqlParameterName("Target_dest_folder") + ")"; IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "Map_id", value.Map_id); AddParameter(cmd, "Name", value.Name); AddParameter(cmd, "Delimiter", value.Delimiter); AddParameter(cmd, "Target_dest_folder", value.Target_dest_folder); cmd.ExecuteNonQuery(); }
/// <summary> /// Deletes the specified object from the <c>CdrExportMap</c> table. /// </summary> /// <param name="value">The <see cref="CdrExportMapRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(CdrExportMapRow value) { return(DeleteByPrimaryKey(value.Map_id)); }