//public DataFile(CurrentJob Cj) // Export file
//{
// CurrentJob = Cj;
// SetDefaults();
// //if (CurrentJob.SelectedDataFile !=null && CurrentJob.SelectedDataFile.IsExcelColumnNames)
// // throw new Exception("Please change Column headers back to original names");
//}
public DataFile(string fileFullPath) // Import file
{
IOFileInfo = new IOFileInfo();
SetFileFullPath(fileFullPath);
FileIncrement = FileIncrement;
// WorkSheets = new List<WorkSheet>();
/// FirstAndLastRowArray = new List<string[]>();
}
private void PopulateTables()
{
IOFileInfo ei = new IOFileInfo();
ei.FileFullPath = this.FileFullPath;
DataAccessBase eda = new MSAccessDataAccess(ei);
Tables = eda.GetTables();
}
public override void SaveData()
{
IOFileInfo ei = new IOFileInfo();
//CommonFunctions.SetCommonPropertyValues(this, ei);
ei.WorkSheetName = FileName;
DataAccessBase eda = new ExcelDataAccess(ei);
eda.Save();
}
public override void SaveData()
{
IOFileInfo ei = new IOFileInfo();
// CommonFunctions.SetCommonPropertyValues(this, ei);
ei.WorkSheetName = FileName;
ei.FileFullPath = this.FolderName + "\\" + FileName + ".XLSX";
DataAccessBase eda = new ExcelDataAccess(ei);
eda.Save();
}
public override void ImportData(string WorkSheetName)
{
IOFileInfo ei = new IOFileInfo();
ei.FileFullPath = FileFullPath;
DataAccessBase eda = new ExcelDataAccess(ei);
DataSource = eda.Import(WorkSheetName);
//RemoveSpecialCharactersFromColumns();
//PopulateTableHeader();
//PopulateFirstAndLastRowArray();
}
public virtual void ImportData(DataTable dt)
{
IOFileInfo ei = new IOFileInfo();
ei.FileFullPath = FileFullPath;
ei.FileName = FileName;
DataAccessBase eda = new FlatFileDataAccess(ei);
eda.ReportProgress += eda_ReportProgress;
DataSource = eda.Import(dt);
}
public override void ImportData(string TableName)
{
IOFileInfo ei = new IOFileInfo();
ei.OutputDataSource = OutputDataSource;
ei.FileFullPath = FileFullPath;
ei.WorkSheetName = TableName;
DataAccessBase eda = new MSAccessDataAccess(ei);
DataSource = eda.Import(TableName);
// ReplaceSpacesWithUnderscore();
}
//public void SetDefaults()
//{
// IOFileInfo = new IOFileInfo();
// IOFileInfo.WrappedWithQuotes = true;
// IOFileInfo.CreateHeader = true;
// IOFileInfo.Delimiter = ",";
// IOFileInfo.WrappedWithQuotes = true;
// if (CurrentJob.Encoding == CurrentJob.EncodingType.Default)
// IOFileInfo.Encoding = IOFileInfo.EncodingType.Default;
// else
// IOFileInfo.Encoding = IOFileInfo.EncodingType.UTF8;
//}
public virtual void ImportData()
{
IOFileInfo ei = new IOFileInfo();
ei.FileFullPath = FileFullPath;
ei.FileName = FileName;
DataAccessBase eda = new FlatFileDataAccess(ei);
eda.ReportProgress += eda_ReportProgress;
DataSource = eda.Import();
// RemoveSpecialCharactersFromColumns();
}
public DataFile()
{
IOFileInfo = new IOFileInfo();
}
