/// <summary>
/// Restores the internal objects.
/// </summary>
/// <param name="workbook">The <see cref="ExcelInterop.Workbook"/> tied to this <see cref="ImportConnectionInfo"/> object.</param>
public void Restore(ExcelInterop.Workbook workbook)
{
if (workbook == null || workbook.GetOrCreateId() != WorkbookGuid)
{
return;
}
if (_excelTable == null && !string.IsNullOrEmpty(_excelTableName))
{
ExcelTable = workbook.GetExcelTableByName(WorksheetName, _excelTableName);
if (ExcelTable == null)
{
return;
}
}
if (MySqlTable != null)
{
return;
}
if (_connection != null)
{
MySqlTable = _connection.CreateImportMySqlTable(OperationType, TableName, ImportColumnNames, SelectQuery, ProcedureResultSetIndex);
}
else
{
ConnectionInfoError = ConnectionInfoErrorType.WorkbenchConnectionDoesNotExist;
}
}