using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using MySql.Data.MySqlClient;

namespace Baza_Danych_UI
{
    /// <summary>
    /// Logika interakcji dla klasy MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {

            InitializeComponent();
        }

        private void login_btn_Click(object sender, RoutedEventArgs e)
        {
            string connectionstring;
            string serveraddress;
            string user;
            string sql_pass;
            string db_name = database_sql.Text.ToString();
            string sslmode;

            if (ip_or_localhost.IsChecked == true)
            {
                serveraddress = "localhost";
            }
            else
            {
                serveraddress = mysql_ip.Text.ToString();
            }

            if(root_sel.IsChecked == true)
            {
                user = "root";
            }
            else
            {
                user = user_sql.Text.ToString();
            }


            if (pass_disable_check.IsChecked == true)
            {
               sql_pass = "" ;
            }
            else
            {
                sql_pass = userpass_sql.Password.ToString();

            }

            if(ssl_check.IsChecked == true)
            {
                sslmode = "Required";
            }
            else
            {
                sslmode = "none";
            }

            connectionstring = "Server=" + serveraddress + ";Database=" + db_name + ";Uid=" + user + ";Pwd=" + sql_pass + ";SslMode=" + sslmode;

            MySqlConnection connection = new MySqlConnection(connectionstring);

            try
            {
                connection.Open();
                MessageBox.Show(connection.ServerVersion, "Połączono", MessageBoxButton.OK);

            }
            catch (Exception ex )
            {
                MessageBox.Show("Informacje o błędzie: " + ex, "Wystąpił Błąd", MessageBoxButton.OK);
            }
        }

        private void root_sel_Checked(object sender, RoutedEventArgs e)
        {
            user_sql.IsEnabled = false;
        }

        private void other_user_sel_Checked(object sender, RoutedEventArgs e)
        {
            user_sql.IsEnabled = true;
        }

        private void pass_disable_check_Checked(object sender, RoutedEventArgs e)
        {
            userpass_sql.IsEnabled = false;
        }
        private void pass_disable_check_UnChecked(object sender, RoutedEventArgs e)
        {
            userpass_sql.IsEnabled = true;
        }

        private void ip_or_localhost_Checked(object sender, RoutedEventArgs e)
        {
            mysql_ip.IsEnabled = false;
        }

        private void ip_or_localhost_UnChecked(object sender, RoutedEventArgs e)
        {
            mysql_ip.IsEnabled = true;
        }
    }
}