private void InitDataFormData(object sender, EventArgs e) { mysql_serversAdapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter(); serverData = new firedumpdbDataSet.sql_serversDataTable(); mysql_serversAdapter.Fill(serverData); comboBox1.DataSource = serverData; comboBox1.DisplayMember = "name"; comboBox1.ValueMember = "id"; }
private void loadComboBoxServers() { serverData = new firedumpdbDataSet.sql_serversDataTable(); mysql_serversAdapter = new firedumpdbDataSetTableAdapters.sql_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); } }
private void bSave_Click(object sender, EventArgs e) { firedumpdbDataSetTableAdapters.sql_serversTableAdapter adapter = new firedumpdbDataSetTableAdapters.sql_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; } sqlservers server = createMySqlServerInfoCreds(); String passwd = EncryptionUtils.sEncrypt(server.password); string path = null; DbType type = Firedump.core.sql.Utils._convert(((ToolStripItemDbType)this.comboBoxDbTypes.SelectedItem).db_type); if (Firedump.core.sql.Utils.IsDbEmbedded(type)) { path = textBoxPath.Text; } if (isUpdate) { adapter.UpdateMySqlServerById(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, mysqlserver.id); } else { adapter.InsertQuery(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, (int)type, path); } 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); tbPassword.Text = ""; tbName.Text = ""; isUpdate = false; }
private void bSave_Click(object sender, EventArgs e) { firedumpdbDataSetTableAdapters.sql_serversTableAdapter adapter = new firedumpdbDataSetTableAdapters.sql_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; } sqlservers server = createMySqlServerInfoCreds(); String passwd = EncryptionUtils.sEncrypt(server.password); if (isUpdate) { adapter.UpdateMySqlServerById(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, mysqlserver.id); } else { adapter.InsertQuery(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, 0); //prepei na bei kai } //adapter.Insert(tbName.Text, server.port, server.host, server.username, server.password, 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; }
internal void Start() { List <string> tables = utils.StringUtils.extractTableListFromString(schedulesRow.tables); string database = schedulesRow.database; firedumpdbDataSetTableAdapters.sql_serversTableAdapter serveradapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter(); firedumpdbDataSet.sql_serversDataTable servertable = new firedumpdbDataSet.sql_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(server.host, (int)server.port, server.username, server.password, database); if (tables.Count > 0) { dumpConfig.excludeTables = tables.ToArray(); } mysqldumpAdapter = new SqlDumpAdapter(); 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); }