// KidsDb2 Example
// Source code file: MainActivity.java

package it372.kidsdb2;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.TextView;
public class MainActivity extends AppCompatActivity {
    private EditText edtName;
    private RadioButton radFemale;
    private RadioButton radMale;
    private RadioButton radOther;
    private EditText edtAge;
    private EditText edtPrimary;
    private TextView txtTableRow;
    private SQLiteDatabase db;
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        edtName = findViewById(R.id.edt_name);
        radFemale = findViewById(R.id.rad_female);
        radMale = findViewById(R.id.rad_male);
        radOther = findViewById(R.id.rad_other);
        edtAge = findViewById(R.id.edt_age);
        edtPrimary = findViewById(R.id.edt_primary_key);
        txtTableRow = findViewById(R.id.txt_table_row);

        SQLiteOpenHelper dbh = new KidsDbHelper(this);
        db = dbh.getWritableDatabase( );
        db.execSQL(
            "create table if not exists " +
            "kids(name text, gender text, age integer);");
    }

    public void insertRow(View view) {
        ContentValues row = new ContentValues( );
        String name = edtName.getText( ).toString( );
        row.put("name", name);
        String gender = "";
        if (radFemale.isChecked( )) {
            gender = "F";
        }
        else if (radMale.isChecked( )) {
            gender = "M";
        }
        else {
            gender = "X";
        }
        row.put("gender", gender);
        int age = Integer.parseInt(edtAge.getText( ).toString( ));
        row.put("age", age);
        db.insert("kids", null, row);
    }

    public void showTableRow(View view) {
        String primaryKey = edtPrimary.getText( ).toString( );
        Cursor cursor = db.query("kids",
            new String[ ] {"name", "gender", "age"},
            "name = ?", new String[ ] {primaryKey},
            null,null,null,null);
        String tableRow = "";
        if (cursor.moveToFirst( )) {
            String name = cursor.getString(0);
            String gender = cursor.getString(1);
            int age = cursor.getInt(2);
            tableRow = String.format("%s %s %d", name, gender, age);
        }
        txtTableRow.setText(tableRow);
    }
}