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.EditText;
import android.widget.Toast;

public class InsertarAlumnoActivity extends AppCompatActivity {

    private EditText calumno,cpadre;

    @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);

    }

    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,"administracion",null,1);
            SQLiteDatabase bd= admin.getWritableDatabase();

            String alumno=calumno.getText().toString();
            String padre=cpadre.getText().toString();


            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);

                bd.insert("alumno",null,datos);
                bd.close();
                calumno.setText("");
                cpadre.setText("");

                Toast.makeText(this,"Registrado Exitosamente",Toast.LENGTH_SHORT).show();


            }
        }
    }

    public void irmenu1(View v){

        Intent i = new Intent(this,MenuActivity.class);
        startActivity(i);
    }

}