/// <summary>
/// Create an parameter to be passed by parameter index.
/// </summary>
public StoredProcedureParameter(object value, ParameterDirectionWrap parameterDirection)
{
this.key = null;
this.value = value;
this.parameterDirection = parameterDirection;
this.size = null;
}
/// <summary>
/// Create an input parameter to be passed by parameter index.
/// </summary>
public StoredProcedureParameter(object value)
{
this.key = null;
this.value = value;
this.parameterDirection = ParameterDirectionWrap.Input;
this.size = null;
}
/// <summary>
/// Create a parameter to be passed by parameter name.
/// </summary>
public StoredProcedureParameter(string key, object value, ParameterDirectionWrap parameterDirection, int size)
{
this.key = key;
this.value = value;
this.parameterDirection = parameterDirection;
this.size = size;
}
/// <summary>
/// Create an input parameter to be passed by parameter index.
/// </summary>
public StoredProcedureParameter(object value)
{
this.key = null;
this.value = value;
this.parameterDirection = ParameterDirectionWrap.Input;
this.size = null;
}
/// <summary>
/// Create an parameter to be passed by parameter index.
/// </summary>
public StoredProcedureParameter(object value, ParameterDirectionWrap parameterDirection)
{
this.key = null;
this.value = value;
this.parameterDirection = parameterDirection;
this.size = null;
}
/// <summary>
/// Create a parameter to be passed by parameter name.
/// </summary>
public StoredProcedureParameter(string key, object value, ParameterDirectionWrap parameterDirection, int size)
{
this.key = key;
this.value = value;
this.parameterDirection = parameterDirection;
this.size = size;
}
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int?size)
{
if (value == null)
{
value = DBNull.Value;
}
SqlParameter sp = new SqlParameter(key, value);
System.Data.ParameterDirection pDir;
switch (direction)
{
case ParameterDirectionWrap.Input:
pDir = System.Data.ParameterDirection.Input;
break;
case ParameterDirectionWrap.InputOutput:
pDir = System.Data.ParameterDirection.InputOutput;
break;
case ParameterDirectionWrap.Output:
pDir = System.Data.ParameterDirection.Output;
break;
case ParameterDirectionWrap.ReturnValue:
pDir = System.Data.ParameterDirection.ReturnValue;
break;
default:
pDir = System.Data.ParameterDirection.Input;
break;
}
sp.Direction = pDir;
if (size.HasValue)
{
sp.Size = size.Value;
}
this.pm.Add(sp);
}
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int? size)
{
if (value == null)
value = DBNull.Value;
SqlParameter sp = new SqlParameter(key, value);
System.Data.ParameterDirection pDir;
switch (direction)
{
case ParameterDirectionWrap.Input:
pDir = System.Data.ParameterDirection.Input;
break;
case ParameterDirectionWrap.InputOutput:
pDir = System.Data.ParameterDirection.InputOutput;
break;
case ParameterDirectionWrap.Output:
pDir = System.Data.ParameterDirection.Output;
break;
case ParameterDirectionWrap.ReturnValue:
pDir = System.Data.ParameterDirection.ReturnValue;
break;
default:
pDir = System.Data.ParameterDirection.Input;
break;
}
sp.Direction = pDir;
if (size.HasValue)
sp.Size = size.Value;
this.pm.Add(sp);
}
public void AddWithValue(string key, object value, ParameterDirectionWrap direction)
{
AddWithValue(key, value, direction, null);
}
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int?size, DbType?dbType)
{
if (value == null)
{
value = DBNull.Value;
}
MySqlParameter sp = new MySqlParameter(key, value);
if (dbType.HasValue)
{
sp.DbType = dbType.Value;
}
System.Data.ParameterDirection pDir;
switch (direction)
{
case ParameterDirectionWrap.Input:
pDir = System.Data.ParameterDirection.Input;
break;
case ParameterDirectionWrap.InputOutput:
pDir = System.Data.ParameterDirection.InputOutput;
break;
case ParameterDirectionWrap.Output:
pDir = System.Data.ParameterDirection.Output;
break;
case ParameterDirectionWrap.ReturnValue:
pDir = System.Data.ParameterDirection.ReturnValue;
break;
default:
pDir = System.Data.ParameterDirection.Input;
break;
}
// Need to prevent adding a duplicate key
int index = pm.IndexOf(key);
if (index == -1)
{
sp.Direction = pDir;
if (size.HasValue)
{
sp.Size = size.Value;
}
this.pm.Add(sp);
}
else
{
pm[index].Direction = pDir;
if (size.HasValue)
{
pm[index].Size = size.Value;
}
pm[index].Value = value;
}
}
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int?size)
{
AddWithValue(key, value, direction, size, null);
}
public void AddTypedDbNull(string key, ParameterDirectionWrap direction, DbType dbType)
{
AddWithValue(key, DBNull.Value, direction, null, dbType);
}
