/// <summary>
/// Adds a new record into the <c>AccessNumberList</c> table.
/// </summary>
/// <param name="value">The <see cref="AccessNumberListRow"/> object to be inserted.</param>
public virtual void Insert(AccessNumberListRow value)
{
string sqlStr = "INSERT INTO [dbo].[AccessNumberList] (" +
"[access_number], " +
"[service_id], " +
"[language], " +
"[surcharge], " +
"[surcharge_type], " +
"[customer_acct_id], " +
"[script_type]" +
") VALUES (" +
_db.CreateSqlParameterName("Access_number") + ", " +
_db.CreateSqlParameterName("Service_id") + ", " +
_db.CreateSqlParameterName("Language") + ", " +
_db.CreateSqlParameterName("Surcharge") + ", " +
_db.CreateSqlParameterName("Surcharge_type") + ", " +
_db.CreateSqlParameterName("Customer_acct_id") + ", " +
_db.CreateSqlParameterName("Script_type") + ")";
IDbCommand cmd = _db.CreateCommand(sqlStr);
AddParameter(cmd, "Access_number", value.Access_number);
AddParameter(cmd, "Service_id",
value.IsService_idNull ? DBNull.Value : (object)value.Service_id);
AddParameter(cmd, "Language", value.Language);
AddParameter(cmd, "Surcharge", value.Surcharge);
AddParameter(cmd, "Surcharge_type", value.Surcharge_type);
AddParameter(cmd, "Customer_acct_id",
value.IsCustomer_acct_idNull ? DBNull.Value : (object)value.Customer_acct_id);
AddParameter(cmd, "Script_type", value.Script_type);
cmd.ExecuteNonQuery();
}
static AccessNumberDto mapToAccessNumber(AccessNumberListRow pAccessNumberRow)
{
if (pAccessNumberRow == null)
{
return(null);
}
var _accessNumber = new AccessNumberDto
{
Number = pAccessNumberRow.Access_number,
ScriptType = pAccessNumberRow.ScriptType,
Language = pAccessNumberRow.ScriptLanguage,
Surcharge = pAccessNumberRow.Surcharge,
SurchargeType = pAccessNumberRow.SurchargeType
};
if (!pAccessNumberRow.IsCustomer_acct_idNull)
{
_accessNumber.CustomerAcctId = pAccessNumberRow.Customer_acct_id;
}
if (!pAccessNumberRow.IsService_idNull)
{
_accessNumber.ServiceId = pAccessNumberRow.Service_id;
}
return(_accessNumber);
}
static AccessNumberListRow mapToAccessNumberRow(AccessNumberDto pAccessNumber)
{
if (pAccessNumber == null)
{
return(null);
}
var _accessNumberListRow = new AccessNumberListRow
{
Access_number = pAccessNumber.Number,
ScriptType = pAccessNumber.ScriptType,
ScriptLanguage = pAccessNumber.Language,
Surcharge = pAccessNumber.Surcharge,
SurchargeType = pAccessNumber.SurchargeType
};
if (pAccessNumber.CustomerAcctId > 0)
{
_accessNumberListRow.Customer_acct_id = pAccessNumber.CustomerAcctId;
}
if (pAccessNumber.ServiceId > 0)
{
_accessNumberListRow.Service_id = pAccessNumber.ServiceId;
}
return(_accessNumberListRow);
}
/// <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="AccessNumberListRow"/> objects.</returns>
protected virtual AccessNumberListRow[] 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 access_numberColumnIndex = reader.GetOrdinal("access_number");
int service_idColumnIndex = reader.GetOrdinal("service_id");
int languageColumnIndex = reader.GetOrdinal("language");
int surchargeColumnIndex = reader.GetOrdinal("surcharge");
int surcharge_typeColumnIndex = reader.GetOrdinal("surcharge_type");
int customer_acct_idColumnIndex = reader.GetOrdinal("customer_acct_id");
int script_typeColumnIndex = reader.GetOrdinal("script_type");
System.Collections.ArrayList recordList = new System.Collections.ArrayList();
int ri = -startIndex;
while (reader.Read())
{
ri++;
if (ri > 0 && ri <= length)
{
AccessNumberListRow record = new AccessNumberListRow();
recordList.Add(record);
record.Access_number = Convert.ToInt64(reader.GetValue(access_numberColumnIndex));
if (!reader.IsDBNull(service_idColumnIndex))
{
record.Service_id = Convert.ToInt16(reader.GetValue(service_idColumnIndex));
}
record.Language = Convert.ToByte(reader.GetValue(languageColumnIndex));
record.Surcharge = Convert.ToDecimal(reader.GetValue(surchargeColumnIndex));
record.Surcharge_type = Convert.ToByte(reader.GetValue(surcharge_typeColumnIndex));
if (!reader.IsDBNull(customer_acct_idColumnIndex))
{
record.Customer_acct_id = Convert.ToInt16(reader.GetValue(customer_acct_idColumnIndex));
}
record.Script_type = Convert.ToInt32(reader.GetValue(script_typeColumnIndex));
if (ri == length && 0 != totalRecordCount)
{
break;
}
}
}
totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1;
return((AccessNumberListRow[])(recordList.ToArray(typeof(AccessNumberListRow))));
}
/// <summary>
/// Converts <see cref="System.Data.DataRow"/> to <see cref="AccessNumberListRow"/>.
/// </summary>
/// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param>
/// <returns>A reference to the <see cref="AccessNumberListRow"/> object.</returns>
protected virtual AccessNumberListRow MapRow(DataRow row)
{
AccessNumberListRow mappedObject = new AccessNumberListRow();
DataTable dataTable = row.Table;
DataColumn dataColumn;
// Column "Access_number"
dataColumn = dataTable.Columns["Access_number"];
if (!row.IsNull(dataColumn))
{
mappedObject.Access_number = (long)row[dataColumn];
}
// Column "Service_id"
dataColumn = dataTable.Columns["Service_id"];
if (!row.IsNull(dataColumn))
{
mappedObject.Service_id = (short)row[dataColumn];
}
// Column "Language"
dataColumn = dataTable.Columns["Language"];
if (!row.IsNull(dataColumn))
{
mappedObject.Language = (byte)row[dataColumn];
}
// Column "Surcharge"
dataColumn = dataTable.Columns["Surcharge"];
if (!row.IsNull(dataColumn))
{
mappedObject.Surcharge = (decimal)row[dataColumn];
}
// Column "Surcharge_type"
dataColumn = dataTable.Columns["Surcharge_type"];
if (!row.IsNull(dataColumn))
{
mappedObject.Surcharge_type = (byte)row[dataColumn];
}
// Column "Customer_acct_id"
dataColumn = dataTable.Columns["Customer_acct_id"];
if (!row.IsNull(dataColumn))
{
mappedObject.Customer_acct_id = (short)row[dataColumn];
}
// Column "Script_type"
dataColumn = dataTable.Columns["Script_type"];
if (!row.IsNull(dataColumn))
{
mappedObject.Script_type = (int)row[dataColumn];
}
return(mappedObject);
}
/// <summary>
/// Updates a record in the <c>AccessNumberList</c> table.
/// </summary>
/// <param name="value">The <see cref="AccessNumberListRow"/>
/// object used to update the table record.</param>
/// <returns>true if the record was updated; otherwise, false.</returns>
public virtual bool Update(AccessNumberListRow value)
{
string sqlStr = "UPDATE [dbo].[AccessNumberList] SET " +
"[service_id]=" + _db.CreateSqlParameterName("Service_id") + ", " +
"[language]=" + _db.CreateSqlParameterName("Language") + ", " +
"[surcharge]=" + _db.CreateSqlParameterName("Surcharge") + ", " +
"[surcharge_type]=" + _db.CreateSqlParameterName("Surcharge_type") + ", " +
"[customer_acct_id]=" + _db.CreateSqlParameterName("Customer_acct_id") + ", " +
"[script_type]=" + _db.CreateSqlParameterName("Script_type") +
" WHERE " +
"[access_number]=" + _db.CreateSqlParameterName("Access_number");
IDbCommand cmd = _db.CreateCommand(sqlStr);
AddParameter(cmd, "Service_id",
value.IsService_idNull ? DBNull.Value : (object)value.Service_id);
AddParameter(cmd, "Language", value.Language);
AddParameter(cmd, "Surcharge", value.Surcharge);
AddParameter(cmd, "Surcharge_type", value.Surcharge_type);
AddParameter(cmd, "Customer_acct_id",
value.IsCustomer_acct_idNull ? DBNull.Value : (object)value.Customer_acct_id);
AddParameter(cmd, "Script_type", value.Script_type);
AddParameter(cmd, "Access_number", value.Access_number);
return(0 != cmd.ExecuteNonQuery());
}
public AccessNumber(AccessNumberListRow pAccessNumberRow)
{
accessNumberRow = pAccessNumberRow;
Number = accessNumberRow.Access_number;
surchargeInfo = new SurchargeInfo(pAccessNumberRow.Surcharge, pAccessNumberRow.SurchargeType);
}
/// <summary>
/// Deletes the specified object from the <c>AccessNumberList</c> table.
/// </summary>
/// <param name="value">The <see cref="AccessNumberListRow"/> object to delete.</param>
/// <returns>true if the record was deleted; otherwise, false.</returns>
public bool Delete(AccessNumberListRow value)
{
return(DeleteByPrimaryKey(value.Access_number));
}
