public void MapByFilePathParseValues()
{
// arrange
var mapper = new CsvMapper <CurryOrder>();
var mappings = new NameValueCollection();
mappings.Add("Curry", "0");
mappings.Add("Quantity", "1");
mappings.Add("Price", "2");
mappings.Add("Total", "3");
// make sure calling GetHeaders does not affect the result
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
// act
var result = mapper.Map(this.CurryOrderFilePath, mappings);
// assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Assert.AreEqual(3, result.Count);
var lastRow = result.LastOrDefault();
Assert.IsNotNull(lastRow);
Assert.AreEqual("Korma", lastRow.Curry);
Assert.AreEqual(2, lastRow.Quantity);
Assert.AreEqual(12.5M, lastRow.Price);
Assert.AreEqual(25M, lastRow.Total);
}
public void MapByFilePathCustomMappings()
{
// arrange
var mapper = new CsvMapper <CurryOrder>();
// make sure calling GetHeaders does not affect the result
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
// act
mapper.OnItemDataBound += this.CurryOrder_OnItemDataBound;
var result = mapper.Map(this.CurryOrderFilePath);
// assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Assert.AreEqual(3, result.Count);
var lastRow = result.LastOrDefault();
Assert.IsNotNull(lastRow);
Assert.AreEqual("Korma", lastRow.Curry);
Assert.AreEqual(2, lastRow.Quantity);
Assert.AreEqual(12.5M, lastRow.Price);
Assert.AreEqual(25M, lastRow.Total);
}
public void MapByFilePathCustomMappings()
{
// arrange
var mapper = new CsvMapper<CurryOrder>();
// make sure calling GetHeaders does not affect the result
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
// act
mapper.OnItemDataBound += this.CurryOrder_OnItemDataBound;
var result = mapper.Map(this.CurryOrderFilePath);
// assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Assert.AreEqual(3, result.Count);
var lastRow = result.LastOrDefault();
Assert.IsNotNull(lastRow);
Assert.AreEqual("Korma", lastRow.Curry);
Assert.AreEqual(2, lastRow.Quantity);
Assert.AreEqual(12.5M, lastRow.Price);
Assert.AreEqual(25M, lastRow.Total);
}
public string[] GetHeaders(string filePath, char delimiter)
{
using (var csvProcessor = new CsvMapper <TranslationLabel>(filePath, delimiter))
{
return(csvProcessor.GetHeaders());
}
}
public void GetHeadersByFilePath()
{
// arrange
var mapper = new CsvMapper <TranslationLabel>();
// act
var result = mapper.GetHeaders(this.TranslationLabelFilePath);
// assert
Assert.IsNotNull(result);
Assert.AreEqual(6, result.Length);
Assert.AreEqual("Italian", result[4]);
}
public void MapByFilePath()
{
// arrange
var mapper = new CsvMapper<TranslationLabel>();
var mappings = this.GetTranslationLabelMappings();
// make sure calling GetHeaders does not affect the result
mapper.GetHeaders(this.TranslationLabelFilePath);
mapper.GetHeaders(this.TranslationLabelFilePath);
mapper.GetHeaders(this.TranslationLabelFilePath);
// act
var result = mapper.Map(this.TranslationLabelFilePath, mappings);
// assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Assert.AreEqual(22, result.Count);
var firstRow = result.FirstOrDefault();
Assert.IsNotNull(firstRow);
Assert.AreEqual("InfinitiMonthlyPayment", firstRow.LabelName);
}
public void GetHeadersByFilePath()
{
// arrange
var mapper = new CsvMapper<TranslationLabel>();
// act
var result = mapper.GetHeaders(this.TranslationLabelFilePath);
// assert
Assert.IsNotNull(result);
Assert.AreEqual(6, result.Length);
Assert.AreEqual("Italian", result[4]);
}
public void MapByFilePath()
{
// arrange
var mapper = new CsvMapper <TranslationLabel>();
var mappings = this.GetTranslationLabelMappings();
// make sure calling GetHeaders does not affect the result
mapper.GetHeaders(this.TranslationLabelFilePath);
mapper.GetHeaders(this.TranslationLabelFilePath);
mapper.GetHeaders(this.TranslationLabelFilePath);
// act
var result = mapper.Map(this.TranslationLabelFilePath, mappings);
// assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Assert.AreEqual(22, result.Count);
var firstRow = result.FirstOrDefault();
Assert.IsNotNull(firstRow);
Assert.AreEqual("InfinitiMonthlyPayment", firstRow.LabelName);
}
public string[] GetHeaders(string filePath)
{
var csvProcessor = new CsvMapper <T>();
return(csvProcessor.GetHeaders(filePath));
}
public void MapByFilePathParseValues()
{
// arrange
var mapper = new CsvMapper<CurryOrder>();
var mappings = new NameValueCollection();
mappings.Add("Curry", "0");
mappings.Add("Quantity", "1");
mappings.Add("Price", "2");
mappings.Add("Total", "3");
// make sure calling GetHeaders does not affect the result
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
mapper.GetHeaders(this.CurryOrderFilePath);
// act
var result = mapper.Map(this.CurryOrderFilePath, mappings);
// assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
Assert.AreEqual(3, result.Count);
var lastRow = result.LastOrDefault();
Assert.IsNotNull(lastRow);
Assert.AreEqual("Korma", lastRow.Curry);
Assert.AreEqual(2, lastRow.Quantity);
Assert.AreEqual(12.5M, lastRow.Price);
Assert.AreEqual(25M, lastRow.Total);
}
