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