public static void AddParameter(this List <SqlDBParameter> parameters, string parameterName, object value, SqlDBType dbType, ParameterDirection parameterDirection = ParameterDirection.Input)
{
var param = new SqlDBParameter();
param.DBType = dbType;
param.Direction = parameterDirection;
param.ParameterName = parameterName;
param.Value = !value.IsNullOrEmpty() ? value : null;
parameters.Add(param);
}
public static void AddParameter(this List <SqlDBParameter> parameters, string parameterName, object value, ParameterDirection parameterDirection, int size)
{
var param = new SqlDBParameter();
param.DBType = SqlDBType.None;
param.Direction = parameterDirection;
param.ParameterName = parameterName;
param.Size = size;
param.Value = !value.IsNullOrEmpty() ? value : null;
parameters.Add(param);
}
public static void AddParameter(this List <SqlDBParameter> parameters, string parameterName, object value, ParameterDirection parameterDirection = ParameterDirection.Input)
{
var param = new SqlDBParameter();
param.DBType = SqlDBType.None;
param.Direction = parameterDirection;
param.ParameterName = parameterName;
param.Size = (parameterDirection == ParameterDirection.Output || parameterDirection == ParameterDirection.InputOutput) ? 2000 : 0;
param.Value = !value.IsNullOrEmpty() ? value : null;
parameters.Add(param);
}
public static int GetValue(this SqlDBParameter parameter)
{
return(!parameter.Value.IsNullOrEmpty() ? Convert.ToInt32(Convert.ToString(parameter.Value)) : 0);
}