package alumnos.com.solemne2;

import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;

public class MainActivity extends AppCompatActivity {


    private EditText edt1, edt2; // declaramos variables.
    private Spinner sp1;
    private DatePicker date;

    private DBHelper dbhelper;

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

        //Convertimos las variables.
        edt1 = (EditText) findViewById(R.id.editText);
        edt2 = (EditText) findViewById(R.id.editText2);
        date = (DatePicker) findViewById(R.id.datePicker);
        sp1 = (Spinner) findViewById(R.id.spinner);

        dbhelper = new DBHelper(this);
        poblarSpinner();


    }

    private void poblarSpinner() {
        ArrayAdapter<String> spinnerAdapter;
        SQLiteDatabase db = dbhelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("SELECT nombre FROM item;", null);
        List<String> spinnerDatos = new ArrayList<String>();
        if (cursor.moveToFirst()) {
            do {
                spinnerDatos.add(cursor.getString(cursor.getColumnIndex("nombre")));
            } while (cursor.moveToNext());
        }

        spinnerAdapter = new ArrayAdapter<String>(this,
                android.R.layout.simple_spinner_item, spinnerDatos);
        sp1.setAdapter(spinnerAdapter);
    }

    public void inserta(View view) {

        String descripcion, fechac;
        int item, dia, mes, anio, monto;

        monto = Integer.parseInt(edt1.getText().toString());
        descripcion = edt2.getText().toString();
        dia = date.getDayOfMonth();
        mes = date.getMonth();
        anio = date.getYear();
        fechac = String.valueOf(anio) + "-" + String.valueOf(mes) + "-" + String.valueOf(dia);
        item = sp1.getSelectedItemPosition();

        if (edt1.equals("")) {
            Toast.makeText(this, "Ingrese Monto", Toast.LENGTH_SHORT).show();
        }else if (edt2.equals("")) {
            Toast.makeText(this, "Ingrese descripcion", Toast.LENGTH_SHORT).show();
        }


        // instancia para los permisos.
        SQLiteDatabase db = dbhelper.getWritableDatabase();
        if (db != null) {

            String consulta = "SELECT * from item;";
            Cursor c = db.rawQuery(consulta, null);
            int contador = c.getCount();
            String[] array = new String[contador];

            if(contador > 0){
                int i = 0;
                if(c.moveToFirst())
                {
                    do{
                        String linea = c.getString(1)+"\n";
                        array[i] = linea;
                        i++;
                    }while(c.moveToNext());
                }
                ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,android.R.layout.simple_spinner_dropdown_item,array);
                sp1.setAdapter(adapter);
            }
        }

        // creamos un objeto registro de la clase ContentValues para
        // pasar los valores a la consulta.
        ContentValues registro = new ContentValues();
        registro.put("monto", monto);
        registro.put("descripcion", descripcion);
        registro.put("fecha", fechac);
        registro.put("item_id", item);


        // i es un contador de numeros de consultas que se ejecutan.
        long i = db.insert("datos", null, registro);

        if (i > 0) {
            Toast.makeText(this, "Registro insertado con exito", Toast.LENGTH_SHORT).show();
        } else {
            Toast.makeText(this, "Error..al insertar", Toast.LENGTH_SHORT).show();
        }

    }

    public void EnviarLista(View view) {

        Intent intent = new Intent(this, ListarActivity.class);
        startActivity(intent);

    }

}