Ejemplo n.º 1
0
        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");
            }
        }
Ejemplo n.º 2
0
        public static bool TestConnection(string sDescription)
        {
            cDatabaseConfig data = configStructure.Find(p => p.Note.Equals(sDescription));

            if (data != null)
            {
                return(TestConnection(data));
            }

            return(false);
        }
Ejemplo n.º 3
0
        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);
        }