public void CsvInventoryItems_Books_Convert_Successfull()
{
var fileContent = "30137\t9783507106062\t30.95\t2017-03-29\t0" + Environment.NewLine +
"30326\t9783507106161\t20.94\t2017-03-28\t0";
var ms = new MemoryStream(Encoding.UTF8.GetBytes(fileContent));
var csv = new CsvDataImport <InventoryItem, InventoryItemCsvMapping>();
var items = csv.Convert(ms);
Assert.Equal(2, items.Count());
var item1 = items.First();
Assert.Equal(Condition.New, item1.Condition);
Assert.Equal("30137", item1.ExternalId);
Assert.True(item1.Article is Book);
Assert.True((item1.Article as Book).InternationalStandardBookNumber == "9783507106062");
Assert.Equal(30.95m, item1.PurchasePrice);
Assert.Equal(new DateTime(2017, 3, 29), item1.PurchasedAt);
var item2 = items.Last();
Assert.Equal(Condition.New, item2.Condition);
Assert.Equal("30326", item2.ExternalId);
Assert.True(item2.Article is Book);
Assert.True((item2.Article as Book).InternationalStandardBookNumber == "9783507106161");
Assert.Equal(20.94m, item2.PurchasePrice);
Assert.Equal(new DateTime(2017, 3, 28), item1.PurchasedAt);
}
static void RunFileImportExamples()
{
Console.WriteLine("RunFileImportExamples()");
ConsoleKeyInfo response = new ConsoleKeyInfo();
do
{
Console.WriteLine();
Console.WriteLine("[1] = CsvImport1");
Console.WriteLine("[2] = ExcelImport1");
Console.WriteLine("[e] = Exit");
Console.Write("\r\nEnter choice: ");
response = Console.ReadKey();
Console.WriteLine("\r\n");
Stopwatch sw = null;
switch (response.Key)
{
case ConsoleKey.D1:
sw = Stopwatch.StartNew();
CsvDataImport.CsvImport1(Common.CsvDataPath);
break;
case ConsoleKey.D2:
sw = Stopwatch.StartNew();
ExcelDataImport.ExcelImport1(Common.ExcelDataPath);
break;
case ConsoleKey.E:
case ConsoleKey.Escape:
break;
default:
Console.WriteLine("Invalid choice.");
break;
}
if (sw != null && sw.IsRunning)
{
sw.Stop();
Common.WriteTime("Import total seconds: ", sw.Elapsed);
}
} while (!(response.Key == ConsoleKey.E || response.Key == ConsoleKey.Escape));
}
static void RunLoopedCsvFileImportExamples()
{
Console.WriteLine("RunLoopedCsvFileImportExamples()");
Console.WriteLine("Import started");
for (int i = 0; i < 5; i++)
{
Stopwatch sw = Stopwatch.StartNew();
CsvDataImport.CsvImport1(Common.CsvDataPath);
sw.Stop();
Common.WriteTime(String.Format("Import {0} total seconds: ", i), sw.Elapsed);
}
Console.WriteLine("\r\nPress any key to continue.");
Console.ReadKey(true);
}
public void CsvBooks_Convert_Successfull()
{
var fileContent = "9783507106062\tAllgemeine und Organische Chemie\tKlaus Dehnert, Manfred J�ckel\tSchroedel Schulbuchverlag\t30,95" + Environment.NewLine +
"9783507106161\tOrganische Chemie\tKarl Risch, Hatto Seitz\tSchroedel Schulbuchverlag\t30,95";
var ms = new MemoryStream(Encoding.UTF8.GetBytes(fileContent));
var csv = new CsvDataImport <Book, BookCsvMapping>();
var books = csv.Convert(ms);
Assert.Equal(2, books.Count());
var book1 = books.Single(x => x.InternationalStandardBookNumber == "9783507106062");
Assert.Equal(2, book1.Authors.Count());
IEnumerable <string> authors = new List <string> {
"Klaus Dehnert", "Manfred J�ckel"
};
Assert.Equal(authors, book1.Authors.Select(a => a.FullName).ToList());
}