public DialogResult ShowDialog2(
UserObject uo,
UserDataImportParms importParms,
string title,
string filter,
string ext,
bool setForm)
{
if (setForm)
{
FileName.Text = importParms.FileName;
HeaderLine.Checked = importParms.FirstLineHeaders;
HeaderLine.Enabled = Lex.Ne(ext, ".sdf");
DeleteExistingData.Checked = importParms.DeleteExisting;
ImportInBackground.Checked = importParms.ImportInBackground;
CheckForFileUpdates.Checked = importParms.CheckForFileUpdates;
Text = title;
FileFilter = filter;
DefaultExt = ext;
}
GetInput:
DialogResult dr = ShowDialog(SessionManager.ActiveForm);
if (dr == DialogResult.Cancel)
{
return(dr);
}
importParms.FileName = FileName.Text;
importParms.ClientFileModified = FileUtil.GetFileLastWriteTime(importParms.FileName);
importParms.FirstLineHeaders = HeaderLine.Checked;
importParms.DeleteExisting = DeleteExistingData.Checked;
if (importParms.DeleteExisting && uo.Id > 0)
{
dr = MessageBoxMx.Show(
"Are you sure you want to delete all existing data?", UmlautMobius.String,
MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (dr != DialogResult.Yes)
{
goto GetInput;
}
}
importParms.ImportInBackground = ImportInBackground.Checked;
importParms.CheckForFileUpdates = CheckForFileUpdates.Checked;
DialogResult = DialogResult.OK;
return(dr);
}
/// <summary>
/// Basic file import dialog (.sdf, .xls)
/// </summary>
/// <param name="importParms"></param>
/// <param name="title"></param>
/// <param name="filter"></param>
/// <param name="ext"></param>
/// <param name="setForm"></param>
/// <returns></returns>
public new static DialogResult ShowDialog(
UserObject uo,
UserDataImportParms importParms,
string title,
string filter,
string ext,
bool setForm)
{
if (Instance == null)
{
Instance = new UserDataImportFile();
}
return(Instance.ShowDialog2(uo, importParms, title, filter, ext, setForm));
}
public DialogResult ShowDialog2(MetaTable cMt, UserObject uo, bool userDatabase)
{
MetaColumn mc;
bool headerLineChecked;
QualifiedNumber qn;
string tok;
UserDataImportParms importParms = cMt.ImportParms;
if (importParms == null)
{
importParms = new UserDataImportParms();
cMt.ImportParms = importParms;
}
else // setup for existing
{
FileName.Text = importParms.FileName;
HeaderLine.Checked = importParms.FirstLineHeaders;
DeleteExistingData.Checked = importParms.DeleteExisting;
ImportInBackground.Checked = importParms.ImportInBackground;
CheckForFileUpdates.Checked = importParms.CheckForFileUpdates;
TabDelim.Checked = (importParms.Delim == '\t');
CommaDelim.Checked = (importParms.Delim == ',');
SemiDelim.Checked = (importParms.Delim == ';');
SpaceDelim.Checked = (importParms.Delim == ' ');
}
if (userDatabase) // setup for db import
{
Text = "Import Database from File";
FileFilter =
"Smiles, CSV (Comma delimited) (*.smi; *.csv)|*.smi; *.csv|All files (*.*)|*.*";
DefaultExt = "smi";
}
else // setup for anotation import
{
Text = "Import annotation table data from a text file";
FileFilter =
"CSV (Comma delimited)(*.csv)|*.csv|Text(*.txt)|*.txt|All files (*.*)|*.*";
DefaultExt = "csv";
}
GetInput:
DialogResult dr = ShowDialog(SessionManager.ActiveForm);
if (dr == DialogResult.Cancel)
{
return(dr);
}
importParms.FileName = FileName.Text;
importParms.ClientFileModified = FileUtil.GetFileLastWriteTime(importParms.FileName);
if (CommaDelim.Checked)
{
importParms.Delim = ',';
}
else if (TabDelim.Checked)
{
importParms.Delim = '\t';
}
else if (SemiDelim.Checked)
{
importParms.Delim = ';';
}
else if (SpaceDelim.Checked)
{
importParms.Delim = ' ';
}
importParms.MultDelimsAsSingle = MultDelimsAsSingle.Checked;
tok = TextQualifier.Text;
if (tok == "\"")
{
importParms.TextQualifier = '\"';
}
else if (tok == "\'")
{
importParms.TextQualifier = '\'';
}
importParms.FirstLineHeaders = HeaderLine.Checked;
UserObjectDao.SetUserParameter( // save setting for next time
SS.I.UserName, "AnnotationHeaderLineChecked", importParms.FirstLineHeaders.ToString());
importParms.DeleteExisting = DeleteExistingData.Checked;
importParms.DeleteDataOnly = false;
if (importParms.DeleteExisting && uo.Id > 0)
{
string userDataTypeLabel = userDatabase ? "database" : "annotation table";
int dri = MessageBoxMx.ShowWithCustomButtons(
"Are you sure you want to delete any existing data for this " + userDataTypeLabel + "?", UmlautMobius.String,
"Yes", "Keep Cols.", "No", null, MessageBoxIcon.Question);
if (dri == 1)
{
} // yes
else if (dri == 2)
{
importParms.DeleteDataOnly = true;
}
else
{
goto GetInput;
}
}
importParms.ImportInBackground = ImportInBackground.Checked;
importParms.CheckForFileUpdates = CheckForFileUpdates.Checked;
DialogResult = DialogResult.OK;
return(DialogResult);
}
