using System;
using System.Collections.Generic;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

using Emgu.CV.UI;
using Emgu.CV;
using Emgu.CV.Structure;
using Emgu.CV.CvEnum;

namespace Face_Recognition
{
    public class User
    {
        //database stuff
        private const String SERVER = "212.237.20.10";
        private const String DATABASE = "inzynierka";
        private const String UID = "patryk";
        private const String PASSWORD = "haslo12345";
        private static MySqlConnection dbConn;

        private static String m;
        private static int lastID;
        // User class stuff
        public int Id { get; private set; }
        public String Name { get; private set; }
        public String Surname { get; private set; }
        public String Sciezka { get; private set; }
        public String Rfid { get; private set; }
        private User(int id, String u, String p, String r, String rfid)
        {
            Id = id;
            Name = u;
            Surname = p;
            Sciezka = r;
            Rfid = rfid;
        }

        public static void InitializeDB()
        {
            MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
            builder.Server = SERVER;
            builder.UserID = UID;
            builder.Password = PASSWORD;
            builder.Database = DATABASE;

            String connString = builder.ToString();

            builder = null;

            Console.WriteLine(connString);

            dbConn = new MySqlConnection(connString);

            Application.ApplicationExit += (sender, args) => {
                if (dbConn != null)
                {
                    dbConn.Dispose();
                    dbConn = null;
                }
            };
        }

        public static List<User> GetUsers()
        {
            List<User> users = new List<User>();

            String query = "SELECT * FROM dostep";

            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            try
            {
                dbConn.Open();
            }
            catch { }


            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                int id = (int)reader["id"];
                String username = reader["imie"].ToString();
                String password = reader["nazwisko"].ToString();
                String sciezka = "";
                String Rfid = "";
                try
                {
                    sciezka = reader["sciezka"].ToString();
                    Rfid = reader["rfidnumber"].ToString();
                    for (int i = 1; i <= 10; i++)
                    {
                        Image<Gray, Byte> faceGrayPic = null;
                        String str = sciezka + '/' + i.ToString() + ".jpg";
                  /*1*/      Image<Gray, Byte> img = new Image<Gray, Byte>(str);
                  /*2*/      faceGrayPic = img
                                      .Convert<Gray, Byte>()
                                      .Resize(76, 64, Emgu.CV.CvEnum.INTER.CV_INTER_CUBIC);
                  /*3*/      Form1.trainingImages.Add(faceGrayPic);
                  /*4*/      Form1.Names_List_ID.Add(id);
                    }
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }



                User u = new User(id, username, password, sciezka, Rfid);
                users.Add(u);
            }

            reader.Close();
            dbConn.Close();
            return users;
        }
        public static int LastID()
        {
            String query = string.Format("SELECT MAX(id) FROM dostep LIMIT 1");
            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            try
            {
                dbConn.Open();
            }catch { }

            int lastId = (int)cmd.LastInsertedId;
            dbConn.Close();
            return lastId;

        }
        public static String returnName(int idik)
        {
            String name = "";
            String query = string.Format("SELECT imie FROM dostep WHERE id LIKE '{0}'", idik);
            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            dbConn.Open();
            MySqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                name = reader["imie"].ToString();
            }
            dbConn.Close();
            return name;
        }
        public static String returnSurname(int idik)
        {
            String name = "";
            String query = string.Format("SELECT nazwisko FROM dostep WHERE id LIKE '{0}'", idik);
            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            dbConn.Open();
            MySqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                name = reader["nazwisko"].ToString();
            }
            dbConn.Close();
            return name;
        }
        public static String checkNumber(int idik)
        {
            String rfid = "";
            String query = string.Format("SELECT rfidnumber FROM dostep WHERE id LIKE '{0}'", idik);
            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            dbConn.Open();
            MySqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                rfid = reader["rfidnumber"].ToString();
            }
            dbConn.Close();
            return rfid;
        }
        public static String checkIDofRFID(String rfidd)///////////////////////nie dziala
        {
            String ide = "";
            String query = string.Format("SELECT id FROM dostep WHERE rfidnumber LIKE '0%'", rfidd);
            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            dbConn.Open();
            MySqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                rfidd = reader["id"].ToString();
            }
            dbConn.Close();
            return ide;
        }

        public static User Insert(String d, String u, String p, String r, String rfid)
        {

            String query = string.Format("INSERT INTO dostep(id, imie, nazwisko, sciezka, rfidnumber) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')", d, u, p, r, rfid);

            MySqlCommand cmd = new MySqlCommand(query, dbConn);
            try
            {
                dbConn.Open();
            }catch { }


            cmd.ExecuteNonQuery();
            int id = (int)cmd.LastInsertedId;
            lastID = id;
            String res = "facesdata/u" + id.ToString();

            User user = new User(id, u, p, r, rfid);

            dbConn.Close();

            return user;

        }
        public void Update(string u, string p, string i, string rfid )
        {
            String query = string.Format("UPDATE dostep SET imie='{0}', nazwisko='{1}', sciezka='{2}', rfidnumber='{3}' WHERE ID={4}", u, p, i, rfid, Id);

            MySqlCommand cmd = new MySqlCommand(query, dbConn);

            dbConn.Open();

            cmd.ExecuteNonQuery();

            dbConn.Close();
        }

        public void Delete()
        {
            String query = string.Format("DELETE FROM dostep WHERE ID={0}", Id);

            MySqlCommand cmd = new MySqlCommand(query, dbConn);

            dbConn.Open();

            cmd.ExecuteNonQuery();

            dbConn.Close();
        }
        public static int getMaxId()
        {
            int lastId = 0;
            String query = string.Format("SELECT MAX(id) FROM dostep LIMIT 1");
            MySqlCommand cmd = new MySqlCommand(query, dbConn);


            try
            {
                dbConn.Open();
                lastId = Convert.ToInt32(cmd.ExecuteScalar());
                dbConn.Close();

            }
            catch
            {

            }

            return lastId;
        }
    }
}