public void ParameterAdd(string text, object value, SqlVariables var, SqlDirections direction = SqlDirections.Input)
{
if (string.IsNullOrEmpty(text))
{
throw new ArgumentNullException(EntitierStrings.MustProvideName);
}
var model = new ArgumentsModel {
Text = text, Value = value, Var = var, Directions = direction
};
if (_parameters == null)
{
_parameters = new List <ArgumentsModel>();
}
_parameters.Add(model);
}
/// <summary>
/// Adds a parameter to the query or store procedure.
/// </summary>
/// <returns>
/// Return true if parameter was added successfully.
/// </returns>
/// <param name="text">Name of the parameter.</param>
/// <param name="value">Value of the parameter.</param>
/// <param name="var">Type of data of the parameter.</param>
/// <param name="directions">Direction of the parameter, Input, Output, Return, etc.</param>
/// <author>GoodBytes</author>
public void AddParameter(string text, object value, SqlVariables var, SqlDirections directions = SqlDirections.Input)
{
var parameter = new SqlParameter();
parameter.ParameterName = "@" + text;
if (var == SqlVariables.Guid)
{
parameter.Value = new Guid(value.ToString());
}
else
{
parameter.Value = value ?? DBNull.Value;
}
parameter.Direction = (ParameterDirection)directions;
parameter.SqlDbType = (SqlDbType)var;
if (parameters == null)
{
parameters = new List <SqlParameter>();
}
parameters.Add(parameter);
}
