class DatabaseConnection
{
    //properties
    private MySqlConnection _connection;
    public MySqlConnection Connection { get { return _connection; } }
    public AccountLogin AccountCredentials { get; }
    public DatabaseLogin DatabaseCredentials { get; }

    //constructor
    public DatabaseConnection(AccountLogin _AccCred,
                              DatabaseLogin _DBCred)
    {
        AccountCredentials = _AccCred;
        DatabaseCredentials = _DBCred;
    }

    public void Connect()
    {
        if (Connection != null)
        {
            return;
        }

        string[] UserInputs =
        {
            DatabaseCredentials?.DatabaseName,
            DatabaseCredentials?.Server,
            DatabaseCredentials?.Port,
            AccountCredentials?.Password,
            AccountCredentials?.Username
        };
        bool ChkInpts = Validators.NullStringValidator(UserInputs);

        if (ChkInpts)
        {
            string ConnInfo = "server=" + DatabaseCredentials.Server + ";" +
                              "user=" + AccountCredentials.Username + ";" +
                              "database=" + DatabaseCredentials.DatabaseName +
                              "port=" + DatabaseCredentials.Port +
                              "password=" + AccountCredentials.Password;
            _connection = new MySqlConnection(ConnInfo);

            try
            {
                Console.WriteLine("Connecting to " + DatabaseCredentials.DatabaseName + "...");
                _connection.Open();
                Console.WriteLine("Connection to " + DatabaseCredentials.DatabaseName + " successful.");
            }

            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
    }
    public void Close()
    {
        _connection.Close();
    }
}