public void Execute_MiddleColumnIsTextualDate_MiddleColumnIsDate()
{
var args = new ObjectsResultSetResolverArgs(new[] { new[] { "Alpha", "06/01/2018", "true" }, new[] { "Beta", "17/12/2015", "false" }, new[] { "Gamma", "Before 2014", "false" } });
var resolver = new ObjectsResultSetResolver(args);
var rs = resolver.Execute();
var factory = new ConverterFactory();
var converter = factory.Instantiate("text", "date", new DateTime(2013, 1, 1), "fr-fr");
Assert.That(converter, Is.Not.Null);
Assert.That(converter, Is.TypeOf <TextToDateConverter>());
var engine = new ConverterEngine("#1", converter);
engine.Execute(rs);
Assert.That(rs.Columns[1].DataType, Is.EqualTo(typeof(DateTime)));
Assert.That(rs.Columns.Count, Is.EqualTo(3));
Assert.That(rs.Rows[0][1], Is.EqualTo(new DateTime(2018, 1, 6)));
Assert.That(rs.Rows[1][1], Is.EqualTo(new DateTime(2015, 12, 17)));
Assert.That(rs.Rows[2][1], Is.EqualTo(new DateTime(2013, 1, 1)));
}
public void Execute_MiddleColumnIsText_MiddleColumnIsNumeric()
{
var args = new ObjectsResultSetResolverArgs(new[] { new[] { "Alpha", "100,12", "true" }, new[] { "Beta", "100", "false" }, new[] { "Gamma", "N/A", "false" } });
var resolver = new ObjectsResultSetResolver(args);
var rs = resolver.Execute();
var factory = new ConverterFactory();
var converter = factory.Instantiate("text", "numeric", null, "fr-fr");
Assert.That(converter, Is.Not.Null);
Assert.That(converter, Is.TypeOf <TextToNumericConverter>());
var engine = new ConverterEngine("#1", converter);
engine.Execute(rs);
Assert.That(rs.Columns[1].DataType, Is.EqualTo(typeof(decimal)));
Assert.That(rs.Columns.Count, Is.EqualTo(3));
Assert.That(rs.Rows[0][1], Is.EqualTo(100.12));
Assert.That(rs.Rows[1][1], Is.EqualTo(100));
Assert.That(rs.Rows[2][1], Is.EqualTo(DBNull.Value));
}
