/// <summary>
/// Converts <see cref="System.Data.DataRow"/> to <see cref="DialPeerViewRow"/>.
/// </summary>
/// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param>
/// <returns>A reference to the <see cref="DialPeerViewRow"/> object.</returns>
protected virtual DialPeerViewRow MapRow(DataRow row)
{
DialPeerViewRow mappedObject = new DialPeerViewRow();
DataTable dataTable = row.Table;
DataColumn dataColumn;
// Column "End_point_id"
dataColumn = dataTable.Columns["End_point_id"];
if (!row.IsNull(dataColumn))
{
mappedObject.End_point_id = (short)row[dataColumn];
}
// Column "Prefix_in"
dataColumn = dataTable.Columns["Prefix_in"];
if (!row.IsNull(dataColumn))
{
mappedObject.Prefix_in = (string)row[dataColumn];
}
// Column "Customer_acct_id"
dataColumn = dataTable.Columns["Customer_acct_id"];
if (!row.IsNull(dataColumn))
{
mappedObject.Customer_acct_id = (short)row[dataColumn];
}
// Column "Alias"
dataColumn = dataTable.Columns["Alias"];
if (!row.IsNull(dataColumn))
{
mappedObject.Alias = (string)row[dataColumn];
}
// Column "Prefix_type_descr"
dataColumn = dataTable.Columns["Prefix_type_descr"];
if (!row.IsNull(dataColumn))
{
mappedObject.Prefix_type_descr = (string)row[dataColumn];
}
// Column "Prefix_type_length"
dataColumn = dataTable.Columns["Prefix_type_length"];
if (!row.IsNull(dataColumn))
{
mappedObject.Prefix_type_length = (byte)row[dataColumn];
}
// Column "Prefix_type_delimiter"
dataColumn = dataTable.Columns["Prefix_type_delimiter"];
if (!row.IsNull(dataColumn))
{
mappedObject.Prefix_type_delimiter = (byte)row[dataColumn];
}
// Column "Customer_acct_name"
dataColumn = dataTable.Columns["Customer_acct_name"];
if (!row.IsNull(dataColumn))
{
mappedObject.Customer_acct_name = (string)row[dataColumn];
}
// Column "Service_id"
dataColumn = dataTable.Columns["Service_id"];
if (!row.IsNull(dataColumn))
{
mappedObject.Service_id = (short)row[dataColumn];
}
// Column "Customer_acct_status"
dataColumn = dataTable.Columns["Customer_acct_status"];
if (!row.IsNull(dataColumn))
{
mappedObject.Customer_acct_status = (byte)row[dataColumn];
}
// Column "Prefix_out"
dataColumn = dataTable.Columns["Prefix_out"];
if (!row.IsNull(dataColumn))
{
mappedObject.Prefix_out = (string)row[dataColumn];
}
// Column "Partner_id"
dataColumn = dataTable.Columns["Partner_id"];
if (!row.IsNull(dataColumn))
{
mappedObject.Partner_id = (int)row[dataColumn];
}
// Column "Allow_rerouting"
dataColumn = dataTable.Columns["Allow_rerouting"];
if (!row.IsNull(dataColumn))
{
mappedObject.Allow_rerouting = (byte)row[dataColumn];
}
// Column "Service_name"
dataColumn = dataTable.Columns["Service_name"];
if (!row.IsNull(dataColumn))
{
mappedObject.Service_name = (string)row[dataColumn];
}
// Column "Service_type"
dataColumn = dataTable.Columns["Service_type"];
if (!row.IsNull(dataColumn))
{
mappedObject.Service_type = (byte)row[dataColumn];
}
// Column "Service_retail_type"
dataColumn = dataTable.Columns["Service_retail_type"];
if (!row.IsNull(dataColumn))
{
mappedObject.Service_retail_type = (int)row[dataColumn];
}
// Column "Partner_name"
dataColumn = dataTable.Columns["Partner_name"];
if (!row.IsNull(dataColumn))
{
mappedObject.Partner_name = (string)row[dataColumn];
}
// Column "Partner_status"
dataColumn = dataTable.Columns["Partner_status"];
if (!row.IsNull(dataColumn))
{
mappedObject.Partner_status = (byte)row[dataColumn];
}
return(mappedObject);
}
/// <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 view.</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="DialPeerViewRow"/> objects.</returns>
protected virtual DialPeerViewRow[] 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 end_point_idColumnIndex = reader.GetOrdinal("end_point_id");
int prefix_inColumnIndex = reader.GetOrdinal("prefix_in");
int customer_acct_idColumnIndex = reader.GetOrdinal("customer_acct_id");
int aliasColumnIndex = reader.GetOrdinal("alias");
int prefix_type_descrColumnIndex = reader.GetOrdinal("prefix_type_descr");
int prefix_type_lengthColumnIndex = reader.GetOrdinal("prefix_type_length");
int prefix_type_delimiterColumnIndex = reader.GetOrdinal("prefix_type_delimiter");
int customer_acct_nameColumnIndex = reader.GetOrdinal("customer_acct_name");
int service_idColumnIndex = reader.GetOrdinal("service_id");
int customer_acct_statusColumnIndex = reader.GetOrdinal("customer_acct_status");
int prefix_outColumnIndex = reader.GetOrdinal("prefix_out");
int partner_idColumnIndex = reader.GetOrdinal("partner_id");
int allow_reroutingColumnIndex = reader.GetOrdinal("allow_rerouting");
int service_nameColumnIndex = reader.GetOrdinal("service_name");
int service_typeColumnIndex = reader.GetOrdinal("service_type");
int service_retail_typeColumnIndex = reader.GetOrdinal("service_retail_type");
int partner_nameColumnIndex = reader.GetOrdinal("partner_name");
int partner_statusColumnIndex = reader.GetOrdinal("partner_status");
System.Collections.ArrayList recordList = new System.Collections.ArrayList();
int ri = -startIndex;
while (reader.Read())
{
ri++;
if (ri > 0 && ri <= length)
{
DialPeerViewRow record = new DialPeerViewRow();
recordList.Add(record);
record.End_point_id = Convert.ToInt16(reader.GetValue(end_point_idColumnIndex));
record.Prefix_in = Convert.ToString(reader.GetValue(prefix_inColumnIndex));
record.Customer_acct_id = Convert.ToInt16(reader.GetValue(customer_acct_idColumnIndex));
if (!reader.IsDBNull(aliasColumnIndex))
{
record.Alias = Convert.ToString(reader.GetValue(aliasColumnIndex));
}
if (!reader.IsDBNull(prefix_type_descrColumnIndex))
{
record.Prefix_type_descr = Convert.ToString(reader.GetValue(prefix_type_descrColumnIndex));
}
if (!reader.IsDBNull(prefix_type_lengthColumnIndex))
{
record.Prefix_type_length = Convert.ToByte(reader.GetValue(prefix_type_lengthColumnIndex));
}
if (!reader.IsDBNull(prefix_type_delimiterColumnIndex))
{
record.Prefix_type_delimiter = Convert.ToByte(reader.GetValue(prefix_type_delimiterColumnIndex));
}
if (!reader.IsDBNull(customer_acct_nameColumnIndex))
{
record.Customer_acct_name = Convert.ToString(reader.GetValue(customer_acct_nameColumnIndex));
}
if (!reader.IsDBNull(service_idColumnIndex))
{
record.Service_id = Convert.ToInt16(reader.GetValue(service_idColumnIndex));
}
if (!reader.IsDBNull(customer_acct_statusColumnIndex))
{
record.Customer_acct_status = Convert.ToByte(reader.GetValue(customer_acct_statusColumnIndex));
}
if (!reader.IsDBNull(prefix_outColumnIndex))
{
record.Prefix_out = Convert.ToString(reader.GetValue(prefix_outColumnIndex));
}
if (!reader.IsDBNull(partner_idColumnIndex))
{
record.Partner_id = Convert.ToInt32(reader.GetValue(partner_idColumnIndex));
}
if (!reader.IsDBNull(allow_reroutingColumnIndex))
{
record.Allow_rerouting = Convert.ToByte(reader.GetValue(allow_reroutingColumnIndex));
}
if (!reader.IsDBNull(service_nameColumnIndex))
{
record.Service_name = Convert.ToString(reader.GetValue(service_nameColumnIndex));
}
if (!reader.IsDBNull(service_typeColumnIndex))
{
record.Service_type = Convert.ToByte(reader.GetValue(service_typeColumnIndex));
}
if (!reader.IsDBNull(service_retail_typeColumnIndex))
{
record.Service_retail_type = Convert.ToInt32(reader.GetValue(service_retail_typeColumnIndex));
}
if (!reader.IsDBNull(partner_nameColumnIndex))
{
record.Partner_name = Convert.ToString(reader.GetValue(partner_nameColumnIndex));
}
if (!reader.IsDBNull(partner_statusColumnIndex))
{
record.Partner_status = Convert.ToByte(reader.GetValue(partner_statusColumnIndex));
}
if (ri == length && 0 != totalRecordCount)
{
break;
}
}
}
totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1;
return((DialPeerViewRow[])(recordList.ToArray(typeof(DialPeerViewRow))));
}
