/// <summary>
/// Constructor
/// </summary>
/// <param name="pSourceProject">The Epi Info 2000 project to check</param>
public UpgradeProblemDisplayDialog(Epi.Epi2000.Project pSourceProject)
{
InitializeComponent();
lvProblems.Items.Clear();
sourceProject = pSourceProject;
this.errorList = new ImportExportErrorList();
}
private void CheckSourceProjectForProblems(Epi.Epi2000.Project sourceProject)
{
Epi.ImportExport.Epi2000.ProjectAnalyzer projectAnalyzer = new Epi.ImportExport.Epi2000.ProjectAnalyzer(sourceProject);
projectAnalyzer.SetStatus += new UpdateStatusEventHandler(projectAnalyzer_SetStatus);
projectAnalyzer.Analyze();
this.errorList = projectAnalyzer.ErrorList;
}
private void CheckSourceProjectForProblems(Epi.Epi2000.Project sourceProject)
{
Epi.ImportExport.Epi2000.ProjectAnalyzer projectAnalyzer = new Epi.ImportExport.Epi2000.ProjectAnalyzer(sourceProject);
projectAnalyzer.SetStatus += new UpdateStatusEventHandler(projectAnalyzer_SetStatus);
projectAnalyzer.Analyze();
this.errorList = projectAnalyzer.ErrorList;
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="pSourceProject">The Epi Info 2000 project to check</param>
public UpgradeProblemDisplayDialog(Epi.Epi2000.Project pSourceProject)
{
InitializeComponent();
lvProblems.Items.Clear();
sourceProject = pSourceProject;
this.errorList = new ImportExportErrorList();
}
public ExportInfo()
{
FormsProcessed = 0;
GridsProcessed = 0;
TotalRecordsPackaged = 0;
RecordsPackaged = new Dictionary <View, int>();
Messages = new ImportExportErrorList();
UserID = string.Empty;
Succeeded = false;
}
public ExportInfo()
{
FormsProcessed = 0;
GridsProcessed = 0;
TotalRecordsPackaged = 0;
RecordsPackaged = new Dictionary<View, int>();
Messages = new ImportExportErrorList();
UserID = string.Empty;
Succeeded = false;
}
/// <summary>
/// Checks the Epi Info 3.5.x project for problems.
/// </summary>
private void CheckSourceProjectForProblems()
{
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_ANALYZING_PROJECT, sourceProject.Name));
}
errorList = new ImportExportErrorList();
try
{
Epi.Data.IDbDriver db = sourceProject.CollectedData.GetDatabase();
string validationMessage = string.Empty;
if (!db.IsDatabaseFormatValid(ref validationMessage))
{
errorList.Add(ImportExportMessageType.Error, "1100", validationMessage);
return;
}
if (sourceProject.Views.Count == 0)
{
errorList.Add(ImportExportMessageType.Error, "1020", ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1020);
}
foreach (Epi.Epi2000.View view in sourceProject.Views)
{
// Check #1 - Does the view have a name?
if (string.IsNullOrEmpty(view.Name))
{
errorList.Add(ImportExportMessageType.Error, "1000", ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1000);
}
if (!view.Name.ToLowerInvariant().StartsWith("view"))
{
errorList.Add(ImportExportMessageType.Error, "1021", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1021, view.Name));
}
if (view.Name.Contains(' '))
{
errorList.Add(ImportExportMessageType.Error, "1022", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1022, view.Name));
}
// Check #2 - Does the view have any pages?
if (view.Pages.Count <= 0)
{
errorList.Add(ImportExportMessageType.Warning, "5000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5000, view.Name));
}
CheckViewSourceReferences(view);
if (!string.IsNullOrEmpty(view.TableName) && db.TableExists(view.TableName))
{
object result = db.ExecuteScalar(db.CreateQuery("SELECT Count(*) FROM [" + view.TableName + "]"));
CheckViewColumns(view);
int baseRowCount = 0;
if (result is Int32)
{
baseRowCount = (Int32)result;
}
else
{
errorList.Add(ImportExportMessageType.Error, "1001", "Something that should never fail has failed.");
}
bool hasUniqueKey = db.ColumnExists(view.TableName, "UniqueKey");
bool hasRecStatus = db.ColumnExists(view.TableName, "RecStatus");
// Check #3a - Does the table have a UniqueKey?
if (!hasUniqueKey)
{
errorList.Add(ImportExportMessageType.Error, "1002", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1002, view.Name));
}
// Check #3b - Does the table have a RECSTATUS column?
if (!hasRecStatus)
{
errorList.Add(ImportExportMessageType.Error, "1003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1003, view.Name));
}
if (hasUniqueKey)
{
// Check #4a - Is the unique key implemented as a number?
DataTable dt = db.GetTableData(view.TableName, "UniqueKey");
string dataType = dt.Columns[0].DataType.ToString();
if (dataType != "System.Int32")
{
errorList.Add(ImportExportMessageType.Error, "1004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1004, view.Name));
}
// Check #4b - Does the unique key have any missing / null values? (May occur if user modifies table by hand for various reasons)
Epi.Data.Query selectDistinctQuery = db.CreateQuery("SELECT UniqueKey FROM [" + view.TableName + "] WHERE UniqueKey = NULL OR UniqueKey is NULL");
dt = db.Select(selectDistinctQuery);
if (dt.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "1005", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1005, view.Name));
}
}
if (hasRecStatus)
{
// Check #4c - Is RECSTATUS implemented as a number?
DataTable dt = db.GetTableData(view.TableName, "RECSTATUS");
string dataType = dt.Columns[0].DataType.ToString();
if (dataType != "System.Int16" && dataType != "System.Byte")
{
errorList.Add(ImportExportMessageType.Error, "1006", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1006, view.Name));
}
// Check #4d - Does RECSTATUS have any values other than 0 or 1?
Epi.Data.Query selectDistinctQuery = db.CreateQuery("SELECT RECSTATUS FROM [" + view.TableName + "] WHERE RECSTATUS = NULL OR RECSTATUS is NULL OR RECSTATUS < 0 OR RECSTATUS > 1");
dt = db.Select(selectDistinctQuery);
if (dt.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "1007", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1007, view.Name));
}
}
List <string> reservedTableNames = new List <string>();
reservedTableNames.Add("metabackgrounds");
reservedTableNames.Add("metadatatypes");
reservedTableNames.Add("metadbinfo");
reservedTableNames.Add("metafields");
reservedTableNames.Add("metafieldtypes");
reservedTableNames.Add("metagridcolumns");
reservedTableNames.Add("metaimages");
reservedTableNames.Add("metalayerrendertypes");
reservedTableNames.Add("metalayers");
reservedTableNames.Add("metamaplayers");
reservedTableNames.Add("metamappoints");
reservedTableNames.Add("metamaps");
reservedTableNames.Add("metapages");
reservedTableNames.Add("metapatterns");
reservedTableNames.Add("metaprograms");
reservedTableNames.Add("metaviews");
// Check #5 - Does the view's table name conflict with Epi Info 7 meta table names?
if (reservedTableNames.Contains(view.TableName.ToLowerInvariant()))
{
errorList.Add(ImportExportMessageType.Error, "1008", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1008, view.Name, view.TableName));
}
if (view.IsWideTableView)
{
foreach (string tableName in view.TableNames)
{
// Wide Table Check #1 - Does this wide table have a name?
if (string.IsNullOrEmpty(tableName))
{
errorList.Add(ImportExportMessageType.Error, "1009", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1009, view.Name));
}
// Wide Table Check #2 - Does this wide table not exist? (We're in an IF that checks to see if the first table exists, so if this doesn't exist, there is a serious problem)
else if (!db.TableExists(tableName))
{
errorList.Add(ImportExportMessageType.Error, "1010", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1010, tableName, view.Name));
}
else
{
// Wide Table Check #3 - See if the wide table has a UniqueKey. Each wide table should have this.
hasUniqueKey = db.ColumnExists(tableName, "UniqueKey");
if (!hasUniqueKey)
{
errorList.Add(ImportExportMessageType.Error, "1011", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1011, tableName, view.Name));
}
if (hasUniqueKey)
{
DataTable dt = db.GetTableData(tableName, "UniqueKey");
string dataType = dt.Columns[0].DataType.ToString();
if (dataType != "System.Int32")
{
errorList.Add(ImportExportMessageType.Error, "1012", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1012, tableName, view.Name));
}
Epi.Data.Query selectDistinctQuery = db.CreateQuery("SELECT UniqueKey FROM [" + tableName + "] WHERE UniqueKey = NULL or UniqueKey is NULL");
dt = db.Select(selectDistinctQuery);
if (dt.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "1013", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1013, tableName, view.Name));
}
}
// Wide Table Check #4 - Check to make sure the row counts match across wide tables.
result = db.ExecuteScalar(db.CreateQuery("SELECT Count(*) FROM [" + tableName + "]"));
if (result is Int32)
{
int tRowCount = (Int32)result;
if (tRowCount != baseRowCount)
{
errorList.Add(ImportExportMessageType.Error, "1014", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1014, view.Name));
}
}
// Wide Table Check #5 - Check all DATA references for duplicates or missing references
DataTable generalCheckTable = db.Select(db.CreateQuery("SELECT [Datatable] FROM [" + view.Name + "] WHERE [Name] = 'GENERAL'"));
if (generalCheckTable.Rows.Count == 0)
{
errorList.Add(ImportExportMessageType.Error, "1015", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1015, view.Name));
}
else if (generalCheckTable.Rows.Count > 1)
{
errorList.Add(ImportExportMessageType.Error, "1016", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1016, view.Name));
}
else
{
if (generalCheckTable.Rows[0][0].ToString().Contains(","))
{
string[] dataRefs = generalCheckTable.Rows[0][0].ToString().Split(',');
List <string> dataRefsList = new List <string>();
foreach (string dataRef in dataRefs)
{
if (!dataRefsList.Contains(dataRef))
{
dataRefsList.Add(dataRef);
}
else
{
errorList.Add(ImportExportMessageType.Error, "1017", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1017, view.Name));
}
}
foreach (string dataRef in dataRefsList)
{
Query dataRefQuery = db.CreateQuery("SELECT [Name] FROM [" + view.Name + "] WHERE [Name] = @DataRef AND [Type] = 'SOURCE'");
dataRefQuery.Parameters.Add(new QueryParameter("@DataRef", DbType.String, dataRef));
DataTable dataRefTable = db.Select(dataRefQuery);
if (dataRefTable.Rows.Count == 0)
{
errorList.Add(ImportExportMessageType.Error, "1018", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1018, view.Name, dataRef));
}
}
}
else
{
errorList.Add(ImportExportMessageType.Error, "1019", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1019, view.Name));
}
}
}
}
} // end if wide table
} // end if (!string.IsNullOrEmpty(view.TableName) && db.TableExists(view.TableName))
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_ANALYZING_RELATIONS, view.Name));
}
Dictionary <string, string> relateButtonNames = new Dictionary <string, string>();
DataTable relateCheckTable1 = db.Select(db.CreateQuery("SELECT [Name], [Pfonttype] FROM [" + view.Name + "] WHERE [Type] = 'RELATE'"));
foreach (DataRow row in relateCheckTable1.Rows)
{
string relButtonName = row[0].ToString();
string relViewName = row[1].ToString();
if (!relateButtonNames.ContainsKey(relButtonName))
{
relateButtonNames.Add(relButtonName, relViewName);
}
else
{
errorList.Add(ImportExportMessageType.Error, "2000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2000, view.Name, relButtonName));
}
}
DataTable relateCheckTable2 = db.Select(db.CreateQuery("SELECT [Name], [Datatable] FROM [" + view.Name + "] WHERE [Name] LIKE 'RELVIE%' AND [Type] = 'SOURCE'"));
foreach (DataRow row in relateCheckTable2.Rows)
{
string relViewRefName = row[0].ToString();
string rViewName = row[1].ToString();
if (!relateButtonNames.ContainsValue(relViewRefName))
{
errorList.Add(ImportExportMessageType.Warning, "5001", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5001, relViewRefName, view.Name));
}
if (string.IsNullOrEmpty(rViewName))
{
errorList.Add(ImportExportMessageType.Error, "2001", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2001, relViewRefName, view.Name));
}
else if (!db.TableExists(rViewName))
{
errorList.Add(ImportExportMessageType.Error, "2002", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2002, relViewRefName, view.Name));
}
else
{
foreach (Epi.Epi2000.View iView in sourceProject.Views)
{
if (iView.Name == rViewName && !string.IsNullOrEmpty(iView.TableName))
{
bool tableExists = db.TableExists(iView.TableName);
if (tableExists && !db.ColumnExists(iView.TableName, "FKEY"))
{
errorList.Add(ImportExportMessageType.Error, "2003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2003, view.Name, rViewName));
}
else if (tableExists)
{
DataTable relateCheckTable3 = db.Select(db.CreateQuery("SELECT FKEY FROM [" + iView.TableName + "] WHERE [FKEY] is NULL"));
if (relateCheckTable3.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "2004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2004, iView.Name));
}
}
}
}
}
}
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_ANALYZING_FIELDS, view.Name));
}
foreach (Epi.Epi2000.Page page in view.Pages)
{
DataTable fieldsTable = sourceProject.Metadata.GetFieldsOnPageAsDataTable(view.Name, page.Position);
foreach (DataRow fieldRow in fieldsTable.Rows)
{
string fieldName = fieldRow["Name"].ToString();
if (Char.IsNumber(fieldName[0]))
{
errorList.Add(ImportExportMessageType.Error, "3000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3000, fieldName, view.Name));
}
if (fieldName.Contains(" "))
{
errorList.Add(ImportExportMessageType.Error, "3001", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3001, fieldName, view.Name));
}
MetaFieldType fieldType = Epi.Epi2000.MetadataDbProvider.InferFieldType(fieldRow);
//if (view.IsWideTableView == false)
//{
// if (fieldType != MetaFieldType.CommandButton && fieldType != MetaFieldType.Grid && fieldType != MetaFieldType.Group && fieldType != MetaFieldType.LabelTitle && fieldType != MetaFieldType.Mirror && fieldType != MetaFieldType.Relate &&
// db.ColumnExists(view.TableName, fieldName) == false && db.TableExists(view.TableName))
// {
// problems.Add(new KeyValuePair<ProjectUpgradeProblemType, string>(ProjectUpgradeProblemType.Error, "3002: The field " + fieldName + " in view " + view.Name + " has no corresponding column in the data table."));
// }
//}
if (fieldType == MetaFieldType.Grid)
{
errorList.Add(ImportExportMessageType.Warning, "5002", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5002, fieldName, view.Name));
}
else if (fieldType == MetaFieldType.Mirror)
{
string mirrorSource = fieldRow["Lists"].ToString();
if (mirrorSource == fieldName)
{
errorList.Add(ImportExportMessageType.Error, "3003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3003, fieldName, view.Name));
}
if (string.IsNullOrEmpty(mirrorSource))
{
errorList.Add(ImportExportMessageType.Warning, "5003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5003, fieldName, view.Name));
}
else
{
bool found = false;
foreach (DataRow iRow in sourceProject.Metadata.GetFieldsAsDataTable(view.Name).Rows)
{
if (iRow["Name"].ToString().Equals(mirrorSource))
{
found = true;
break;
}
}
if (!found)
{
errorList.Add(ImportExportMessageType.Warning, "5004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5004, fieldName, view.Name));
}
}
}
else if (fieldType == MetaFieldType.LegalValues || fieldType == MetaFieldType.CommentLegal)
{
string lists = fieldRow["Lists"].ToString();
string valueFieldName = string.Empty;
string[] rightSide = lists.Split('(');
if (rightSide.Length > 1)
{
string[] leftSide = rightSide[1].Split(',');
if (leftSide.Length > 1)
{
valueFieldName = leftSide[1].Trim(')').Trim();
string codeReference = leftSide[0];
Query codeTableCheckQuery = db.CreateQuery("SELECT [Name], [Datatable] FROM [" + view.Name + "] WHERE [Name] = @CodeReference");
codeTableCheckQuery.Parameters.Add(new QueryParameter("@CodeReference", DbType.String, codeReference));
DataTable codeTableCheck = db.Select(codeTableCheckQuery);
if (codeTableCheck.Rows.Count > 0)
{
string tableName = codeTableCheck.Rows[0]["Datatable"].ToString();
foreach (Epi.Epi2000.View sView in sourceProject.Views)
{
if (!string.IsNullOrEmpty(sView.TableName) && sView.TableName.ToLowerInvariant() == tableName.ToLowerInvariant())
{
errorList.Add(ImportExportMessageType.Error, "3013", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3013, fieldName, view.Name));
}
}
}
}
}
}
else if (fieldType == MetaFieldType.Codes)
{
string lists = fieldRow["Lists"].ToString();
string valueFieldName = string.Empty;
string[] rightSide = lists.Split('(');
if (rightSide.Length > 1)
{
string[] leftSide = rightSide[1].Split(',');
if (leftSide.Length > 2)
{
valueFieldName = leftSide[2].Trim(')').Trim();
string[] asterisks = valueFieldName.Split('*');
if (asterisks.Length > 1)
{
valueFieldName = asterisks[1];
}
}
}
string tableName = string.Empty;
int indexOf = lists.IndexOf(',');
tableName = lists.Substring(indexOf + 1);
indexOf = tableName.IndexOf('*');
if (indexOf > 0)
{
tableName = tableName.Substring(0, indexOf).Trim();
}
foreach (Epi.Epi2000.View sView in sourceProject.Views)
{
if (!string.IsNullOrEmpty(sView.TableName) && sView.TableName.ToLowerInvariant() == tableName.ToLowerInvariant())
{
errorList.Add(ImportExportMessageType.Error, "3004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3004, fieldName, view.Name));
}
}
}
}
}
CheckAllFields(view, db);
}
db.Dispose();
db = null;
}
catch (Exception ex)
{
errorList.Add(ImportExportMessageType.Error, "4000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E4000, ex.Message));
}
finally
{
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_FINISHED, sourceProject.Name));
}
}
}
/// <summary>
/// Checks the Epi Info 3.5.x project for problems.
/// </summary>
private void CheckSourceProjectForProblems()
{
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_ANALYZING_PROJECT, sourceProject.Name));
}
errorList = new ImportExportErrorList();
try
{
Epi.Data.IDbDriver db = sourceProject.CollectedData.GetDatabase();
string validationMessage = string.Empty;
if (!db.IsDatabaseFormatValid(ref validationMessage))
{
errorList.Add(ImportExportMessageType.Error, "1100", validationMessage);
return;
}
if (sourceProject.Views.Count == 0)
{
errorList.Add(ImportExportMessageType.Error, "1020", ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1020);
}
foreach (Epi.Epi2000.View view in sourceProject.Views)
{
// Check #1 - Does the view have a name?
if (string.IsNullOrEmpty(view.Name))
{
errorList.Add(ImportExportMessageType.Error, "1000", ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1000);
}
if (!view.Name.ToLower().StartsWith("view"))
{
errorList.Add(ImportExportMessageType.Error, "1021", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1021, view.Name));
}
if (view.Name.Contains(' '))
{
errorList.Add(ImportExportMessageType.Error, "1022", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1022, view.Name));
}
// Check #2 - Does the view have any pages?
if (view.Pages.Count <= 0)
{
errorList.Add(ImportExportMessageType.Warning, "5000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5000, view.Name));
}
CheckViewSourceReferences(view);
if (!string.IsNullOrEmpty(view.TableName) && db.TableExists(view.TableName))
{
object result = db.ExecuteScalar(db.CreateQuery("SELECT Count(*) FROM [" + view.TableName + "]"));
CheckViewColumns(view);
int baseRowCount = 0;
if (result is Int32)
{
baseRowCount = (Int32)result;
}
else
{
errorList.Add(ImportExportMessageType.Error, "1001", "Something that should never fail has failed.");
}
bool hasUniqueKey = db.ColumnExists(view.TableName, "UniqueKey");
bool hasRecStatus = db.ColumnExists(view.TableName, "RecStatus");
// Check #3a - Does the table have a UniqueKey?
if (!hasUniqueKey)
{
errorList.Add(ImportExportMessageType.Error, "1002", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1002, view.Name));
}
// Check #3b - Does the table have a RECSTATUS column?
if (!hasRecStatus)
{
errorList.Add(ImportExportMessageType.Error, "1003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1003, view.Name));
}
if (hasUniqueKey)
{
// Check #4a - Is the unique key implemented as a number?
DataTable dt = db.GetTableData(view.TableName, "UniqueKey");
string dataType = dt.Columns[0].DataType.ToString();
if (dataType != "System.Int32")
{
errorList.Add(ImportExportMessageType.Error, "1004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1004, view.Name));
}
// Check #4b - Does the unique key have any missing / null values? (May occur if user modifies table by hand for various reasons)
Epi.Data.Query selectDistinctQuery = db.CreateQuery("SELECT UniqueKey FROM [" + view.TableName + "] WHERE UniqueKey = NULL OR UniqueKey is NULL");
dt = db.Select(selectDistinctQuery);
if (dt.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "1005", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1005, view.Name));
}
}
if (hasRecStatus)
{
// Check #4c - Is RECSTATUS implemented as a number?
DataTable dt = db.GetTableData(view.TableName, "RECSTATUS");
string dataType = dt.Columns[0].DataType.ToString();
if (dataType != "System.Int16" && dataType != "System.Byte")
{
errorList.Add(ImportExportMessageType.Error, "1006", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1006, view.Name));
}
// Check #4d - Does RECSTATUS have any values other than 0 or 1?
Epi.Data.Query selectDistinctQuery = db.CreateQuery("SELECT RECSTATUS FROM [" + view.TableName + "] WHERE RECSTATUS = NULL OR RECSTATUS is NULL OR RECSTATUS < 0 OR RECSTATUS > 1");
dt = db.Select(selectDistinctQuery);
if (dt.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "1007", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1007, view.Name));
}
}
List<string> reservedTableNames = new List<string>();
reservedTableNames.Add("metabackgrounds");
reservedTableNames.Add("metadatatypes");
reservedTableNames.Add("metadbinfo");
reservedTableNames.Add("metafields");
reservedTableNames.Add("metafieldtypes");
reservedTableNames.Add("metagridcolumns");
reservedTableNames.Add("metaimages");
reservedTableNames.Add("metalayerrendertypes");
reservedTableNames.Add("metalayers");
reservedTableNames.Add("metamaplayers");
reservedTableNames.Add("metamappoints");
reservedTableNames.Add("metamaps");
reservedTableNames.Add("metapages");
reservedTableNames.Add("metapatterns");
reservedTableNames.Add("metaprograms");
reservedTableNames.Add("metaviews");
// Check #5 - Does the view's table name conflict with Epi Info 7 meta table names?
if (reservedTableNames.Contains(view.TableName.ToLower()))
{
errorList.Add(ImportExportMessageType.Error, "1008", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1008, view.Name, view.TableName));
}
if (view.IsWideTableView)
{
foreach (string tableName in view.TableNames)
{
// Wide Table Check #1 - Does this wide table have a name?
if (string.IsNullOrEmpty(tableName))
{
errorList.Add(ImportExportMessageType.Error, "1009", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1009, view.Name));
}
// Wide Table Check #2 - Does this wide table not exist? (We're in an IF that checks to see if the first table exists, so if this doesn't exist, there is a serious problem)
else if (!db.TableExists(tableName))
{
errorList.Add(ImportExportMessageType.Error, "1010", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1010, tableName, view.Name));
}
else
{
// Wide Table Check #3 - See if the wide table has a UniqueKey. Each wide table should have this.
hasUniqueKey = db.ColumnExists(tableName, "UniqueKey");
if (!hasUniqueKey)
{
errorList.Add(ImportExportMessageType.Error, "1011", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1011, tableName, view.Name));
}
if (hasUniqueKey)
{
DataTable dt = db.GetTableData(tableName, "UniqueKey");
string dataType = dt.Columns[0].DataType.ToString();
if (dataType != "System.Int32")
{
errorList.Add(ImportExportMessageType.Error, "1012", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1012, tableName, view.Name));
}
Epi.Data.Query selectDistinctQuery = db.CreateQuery("SELECT UniqueKey FROM [" + tableName + "] WHERE UniqueKey = NULL or UniqueKey is NULL");
dt = db.Select(selectDistinctQuery);
if (dt.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "1013", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1013, tableName, view.Name));
}
}
// Wide Table Check #4 - Check to make sure the row counts match across wide tables.
result = db.ExecuteScalar(db.CreateQuery("SELECT Count(*) FROM [" + tableName + "]"));
if (result is Int32)
{
int tRowCount = (Int32)result;
if (tRowCount != baseRowCount)
{
errorList.Add(ImportExportMessageType.Error, "1014", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1014, view.Name));
}
}
// Wide Table Check #5 - Check all DATA references for duplicates or missing references
DataTable generalCheckTable = db.Select(db.CreateQuery("SELECT [Datatable] FROM [" + view.Name + "] WHERE [Name] = 'GENERAL'"));
if (generalCheckTable.Rows.Count == 0)
{
errorList.Add(ImportExportMessageType.Error, "1015", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1015, view.Name));
}
else if (generalCheckTable.Rows.Count > 1)
{
errorList.Add(ImportExportMessageType.Error, "1016", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1016, view.Name));
}
else
{
if (generalCheckTable.Rows[0][0].ToString().Contains(","))
{
string[] dataRefs = generalCheckTable.Rows[0][0].ToString().Split(',');
List<string> dataRefsList = new List<string>();
foreach (string dataRef in dataRefs)
{
if (!dataRefsList.Contains(dataRef))
{
dataRefsList.Add(dataRef);
}
else
{
errorList.Add(ImportExportMessageType.Error, "1017", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1017, view.Name));
}
}
foreach (string dataRef in dataRefsList)
{
DataTable dataRefTable = db.Select(db.CreateQuery("SELECT [Name] FROM [" + view.Name + "] WHERE [Name] = '" + dataRef + "' AND [Type] = 'SOURCE'"));
if (dataRefTable.Rows.Count == 0)
{
errorList.Add(ImportExportMessageType.Error, "1018", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1018, view.Name, dataRef));
}
}
}
else
{
errorList.Add(ImportExportMessageType.Error, "1019", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E1019, view.Name));
}
}
}
}
} // end if wide table
} // end if (!string.IsNullOrEmpty(view.TableName) && db.TableExists(view.TableName))
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_ANALYZING_RELATIONS, view.Name));
}
Dictionary<string, string> relateButtonNames = new Dictionary<string, string>();
DataTable relateCheckTable1 = db.Select(db.CreateQuery("SELECT [Name], [Pfonttype] FROM [" + view.Name + "] WHERE [Type] = 'RELATE'"));
foreach (DataRow row in relateCheckTable1.Rows)
{
string relButtonName = row[0].ToString();
string relViewName = row[1].ToString();
if (!relateButtonNames.ContainsKey(relButtonName))
{
relateButtonNames.Add(relButtonName, relViewName);
}
else
{
errorList.Add(ImportExportMessageType.Error, "2000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2000, view.Name, relButtonName));
}
}
DataTable relateCheckTable2 = db.Select(db.CreateQuery("SELECT [Name], [Datatable] FROM [" + view.Name + "] WHERE [Name] LIKE 'RELVIE%' AND [Type] = 'SOURCE'"));
foreach (DataRow row in relateCheckTable2.Rows)
{
string relViewRefName = row[0].ToString();
string rViewName = row[1].ToString();
if (!relateButtonNames.ContainsValue(relViewRefName))
{
errorList.Add(ImportExportMessageType.Warning, "5001", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5001, relViewRefName, view.Name));
}
if (string.IsNullOrEmpty(rViewName))
{
errorList.Add(ImportExportMessageType.Error, "2001", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2001, relViewRefName, view.Name));
}
else if (!db.TableExists(rViewName))
{
errorList.Add(ImportExportMessageType.Error, "2002", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2002, relViewRefName, view.Name));
}
else
{
foreach (Epi.Epi2000.View iView in sourceProject.Views)
{
if (iView.Name == rViewName && !string.IsNullOrEmpty(iView.TableName))
{
bool tableExists = db.TableExists(iView.TableName);
if (tableExists && !db.ColumnExists(iView.TableName, "FKEY"))
{
errorList.Add(ImportExportMessageType.Error, "2003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2003, view.Name, rViewName));
}
else if (tableExists)
{
DataTable relateCheckTable3 = db.Select(db.CreateQuery("SELECT FKEY FROM [" + iView.TableName + "] WHERE [FKEY] is NULL"));
if (relateCheckTable3.Rows.Count > 0)
{
errorList.Add(ImportExportMessageType.Error, "2004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E2004, iView.Name));
}
}
}
}
}
}
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_ANALYZING_FIELDS, view.Name));
}
foreach (Epi.Epi2000.Page page in view.Pages)
{
DataTable fieldsTable = sourceProject.Metadata.GetFieldsOnPageAsDataTable(view.Name, page.Position);
foreach (DataRow fieldRow in fieldsTable.Rows)
{
string fieldName = fieldRow["Name"].ToString();
if (Char.IsNumber(fieldName[0]))
{
errorList.Add(ImportExportMessageType.Error, "3000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3000, fieldName, view.Name));
}
if (fieldName.Contains(" "))
{
errorList.Add(ImportExportMessageType.Error, "3001", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3001, fieldName, view.Name));
}
MetaFieldType fieldType = Epi.Epi2000.MetadataDbProvider.InferFieldType(fieldRow);
//if (view.IsWideTableView == false)
//{
// if (fieldType != MetaFieldType.CommandButton && fieldType != MetaFieldType.Grid && fieldType != MetaFieldType.Group && fieldType != MetaFieldType.LabelTitle && fieldType != MetaFieldType.Mirror && fieldType != MetaFieldType.Relate &&
// db.ColumnExists(view.TableName, fieldName) == false && db.TableExists(view.TableName))
// {
// problems.Add(new KeyValuePair<ProjectUpgradeProblemType, string>(ProjectUpgradeProblemType.Error, "3002: The field " + fieldName + " in view " + view.Name + " has no corresponding column in the data table."));
// }
//}
if (fieldType == MetaFieldType.Grid)
{
errorList.Add(ImportExportMessageType.Warning, "5002", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5002, fieldName, view.Name));
}
else if (fieldType == MetaFieldType.Mirror)
{
string mirrorSource = fieldRow["Lists"].ToString();
if (mirrorSource == fieldName)
{
errorList.Add(ImportExportMessageType.Error, "3003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3003, fieldName, view.Name));
}
if (string.IsNullOrEmpty(mirrorSource))
{
errorList.Add(ImportExportMessageType.Warning, "5003", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5003, fieldName, view.Name));
}
else
{
bool found = false;
foreach (DataRow iRow in sourceProject.Metadata.GetFieldsAsDataTable(view.Name).Rows)
{
if (iRow["Name"].ToString().Equals(mirrorSource))
{
found = true;
break;
}
}
if (!found)
{
errorList.Add(ImportExportMessageType.Warning, "5004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_W5004, fieldName, view.Name));
}
}
}
else if (fieldType == MetaFieldType.LegalValues || fieldType == MetaFieldType.CommentLegal)
{
string lists = fieldRow["Lists"].ToString();
string valueFieldName = string.Empty;
string[] rightSide = lists.Split('(');
if (rightSide.Length > 1)
{
string[] leftSide = rightSide[1].Split(',');
if (leftSide.Length > 1)
{
valueFieldName = leftSide[1].Trim(')').Trim();
string codeReference = leftSide[0];
DataTable codeTableCheck = db.Select(db.CreateQuery("SELECT [Name], [Datatable] FROM [" + view.Name + "] WHERE [Name] = '" + codeReference + "'"));
if (codeTableCheck.Rows.Count > 0)
{
string tableName = codeTableCheck.Rows[0]["Datatable"].ToString();
foreach (Epi.Epi2000.View sView in sourceProject.Views)
{
if (!string.IsNullOrEmpty(sView.TableName) && sView.TableName.ToLower() == tableName.ToLower())
{
errorList.Add(ImportExportMessageType.Error, "3013", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3013, fieldName, view.Name));
}
}
}
}
}
}
else if (fieldType == MetaFieldType.Codes)
{
string lists = fieldRow["Lists"].ToString();
string valueFieldName = string.Empty;
string[] rightSide = lists.Split('(');
if (rightSide.Length > 1)
{
string[] leftSide = rightSide[1].Split(',');
if (leftSide.Length > 2)
{
valueFieldName = leftSide[2].Trim(')').Trim();
string[] asterisks = valueFieldName.Split('*');
if (asterisks.Length > 1)
{
valueFieldName = asterisks[1];
}
}
}
string tableName = string.Empty;
int indexOf = lists.IndexOf(',');
tableName = lists.Substring(indexOf + 1);
indexOf = tableName.IndexOf('*');
if (indexOf > 0)
{
tableName = tableName.Substring(0, indexOf).Trim();
}
foreach (Epi.Epi2000.View sView in sourceProject.Views)
{
if (!string.IsNullOrEmpty(sView.TableName) && sView.TableName.ToLower() == tableName.ToLower())
{
errorList.Add(ImportExportMessageType.Error, "3004", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E3004, fieldName, view.Name));
}
}
}
}
}
CheckAllFields(view, db);
}
db.Dispose();
db = null;
}
catch (Exception ex)
{
errorList.Add(ImportExportMessageType.Error, "4000", string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_ERROR_E4000, ex.Message));
}
finally
{
if (SetStatus != null)
{
SetStatus(string.Format(ImportExportSharedStrings.UPGRADE_PROBLEM_CHECK_MESSAGE_FINISHED, sourceProject.Name));
}
}
}
