package com.ronramos.samples.mysimpledb;

import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class QuotesMain extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
        final DBHelper db = new DBHelper(this);
        Button btnAdd = (Button) findViewById(R.id.button1);
        Button btnShow = (Button) findViewById(R.id.button2);
        final EditText txtQuote = (EditText) findViewById(R.id.editText1);
        final EditText txtRow = (EditText) findViewById(R.id.editText2);
        
        OnClickListener add = new OnClickListener(){
        public void onClick(View view){
            db.open();
            long id;
            id = db.insertQuote(txtQuote.getText().toString());
            db.close();
        }
        };
        
        
        OnClickListener show = new OnClickListener(){
        public void onClick(View view){
            db.open();
            Cursor c = db.getQuote(Long.parseLong(txtRow.getText().toString())); 
            if (c.moveToFirst()){
                Toast.makeText(getApplicationContext(), 
                        "id: " + c.getString(0) + "\n" +
                        "Quote: " + c.getString(1) + "\n",
                        Toast.LENGTH_LONG).show();        

            }
            else{
            Toast.makeText(getApplicationContext(), 
                        "No Quote!",
                        Toast.LENGTH_LONG).show();        
            
            }
            
            db.close();
        }
        };
        
        btnAdd.setOnClickListener(add);
        btnShow.setOnClickListener(show);
 
    }
}