public void TestLoadingFormatThenFile() { FixedWidthFormatFile formatFile = CreateFormatFile(); string tempFileToCreate = Path.Combine(TestContext.CurrentContext.TestDirectory, "unitTestFixedWidthFile.txt"); StreamWriter streamWriter = File.CreateText(tempFileToCreate); try { streamWriter.WriteLine("002644099999Akerman Frank FM 380512004040120090501"); streamWriter.WriteLine("002705600000SHAW LENA LC 852251978100119941031"); streamWriter.Flush(); streamWriter.Close(); DataTable dataTable = formatFile.GetDataTableFromFlatFile(new FileInfo(tempFileToCreate)); Assert.AreEqual(dataTable.Rows.Count, 2); Assert.AreEqual("0026440", dataTable.Rows[0]["gmc"]); Assert.AreEqual("99999", dataTable.Rows[0]["gp_code"]); Assert.AreEqual("Akerman", dataTable.Rows[0]["surname"]); Assert.AreEqual("Frank", dataTable.Rows[0]["forename"]); Assert.AreEqual("FM", dataTable.Rows[0]["initials"]); Assert.AreEqual("38051", dataTable.Rows[0]["practice_code"]); Assert.AreEqual(new DateTime(2004, 4, 1), dataTable.Rows[0]["date_into_practice"]); Assert.AreEqual(new DateTime(2009, 5, 1), dataTable.Rows[0]["date_out_of_practice"]); } finally { File.Delete(tempFileToCreate); } }
public void TestLoadingFormat() { FixedWidthFormatFile formatFile = CreateFormatFile(); Assert.AreEqual(8, formatFile.FormatColumns.Length); Assert.AreEqual("gmc", formatFile.FormatColumns[0].Field); Assert.AreEqual(1, formatFile.FormatColumns[0].From); Assert.AreEqual(7, formatFile.FormatColumns[0].To); Assert.AreEqual(1 + formatFile.FormatColumns[0].To - formatFile.FormatColumns[0].From, formatFile.FormatColumns[0].Size); Assert.AreEqual(7, formatFile.FormatColumns[0].Size); Assert.AreEqual("gp_code", formatFile.FormatColumns[1].Field); Assert.AreEqual(8, formatFile.FormatColumns[1].From); Assert.AreEqual(12, formatFile.FormatColumns[1].To); Assert.AreEqual(1 + formatFile.FormatColumns[1].To - formatFile.FormatColumns[1].From, formatFile.FormatColumns[1].Size); Assert.AreEqual(5, formatFile.FormatColumns[1].Size); Assert.AreEqual("surname", formatFile.FormatColumns[2].Field); Assert.AreEqual(13, formatFile.FormatColumns[2].From); Assert.AreEqual(32, formatFile.FormatColumns[2].To); Assert.AreEqual(1 + formatFile.FormatColumns[2].To - formatFile.FormatColumns[2].From, formatFile.FormatColumns[2].Size); Assert.AreEqual(20, formatFile.FormatColumns[2].Size); Assert.AreEqual("forename", formatFile.FormatColumns[3].Field); Assert.AreEqual(33, formatFile.FormatColumns[3].From); Assert.AreEqual(52, formatFile.FormatColumns[3].To); Assert.AreEqual(1 + formatFile.FormatColumns[3].To - formatFile.FormatColumns[3].From, formatFile.FormatColumns[3].Size); Assert.AreEqual(20, formatFile.FormatColumns[3].Size); Assert.AreEqual("initials", formatFile.FormatColumns[4].Field); Assert.AreEqual(53, formatFile.FormatColumns[4].From); Assert.AreEqual(55, formatFile.FormatColumns[4].To); Assert.AreEqual(1 + formatFile.FormatColumns[4].To - formatFile.FormatColumns[4].From, formatFile.FormatColumns[4].Size); Assert.AreEqual(3, formatFile.FormatColumns[4].Size); Assert.AreEqual("practice_code", formatFile.FormatColumns[5].Field); Assert.AreEqual(56, formatFile.FormatColumns[5].From); Assert.AreEqual(60, formatFile.FormatColumns[5].To); Assert.AreEqual(1 + formatFile.FormatColumns[5].To - formatFile.FormatColumns[5].From, formatFile.FormatColumns[5].Size); Assert.AreEqual(5, formatFile.FormatColumns[5].Size); Assert.AreEqual("date_into_practice", formatFile.FormatColumns[6].Field); Assert.AreEqual(61, formatFile.FormatColumns[6].From); Assert.AreEqual(68, formatFile.FormatColumns[6].To); Assert.AreEqual(1 + formatFile.FormatColumns[6].To - formatFile.FormatColumns[6].From, formatFile.FormatColumns[6].Size); Assert.AreEqual(8, formatFile.FormatColumns[6].Size); Assert.AreEqual("yyyyMMdd", formatFile.FormatColumns[6].DateFormat); Assert.AreEqual("date_out_of_practice", formatFile.FormatColumns[7].Field); Assert.AreEqual(69, formatFile.FormatColumns[7].From); Assert.AreEqual(76, formatFile.FormatColumns[7].To); Assert.AreEqual(1 + formatFile.FormatColumns[7].To - formatFile.FormatColumns[7].From, formatFile.FormatColumns[7].Size); Assert.AreEqual(8, formatFile.FormatColumns[7].Size); Assert.AreEqual("yyyyMMdd", formatFile.FormatColumns[7].DateFormat); }