public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context)
{
var frm = new Excel2010ImporterOptionsWindow(_options);
if (frm.ShowDialog().ValueOrFalse())
{
_options = new Excel2010ImporterOptions {
Filename = frm.Filename, Worksheet = frm.Worksheet
};
return(true);
}
return(false);
}
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context)
{
var filename = PromptForFilename("*.sqlite", "Error databases (*.sqlite)|*.sqlite");
if (!string.IsNullOrEmpty(filename))
{
_options = new ErrorDatabaseImporterOptions {
Filename = filename
};
var frm = new ErrorDatabaseImportOptionsWindow(_options, context);
frm.Owner = parentWindow;
frm.WindowStartupLocation = WindowStartupLocation.CenterOwner;
return(frm.ShowDialog().ValueOrFalse());
}
return(false);
}
public ErrorDatabaseImportOptionsWindow(ErrorDatabaseImporterOptions options, ImportWizardContext context)
{
InitializeComponent();
_service = new ImportStagingService(options.Filename);
Options = options;
Context = context;
_mappings = _service.GetMappings();
dataGrid.AutoGenerateColumns = false;
foreach (ImportFieldMapping mapping in _mappings) {
dataGrid.Columns.Add(CreateColumn(mapping));
}
var ds = _service.GetErrorsDataSet();
dataGrid.ItemsSource = ds.Tables[0].DefaultView;
dataGrid.IsReadOnly = true;
dataGrid.MouseDoubleClick += new MouseButtonEventHandler(dataGrid_MouseDoubleClick);
}
public ErrorDatabaseImportOptionsWindow(ErrorDatabaseImporterOptions options, ImportWizardContext context)
{
InitializeComponent();
_service = new ImportStagingService(options.Filename);
Options = options;
Context = context;
_mappings = _service.GetMappings();
dataGrid.AutoGenerateColumns = false;
foreach (ImportFieldMapping mapping in _mappings)
{
dataGrid.Columns.Add(CreateColumn(mapping));
}
var ds = _service.GetErrorsDataSet();
dataGrid.ItemsSource = ds.Tables[0].DefaultView;
dataGrid.IsReadOnly = true;
dataGrid.MouseDoubleClick += new MouseButtonEventHandler(dataGrid_MouseDoubleClick);
}
public abstract bool GetOptions(Window parentWindow, ImportWizardContext context);
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context)
{
var frm = new ExcelImporterOptionsWindow(_options);
if (frm.ShowDialog().ValueOrFalse()) {
_options = new ExcelImporterOptions { Filename = frm.Filename, Worksheet = frm.Worksheet };
return true;
}
return false;
}
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context)
{
var frm = new BVPImportOptionsWindow(PluginManager.Instance.User, _options);
frm.Owner = parentWindow;
frm.WindowStartupLocation = WindowStartupLocation.CenterOwner;
if (frm.ShowDialog().GetValueOrDefault(false)) {
_options = new BVPImportOptions { Filename = frm.Filename, RowSource = frm.RowSource };
if (context.FieldMappings == null || context.FieldMappings.Count() == 0) {
PreloadMappings(context);
}
return true;
}
return false;
}
private void PreloadMappings(ImportWizardContext context)
{
var service = new ImportService(PluginManager.Instance.User);
var fields = service.GetImportFields();
var mappings = new List<ImportFieldMapping>();
if (_options != null && _options.RowSource != null) {
_options.RowSource.Reset();
var columns = _options.RowSource.ColumnNames;
foreach (String colName in columns) {
var candidate = fields.Find((field) => {
if (!string.IsNullOrEmpty(colName)) {
// First try a simple match of the name...
if (field.DisplayName.Equals(colName, StringComparison.CurrentCultureIgnoreCase)) {
return true;
};
// Next convert all underscores to spaces and try that....
var test = colName.Replace("_", " ");
if (field.DisplayName.Equals(test, StringComparison.CurrentCultureIgnoreCase)) {
return true;
}
}
return false;
});
var mapping = new ImportFieldMapping { SourceColumn = colName, TargetColumn = "Material.Other", DefaultValue = null, IsFixed = false };
if (candidate != null) {
mapping.TargetColumn = string.Format("{0}.{1}", candidate.Category, candidate.DisplayName);
} else {
DarwinCoreField dwc;
if (Enum.TryParse<DarwinCoreField>(colName, out dwc)) {
switch (dwc) {
case DarwinCoreField.fieldNotes:
case DarwinCoreField.validatorNotes:
case DarwinCoreField.transcriberNotes:
mapping.TargetColumn = "Material.Notes";
break;
case DarwinCoreField.associatedMedia:
mapping.TargetColumn = "Material.Multimedia";
break;
}
}
}
mappings.Add(mapping);
}
}
context.FieldMappings = mappings;
}
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context)
{
var filename = PromptForFilename("*.sqlite", "Error databases (*.sqlite)|*.sqlite");
if (!string.IsNullOrEmpty(filename)) {
_options = new ErrorDatabaseImporterOptions { Filename = filename };
var frm = new ErrorDatabaseImportOptionsWindow(_options, context);
frm.Owner = parentWindow;
frm.WindowStartupLocation = WindowStartupLocation.CenterOwner;
return frm.ShowDialog().ValueOrFalse();
}
return false;
}
public abstract bool GetOptions(Window parentWindow, ImportWizardContext context);
