protected virtual ChannelRow MapRow(DataRow row) { ChannelRow mappedObject = new ChannelRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "Channel_ID" dataColumn = dataTable.Columns["Channel_ID"]; if (!row.IsNull(dataColumn)) { mappedObject.Channel_ID = (int)row[dataColumn]; } // Column "Channel_Name" dataColumn = dataTable.Columns["Channel_Name"]; if (!row.IsNull(dataColumn)) { mappedObject.Channel_Name = (string)row[dataColumn]; } // Column "Channel_Description" dataColumn = dataTable.Columns["Channel_Description"]; if (!row.IsNull(dataColumn)) { mappedObject.Channel_Description = (string)row[dataColumn]; } return(mappedObject); }
public virtual bool Update(ChannelRow value) { string sqlStr = "UPDATE [dbo].[Channel] SET " + "[Channel_Name]=" + _db.CreateSqlParameterName("Channel_Name") + ", " + "[Channel_Description]=" + _db.CreateSqlParameterName("Channel_Description") + " WHERE " + "[Channel_ID]=" + _db.CreateSqlParameterName("Channel_ID"); IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "Channel_Name", value.Channel_Name); AddParameter(cmd, "Channel_Description", value.Channel_Description); AddParameter(cmd, "Channel_ID", value.Channel_ID); return(0 != cmd.ExecuteNonQuery()); }
protected virtual ChannelRow[] 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 channel_IDColumnIndex = reader.GetOrdinal("Channel_ID"); int channel_NameColumnIndex = reader.GetOrdinal("Channel_Name"); int channel_DescriptionColumnIndex = reader.GetOrdinal("Channel_Description"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { ChannelRow record = new ChannelRow(); recordList.Add(record); record.Channel_ID = Convert.ToInt32(reader.GetValue(channel_IDColumnIndex)); if (!reader.IsDBNull(channel_NameColumnIndex)) { record.Channel_Name = Convert.ToString(reader.GetValue(channel_NameColumnIndex)); } if (!reader.IsDBNull(channel_DescriptionColumnIndex)) { record.Channel_Description = Convert.ToString(reader.GetValue(channel_DescriptionColumnIndex)); } if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((ChannelRow[])(recordList.ToArray(typeof(ChannelRow)))); }
public virtual void Insert(ChannelRow value) { string sqlStr = "INSERT INTO [dbo].[Channel] (" + "[Channel_ID], " + "[Channel_Name], " + "[Channel_Description]" + ") VALUES (" + _db.CreateSqlParameterName("Channel_ID") + ", " + _db.CreateSqlParameterName("Channel_Name") + ", " + _db.CreateSqlParameterName("Channel_Description") + ")"; IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "Channel_ID", value.Channel_ID); AddParameter(cmd, "Channel_Name", value.Channel_Name); AddParameter(cmd, "Channel_Description", value.Channel_Description); cmd.ExecuteNonQuery(); }
public bool Delete(ChannelRow value) { return(DeleteByPrimaryKey(value.Channel_ID)); }