public void selected_value_should_match()
{
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
var options = _filter.Options.ToList();
Assert.True(options[1].Selected);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.19");
options = _filter.Options.ToList();
Assert.True(options[2].Selected);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
options = _filter.Options.ToList();
Assert.True(options[3].Selected);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.06.20-2015.07.20");
options = _filter.Options.ToList();
Assert.True(options[4].Selected);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.04.20-2015.07.20");
options = _filter.Options.ToList();
Assert.True(options[5].Selected);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.01.20-2015.07.20");
options = _filter.Options.ToList();
Assert.True(options[6].Selected);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2014.07.20-2015.07.20");
options = _filter.Options.ToList();
Assert.True(options[7].Selected);
}
public DateTimeEntityFilter_()
{
var entity = new Entity(typeof(TestEntity));
_property = entity["DateAdd"];
_fakeClock = new FakeClock(
() => new DateTime(2015, 7, 20),
() => new DateTime(2015, 7, 20));
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
}
public void sql_condition_should_match()
{
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
var args = new List<object>();
var sql = _filter.GetSqlCondition("t0", ref args);
Assert.Equal("(t0[DateAdd] >= @0 AND t0[DateAdd] <= @1)", sql);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
args = new List<object>();
sql = _filter.GetSqlCondition("t0", ref args);
Assert.Equal("(t0[DateAdd] >= @0 AND t0[DateAdd] <= @1)", sql);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "-2015.07.20");
args = new List<object>();
sql = _filter.GetSqlCondition("t0", ref args);
Assert.Equal("t0[DateAdd] <= @0", sql);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-");
args = new List<object>();
sql = _filter.GetSqlCondition("t0", ref args);
Assert.Equal("t0[DateAdd] >= @0", sql);
}
public IList<IEntityFilter> PrepareFilters(Entity entity)
{
var filters = new List<IEntityFilter>();
foreach (var property in entity.Properties.Where(x => x.TypeInfo.DataType == DataType.Bool))
{
var value = Request[property.Name];
var filter = new BoolEntityFilter();
filter.Initialize(property, value);
filters.Add(filter);
}
foreach (var property in entity.Properties.Where(x => x.TypeInfo.DataType == DataType.Enum))
{
var value = Request[property.Name];
var filter = new EnumEntityFilter();
filter.Initialize(property, value);
filters.Add(filter);
}
foreach (var property in entity.Properties.Where(x => x.TypeInfo.DataType == DataType.DateTime))
{
var value = Request[property.Name];
var filter = new DateTimeEntityFilter();
filter.Initialize(property, value);
filters.Add(filter);
}
return filters;
}
public void arguments_should_match()
{
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
var args = new List<object>();
_filter.GetSqlCondition("t0", ref args);
Assert.Equal(2, args.Count);
Assert.Equal("2015.07.20 00:00", args[0]);
Assert.Equal("2015.07.20 23:59", args[1]);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
args = new List<object>();
_filter.GetSqlCondition("t0", ref args);
Assert.Equal(2, args.Count);
Assert.Equal("2015.07.13 00:00", args[0]);
Assert.Equal("2015.07.20 23:59", args[1]);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "-2015.07.20");
args = new List<object>();
_filter.GetSqlCondition("t0", ref args);
Assert.Equal(1, args.Count);
Assert.Equal("2015.07.20 23:59", args[0]);
_filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-");
args = new List<object>();
_filter.GetSqlCondition("t0", ref args);
Assert.Equal(1, args.Count);
Assert.Equal("2015.07.13 00:00", args[0]);
}
