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.MySqlClient;

namespace zad21
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        String konekcioniString = "Server=localhost;Database=hr;User=root;Password='';";

        private void buttonPrijava_Click(object sender, EventArgs e)
        {
            errorProvider1.Clear();
            string user = textBox1.Text;
            string sifra = textBox2.Text;

            String query = "SELECT passwd, CONCAT(first_name, ' ', last_name), employee_id " +
                " FROM employees WHERE username ='" + user + "' ";
            try
            {
                MySqlConnection konekcija = new MySqlConnection(konekcioniString);
                konekcija.Open();

                MySqlCommand cmd = new MySqlCommand(query,konekcija);

                MySqlDataReader reader;
                reader = cmd.ExecuteReader();
                reader.Read();

                if (!reader.HasRows)
                {
                    errorProvider1.SetError(textBox1, "Username ne postoji");

                }
                else
                {
                    String passwd = reader[0].ToString();
                    String imePrezime = reader[1].ToString();
                    String id = reader[2].ToString();

                    if (sifra == passwd) {
                        MessageBox.Show("Uspjesno ste ulogovani " + imePrezime+ " ID = " +id);
                    }
                    else
                        errorProvider1.SetError(textBox2, "Pogresan password");



                }

                reader.Close();
                konekcija.Close();



            }
            catch (Exception ex) {
                MessageBox.Show(ex.Message);
            }





        }
    }
}