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)); }