package com.a4ci.fastorder;


import android.content.Context;
import android.net.wifi.WifiManager;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ListView;
import android.widget.Toast;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class MenuList extends AppCompatActivity {

    private ArrayList<Prodotto> prodotti = new ArrayList<>();
    private ListView lista;
    private Connection con;
    private Thread t1;


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_menu_list);

        //code
        lista = (ListView) findViewById(R.id.menuLV);
        Bundle bundle = getIntent().getExtras();
        prodotti = (ArrayList<Prodotto>) bundle.getSerializable("prodotti");
        AdapterMenu adapterMenu = new AdapterMenu(getApplicationContext(), prodotti);
        lista.setAdapter(adapterMenu);

        lista.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            public void onItemClick(AdapterView<?> parent, View clickView, int position, long id) {
                scriviCarrello(position);
            }
        });

    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        MenuInflater inflater = getMenuInflater();
        inflater.inflate(R.menu.main, menu);
        return true;
    }

    private void importData() {
        WifiManager wifiMgr = (WifiManager) this.getSystemService(Context.WIFI_SERVICE);
        String rete = wifiMgr.getConnectionInfo().getSSID();

        String query = "SELECT * from" + rete;
        //if (wifiMgr.getConnectionInfo().getSupplicantState().isValidState(wifiMgr.getConnectionInfo().getSupplicantState())) {
        /*try {
            Connection connection = DriverManager.getConnection("jdbc:mysql://mattone.ddns.net:3306/FastOrder", "root", "mattone17");
            Statement stm = connection.createStatement();
            ResultSet rs = stm.executeQuery("SELECT * from Test");
            //ResultSet rs=stm.executeQuery(query);
            while (rs.next()) {
                Prodotto p = new Prodotto(rs.getString("nome"), rs.getFloat("prezzo"));
                prodotti.add(p);
            }
        } catch (SQLException e) {
            Toast.makeText(this, "error" + e.toString(), Toast.LENGTH_LONG).show();
        }*/
        //}
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            Toast.makeText(getApplicationContext(), e.toString(), Toast.LENGTH_LONG).show();
        }
        t1 = new Thread(new Runnable() {
            public void run() {
                if (!Thread.interrupted()) {
                    try {
                        Thread.sleep(100);
                    } catch (InterruptedException e1) {
                    }

                    if (con == null) {
                        try {
                            con = DriverManager.getConnection("jdbc:mysql://mattone.ddns.net:3306/FastOrder", "root", "mattone17");
                            System.out.println("connesso");
                            //////////////
                            try {
                                Statement stm = con.createStatement();
                                ResultSet rs = stm.executeQuery("SELECT * from Test");
                                //ResultSet rs=stm.executeQuery(query);
                                while (rs.next()) {
                                    Prodotto p = new Prodotto(rs.getString("nome"), rs.getFloat("prezzo"));
                                    prodotti.add(p);
                                    System.out.println("Nome: " + rs.getString("nome"));
                                }
                            } catch (SQLException e) {
                                System.out.println(e);
                            }

                        } catch (SQLException e) {
                            System.out.println(e);
                            con = null;
                        }
                    }
                }
            }
        });//fine thread
        if ((t1 != null) && (!t1.isAlive())) {
            t1.start();
        }
    }


    private void scriviCarrello(int position) {
        DbManager db = new DbManager(this);
        db.save(prodotti.get(position).getNome(),prodotti.get(position).getPrezzo());
    }
}