private void loadServerData() { serverData = new firedumpdbDataSet.mysql_serversDataTable(); mysql_serversAdapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); mysql_serversAdapter.Fill(serverData); cmbServers.DataSource = serverData; cmbServers.DisplayMember = "name"; cmbServers.ValueMember = "id"; if (cmbServers.Items.Count > 0) { cmbServers.SelectedIndex = 0; } }
private void loadComboBoxServers() { serverData = new firedumpdbDataSet.mysql_serversDataTable(); mysql_serversAdapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); mysql_serversAdapter.Fill(serverData); cmbServers.DataSource = serverData; cmbServers.DisplayMember = "name"; cmbServers.ValueMember = "id"; if (cmbServers.Items.Count > 0) { cmbServers.SelectedIndex = 0; //backgroundWorker1.RunWorkerAsync(); fillDatabaseCmb(null, null); } }
internal void Start() { List <string> tables = utils.StringUtils.extractTableListFromString(schedulesRow.tables); string database = schedulesRow.database; firedumpdbDataSetTableAdapters.mysql_serversTableAdapter serveradapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); firedumpdbDataSet.mysql_serversDataTable servertable = new firedumpdbDataSet.mysql_serversDataTable(); serveradapter.FillById(servertable, schedulesRow.server_id); if (servertable?.Count > 0) { //File.AppendAllText(@"servicelog.txt", "COUNT:"+servertable.Count+","); server = servertable[0]; } else { //File.AppendAllText(@"servicelog.txt", "COUNT:" + "EMPTY" + ","); return; } DumpCredentialsConfig dumpConfig = new DumpCredentialsConfig(); dumpConfig.database = database; dumpConfig.username = server.username; dumpConfig.password = server.password; dumpConfig.host = server.host; dumpConfig.port = (int)server.port; if (tables.Count > 0) { dumpConfig.excludeTables = tables.ToArray(); } mysqldumpAdapter = new MySqlDumpAdapter(); mysqldumpAdapter.Cancelled += OnCancelled; mysqldumpAdapter.Completed += OnCompleted; mysqldumpAdapter.CompressProgress += oncompressprogress; mysqldumpAdapter.CompressStart += oncompstart; mysqldumpAdapter.Error += onerror; mysqldumpAdapter.InitDumpTables += oninitdumptables; mysqldumpAdapter.Progress += onprogress; mysqldumpAdapter.TableRowCount += ontablerowcount; mysqldumpAdapter.TableStartDump += ontablestartdump; //File.AppendAllText(@"servicelog.txt", "STARTDUMP"); mysqldumpAdapter.startDump(dumpConfig); }
private void bSave_Click(object sender, EventArgs e) { firedumpdbDataSetTableAdapters.mysql_serversTableAdapter adapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); if (string.IsNullOrEmpty(tbName.Text)) { MessageBox.Show("Type a name for the new server", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if ((Int64)adapter.numberOfOccurances(tbName.Text) == 0 || isUpdate) { if (!performChecks()) { return; } if (isUpdate) { adapter.UpdateMySqlServerById(tbName.Text, con.port, con.Host, con.username, con.password, tbDatabase.Text, mysqlserver.id); } else { adapter.Insert(tbName.Text, con.port, con.Host, con.username, tbPassword.Text, tbDatabase.Text); //prepei na bei kai database } int id = Convert.ToInt32((Int64)adapter.GetIdByName(tbName.Text)); onReloadServerData(id); this.Close(); return; } MessageBox.Show("Name " + tbName.Text + " already exists", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Warning); tbUsername.Text = ""; tbPassword.Text = ""; tbHost.Text = ""; tbName.Text = ""; tbDatabase.Text = ""; isUpdate = false; }