private void btnAdd_Click(object sender, EventArgs e) { int num = cMySQL.configStructure.FindIndex((cDatabaseConfig p) => p.Name.Equals(tbName.Text)); if (num == -1) { int.TryParse(tbPort.Text, out int port); cDatabaseConfig dbc = new cDatabaseConfig { Name = tbName.Text, Note = tbNote.Text, Host = tbIP.Text, Port = port, Username = tbUsername.Text, Password = tbPassword.Text, Database = tbDatabase.Text }; cMySQL.configStructure.Add(dbc); MakeList(); } else { MessageBox.Show("A config with this name already exists"); } }
public static bool TestConnection(string sDescription) { cDatabaseConfig data = configStructure.Find(p => p.Note.Equals(sDescription)); if (data != null) { return(TestConnection(data)); } return(false); }
public static bool SetConnection(string strName) { cDatabaseConfig cConfig = configStructure.Find(p => p.Name.Equals(strName)); if (cConfig == null) { return(false); } strProvider = string.Format("Data Source={0}; Port={1}; Database={2}; User ID={3}; Password={4}; SslMode=none;", cConfig.Host, cConfig.Port, cConfig.Database, cConfig.Username, cConfig.Password); return(true); }