using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        MySqlConnection connection;

        public Form1()
        {
            InitializeComponent();
            ConnectToDatabase();
        }

        private void ConnectToDatabase()
        {
            try
            {
                MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder();
                conn_string.Server = "127.0.0.1";
                conn_string.UserID = "root";
                conn_string.Port = 3307;
                conn_string.Password = "";
                conn_string.Database = "test";

                connection = new MySqlConnection(conn_string.ToString());
                connection.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Hiba:" + ex.Message);
            }
        }

        private void loginButton_Click(object sender, EventArgs e)
        {
            try
            {
                MySqlCommand cmd = connection.CreateCommand();
                cmd.CommandText = "SELECT * FROM users where user='" + userText.Text + "' AND pw='" + passText.Text + "'";
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        MessageBox.Show("Sikeres belépés");
                    }
                    else
                    {
                        MessageBox.Show("Hibás belépési adatok");
                    }
                }


            }
            catch (Exception ex)
            {
                MessageBox.Show("Hiba:" + ex.Message);
            }

        }
    }
}