//---------------------------------------------------------------------
/// <summary>
/// Adds a SQL parameter to the SQL command object managed by this
/// class instance
/// </summary>
/// <param name="Name">Parameter name</param>
/// <param name="Type">Parameter type</param>
/// <param name="Size">Parameter size</param>
/// <param name="Value">Parameter value</param>
/// <param name="Direction">Parameter direction</param>
/// <returns>
/// On success, returns the SqlParameter object added, null
/// otherwise
/// </returns>
//---------------------------------------------------------------------
public TParameter AddParameter(String Name, SqlDbType Type, int Size,
Object Value, ParameterDirection Direction)
{
// Convert the SqlDbType to a generic DbType
DbType DbTypeToUse;
if (!AntiSQLiCommon.ConvertToDbType(Type, out DbTypeToUse))
{
return(default(TParameter));
}
// Add the parameter
try
{
// Set the name, type and size
//SqlParameter CurrentParameter = new SqlParameter(Name, Type, Size);
TParameter CurrentParameter = new TParameter();
CurrentParameter.ParameterName = Name;
CurrentParameter.DbType = DbTypeToUse;
CurrentParameter.Size = Size;
// Set direction
CurrentParameter.Direction = Direction;
// Set value, only if it's an input or inputoutput parameter
if ((Direction == ParameterDirection.Input) ||
(Direction == ParameterDirection.InputOutput))
{
CurrentParameter.Value = Value;
}
// Add the parameter to the main sql command object
SqlCommandObject.Parameters.Add(CurrentParameter);
// Return the current parameter object in case the
// caller wants reference to it
return(CurrentParameter);
}
catch (Exception)
{
return(default(TParameter));
}
}
