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