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