private static CsvWriter GetExportData(DataTable table) { var exportData = new CsvWriter(); Type dateTimeType = typeof(DateTime); foreach (DataRow row in table.Rows) { exportData.AddRow(); for (var i = 0; i < table.Columns.Count; ++i) { var columnName = table.Columns[i].ColumnName; string value; if (table.Columns[i].DataType == dateTimeType) { value = row[columnName] is DBNull ? string.Empty : ((DateTime)row[columnName]).ToString("yyyy-MM-dd HH:mm:ss.fff"); } else { value = row[columnName] is DBNull ? string.Empty : row[columnName].ToString(); } exportData[columnName] = value; } } return(exportData); }
private static CsvWriter GetExportData(DataTable table) { var exportData = new CsvWriter(); Type dateTimeType = typeof(DateTime); foreach (DataRow row in table.Rows) { exportData.AddRow(); for (var i = 0; i < table.Columns.Count; ++i) { var columnName = table.Columns[i].ColumnName; string value; if (table.Columns[i].DataType == dateTimeType) { value = row[columnName] is DBNull ? string.Empty : ((DateTime)row[columnName]).ToString("yyyy-MM-dd HH:mm:ss.fff"); } else { value = row[columnName] is DBNull ? string.Empty : row[columnName].ToString(); } exportData[columnName] = value; } } return exportData; }
public void CsvWriterReaderAccuracyTestShouldHaveAccurateData() { File.Delete("Somefile.csv"); var originalDataList = new List<TestData>(); var data1 = new TestData { Region = "Ealing,\n London", Sales = 10000, DateOpened = new DateTime(2012, 04, 23) }; originalDataList.Add(data1); var data2 = new TestData { Region = "\"\"Glasgow in Scotland\"\"", Sales = 50000, DateOpened = new DateTime(2012, 4, 1, 15, 31, 0) }; originalDataList.Add(data2); var data3 = new TestData { Region = "USA 'Gods own country'", Sales = 40000, DateOpened = new DateTime(2011, 12, 29, 9, 30, 0) }; originalDataList.Add(data3); var exportData = new CsvWriter(); exportData.AddRow(); exportData["Region"] = data1.Region; exportData["Sales"] = Convert.ToString(data1.Sales); exportData["Date Opened"] = Convert.ToString(data1.DateOpened); exportData.AddRow(); exportData["Region"] = data2.Region; exportData["Sales"] = Convert.ToString(data2.Sales); exportData["Date Opened"] = Convert.ToString(data2.DateOpened); exportData.AddRow(); exportData["Region"] = data3.Region; exportData["Sales"] = Convert.ToString(data3.Sales); exportData["Date Opened"] = Convert.ToString(data3.DateOpened); exportData.ExportToFile("Somefile.csv"); bool readingHeader = true; using (var reader = new CsvFileReader("Somefile.csv")) { var row = new CsvRow(); var newDataList = new List<TestData>(); while (reader.ReadRow(row)) { var headersList = new List<string>(); if (readingHeader) { headersList.AddRange(row); headersList.ToArray(); readingHeader = false; } else { var outData = new TestData { Region = row[0], Sales = Convert.ToInt32(row[1]), DateOpened = Convert.ToDateTime(row[2]) }; newDataList.Add(outData); } } var resultData = from newData in newDataList join originalData in originalDataList on newData.Region equals originalData.Region select new { NewData = newData, OriginalData = originalData }; foreach (var data in resultData) { Assert.IsTrue( data.NewData.Sales == data.OriginalData.Sales && data.NewData.Region == data.OriginalData.Region && data.NewData.DateOpened == data.OriginalData.DateOpened); } } }