/// <summary>
/// Adds a parameter to the Oracle command passed as parameter.
/// </summary>
/// <param name="command">The command to be used.</param>
/// <param name="parameter">The parameter to be passed.</param>
public static void AddCommandParameter(OracleCommand command, QueryParameter parameter)
{
if (null != parameter)
{
if (parameter.IsInput())
{
if (null != parameter.Value)
{
if (parameter.DbSize > 0)
{
command.Parameters.Add(parameter.Name, DbTypeToOracleDbType(parameter.DbType), parameter.DbSize).Value = parameter.Value;
}
else
{
command.Parameters.Add(parameter.Name, parameter.Value);
}
}
else
{
command.Parameters.Add(parameter.Name, DBNull.Value);
}
}
else if (parameter.IsInputOutput() || parameter.IsOutput())
{
if (parameter.DbType == Database.DbType.DECIMAL)
{
command.Parameters.Add(parameter.Name, DbTypeToOracleDbType(parameter.DbType), parameter.Direction).Precision = (byte)parameter.DbSize;
}
else
{
command.Parameters.Add(parameter.Name, DbTypeToOracleDbType(parameter.DbType), parameter.DbSize).Direction = parameter.Direction;
}
}
}
}