public void FullClassBuilding() { var cb = new DelimitedClassBuilder("Customers", ","); cb.IgnoreFirstLines = 1; cb.IgnoreEmptyLines = true; cb.AddField("Field1", typeof(DateTime)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.QuoteMode = QuoteMode.AlwaysQuoted; cb.LastField.FieldNullValue = DateTime.Today; cb.AddField("Field2", typeof(string)); cb.LastField.FieldQuoted = true; cb.LastField.QuoteChar = '"'; cb.AddField("Field3", typeof(int)); mEngine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = mEngine.ReadFileAsDT(TestCommon.GetPath("Good", "Test2.txt")); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, mEngine.TotalRecords); Assert.AreEqual(0, mEngine.ErrorManager.ErrorCount); Assert.AreEqual("Field1", dt.Columns[0].ColumnName); Assert.AreEqual("Field2", dt.Columns[1].ColumnName); Assert.AreEqual("Field3", dt.Columns[2].ColumnName); Assert.AreEqual("Hola", dt.Rows[0][1]); Assert.AreEqual(DateTime.Today, dt.Rows[2][0]); }
public void TestingNameAndTypes() { var cb = new DelimitedClassBuilder("Customers", ","); cb.IgnoreFirstLines = 1; cb.IgnoreEmptyLines = true; cb.AddField("Field1", typeof (DateTime)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.QuoteMode = QuoteMode.AlwaysQuoted; cb.LastField.FieldNullValue = DateTime.Today; cb.AddField("Field2", typeof (string)); cb.LastField.FieldQuoted = true; cb.LastField.QuoteChar = '"'; cb.AddField("Field3", typeof (int)); mEngine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = mEngine.ReadFileAsDT(TestCommon.GetPath("Good", "Test2.txt")); Assert.AreEqual("Field1", dt.Columns[0].ColumnName); Assert.AreEqual(typeof (DateTime), dt.Columns[0].DataType); Assert.AreEqual("Field2", dt.Columns[1].ColumnName); Assert.AreEqual(typeof (string), dt.Columns[1].DataType); Assert.AreEqual("Field3", dt.Columns[2].ColumnName); Assert.AreEqual(typeof (int), dt.Columns[2].DataType); }
public void FullClassBuilding() { var cb = new DelimitedClassBuilder("Customers", ","); cb.IgnoreFirstLines = 1; cb.IgnoreEmptyLines = true; cb.AddField("Field1", typeof(DateTime)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.QuoteMode = QuoteMode.AlwaysQuoted; cb.LastField.FieldNullValue = DateTime.Today; cb.AddField("Field2", typeof(string)); cb.LastField.FieldQuoted = true; cb.LastField.QuoteChar = '"'; cb.AddField("Field3", typeof(int)); engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = engine.ReadFileAsDT(TestCommon.GetPath("Good", "Test2.txt")); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual("Field1", dt.Columns[0].ColumnName); Assert.AreEqual("Field2", dt.Columns[1].ColumnName); Assert.AreEqual("Field3", dt.Columns[2].ColumnName); Assert.AreEqual("Hola", dt.Rows[0][1]); Assert.AreEqual(DateTime.Today, dt.Rows[2][0]); }
public void FullClassBuildingFixed() { var cb = new FixedLengthClassBuilder("Customers"); cb.AddField("Field1", 8, typeof(DateTime)); cb.LastField.Converter.Kind = ConverterKind.Date; cb.LastField.Converter.Arg1 = "ddMMyyyy"; cb.LastField.FieldNullValue = DateTime.Now; cb.AddField("Field2", 3, typeof(string)); cb.LastField.AlignMode = AlignMode.Right; cb.LastField.AlignChar = ' '; cb.AddField("Field3", 3, typeof(int)); cb.LastField.AlignMode = AlignMode.Right; cb.LastField.AlignChar = '0'; cb.LastField.TrimMode = TrimMode.Both; engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); }
public void TestingNameAndTypes() { var cb = new DelimitedClassBuilder("Customers", ","); cb.IgnoreFirstLines = 1; cb.IgnoreEmptyLines = true; cb.AddField("Field1", typeof(DateTime)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.QuoteMode = QuoteMode.AlwaysQuoted; cb.LastField.FieldNullValue = DateTime.Today; cb.AddField("Field2", typeof(string)); cb.LastField.FieldQuoted = true; cb.LastField.QuoteChar = '"'; cb.AddField("Field3", typeof(int)); engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = engine.ReadFileAsDT(TestCommon.GetPath("Good", "Test2.txt")); Assert.AreEqual("Field1", dt.Columns[0].ColumnName); Assert.AreEqual(typeof(DateTime), dt.Columns[0].DataType); Assert.AreEqual("Field2", dt.Columns[1].ColumnName); Assert.AreEqual(typeof(string), dt.Columns[1].DataType); Assert.AreEqual("Field3", dt.Columns[2].ColumnName); Assert.AreEqual(typeof(int), dt.Columns[2].DataType); }
public void ReadFileDiffDir() { string oldDir = Environment.CurrentDirectory; Environment.CurrentDirectory = Path.GetTempPath(); Type t = ClassBuilder.ClassFromString(mClass); Environment.CurrentDirectory = oldDir; engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
static void RunTimeRecordsFixed() { Console.WriteLine("Run Time Records now =) ..."); Console.WriteLine(); FixedLengthClassBuilder cb = new FixedLengthClassBuilder("Customer", FixedMode.ExactLength); cb.AddField("CustId", 5, typeof(Int32)); cb.AddField("Name", 20, typeof(string)); cb.AddField("Balance", 8, typeof(Decimal)); cb.AddField("AddedDate", 8, typeof(DateTime)); cb.LastField.Converter.Kind = ConverterKind.Date; cb.LastField.Converter.Arg1 = "ddMMyyyy"; // Estas dos lineas son el uso de la librería FileHelperEngine engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = engine.ReadFileAsDT(@"..\Data\CustomersFixedLength.txt"); // Aqui es donde ustedes agregan su código foreach (DataRow dr in dt.Rows) { Console.WriteLine("Customer: " + dr[0].ToString() + " - " + dr[1].ToString()); } }
public void ReadFileEncDec() { var tempFile = "temp.fhc"; ClassBuilder.ClassToBinaryFile(tempFile, mClass); Type t = ClassBuilder.ClassFromBinaryFile(tempFile); File.Delete(tempFile); engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
public void FullClassBuildingFixed() { var cb = new FixedLengthClassBuilder("Customers"); cb.AddField("Field1", 8, typeof (DateTime)); cb.LastField.Converter.Kind = ConverterKind.Date; cb.LastField.Converter.Arg1 = "ddMMyyyy"; cb.LastField.FieldNullValue = DateTime.Now; cb.AddField("Field2", 3, typeof (string)); cb.LastField.AlignMode = AlignMode.Right; cb.LastField.AlignChar = ' '; cb.AddField("Field3", 3, typeof (int)); cb.LastField.AlignMode = AlignMode.Right; cb.LastField.AlignChar = '0'; cb.LastField.TrimMode = TrimMode.Both; mEngine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = mEngine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, mEngine.TotalRecords); Assert.AreEqual(0, mEngine.ErrorManager.ErrorCount); }
private void ValidateType(Type t) { engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); }
protected override DataTable readWholeTable(UnitType source) { //initialize the engine FileHelperEngine engine = new FileHelperEngine(getRecordType(source)); //ignore the average annual outputs engine.Options.IgnoreLastLines = getNumberOfLinesForAverageAnnualOutput(source); //Console.WriteLine("Reading whole table for " + source.ToString()); return(engine.ReadFileAsDT(getOutputFileFromType(source))); }
public void ReadAsDataTable2() { DelimitedClassBuilder cb = new DelimitedClassBuilder("ImportContact", ","); cb.IgnoreEmptyLines = true; cb.GenerateProperties = true; cb.AddField("FirstName", typeof(string)); cb.LastField.TrimMode = FileHelpers.TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("LastName", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetNumber", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetAddress", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Unit", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("City", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("State", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Zip", typeof(string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; var engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable contactData = engine.ReadFileAsDT(TestCommon.GetPath("Good", "ReadAsDataTable.txt")); Assert.AreEqual(3, contactData.Rows.Count); Assert.AreEqual(8, contactData.Columns.Count); Assert.AreEqual("Alex & Jen", contactData.Rows[0][0].ToString()); Assert.AreEqual("Mark & Lisa K", contactData.Rows[1][0].ToString()); // new DelimitedClassBuilder("", ","); }
public void ReadFile() { var engine = new FileHelperEngine <SampleType>(); var dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), (DateTime)dt.Rows[0]["Field1"]); Assert.AreEqual("901", (string)dt.Rows[0]["Field2"]); Assert.AreEqual(234, (int)dt.Rows[0]["Field3"]); Assert.AreEqual(new DateTime(1314, 11, 10), (DateTime)dt.Rows[1]["Field1"]); Assert.AreEqual("012", (string)dt.Rows[1]["Field2"]); Assert.AreEqual(345, (int)dt.Rows[1]["Field3"]); }
public void ReadFile() { var engine = new FileHelperEngine<SampleType>(); var dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), (DateTime) dt.Rows[0]["Field1"]); Assert.AreEqual("901", (string) dt.Rows[0]["Field2"]); Assert.AreEqual(234, (int) dt.Rows[0]["Field3"]); Assert.AreEqual(new DateTime(1314, 11, 10), (DateTime) dt.Rows[1]["Field1"]); Assert.AreEqual("012", (string) dt.Rows[1]["Field2"]); Assert.AreEqual(345, (int) dt.Rows[1]["Field3"]); }
/// <summary> /// Read data from SWAT output file using FileHelperAsyncEngine /// </summary> /// <remarks> /// 1. Need to define classes correponding to each data table /// 2. Get the data table directly /// </remarks> static void TestExtractFromText_FileHelperAsyncEngine(string filePah) { Console.WriteLine("FileHelperAsyncEngine"); DateTime before = DateTime.Now; FileHelperEngine engine = new FileHelperEngine(typeof(SWATSub)); using (DataTable dt = engine.ReadFileAsDT(filePah)) { DataRow[] rows = dt.Select("SUB=1"); //foreach (DataRow r in rows) //{ // Console.WriteLine(string.Format("{0},{1},{2}", r["SUB"], r["MON"], r["PETmm"])); //} } DateTime after = DateTime.Now; Console.WriteLine(string.Format("******\nTime Used: {0} seconds\n******", after.Subtract(before).TotalSeconds)); }
public void ReadNullableTypes() { var engine = new FileHelperEngine<NullableType>(); var res = engine.ReadFileAsDT(FileTest.Good.NullableTypes1.Path); Assert.AreEqual(4, res.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), (DateTime) res.Rows[0]["Field1"]); Assert.AreEqual("901", (string) res.Rows[0]["Field2"]); Assert.AreEqual(234, (int) res.Rows[0]["Field3"]); Assert.AreEqual(DBNull.Value, res.Rows[1]["Field1"]); Assert.AreEqual("012", (string) res.Rows[1]["Field2"]); Assert.AreEqual(345, (int) res.Rows[1]["Field3"]); Assert.AreNotEqual(DBNull.Value, res.Rows[2]["Field1"]); }
public void ReadFileAsDataTable() { engine = new FileHelperEngine(typeof(SampleType)); DataTable res; res = engine.ReadFileAsDT(TestCommon.TestPath(@"Good\test1.txt")); Assert.AreEqual(4, res.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), res.Rows[0]["Field1"]); Assert.AreEqual("901", res.Rows[0]["Field2"]); Assert.AreEqual(234, res.Rows[0]["Field3"]); Assert.AreEqual(new DateTime(1314, 11, 10), res.Rows[1]["Field1"]); Assert.AreEqual("012", res.Rows[1]["Field2"]); Assert.AreEqual(345, res.Rows[1]["Field3"]); }
public void ReadFile() { Type t = ClassBuilder.ClassFromString(mClass); engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
public void ReadFile() { Type t = ClassBuilder.ClassFromString(Class); mEngine = new FileHelperEngine(t); DataTable dt = mEngine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, mEngine.TotalRecords); Assert.AreEqual(0, mEngine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
public void ReadFileClassInFileVbNet() { Type t = ClassBuilder.ClassFromSourceFile(Common.TestPath(@"Classes\SampleClass.vb"), NetLanguage.VbNet); engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(Common.TestPath(@"Good\test1.txt")); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
public void ReadNullableTypes() { var engine = new FileHelperEngine <NullableType>(); var res = engine.ReadFileAsDT(FileTest.Good.NullableTypes1.Path); Assert.AreEqual(4, res.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), (DateTime)res.Rows[0]["Field1"]); Assert.AreEqual("901", (string)res.Rows[0]["Field2"]); Assert.AreEqual(234, (int)res.Rows[0]["Field3"]); Assert.AreEqual(DBNull.Value, res.Rows[1]["Field1"]); Assert.AreEqual("012", (string)res.Rows[1]["Field2"]); Assert.AreEqual(345, (int)res.Rows[1]["Field3"]); Assert.AreNotEqual(DBNull.Value, res.Rows[2]["Field1"]); }
public void ReadFileClassInFileVbNet() { Type t = ClassBuilder.ClassFromSourceFile(FileTest.Classes.SampleClassVB.Path, NetLanguage.VbNet); var engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
public void ReadFileAsDataTable() { FileHelperEngine <SampleType> engine = new FileHelperEngine <SampleType>(); DataTable res; res = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, res.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), res.Rows[0]["Field1"]); Assert.AreEqual("901", res.Rows[0]["Field2"]); Assert.AreEqual(234, res.Rows[0]["Field3"]); Assert.AreEqual(new DateTime(1314, 11, 10), res.Rows[1]["Field1"]); Assert.AreEqual("012", res.Rows[1]["Field2"]); Assert.AreEqual(345, res.Rows[1]["Field3"]); }
public void ReadFileClassInFileEnc() { var t = ClassBuilder.ClassFromBinaryFile(FileTest.Classes.SampleBinaryClass.Path); mEngine = new FileHelperEngine(t); DataTable dt = mEngine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, mEngine.TotalRecords); Assert.AreEqual(0, mEngine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
public void ReadFile() { Type t = ClassBuilder.ClassFromString(mClass); engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(Common.TestPath(@"Good\test1.txt")); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
private void Open_Click(object sender, RoutedEventArgs e) { DelimitedClassBuilder classBuilder = ExamineGridForColumnOrder(","); OpenFileDialog openFileDialog1 = new OpenFileDialog { Filter = "csv files (*.csv)|*.csv|Excel files (*.xls;*.xlsx)|*.xls;*.xlsx|All files (*.*)|*.*", FilterIndex = 3 }; if (openFileDialog1.ShowDialog() != true) { return; } try { DataTable dt; if (Path.GetExtension(openFileDialog1.FileName).ToLower().Equals(".csv")) { FileHelperEngine engine = new FileHelperEngine(classBuilder.CreateRecordClass()); dt = engine.ReadFileAsDT(openFileDialog1.FileName); } else if (Path.GetExtension(openFileDialog1.FileName).ToLower().Equals(".xls") || Path.GetExtension(openFileDialog1.FileName).ToLower().Equals(".xlsx")) { ExcelStorage storage = new ExcelStorage(classBuilder.CreateRecordClass(), openFileDialog1.FileName, 1, 1); dt = storage.ExtractRecordsAsDT(); } else { return; } PasteDataTable(dt); } catch (Exception ex) { MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message); } }
public void ReadFileDiffDir() { string oldDir = Environment.CurrentDirectory; Environment.CurrentDirectory = Path.GetTempPath(); Type t = ClassBuilder.ClassFromString(Class); Environment.CurrentDirectory = oldDir; mEngine = new FileHelperEngine(t); DataTable dt = mEngine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, mEngine.TotalRecords); Assert.AreEqual(0, mEngine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
private DataTable LoadIntoCollection(string path) { FileHelperEngine engine = new FileHelperEngine(typeof(FileTemplate)); return(engine.ReadFileAsDT(path)); }
public void ReadFileAsDataTable() { FileHelperEngine<SampleType> engine = new FileHelperEngine<SampleType>(); DataTable res; res = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, res.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), res.Rows[0]["Field1"]); Assert.AreEqual("901", res.Rows[0]["Field2"]); Assert.AreEqual(234, res.Rows[0]["Field3"]); Assert.AreEqual(new DateTime(1314, 11, 10), res.Rows[1]["Field1"]); Assert.AreEqual("012", res.Rows[1]["Field2"]); Assert.AreEqual(345, res.Rows[1]["Field3"]); }
public void ReadFileClassInFileVbNet() { Type t = ClassBuilder.ClassFromSourceFile(FileTest.Classes.SampleClassVB.Path, NetLanguage.VbNet); engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
private void ValidateType(Type t) { engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); }
public void ReadFileAsDataTable() { engine = new FileHelperEngine(typeof (SampleType)); DataTable res; res = engine.ReadFileAsDT(Common.TestPath(@"Good\test1.txt")); Assert.AreEqual(4, res.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), res.Rows[0]["Field1"]); Assert.AreEqual("901", res.Rows[0]["Field2"]); Assert.AreEqual(234, res.Rows[0]["Field3"]); Assert.AreEqual(new DateTime(1314, 11, 10), res.Rows[1]["Field1"]); Assert.AreEqual("012", res.Rows[1]["Field2"]); Assert.AreEqual(345, res.Rows[1]["Field3"]); }
private void btnUpload_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtInputFile.Text)) { return; } string message = string.Format("Do you want to upload {0} from file: \r\n{1}", mSelectedTable, txtInputFile.Text); DialogResult result = MessageBox.Show(message, "Information", MessageBoxButtons.OKCancel); if (result == System.Windows.Forms.DialogResult.Cancel) return; this.Cursor = Cursors.WaitCursor; List<string> rows = new List<string>(); //StreamReader reader = new StreamReader(txtInputFile.Text, Encoding.GetEncoding("Shift-JIS")); FileHelperEngine engine = null; switch (mSelectedModule) { case FYamaya.TAB_KEY_AREA: engine = new FileHelperEngine(typeof(AreaMapping), Encoding.GetEncoding("Shift-JIS")); break; case FYamaya.TAB_KEY_CATEGORY: engine = new FileHelperEngine(typeof(CategoryMapping), Encoding.GetEncoding("Shift-JIS")); break; case FYamaya.TAB_KEY_ITEM: engine = new FileHelperEngine(typeof(ItemMapping), Encoding.GetEncoding("Shift-JIS")); break; case FYamaya.TAB_KEY_ITEM_DESC: engine = new FileHelperEngine(typeof(ItemDescMapping), Encoding.GetEncoding("Shift-JIS")); break; default: break; } // to Read use: DataTable dt = engine.ReadFileAsDT(txtInputFile.Text); ProgessStatus mFProgessStatus = new ProgessStatus(); mFProgessStatus.uploadAreaCSV(dt, mSelectedModule, mDBConn); DialogResult dresult = mFProgessStatus.ShowDialog(); if (dresult == System.Windows.Forms.DialogResult.Yes) { MessageBox.Show("Successfully upload record to database!", "Upload CSV File", MessageBoxButtons.OK); onSuccessUpload(mSelectedModule); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK); } finally { this.Cursor = Cursors.Default; } }
/// <summary> /// Read data from SWAT output file using FileHelperAsyncEngine /// </summary> /// <remarks> /// 1. Need to define classes correponding to each data table /// 2. Get the data table directly /// </remarks> static void TestExtractFromText_FileHelperAsyncEngine(string filePah) { Console.WriteLine("FileHelperAsyncEngine"); DateTime before = DateTime.Now; FileHelperEngine engine = new FileHelperEngine(typeof(SWATSub)); using (DataTable dt = engine.ReadFileAsDT(filePah)) { DataRow[] rows = dt.Select("SUB=1"); //foreach (DataRow r in rows) //{ // Console.WriteLine(string.Format("{0},{1},{2}", r["SUB"], r["MON"], r["PETmm"])); //} } DateTime after = DateTime.Now; Console.WriteLine(string.Format("******\nTime Used: {0} seconds\n******", after.Subtract(before).TotalSeconds)); }
public void ReadAsDataTable2() { var cb = new DelimitedClassBuilder("ImportContact", ","); cb.IgnoreEmptyLines = true; cb.GenerateProperties = true; cb.AddField("FirstName", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("LastName", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetNumber", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("StreetAddress", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Unit", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("City", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("State", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; cb.AddField("Zip", typeof (string)); cb.LastField.TrimMode = TrimMode.Both; cb.LastField.FieldQuoted = false; var engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable contactData = engine.ReadFileAsDT(TestCommon.GetPath("Good", "ReadAsDataTable.txt")); Assert.AreEqual(3, contactData.Rows.Count); Assert.AreEqual(8, contactData.Columns.Count); Assert.AreEqual("Alex & Jen", contactData.Rows[0][0].ToString()); Assert.AreEqual("Mark & Lisa K", contactData.Rows[1][0].ToString()); // new DelimitedClassBuilder("", ","); }
protected override DataTable readWholeTable(UnitType source) { //initialize the engine FileHelperEngine engine = new FileHelperEngine(getRecordType(source)); //ignore the average annual outputs engine.Options.IgnoreLastLines = getNumberOfLinesForAverageAnnualOutput(source); //Console.WriteLine("Reading whole table for " + source.ToString()); return engine.ReadFileAsDT(getOutputFileFromType(source)); }
public void ReadFileEncDec() { var tempFile = "temp.fhc"; ClassBuilder.ClassToBinaryFile(tempFile, Class); Type t = ClassBuilder.ClassFromBinaryFile(tempFile); File.Delete(tempFile); mEngine = new FileHelperEngine(t); DataTable dt = mEngine.ReadFileAsDT(FileTest.Good.Test1.Path); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, mEngine.TotalRecords); Assert.AreEqual(0, mEngine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
protected void UploadButton_Click(object sender, EventArgs e) { // csv bool isLive = true; if (FileUpload.HasFiles) { foreach (HttpPostedFile uploadedFile in FileUpload.PostedFiles) { string Filename = ""; string Extension = ""; Filename = uploadedFile.FileName; Extension = Path.GetExtension(Filename).ToLower(); string thisID = Guid.NewGuid().ToString(); if (Extension == ".csv") { uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Temp/"), thisID + Extension)); //MySqlConnection DBConnection; //MySqlCommand DBCommand; //MySqlDataReader DBResult; FileHelperEngine engine = new FileHelperEngine(typeof(ContactsVerticalBar)); DataTable objTable = engine.ReadFileAsDT(System.IO.Path.Combine(Server.MapPath("~/Temp/"), thisID + Extension)); ResultsLiteral.Text += "<table><tr><th>Name</th><th>Company</th><th>Tel</th><th>Mobile</th><th>Email</th></tr>"; ResultsStatsLiteral.Text = "Importing " + objTable.Rows.Count + " rows..."; foreach (DataRow row in objTable.Rows) { string thisName = row["Name"].ToString(); string thisCompany = row["Company"].ToString(); string thisTel = row["Tel"].ToString(); string thisMobile = row["Mobile"].ToString(); string thisEmail = row["Email"].ToString(); string thisPosition = row["Position"].ToString(); string thisAddress = row["Address"].ToString(); string thisStreet = row["Street"].ToString(); string thisTown = row["Town"].ToString(); string thisCounty = row["County"].ToString(); string thisPostcode = row["Postcode"].ToString(); string thisLocationID = row["LocationID"].ToString(); string thisContactType = row["ContactType"].ToString(); string thisContactTypeText = ""; if (!string.IsNullOrEmpty(thisName)) { switch (thisContactType) { case "1": thisContactTypeText = "Location Owner"; break; case "2": thisContactTypeText = "Project Company"; break; default: thisContactTypeText = ""; thisContactTypeText = "Location Owner"; thisContactType = "1"; break; } ResultsLiteral.Text += "<tr><td valign=\"top\">" + thisContactTypeText + "</td><td>" + thisName + "</td><td>" + thisCompany + "</td><td>" + thisTel + "</td><td>" + thisMobile + "</td><td>" + thisEmail + "</td></tr>"; ResultsLiteral.Text += "<tr><td></td><td colspan=\"5\">"; ResultsLiteral.Text += "<b>Notes:</b>"; UK_Film_Location_Class.ContactDetails objContact = new UK_Film_Location_Class.ContactDetails(); bool foundContact = false; if (!string.IsNullOrEmpty(thisEmail)) { objContact.getContactFromEmail(thisEmail); if (!string.IsNullOrEmpty(objContact.ContactID)) { ResultsLiteral.Text += "<p>Contact found by Email!</p>"; foundContact = true; } } if (!foundContact && !string.IsNullOrEmpty(thisTel)) { objContact.getContactFromTel(thisTel); if (!string.IsNullOrEmpty(objContact.ContactID)) { ResultsLiteral.Text += "<p>Contact found by Tel!</p>"; foundContact = true; } } if (!foundContact && !string.IsNullOrEmpty(thisName)) { objContact.getContactFromName(thisName); if (!string.IsNullOrEmpty(objContact.ContactID)) { ResultsLiteral.Text += "<p>Contact found by Name :/</p>"; foundContact = true; } } // Compare Data on found records if (foundContact) { bool isMod = false; ResultsLiteral.Text += "<p><i>Updating Contact!</i></p>"; if (string.IsNullOrEmpty(objContact.Company) && !string.IsNullOrEmpty(thisCompany)) { objContact.Company = thisCompany.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Company!</p>"; } if (string.IsNullOrEmpty(objContact.Name) && !string.IsNullOrEmpty(thisName)) { objContact.Name = thisName.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Name!</p>"; } if (string.IsNullOrEmpty(objContact.Tel) && !string.IsNullOrEmpty(thisTel)) { objContact.Tel = thisTel.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Tel!</p>"; } if (string.IsNullOrEmpty(objContact.Mobile) && !string.IsNullOrEmpty(thisMobile)) { objContact.Mobile = thisMobile.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Mobile!</p>"; } if (string.IsNullOrEmpty(objContact.ContactType) && !string.IsNullOrEmpty(thisContactType)) { objContact.ContactType = thisContactType.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Contact Type!</p>"; } if (string.IsNullOrEmpty(objContact.Email) && !string.IsNullOrEmpty(thisEmail)) { objContact.Email = thisEmail.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Email Address!</p>"; } if (string.IsNullOrEmpty(objContact.Address) && !string.IsNullOrEmpty(thisAddress)) { objContact.Address = thisAddress.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Address!</p>"; } if (string.IsNullOrEmpty(objContact.Street) && !string.IsNullOrEmpty(thisStreet)) { objContact.Street = thisStreet.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Street!</p>"; } if (string.IsNullOrEmpty(objContact.Town) && !string.IsNullOrEmpty(thisTown)) { objContact.Town = thisTown.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Town!</p>"; } if (string.IsNullOrEmpty(objContact.County) && !string.IsNullOrEmpty(thisCounty)) { objContact.County = thisCounty.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating County!</p>"; } if (string.IsNullOrEmpty(objContact.PostCode) && !string.IsNullOrEmpty(thisPostcode)) { objContact.PostCode = thisPostcode.Trim(); isMod = true; ResultsLiteral.Text += "<p>Updating Postcode!</p>"; } if (isMod) { if (isLive) objContact.Update(); ResultsLiteral.Text += "<p>Updated!</p>"; } else ResultsLiteral.Text += "<p>Up to Date!</p>"; } else { ResultsLiteral.Text += "<p>New Contact!</p>"; objContact.Name = thisName.Trim(); objContact.Company = thisCompany.Trim(); objContact.Tel = thisTel.Trim(); objContact.Mobile = thisMobile.Trim(); objContact.Email = thisEmail.Trim(); if (!string.IsNullOrEmpty(thisLocationID)) { objContact.ContactType = "1"; } else { objContact.ContactType = thisContactType.Trim(); } objContact.Address = thisAddress.Trim(); objContact.Street = thisStreet.Trim(); objContact.Town = thisTown.Trim(); objContact.County = thisCounty.Trim(); objContact.PostCode = thisPostcode.Trim(); if (isLive) objContact.Create(); } // Check LocationID's if (!string.IsNullOrEmpty(thisLocationID)) { UK_Film_Location_Class.LocationDetails objLocation = new UK_Film_Location_Class.LocationDetails(); objLocation.getLocationFromID(thisLocationID); if (objLocation.RecordID > 0) { objLocation.ContactID = objContact.ContactID; if (isLive) objLocation.saveLocation(); ResultsLiteral.Text += "<p>Associated contact with location " + thisLocationID + "!</p>"; } else { ResultsLiteral.Text += "<p>Lcation " + thisLocationID + " NOT FOUND!</p>"; } } } } ResultsLiteral.Text += "</td></tr>"; } ResultsLiteral.Text += "</table>"; //var engine = new FileHelperAsyncEngine<ContactsVerticalBar>(); //engine.BeginReadFile(System.IO.Path.Combine(Server.MapPath("~/Temp/"), thisID + Extension)); // The Async engines are IEnumerable //foreach (ContactsVerticalBar cust in engine) //{ // // your code here // ResultsLiteral.Text = cust.Name + " - " + cust.Email + "<br>"; //} } } }
public void ReadFileDiffDir() { string oldDir = Environment.CurrentDirectory; Environment.CurrentDirectory = @"C:\"; Type t = ClassBuilder.ClassFromString(mClass); Environment.CurrentDirectory = oldDir; engine = new FileHelperEngine(t); DataTable dt = engine.ReadFileAsDT(Common.TestPath(@"Good\test1.txt")); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(4, engine.TotalRecords); Assert.AreEqual(0, engine.ErrorManager.ErrorCount); Assert.AreEqual(new DateTime(1314, 12, 11), dt.Rows[0][0]); Assert.AreEqual("901", dt.Rows[0][1]); Assert.AreEqual(234, dt.Rows[0][2]); Assert.AreEqual(new DateTime(1314, 11, 10), dt.Rows[1][0]); Assert.AreEqual("012", dt.Rows[1][1]); Assert.AreEqual(345, dt.Rows[1][2]); }
static void RunTimeRecordsFixed() { Console.WriteLine("Run Time Records now =) ..."); Console.WriteLine(); FixedLengthClassBuilder cb = new FixedLengthClassBuilder("Customer", FixedMode.ExactLength); cb.AddField("CustId", 5, typeof(Int32)); cb.AddField("Name", 20, typeof(string)); cb.AddField("Balance", 8, typeof(Decimal)); cb.AddField("AddedDate", 8, typeof(DateTime)); cb.LastField.Converter.Kind = ConverterKind.Date; cb.LastField.Converter.Arg1 = "ddMMyyyy"; // Estas dos lineas son el uso de la librería FileHelperEngine engine = new FileHelperEngine(cb.CreateRecordClass()); DataTable dt = engine.ReadFileAsDT(@"..\Data\CustomersFixedLength.txt"); // Aqui es donde ustedes agregan su código foreach (DataRow dr in dt.Rows) { Console.WriteLine("Customer: " + dr[0].ToString() + " - " + dr[1].ToString()); } }
/// <summary> /// Used to read a file as a DataTable without instanciate the engine.<br /> /// <b>This is feature limited method try to use the non static methods.</b> /// </summary> /// <param name="recordClass">The record class.</param> /// <param name="fileName">The file name</param> /// <param name="maxRecords">The max number of records to read. Int32.MaxValue or -1 to read all records.</param> /// <returns>The datatable representing all the read records.</returns> public static DataTable ReadFileAsDT(Type recordClass, string fileName, int maxRecords) { var engine = new FileHelperEngine(recordClass); return(engine.ReadFileAsDT(fileName, maxRecords)); }