package be.condorcet.projetandroidgroupe8;

import java.sql.Connection;
import java.util.ArrayList;

import myconnections.DBConnection;
import Modele.CategorieDB;
import Modele.CommunauteDB;
import Modele.MessageDB;
import Modele.UtilisateurDB;
import android.app.ProgressDialog;
import android.os.AsyncTask;
import android.os.Bundle;
import android.support.v7.app.ActionBarActivity;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

public class ChoixCategorie extends ActionBarActivity {

    private ListView liste;
    private ArrayList <String> nomCategories;
    private String choixCategorie;
    private Connection con = null;
    private ArrayList <CategorieDB> categories = new ArrayList <CategorieDB> ();
    ArrayAdapter <String> adapter;

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

        MyAccesDB adb = new MyAccesDB(ChoixCategorie.this);
        adb.execute();



        /*liste.setOnItemClickListener (
                new OnItemClickListener()
                    {   @Override
                        public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,long arg3) {
                            String nomItem = (String)arg0.getItemAtPosition(arg2);
                            choixCategorie = nomItem;
                        }
                    }
        );

        //Toast.makeText(this, choixCategorie, Toast.LENGTH_SHORT).show(); */
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.choix_categorie, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        int id = item.getItemId();
        if (id == R.id.action_settings) {
            return true;
        }
        return super.onOptionsItemSelected(item);
    }

    @Override
    public void onDestroy(){
        super.onDestroy();
         try {
             con.close();
             con=null;
             Log.d("connexion","deconnexion OK");
         }
         catch (Exception e) {

         }
         Log.d("connexion","deconnexion OK");
    }

    class MyAccesDB extends AsyncTask <String,Integer,Boolean> {

        private String resultat;
        private ProgressDialog pgd = null;

        public MyAccesDB (ChoixCategorie pActivity) { }

        private void link (ChoixCategorie pActivity) { }

        protected void onPreExecute(){
            super.onPreExecute();
            pgd = new ProgressDialog(ChoixCategorie.this);
            pgd.setMessage("Accès à la base de données en cours");
            pgd.setProgressStyle(ProgressDialog.STYLE_SPINNER);
            pgd.show();
        }

        @Override
        protected Boolean doInBackground(String... arg0) {

            if(con==null) {
                con = new DBConnection().getConnection();
                if(con==null) {
                    resultat = "echec de la connexion";
                    Log.d("connexion","connexion BAD");
                    return false;
                }
                Log.d("connexion","connexion OK");

                CategorieDB.setConnection(con);
                CommunauteDB.setConnection(con);
                MessageDB.setConnection(con);
                UtilisateurDB.setConnection(con);
            }

            try {
                categories = CategorieDB.readCategories();


                Log.d("ok ","test 0"+categories);
            }
            catch(Exception e) {
                resultat = "erreur" +e.getMessage();
                Log.d("test","test "+e.getMessage());
                //Toast.makeText(this, resultat , Toast.LENGTH_SHORT).show();
                return false;
            }
            return true;
        }

        protected void onPostExecute(Boolean result){
            super.onPostExecute(result);
            pgd.dismiss();

            if(result) {
                liste = (ListView) findViewById(R.id.listeCategories);
                nomCategories = new  ArrayList<String>();

                for ( CategorieDB c : categories )
                {   //Toast.makeText(this, c.getNomCategorie(), Toast.LENGTH_SHORT).show();
                    nomCategories.add(c.toString());
                }

                adapter = new  ArrayAdapter <String> (ChoixCategorie.this,android.R.layout.simple_list_item_1,nomCategories);
                liste.setAdapter(adapter);
            }
        }
    }
}