package academic.th;

import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;

public class InsertarAlumnoActivity extends AppCompatActivity {

    private EditText calumno,cpadre;
    Spinner spinner;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_insertar_alumno);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
                        .setAction("Action", null).show();
            }
        });

        calumno=(EditText)findViewById(R.id.editcodigoalumno);
        cpadre=(EditText)findViewById(R.id.editcodigopadre);
        spinner=(Spinner)findViewById(R.id.spinnercolegios);
        List lista= new ArrayList();
        lista.add("alfonsodelhierro");
        lista.add("ambato");
        lista.add("atuntaqui");
        lista.add("azogues");
        lista.add("cariamanga");
        lista.add("conocoto");
        lista.add("cuenca");
        lista.add("cuenca2");
        lista.add("febrescordero");
        lista.add("hermanomiguel");
        lista.add("ibarra");
        lista.add("juanbautista");
        lista.add("lamagdalena");
        lista.add("lasallegye");
        lista.add("latacunga");
        lista.add("loja");
        lista.add("sanbenildo");
        lista.add("tulcan");
        lista.add("usanbenildo");


        ArrayAdapter arreglo=new ArrayAdapter(this,android.R.layout.simple_dropdown_item_1line,lista);
        arreglo.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinner.setAdapter(arreglo);

       /* spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
               // Toast.makeText(InsertarAlumnoActivity.this,"Posicion"+String.valueOf(spinner.getSelectedItem()),Toast.LENGTH_SHORT).show();

            }

            @Override
            public void onNothingSelected(AdapterView<?> parent) {

            }
        });*/



    }

    public void insertaralumno(View v){

        if(calumno.getText().length()==0){
            calumno.setError("Ingresar el Codigo del Alumno");
        }
        if(cpadre.getText().length()==0){
            cpadre.setError("Ingresar el Codigo del Representante");
        }
        else{

            AdminSQLite admin= new AdminSQLite(this,"administracion4",null,1);
            SQLiteDatabase bd= admin.getWritableDatabase();

            String alumno=calumno.getText().toString();
            String padre=cpadre.getText().toString();
            String colegio=spinner.getSelectedItem().toString();

            ////validacion unico registro
            Cursor numalumno= bd.rawQuery("select * from alumno",null);

            if(!numalumno.moveToFirst()) {


                Cursor fila = bd.rawQuery("select * from alumno where calumno_alu='" + alumno + "'", null);

                if (!fila.moveToFirst()) {

                    ContentValues datos = new ContentValues();

                    datos.put("calumno_alu", alumno);
                    datos.put("cpadre_alu", padre);
                    datos.put("colegio_alu", colegio);

                    bd.insert("alumno", null, datos);
                    bd.close();
                    calumno.setText("");
                    cpadre.setText("");

                    Toast.makeText(this, "Registrado Exitosamente", Toast.LENGTH_SHORT).show();
                }
            }
            else{

                Toast.makeText(this, "Solo se puede registrar un alumno", Toast.LENGTH_SHORT).show();
                bd.close();
            }

        }

    }

    public void irmenu1(View v){

        Intent i = new Intent(this,MenuActivity.class);
        startActivity(i);
    }





}
