package com.example.justim.sqliteexample;

import android.content.Intent;
import android.database.Cursor;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.Toast;


public class MainActivity extends ActionBarActivity {
    ListView todoList;
    DBAccess access;
    SimpleCursorAdapter adapter=null;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        todoList = (ListView)findViewById(R.id.lvToDo);
        access = new DBAccess(this, "schedule", null, 1);
        Button btnAdd = (Button)findViewById(R.id.btnNew);
        btnAdd.setOnClickListener(addNewEvent);

        todoList.setOnItemClickListener(modifyEvent);
    }

    private AdapterView.OnItemClickListener modifyEvent = new AdapterView.OnItemClickListener() {
        @Override
        public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
            Intent it = new Intent();
            it.setClass(MainActivity.this, ModifyActivity.class);
            Bundle bdl = new Bundle();
            bdl.putLong("id", id);


            it.putExtras(bdl);
            startActivity(it);
        }
    };

    /*@Override
    protected void onResume() {

        Cursor c=access.getData(
                DBAccess.DATE_FIELD+">= strftime('%Y-%m-%d','now')",
                DBAccess.DATE_FIELD+" ,"+DBAccess.TIME_FIELD);

        if(adapter == null) {
            adapter=new SimpleCursorAdapter(this, R.layout.todoitem, c,
                    new String[]{DBAccess.DATE_FIELD, DBAccess.TIME_FIELD,
                            DBAccess.TITLE_FIELD},
                    new int[]{R.id.tvDate,R.id.tvTime,R.id.tvEvent},
                    0);

            todoList.setAdapter(adapter);
        } else
            adapter.changeCursor(c);//更新ListView呈現的資料
       super.onResume();

    }*/

    @Override
    protected void onDestroy() {
        super.onDestroy();
        access.close();
    }

    private View.OnClickListener addNewEvent = new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            EditText etDate = (EditText)findViewById(R.id.etDate);
            EditText etTime = (EditText)findViewById(R.id.etTime);
            EditText etEvent = (EditText)findViewById(R.id.etEvent);
            EditText etExplanation = (EditText)findViewById(R.id.etExplanation);
            long result = access.add(etDate.getText().toString(),
                    etTime.getText().toString(),
                    etEvent.getText().toString(),
                    etExplanation.getText().toString());

            if(result>=0) {//新增成功
                Toast.makeText(MainActivity.this, "新增成功", Toast.LENGTH_LONG).show();


                Cursor c=access.getData(
                        DBAccess.DATE_FIELD+">= strftime('%Y-%m-%d','now')",
                        DBAccess.DATE_FIELD+" ,"+DBAccess.TIME_FIELD);
                adapter.changeCursor(c);//更新ListView呈現的資料
            }else//失敗
                Toast.makeText(MainActivity.this, "新增資料失敗", Toast.LENGTH_LONG).show();


        }
    };
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}