/*
 * Created by SharpDevelop.
 * User: Soma
 * Date: 2018.07.05.
 * Time: 21:14
 *
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */
using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;
using System.Threading;
using System.ComponentModel;

namespace nyakvago_csharpclient
{
    /// <summary>
    /// Description of beerkezoForm.
    /// </summary>
    public partial class beerkezoForm : Form
    {
        int tickcnt=0;
        System.Windows.Forms.Timer time = new System.Windows.Forms.Timer();
        public beerkezoForm()
        {
            //
            // The InitializeComponent() call is required for Windows Forms designer support.
            //
            InitializeComponent();
            time.Start();
            time.Tick += new EventHandler(timeTick);

            //
            // TODO: Add constructor code after the InitializeComponent() call.
            //

        }
        void timeTick(object sender, EventArgs e)
        {
            //MessageBox.Show("yay");
            if(tickcnt==10){
            //MessageBox.Show("A  felépült");
            string connectionString = "SERVER=192.168.0.112;DATABASE=nyakvago;UID=nyakvago;PASSWORD=Furmint123;SslMode=none";
            string sql = "SELECT v.nev AS nev, b.rfiddata, CONCAT(v.tav,' Km') AS tav, v.rajtszam AS rajtszam,b.beerkezes as beerkezes FROM beerkezes b INNER JOIN versenyzo v on b.rfiddata = v.rfiddata WHERE b.beerkezes<>'00:00:00' ORDER BY beerkezes desc";
            MySqlConnection connection = new MySqlConnection(connectionString);
            try{
                connection.OpenAsync();
            //  MessageBox.Show("A kapcsolat felépült");
            MySqlCommand sCommand = new MySqlCommand(sql, connection);
             // cmd.CommandText = query;
            MySqlDataAdapter sAdapter = new MySqlDataAdapter(sCommand);
            MySqlCommandBuilder sBuilder = new MySqlCommandBuilder(sAdapter);
            DataSet sDs = new DataSet();
            sAdapter.FillAsync(sDs, "characters");
            DataTable sTable = sDs.Tables["characters"];
            connection.Close();
            dataGridView1.DataSource = sDs.Tables["characters"];
            dataGridView1.ReadOnly = true;
            dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            dataGridView1.Columns[0].HeaderText = "Név";
            dataGridView1.Columns[1].HeaderText = "RFIDdata";
            dataGridView1.Columns[2].HeaderText = "Táv";
            dataGridView1.Columns[3].HeaderText = "Rajtszám";
            dataGridView1.Columns[4].HeaderText = "Beérkezési idő";
                        } catch(MySqlException ex)
            {
                MessageBox.Show(ex.ToString());
            }
            MySqlConnection dbConn = new MySqlConnection(connectionString);
            MySqlCommand cmd = dbConn.CreateCommand();
            cmd.CommandText = "SELECT versenyzo.tav as tav, COUNT(*) as fennmarado FROM beerkezes INNER JOIN versenyzo on beerkezes.rfiddata=versenyzo.rfiddata WHERE beerkezes.beerkezes='00:00:00' AND indulas<>'00:00:00' GROUP BY versenyzo.tav ";

            try
            {
                dbConn.OpenAsync();
            } catch (Exception erro) {
                MessageBox.Show("Error" + erro);

            }

            MySqlDataReader reader = cmd.ExecuteReader();


            while (reader.Read())
            {
                //idnumber = reader.ToString();
                string tav=reader["tav"].ToString();
                string fennmarado = reader["fennmarado"].ToString();
                if(tav=="3.5")
                {
                    haromBox.Text=reader["fennmarado"].ToString();
                }
                if(tav=="7")
                {
                    hetBox.Text=reader["fennmarado"].ToString();
                }
                if(tav=="14")
                {
                    tizennegyBox.Text=reader["fennmarado"].ToString();
                }
                if(tav=="22.5")
                {
                    huszonkettoBox.Text=reader["fennmarado"].ToString();
                }
                if(tav=="22.5b")
                {
                    kerekparBox.Text=reader["fennmarado"].ToString();
                }
            }




            tickcnt=0;
            }
            tickcnt++;
        }
        void Button1Click(object sender, EventArgs e)
        {
            if(textBox1.Text!=""){
            // "UPDATE Inventory SET Inventorynumber='"+ num +"',Inventory_Name='"+name+"', Quantity ='"+ quant+"',Location ='"+ location+"' Category ='"+ category+"' WHERE Inventorynumber ='"+ numquery +"';";
             string query = "UPDATE beerkezes INNER JOIN versenyzo ON beerkezes.rfiddata = versenyzo.rfiddata  SET `beerkezes`=CURRENT_TIME() WHERE versenyzo.rajtszam =@rajtszam";
            //string query = "INSERT INTO beerkezes (`indulas`) VALUES (CURRENT_TIME())";
            string connectionString = "SERVER=192.168.0.112;DATABASE=nyakvago;UID=nyakvago;PASSWORD=Furmint123;SslMode=none";
            // string sql = "SELECT v.nev AS nev, b.rfiddata, CONCAT(v.tav,' Km') AS tav, v.rajtszam AS rajtszam,b.indulas as indulas FROM beerkezes b INNER JOIN versenyzo v on b.rfiddata = v.rfiddata WHERE b.beerkezes<>'00:00:00'";
            MySqlConnection connection = new MySqlConnection(connectionString);
                            try{
                connection.Open();
                    MySqlCommand cmd = new MySqlCommand();
                   cmd.CommandText = query;
                    cmd.Parameters.AddWithValue("@rajtszam",textBox1.Text);
                    cmd.Connection = connection;
                    cmd.ExecuteNonQueryAsync();
                    connection.Close();
                    //Bind();
            }
            catch(MySqlException ex)
                {
                MessageBox.Show(ex.ToString());
                }
            }}
        void Formcloser(object sender, FormClosingEventArgs e)
        {
            time.Stop();
            time.Dispose();
        }
    }
}