private static string GetCharacteristicQuery(IFilter characteristic, SqlParameterCollection parameterCollection)
{
SqlParameter[] parameters = characteristic.MakeQuery();
parameterCollection.AddRange(parameters);
return
($"{characteristic.Title} >= {parameters[0].ParameterName} AND {characteristic.Title} <= {parameters[1].ParameterName}");
}
public void CollectionAddInvalidRange_Throws()
{
SqlCommand command = new SqlCommand();
SqlParameterCollection collection = command.Parameters;
Array invalid = null;
Assert.Throws <ArgumentNullException>(() => collection.AddRange(invalid));
}
public void CollectionAddRange()
{
SqlCommand command = new SqlCommand();
SqlParameterCollection collection = command.Parameters;
Array sqlParameters = new SqlParameter[] { new("Test1", 1), new("Test2", 2) };
collection.AddRange(sqlParameters);
Assert.Equal(2, collection.Count);
Assert.Equal((SqlParameter)sqlParameters.GetValue(0), collection[0]);
Assert.Equal((SqlParameter)sqlParameters.GetValue(1), collection[1]);
}
public void AddOtherFilter(string sql, params SqlParameter[] list)
{
if (whereStringAdded == false)
{
sb.Append(" where ");
whereStringAdded = true;
filterAdded++;
}
else
{
sb.Append(" and ");
}
sb.Append(sql);
if (list != null)
{
parameterList.AddRange(list);
}
}
public static SqlParameterCollection AddParameters(this SqlParameterCollection parameters, params SqlParameter[] args)
{
parameters.AddRange(args);
return(parameters);
}