using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Diagnostics;
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 Dormonto
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    ///
    public partial class MainWindow : Window
    {
        private string conn;
        private MySqlConnection connect;

        public string userId { get; set; }

        public MainWindow()
        {
            InitializeComponent();

            cnvRegister.Visibility = Visibility.Hidden;
            lblAccountRegisterSuccess.Visibility = Visibility.Hidden;
            lblLoginSuccess.Visibility = Visibility.Hidden;
            lblLoginFailed.Visibility = Visibility.Hidden;
            lblServerMessedUp.Visibility = Visibility.Hidden;
        }

        private void MainWindow_Loaded(object sender, RoutedEventArgs e)
        {
            Application.Current.MainWindow = this;
        }

        private void db_connection()
        {
            try
            {
                conn = "server=localhost:3306;uid=dormonto;" + "pwd=12donedone;database=dormont_users;";
                connect = new MySqlConnection(conn);
                connect.Open();
            }
            catch (MySqlException e)
            {
                MessageBox.Show(e.Message);
            }
        }

        public bool validateLogin (string user, string pass)
        {
            db_connection();
            string sql = "SELECT * FROM Dormonto WHERE Username=@user and _Password=@pass";
            MySqlCommand cmd = new MySqlCommand(sql, connect);
            cmd.Parameters.Add("@user", user);
            cmd.Parameters.Add("@pass", pass);
            MySqlDataReader login = cmd.ExecuteReader();

            lblServerSucess.Visibility = Visibility.Hidden;
            // MySqlCommand cmd = new MySqlCommand($"SELECT * FROM Dormonto WHERE Username='{user}' AND _Password='{pass}'", connect);
            // MySqlDataReader login = cmd.ExecuteReader();
            try
            {
                if (login.Read())
                {
                    // LOGIN INFO CORRECT
                    lblServerSucess.Visibility = Visibility.Hidden;
                    lblLoginSuccess.Visibility = Visibility.Visible;

                    userId = login["UserID"].ToString();
                    connect.Close();
                    return true;
                }
                else
                {
                    connect.Close();
                    return false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                lblServerMessedUp.Visibility = Visibility.Visible;
                return false;
            }
        }

        private void btnLogin_Click(object sender, RoutedEventArgs e)
        {
            lblServerMessedUp.Visibility = Visibility.Hidden;
            lblAccountRegisterSuccess.Visibility = Visibility.Hidden;

            // run command to make sure the login info matches one in the database
            string usernameUsed = tbUsername.Text;
            string passwordUsed = passwordBox.Password;
            validateLogin(usernameUsed, passwordUsed);

            if (validateLogin(usernameUsed, passwordUsed))
            {
                // close current window and open client
                Intro window1 = new Intro(userId);
                window1.Show();
                this.Close();
            }
            else
            {
                // LOGIN FAILED
                lblLoginFailed.Visibility = Visibility.Visible;
                Console.WriteLine("Incorrect login information entered.");
            }
        }

        private void button_Click(object sender, RoutedEventArgs e)
        {
            cnvRegister.Visibility = Visibility.Visible;
        }

        private void btnRegister_Click(object sender, RoutedEventArgs e)
        {
            db_connection();
            lblServerSucess.Visibility = Visibility.Hidden;
            if ((tbRegisterUsername.Text.Length > 6) && (tbRegisterEmail.Text.Length > 7))
            {
                try
                {
                    // save user values to strings so we can add them to our server
                    string registerUsername = tbRegisterUsername.Text;
                    string registerPassword = pbRegisterPassword.Password;
                    string registerEmail = tbRegisterEmail.Text;

                    // remember username, password, and email
                    MySqlCommand addUser = connect.CreateCommand();
                    addUser.CommandText = $"INSERT INTO Users (Username, Password, Email) VALUES ('"+registerUsername+"','"+registerPassword+"','"+registerEmail+"')";
                    addUser.ExecuteNonQuery();
                    lblAccountRegisterSuccess.Visibility = Visibility.Visible;
                    cnvRegister.Visibility = Visibility.Hidden;

                    // add user with the same ID to table ranks
                    MySqlCommand addUser2 = connect.CreateCommand();
                    addUser2.CommandText = $"INSERT INTO ranks (Username) VALUES ('"+registerUsername+"')";
                    addUser2.ExecuteNonQuery();

                    // add used with the same ID to table stats
                    MySqlCommand addUser3 = connect.CreateCommand();
                    addUser3.CommandText = $"INSERT INTO stats (Username) VALUES ('"+registerUsername+"')";
                    addUser3.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    connect.Close();
                }
            }
        }
    }
}