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;
}