public void Load4()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited();
TestObject.Parse("\"Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38\"");
Assert.Equal(1, TestObject.Count);
Assert.Equal("\"Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38\"\r\n", TestObject.ToString());
}
public void TabLoad3()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("\"Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38\"", "\t");
Assert.Equal(1, TestObject.Count);
Assert.Equal("\"Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38\"\r\n", TestObject);
}
public void TabLoad()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\"\t\"Make\"\t\"Model\"\t\"Length\"" + System.Environment.NewLine + "\"1997\"\t\"Ford\"\t\"E350\"\t\"2.34\"" + System.Environment.NewLine + "\"2000\"\t\"Mercury\"\t\"Cougar\"\t\"2.38\"" + System.Environment.NewLine, TestObject);
}
public void Load()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\",\"Make\",\"Model\",\"Length\"" + System.Environment.NewLine + "\"1997\",\"Ford\",\"E350\",\"2.34\"" + System.Environment.NewLine + "\"2000\",\"Mercury\",\"Cougar\",\"2.38\"" + System.Environment.NewLine, TestObject.ToString());
}
public void Load5()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("\"Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38\"");
Assert.Equal(1, TestObject.Count);
Assert.Equal("\"Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38\"\r\n", TestObject);
}
public void PipeLoad()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\"|\"Make\"|\"Model\"|\"Length\"" + System.Environment.NewLine + "\"1997\"|\"Ford\"|\"E350\"|\"2.34\"" + System.Environment.NewLine + "\"2000\"|\"Mercury\"|\"Cougar\"|\"2.38\"" + System.Environment.NewLine, TestObject);
}
/// <summary>
/// Converts an IEnumerable to a delimited file
/// </summary>
/// <param name="Data">The DataTable to convert</param>
/// <param name="Delimiter">Delimiter to use</param>
/// <returns>The delimited file containing the list</returns>
public static Utilities.IO.FileFormats.Delimited.Delimited ToDelimitedFile(this DataTable Data, string Delimiter = ",")
{
var ReturnValue = new Utilities.IO.FileFormats.Delimited.Delimited("", Delimiter);
if (Data == null)
{
return(ReturnValue);
}
var TempRow = new FileFormats.Delimited.Row(Delimiter);
foreach (DataColumn Column in Data.Columns)
{
TempRow.Add(new Utilities.IO.FileFormats.Delimited.Cell(Column.ColumnName));
}
ReturnValue.Add(TempRow);
foreach (DataRow Row in Data.Rows)
{
TempRow = new Utilities.IO.FileFormats.Delimited.Row(Delimiter);
for (int x = 0; x < Data.Columns.Count; ++x)
{
TempRow.Add(new Utilities.IO.FileFormats.Delimited.Cell(Row.ItemArray[x].ToString()));
}
ReturnValue.Add(TempRow);
}
return(ReturnValue);
}
public void PipeLoad3()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("\"Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38\"");
Assert.Equal(1, TestObject.Count);
Assert.Equal("\"Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38\"\r\n", TestObject);
}
public void ToDelimitedFile()
{
List <ExportClass> Temp = new ExportClass[] { new ExportClass {
ID = 1, Value = "A"
}, new ExportClass {
ID = 2, Value = "B"
}, new ExportClass {
ID = 3, Value = "C"
} }.ToList();
Temp.ToDelimitedFile();
Utilities.IO.FileFormats.Delimited.Delimited TestObject = Temp.ToDelimitedFile();
Assert.Equal(4, TestObject.Count);
Assert.Equal("\"ID\"\t\"Value\"\r\n\"1\"\t\"A\"\r\n\"2\"\t\"B\"\r\n\"3\"\t\"C\"\r\n", TestObject.ToString());
}
public void ToDataTable()
{
DataTable TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38").ToDataTable();
Assert.Equal(2, TestObject.Rows.Count);
Assert.Equal("Year", TestObject.Columns[0].ColumnName);
Assert.Equal("Make", TestObject.Columns[1].ColumnName);
Assert.Equal("Model", TestObject.Columns[2].ColumnName);
Assert.Equal("Length", TestObject.Columns[3].ColumnName);
Assert.Equal("1997", TestObject.Rows[0].ItemArray[0]);
Assert.Equal("Ford", TestObject.Rows[0].ItemArray[1]);
Assert.Equal("E350", TestObject.Rows[0].ItemArray[2]);
Assert.Equal("2.34", TestObject.Rows[0].ItemArray[3]);
Assert.Equal("2000", TestObject.Rows[1].ItemArray[0]);
Assert.Equal("Mercury", TestObject.Rows[1].ItemArray[1]);
Assert.Equal("Cougar", TestObject.Rows[1].ItemArray[2]);
Assert.Equal("2.38", TestObject.Rows[1].ItemArray[3]);
}
public void PipeToDataTable()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38").ToDataTable();
Assert.Equal(2, TestObject.Rows.Count);
Assert.Equal("Year", TestObject.Columns[0].ColumnName);
Assert.Equal("Make", TestObject.Columns[1].ColumnName);
Assert.Equal("Model", TestObject.Columns[2].ColumnName);
Assert.Equal("Length", TestObject.Columns[3].ColumnName);
Assert.Equal("1997", TestObject.Rows[0].ItemArray[0]);
Assert.Equal("Ford", TestObject.Rows[0].ItemArray[1]);
Assert.Equal("E350", TestObject.Rows[0].ItemArray[2]);
Assert.Equal("2.34", TestObject.Rows[0].ItemArray[3]);
Assert.Equal("2000", TestObject.Rows[1].ItemArray[0]);
Assert.Equal("Mercury", TestObject.Rows[1].ItemArray[1]);
Assert.Equal("Cougar", TestObject.Rows[1].ItemArray[2]);
Assert.Equal("2.38", TestObject.Rows[1].ItemArray[3]);
}
public void TabToDataTable()
{
DataTable TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38", "\t").ToDataTable();
Assert.Equal(2, TestObject.Rows.Count);
Assert.Equal("Year", TestObject.Columns[0].ColumnName);
Assert.Equal("Make", TestObject.Columns[1].ColumnName);
Assert.Equal("Model", TestObject.Columns[2].ColumnName);
Assert.Equal("Length", TestObject.Columns[3].ColumnName);
Assert.Equal("1997", TestObject.Rows[0].ItemArray[0]);
Assert.Equal("Ford", TestObject.Rows[0].ItemArray[1]);
Assert.Equal("E350", TestObject.Rows[0].ItemArray[2]);
Assert.Equal("2.34", TestObject.Rows[0].ItemArray[3]);
Assert.Equal("2000", TestObject.Rows[1].ItemArray[0]);
Assert.Equal("Mercury", TestObject.Rows[1].ItemArray[1]);
Assert.Equal("Cougar", TestObject.Rows[1].ItemArray[2]);
Assert.Equal("2.38", TestObject.Rows[1].ItemArray[3]);
}
public void PipeToDataTable()
{
DataTable TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38").ToDataTable();
Assert.Equal(2, TestObject.Rows.Count);
Assert.Equal("Year", TestObject.Columns[0].ColumnName);
Assert.Equal("Make", TestObject.Columns[1].ColumnName);
Assert.Equal("Model", TestObject.Columns[2].ColumnName);
Assert.Equal("Length", TestObject.Columns[3].ColumnName);
Assert.Equal("1997", TestObject.Rows[0].ItemArray[0]);
Assert.Equal("Ford", TestObject.Rows[0].ItemArray[1]);
Assert.Equal("E350", TestObject.Rows[0].ItemArray[2]);
Assert.Equal("2.34", TestObject.Rows[0].ItemArray[3]);
Assert.Equal("2000", TestObject.Rows[1].ItemArray[0]);
Assert.Equal("Mercury", TestObject.Rows[1].ItemArray[1]);
Assert.Equal("Cougar", TestObject.Rows[1].ItemArray[2]);
Assert.Equal("2.38", TestObject.Rows[1].ItemArray[3]);
}
public void TabLoad2()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("\"Year\tMake\tModel\tLength\"\r\n\"1997\tFord\tE350\t2.34\"\r\n\"2000\tMercury\tCougar\t2.38\"", "\t");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\tMake\tModel\tLength\"\r\n\"1997\tFord\tE350\t2.34\"\r\n\"2000\tMercury\tCougar\t2.38\"\r\n", TestObject);
}
public void TabLoad4()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited();
TestObject.Parse("\"Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38\"");
Assert.Equal(1, TestObject.Count);
Assert.Equal("\"Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38\"\r\n", TestObject);
}
public void TabToDataTable()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38", "\t").ToDataTable();
Assert.Equal(2, TestObject.Rows.Count);
Assert.Equal("Year", TestObject.Columns[0].ColumnName);
Assert.Equal("Make", TestObject.Columns[1].ColumnName);
Assert.Equal("Model", TestObject.Columns[2].ColumnName);
Assert.Equal("Length", TestObject.Columns[3].ColumnName);
Assert.Equal("1997", TestObject.Rows[0].ItemArray[0]);
Assert.Equal("Ford", TestObject.Rows[0].ItemArray[1]);
Assert.Equal("E350", TestObject.Rows[0].ItemArray[2]);
Assert.Equal("2.34", TestObject.Rows[0].ItemArray[3]);
Assert.Equal("2000", TestObject.Rows[1].ItemArray[0]);
Assert.Equal("Mercury", TestObject.Rows[1].ItemArray[1]);
Assert.Equal("Cougar", TestObject.Rows[1].ItemArray[2]);
Assert.Equal("2.38", TestObject.Rows[1].ItemArray[3]);
}
public void ToDataTable()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38").ToDataTable();
Assert.Equal(2, TestObject.Rows.Count);
Assert.Equal("Year", TestObject.Columns[0].ColumnName);
Assert.Equal("Make", TestObject.Columns[1].ColumnName);
Assert.Equal("Model", TestObject.Columns[2].ColumnName);
Assert.Equal("Length", TestObject.Columns[3].ColumnName);
Assert.Equal("1997", TestObject.Rows[0].ItemArray[0]);
Assert.Equal("Ford", TestObject.Rows[0].ItemArray[1]);
Assert.Equal("E350", TestObject.Rows[0].ItemArray[2]);
Assert.Equal("2.34", TestObject.Rows[0].ItemArray[3]);
Assert.Equal("2000", TestObject.Rows[1].ItemArray[0]);
Assert.Equal("Mercury", TestObject.Rows[1].ItemArray[1]);
Assert.Equal("Cougar", TestObject.Rows[1].ItemArray[2]);
Assert.Equal("2.38", TestObject.Rows[1].ItemArray[3]);
}
public void Load()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year,Make,Model,Length\r\n1997,Ford,E350,2.34\r\n2000,Mercury,Cougar,2.38");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\",\"Make\",\"Model\",\"Length\"" + System.Environment.NewLine + "\"1997\",\"Ford\",\"E350\",\"2.34\"" + System.Environment.NewLine + "\"2000\",\"Mercury\",\"Cougar\",\"2.38\"" + System.Environment.NewLine, TestObject.ToString());
}
public void PipeLoad()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\"|\"Make\"|\"Model\"|\"Length\"" + System.Environment.NewLine + "\"1997\"|\"Ford\"|\"E350\"|\"2.34\"" + System.Environment.NewLine + "\"2000\"|\"Mercury\"|\"Cougar\"|\"2.38\"" + System.Environment.NewLine, TestObject);
}
public void TabLoad()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("Year\tMake\tModel\tLength\r\n1997\tFord\tE350\t2.34\r\n2000\tMercury\tCougar\t2.38");
Assert.Equal(3, TestObject.Count);
Assert.Equal("\"Year\"\t\"Make\"\t\"Model\"\t\"Length\"" + System.Environment.NewLine + "\"1997\"\t\"Ford\"\t\"E350\"\t\"2.34\"" + System.Environment.NewLine + "\"2000\"\t\"Mercury\"\t\"Cougar\"\t\"2.38\"" + System.Environment.NewLine, TestObject);
}
public void PipeLoad3()
{
var TestObject = new Utilities.IO.FileFormats.Delimited.Delimited("\"Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38\"");
Assert.Equal(1, TestObject.Count);
Assert.Equal("\"Year|Make|Model|Length\r\n1997|Ford|E350|2.34\r\n2000|Mercury|Cougar|2.38\"\r\n", TestObject);
}
