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); }