private void buttonImportRemote_Click(object sender, EventArgs e) { if (textBoxImportPathRemote.Text != "") { //save settings Properties.Settings.Default.ServerIP = textBoxServerIP.Text; Properties.Settings.Default.Username = textBoxUsername.Text; Properties.Settings.Default.Password = textBoxPassword.Text; Properties.Settings.Default.ImportPathRemote = textBoxImportPathRemote.Text; Properties.Settings.Default.DatabaseName = textBoxDatabaseName.Text; Properties.Settings.Default.Save(); //read files List <XbmcFile> files = XMLConnector.ReadFiles(textBoxImportPathRemote.Text); if (files != null) { disableButtons(); //run import in different thread XbmcMySqlConnector sql = new XbmcMySqlConnector(textBoxServerIP.Text, textBoxUsername.Text, textBoxPassword.Text, files); toolStripProgressBar1.Style = ProgressBarStyle.Marquee; //turn on the progress bar backgroundWorkerImportRemote.RunWorkerAsync(sql); } } else { MessageBox.Show("Please select a file."); } }
private void backgroundWorkerImportRemote_DoWork(object sender, DoWorkEventArgs e) { //cast the connector then execute import command XbmcMySqlConnector sql = (XbmcMySqlConnector)e.Argument; e.Result = sql.ImportWatchedFlags().ToString(); //MessageBox.Show("Import complete. " + sql.ImportWatchedFlags().ToString() + " rows updated."); }
private void backgroundWorkerExportRemote_DoWork(object sender, DoWorkEventArgs e) { //cast the connector then execute export command XbmcMySqlConnector sql = (XbmcMySqlConnector)e.Argument; List <XbmcFile> files = sql.ExportWatchedFlags(); files.Sort(); XMLConnector.WriteFiles(textBoxExportPathRemote.Text, files); e.Result = files.Count; //MessageBox.Show("Export complete. " + files.Count + " files found."); }