/// <summary>
/// Constructor for CollectedDataProvider
/// </summary>
/// <param name="proj"></param>
public CollectedDataProvider(Project proj)
{
IDbDriverFactory dbFactory = DbDriverFactoryCreator.GetDbDriverFactory(Configuration.AccessDriver);
OleDbConnectionStringBuilder cnnStrBuilder = new OleDbConnectionStringBuilder();
cnnStrBuilder.DataSource = proj.FilePath;
this.db = dbFactory.CreateDatabaseObject(cnnStrBuilder);
//this.db = dbFactory.CreateDatabaseObjectByConfiguredName(proj.FilePath);
//db = DatabaseFactoryCreator.CreateDatabaseInstanceByFileExtension(proj.FilePath);
}
/// <summary>
/// Constructor to build a view from a Epi 2000 project
/// </summary>
/// <param name="proj"></param>
public View(Project proj)
{
project = proj;
}
/// <summary>
/// Constructs a new view from a data row
/// </summary>
/// <param name="row">Data row containing view information</param>
/// <param name="proj"></param>
public View(DataRow row, Project proj)
{
project = proj;
Name = row[ColumnNames.NAME].ToString();
System.Text.StringBuilder CheckCode = new System.Text.StringBuilder();
// DefineVariable CheckCode Block
if (!string.IsNullOrEmpty(row[ColumnNames.CHECK_CODE_VARIABLE_DEFINITIONS].ToString()))
{
CheckCode.Append("\nDefineVariables\n\t");
CheckCode.Append(row[ColumnNames.CHECK_CODE_VARIABLE_DEFINITIONS].ToString().Replace("\n","\n\t\t"));
CheckCode.Append("\nEnd-DefineVariables");
}
// View CheckCode Block
if (
(!string.IsNullOrEmpty(row[ColumnNames.CHECK_CODE_BEFORE].ToString()))
||
(!string.IsNullOrEmpty(row[ColumnNames.CHECK_CODE_AFTER].ToString()))
)
{
CheckCode.Append("\nView\n\t");
if (!string.IsNullOrEmpty(row[ColumnNames.CHECK_CODE_BEFORE].ToString()))
{
CheckCode.Append("Before\n\t\t");
//CheckCodeBefore = row[ColumnNames.CHECK_CODE_BEFORE].ToString().Replace("\n", "\n\t\t\t");
CheckCode.Append(row[ColumnNames.CHECK_CODE_BEFORE].ToString().Replace("\n", "\n\t\t\t"));
CheckCode.Append("\n\tEnd-Before\n");
}
if (!string.IsNullOrEmpty(row[ColumnNames.CHECK_CODE_AFTER].ToString()))
{
CheckCode.Append("After\n\t\t");
//CheckCodeAfter = row[ColumnNames.CHECK_CODE_AFTER].ToString().Replace("\n", "\n\t\t\t");
CheckCode.Append(row[ColumnNames.CHECK_CODE_AFTER].ToString().Replace("\n", "\n\t\t\t"));
CheckCode.Append("\n\tEnd-After\n\t\t");
}
CheckCode.Append("\nEnd-View");
}
// Record CheckCode Block
if (
(!string.IsNullOrEmpty(row[ColumnNames.RECORD_CHECK_CODE_BEFORE].ToString()))
||
(!string.IsNullOrEmpty(row[ColumnNames.RECORD_CHECK_CODE_AFTER].ToString()))
)
{
CheckCode.Append("\nRecord\n\t");
if (!string.IsNullOrEmpty(row[ColumnNames.RECORD_CHECK_CODE_BEFORE].ToString()))
{
CheckCode.Append("Before\n\t\t");
//CheckCodeBefore = row[ColumnNames.RECORD_CHECK_CODE_BEFORE].ToString().Replace("\n", "\n\t\t\t");
CheckCode.Append(row[ColumnNames.RECORD_CHECK_CODE_BEFORE].ToString().Replace("\n", "\n\t\t\t"));
CheckCode.Append("\n\tEnd-Before\n");
}
if (!string.IsNullOrEmpty(row[ColumnNames.RECORD_CHECK_CODE_AFTER].ToString()))
{
CheckCode.Append("After\n\t\t");
//CheckCodeAfter = row[ColumnNames.RECORD_CHECK_CODE_AFTER].ToString().Replace("\n", "\n\t\t\t");
CheckCode.Append(row[ColumnNames.RECORD_CHECK_CODE_AFTER].ToString().Replace("\n", "\n\t\t\t"));
CheckCode.Append("\n\tEnd-After\n\t\t");
}
CheckCode.Append("\nEnd-Record");
}
CheckCodeBefore = CheckCode.ToString();
/*
CheckCodeVariableDefinitions = row[ColumnNames.CHECK_CODE_VARIABLE_DEFINITIONS].ToString();
CheckCodeBefore = row[ColumnNames.CHECK_CODE_BEFORE].ToString();
CheckCodeAfter = row[ColumnNames.CHECK_CODE_AFTER].ToString();
RecordCheckCodeBefore = row[ColumnNames.RECORD_CHECK_CODE_BEFORE].ToString();
RecordCheckCodeAfter = row[ColumnNames.RECORD_CHECK_CODE_AFTER].ToString();*/
// dataTableName = row[ColumnNames.DATA_TABLE_NAME].ToString();
dataTableNames.Add(row[ColumnNames.DATA_TABLE_NAME].ToString());
if (dataTableNames[0].Contains(";"))
{
IsWideTableView = true;
string[] tableNames = dataTableNames[0].Split(';');
dataTableNames.Clear();
foreach (string s in tableNames)
{
dataTableNames.Add(s);
}
}
}
/// <summary>
/// Constructs and initializes a new Import manager object
/// </summary>
/// <param name="sourceProj">The Epi Info 3.x project</param>
/// <param name="destProj">The resulting new project</param>
public ProjectUpgradeManager(Epi.Epi2000.Project sourceProj, Project destProj)
{
this.sourceProject = sourceProj;
this.destinationProject = destProj;
}
