/// <summary>
/// btnCheckFile_Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCheckFile_Click(object sender, EventArgs e)
{
if(this.txtFilename.Text != null
&& this.txtFilename.Text.Trim() != ""
&& this.txtSheet.Text != null
&& this.txtSheet.Text.Trim() != "") {
DataSet data;
switch(this.cbImport.SelectedIndex) {
case 0:
if(File.Exists(this.txtFilename.Text.Trim())) {
try {
this._importer = (IImporter)new OpenDocumentImporter(
Configuration.ConnectionString,
this.txtFilename.Text.Trim()
);
if(this._importer.LoadFile()) {
this.btnImport.Enabled = true;
this._fileCanImported = true;
this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState);
data = this._importer.GetPreview();
DataSetPreviewForm dspf = new DataSetPreviewForm(data);
if(dspf.ShowDialog(this) == DialogResult.OK) {
this._allocation = dspf.ColumnAllocation;
}
}
else {
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
catch(FileNotFoundException fileex) {
ErrorHandler.DisplayErrorMessagebox(fileex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch(ArgumentNullException nullex) {
ErrorHandler.DisplayErrorMessagebox(nullex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch(Exception ex) {
ErrorHandler.DisplayErrorMessagebox(ex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
break;
case 1:
if(File.Exists(this.txtFilename.Text.Trim())) {
try {
this._importer = (IImporter)new Excel2003Importer(
this.txtFilename.Text.Trim(),
this.txtSheet.Text.Trim()
);
if(this._importer.LoadFile()) {
this.btnImport.Enabled = true;
this._fileCanImported = true;
this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState);
data = this._importer.GetPreview();
}
else {
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
catch(FileNotFoundException fileex) {
ErrorHandler.DisplayErrorMessagebox(fileex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch(ArgumentNullException nullex) {
ErrorHandler.DisplayErrorMessagebox(nullex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch(Exception ex) {
ErrorHandler.DisplayErrorMessagebox(ex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
break;
default:
if(File.Exists(this.txtFilename.Text.Trim())) {
try {
this._importer = (IImporter)new OpenDocumentImporter(
Configuration.ConnectionString,
this.txtFilename.Text.Trim()
);
if(this._importer.LoadFile()) {
this.btnImport.Enabled = true;
this._fileCanImported = true;
this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState);
// Hier Fenster mit Datenvorschau
}
else {
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
catch(FileNotFoundException fileex) {
ErrorHandler.DisplayErrorMessagebox(fileex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch(ArgumentNullException nullex) {
ErrorHandler.DisplayErrorMessagebox(nullex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch(Exception ex) {
ErrorHandler.DisplayErrorMessagebox(ex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
break;
}
}
}
/// <summary>
/// btnCheckFile_Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCheckFile_Click(object sender, EventArgs e)
{
if (this.txtFilename.Text != null &&
this.txtFilename.Text.Trim() != "" &&
this.txtSheet.Text != null &&
this.txtSheet.Text.Trim() != "")
{
DataSet data;
switch (this.cbImport.SelectedIndex)
{
case 0:
if (File.Exists(this.txtFilename.Text.Trim()))
{
try {
this._importer = (IImporter) new OpenDocumentImporter(
Configuration.ConnectionString,
this.txtFilename.Text.Trim()
);
if (this._importer.LoadFile())
{
this.btnImport.Enabled = true;
this._fileCanImported = true;
this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState);
data = this._importer.GetPreview();
DataSetPreviewForm dspf = new DataSetPreviewForm(data);
if (dspf.ShowDialog(this) == DialogResult.OK)
{
this._allocation = dspf.ColumnAllocation;
}
}
else
{
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
catch (FileNotFoundException fileex) {
ErrorHandler.DisplayErrorMessagebox(fileex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch (ArgumentNullException nullex) {
ErrorHandler.DisplayErrorMessagebox(nullex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch (Exception ex) {
ErrorHandler.DisplayErrorMessagebox(ex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
break;
case 1:
if (File.Exists(this.txtFilename.Text.Trim()))
{
try {
this._importer = (IImporter) new Excel2003Importer(
this.txtFilename.Text.Trim(),
this.txtSheet.Text.Trim()
);
if (this._importer.LoadFile())
{
this.btnImport.Enabled = true;
this._fileCanImported = true;
this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState);
data = this._importer.GetPreview();
}
else
{
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
catch (FileNotFoundException fileex) {
ErrorHandler.DisplayErrorMessagebox(fileex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch (ArgumentNullException nullex) {
ErrorHandler.DisplayErrorMessagebox(nullex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch (Exception ex) {
ErrorHandler.DisplayErrorMessagebox(ex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
break;
default:
if (File.Exists(this.txtFilename.Text.Trim()))
{
try {
this._importer = (IImporter) new OpenDocumentImporter(
Configuration.ConnectionString,
this.txtFilename.Text.Trim()
);
if (this._importer.LoadFile())
{
this.btnImport.Enabled = true;
this._fileCanImported = true;
this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState);
// Hier Fenster mit Datenvorschau
}
else
{
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
catch (FileNotFoundException fileex) {
ErrorHandler.DisplayErrorMessagebox(fileex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch (ArgumentNullException nullex) {
ErrorHandler.DisplayErrorMessagebox(nullex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
catch (Exception ex) {
ErrorHandler.DisplayErrorMessagebox(ex);
this.btnImport.Enabled = false;
this._fileCanImported = false;
}
}
break;
}
}
}