private void btnImport_Click(object sender, EventArgs e) { this.btnOK.Enabled = false; this.btnCancel.Enabled = false; if (StaticWindows.Requester( "Wollen Sie wirklich Ihre Microsoft SQL Server Datenbank in die SQLite Datenbank migrieren?" ) == System.Windows.Forms.DialogResult.Yes) { this.lblState.Text = "Migration gestartet, lade Daten..."; this.btnCancel.Enabled = true; this._importer = new SQLServerToSQLiteImporter(); this._importer.PercentState += new ImportPercentEventHandler(_importer_PercentState); if (this._importer.Import()) { StaticWindows.InfoBox("Erfolgreich migriert!"); } else { StaticWindows.ErrorBox("Während der Migration ist ein Fehler aufgetreten!"); } } else { this.lblState.Text = "Migration abgebrochen!"; this.btnOK.Enabled = true; this.btnCancel.Enabled = true; } }
/// <summary> /// Handles the Click event of the btnOK control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> private void btnOK_Click(object sender, EventArgs e) { this.pbState.Value = 0; this.lblState.Text = ""; this.lblState.Text = "Starte Export..."; this.lblState.Refresh(); this.lblState.Update(); string filename = "Movies_" + DateTime.Now.ToFileNameString() + ".xls"; string targetPath = Configuration.CommonApplicationTempPath; string sheetTitle = "Filmliste vom " + DateTime.Now.ToShortDateString(); if (!this.txtFilename.Text.IsNullOrTrimmedEmpty()) { if (!PathExtensions.GetFullExtension(this.txtFilename.Text).ToLower().Contains(".xls") && !PathExtensions.GetFullExtension(this.txtFilename.Text).ToLower().Contains(".xlsx") && !PathExtensions.GetFullExtension(this.txtFilename.Text).ToLower().Contains(".ods")) { this.txtFilename.Text = this.txtFilename.Text + ".xls"; } filename = this.txtFilename.Text; } if (!this.txtTargetPath.Text.IsNullOrTrimmedEmpty()) { bool thisTarget = false; if (!Directory.Exists(this.txtTargetPath.Text)) { if (StaticWindows.Requester( "Das angegebene Verzeichnis existiert nicht, wollen sie es nun anlegen?" ) == DialogResult.Yes) { try { Directory.CreateDirectory(this.txtTargetPath.Text); thisTarget = true; } catch (Exception ex) { Exception ex2 = new Exception("Verzeichnis konnte nicht erstellt werden!", ex); StaticWindows.DisplayErrorMessagebox(ex2); } } } if (thisTarget) { targetPath = this.txtTargetPath.Text; } } if (!this.txtSheettitle.Text.IsNullOrTrimmedEmpty()) { sheetTitle = this.txtSheettitle.Text; } this.btnOK.Enabled = false; this.btnCancel.Enabled = false; this.txtFilename.Enabled = false; this.txtTargetPath.Enabled = false; this.txtSheettitle.Enabled = false; this.cbExport.Enabled = false; this.groupBox1.Refresh(); this.groupBox1.Update(); foreach (CheckBox chk in this.colsPanel.Controls) { chk.Enabled = false; } this.groupBox2.Refresh(); this.groupBox2.Update(); this._Export(filename, targetPath, sheetTitle); }