private static void GenerateCommandParameters(SqlCommand command, MethodInfo method, object[] values)
{
ParameterInfo[] methodParameters = method.GetParameters();
int paramIndex = 0;
ParameterInfo paramInfo;
foreach (ParameterInfo tempLoopVar_paramInfo in methodParameters)
{
paramInfo = tempLoopVar_paramInfo;
if (!Attribute.IsDefined(paramInfo, typeof(NonCommandParameterAttribute)))
{
SqlParameterAttribute paramAttribute = (SqlParameterAttribute)Attribute.GetCustomAttribute(paramInfo, typeof(SqlParameterAttribute));
if (paramAttribute == null)
{
paramAttribute = new SqlParameterAttribute(null, SqlDbType.BigInt, 0, byte.MinValue, byte.MinValue, ((ParameterDirection)0));
}
SqlParameter sqlParameter = new SqlParameter();
if (paramAttribute.IsNameDefined)
{
sqlParameter.ParameterName = paramAttribute.Name;
}
else
{
sqlParameter.ParameterName = paramInfo.Name;
}
if (!sqlParameter.ParameterName.StartsWith("@"))
{
sqlParameter.ParameterName = "@" + sqlParameter.ParameterName;
}
if (paramAttribute.IsTypeDefined)
{
sqlParameter.SqlDbType = paramAttribute.SqlDbType;
}
if (paramAttribute.IsSizeDefined)
{
sqlParameter.Size = paramAttribute.Size;
}
if (paramAttribute.IsScaleDefined)
{
sqlParameter.Scale = paramAttribute.Scale;
}
if (paramAttribute.IsPrecisionDefined)
{
sqlParameter.Precision = paramAttribute.Precision;
}
if (paramAttribute.IsDirectionDefined)
{
sqlParameter.Direction = paramAttribute.Direction;
}
else
{
if (paramInfo.ParameterType.IsByRef)
{
if (paramInfo.IsOut)
{
sqlParameter.Direction = ParameterDirection.Output;
}
else
{
sqlParameter.Direction = ParameterDirection.InputOutput;
}
}
else
{
sqlParameter.Direction = ParameterDirection.Input;
}
}
sqlParameter.Value = values[paramIndex];
command.Parameters.Add(sqlParameter);
paramIndex++;
}
}
}
private static void GenerateCommandParameters(SqlCommand command, MethodInfo method, object[] values)
{
ParameterInfo[] methodParameters = method.GetParameters();
int paramIndex = 0;
ParameterInfo paramInfo;
foreach (ParameterInfo tempLoopVar_paramInfo in methodParameters)
{
paramInfo = tempLoopVar_paramInfo;
if (!Attribute.IsDefined(paramInfo, typeof(NonCommandParameterAttribute)))
{
SqlParameterAttribute paramAttribute = (SqlParameterAttribute)Attribute.GetCustomAttribute(paramInfo, typeof(SqlParameterAttribute));
if (paramAttribute == null)
{
paramAttribute = new SqlParameterAttribute(null, SqlDbType.BigInt, 0, byte.MinValue, byte.MinValue, ((ParameterDirection)0));
}
SqlParameter sqlParameter = new SqlParameter();
if (paramAttribute.IsNameDefined)
{
sqlParameter.ParameterName = paramAttribute.Name;
}
else
{
sqlParameter.ParameterName = paramInfo.Name;
}
if (!sqlParameter.ParameterName.StartsWith("@"))
{
sqlParameter.ParameterName = "@" + sqlParameter.ParameterName;
}
if (paramAttribute.IsTypeDefined)
{
sqlParameter.SqlDbType = paramAttribute.SqlDbType;
}
if (paramAttribute.IsSizeDefined)
{
sqlParameter.Size = paramAttribute.Size;
}
if (paramAttribute.IsScaleDefined)
{
sqlParameter.Scale = paramAttribute.Scale;
}
if (paramAttribute.IsPrecisionDefined)
{
sqlParameter.Precision = paramAttribute.Precision;
}
if (paramAttribute.IsDirectionDefined)
{
sqlParameter.Direction = paramAttribute.Direction;
}
else
{
if (paramInfo.ParameterType.IsByRef)
{
if (paramInfo.IsOut)
{
sqlParameter.Direction = ParameterDirection.Output;
}
else
{
sqlParameter.Direction = ParameterDirection.InputOutput;
}
}
else
{
sqlParameter.Direction = ParameterDirection.Input;
}
}
sqlParameter.Value = values[paramIndex];
command.Parameters.Add(sqlParameter);
paramIndex++;
}
}
}
