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

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

        // Konekcioni string koji sadrži podatke o konekciji na određenu shemu
        // u našoj mysql bazi
        // server - IP-adresa (localhost) gdje je instaliran mysql
        // port 3306 - standarni port za mysql
        // Database - shema na koju se konektujemo u mysql bazi
        // Uid - username za konekciju na bazu
        // Pwd - password za konekciju na bazu
        String konekcioniString = "Server=localhost;Database=hr;User=root;Password='';";
        public static string employeeID;



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





            String query = "SELECT password,CONCAT(first_name, ' ', last_name) , employee_id,login_status" +
                " 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 lozinka = reader[0].ToString();
                    String imePrez = reader[1].ToString();
                    employeeID = reader[2].ToString();
                    string login = reader[3].ToString();

                    if (login=="1") {
                        errorProvider1.SetError(textBox1, "User je vec logovan");
                    }

                    else if (sifra == lozinka)
                    {



                        MessageBox.Show("Uspjesno ste ulogovani " + imePrez + " ID = " + employeeID);
                        PostaviLogin();
                        Form3 fr3 = new Form3();
                        this.Hide();
                        fr3.Show();

                    }
                    else
                    {
                        errorProvider1.SetError(textBox2, "Netacna lozinka");
                    }



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





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




        }






        private void Form1_FormClosed(object sender, FormClosedEventArgs e)
        {
            Application.Exit();

        }
        private void PostaviLogin() {
            string query = "UPDATE employees SET login_status=1 WHERE employee_id='" +employeeID+ "' ";

            try
            {
                MySqlConnection konekcija = new MySqlConnection(konekcioniString);
                konekcija.Open();
                MySqlCommand cmd = new MySqlCommand(query,konekcija);
                cmd.ExecuteNonQuery();

                konekcija.Close();

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



        }


        public void PostaviLogout()
        {
            string query = "UPDATE employees SET login_status=0 WHERE employee_id='" + employeeID + "' ";

            try
            {
                MySqlConnection konekcija = new MySqlConnection(konekcioniString);
                konekcija.Open();
                MySqlCommand cmd = new MySqlCommand(query, konekcija);
                cmd.ExecuteNonQuery();

                konekcija.Close();

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


        }
















    }

}