/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Schedule_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Type":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Day_of_week":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Day_of_the_month_1":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Day_of_the_month_2":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Prefix_in_type_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Description":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Length":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Delimiter":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Wholesale_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Service_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Map_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Delimiter":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Target_dest_folder":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Carrier_acct_EP_map_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Carrier_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "End_point_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Priority":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Carrier_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Country_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Country_code":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Version":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Rate_info_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Type_of_day_choice":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Start_hour":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Stop_hour":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Time_of_day":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Routing_plan_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Carrier_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Version":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Retail_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Retail_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Start_bonus_minutes":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Current_bonus_minutes":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Map_detail_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Map_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Sequence":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Field_name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Format_type":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Node_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Customer_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Max_calls":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Current_calls":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Contact_info_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Address1":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Address2":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "City":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "State":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Zip_code":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Email":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Home_phone_number":
parameter = _db.AddParameter(cmd, paramName, DbType.Int64, value);
break;
case "Cell_phone_number":
parameter = _db.AddParameter(cmd, paramName, DbType.Int64, value);
break;
case "Work_phone_number":
parameter = _db.AddParameter(cmd, paramName, DbType.Int64, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Service_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Batch_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Timestamp":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Command":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Number_of_cards":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Denomination":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Customer_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Reseller_partner_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Reseller_agent_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Person_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Resell_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Wholesale_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Date_on":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Date_off":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Rate_info_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Commision_type":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Markup_dollar":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Markup_percent":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Markup_per_call":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Markup_per_minute":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Carrier_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Rating_type":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Prefix_out":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Strip_1plus":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Intl_dial_code":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Partner_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Calling_plan_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Max_call_length":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Retail_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Date_time":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Previous_amount":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Payment_amount":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Previous_bonus_minutes":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Added_bonus_minutes":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Comments":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Person_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Balance_adjustment_reason_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Cdr_key":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Type_of_day_choice":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "IP_address":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "End_point_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Carrier_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Carrier_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Asr_time_window":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Asr_target":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Acd_time_window":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Acd_target":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Next_ep":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "End_point_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Carrier_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Alias":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Carrier_acct_name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Carrier_acct_status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Prefix_out":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Partner_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Partner_name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Partner_status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Group_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Description":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Role":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Max_amount":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Allow_status_change":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Vendor_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Service_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "ANI":
parameter = _db.AddParameter(cmd, paramName, DbType.Int64, value);
break;
case "Status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Date_first_used":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Date_last_used":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Retail_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Partner_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Status":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Contact_info_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Billing_schedule_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Virtual_switch_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Balance_adjustment_reason_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Description":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Type":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Box_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Date_created":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Date_activated":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Lot_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Service_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Denomination":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Payphone_surcharge_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Surcharge":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "Surcharge_type":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Carrier_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Route_name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Carrier_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Carrier_acct_name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Calling_plan_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Rating_type":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
case "Base_route_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Partial_coverage":
parameter = _db.AddParameter(cmd, paramName, DbType.Byte, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Request_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Date_requested":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Date_to_process":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Date_completed":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "Number_of_batches":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Batch_size":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Lot_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Service_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Customer_acct_id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int16, value);
break;
case "Timestamp":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "First_used":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Total_used":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Balance_depleted":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Expired":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
