LRc6mKCq

1package com.example.darles.cadastropessoas;
2
3import android.annotation.SuppressLint;
4import android.app.DatePickerDialog;
5import android.content.Intent;
6import android.database.Cursor;
7import android.database.sqlite.SQLiteDatabase;
8import android.support.v7.app.AppCompatActivity;
9import android.os.Bundle;
10import android.view.View;
11import android.widget.AdapterView;
12import android.widget.Button;
13import android.widget.DatePicker;
14import android.widget.EditText;
15import android.widget.ListView;
16import android.widget.SimpleCursorAdapter;
17
18
19
20import java.util.Calendar;
21
22
23public class MainActivity extends AppCompatActivity {
24
25
26            private EditText data;
27            DatePickerDialog datePickerDialog;
28
29
30            private SQLiteDatabase db = null;
31            private SimpleCursorAdapter adt = null;
32
33            @SuppressLint("WrongConstant")
34            @Override
35            protected void onCreate(Bundle savedInstanceState) {
36                super.onCreate(savedInstanceState);
37                setContentView(R.layout.activity_main);
38
39
40
41                data = (EditText) findViewById(R.id.txtDATA);
42                data.setOnClickListener(new View.OnClickListener() {
43                    @Override
44                    public void onClick(View v) {
45                        Calendar calendar=Calendar.getInstance();
46                        final int year=calendar.get(Calendar.YEAR);
47                        final int month=calendar.get(Calendar.MONTH);
48                        final int day=calendar.get(Calendar.DAY_OF_MONTH);
49                        datePickerDialog=new DatePickerDialog(MainActivity.this, new DatePickerDialog.OnDateSetListener() {
50                            @Override
51                            public void onDateSet(DatePicker datePicker, int i, int i1, int i2) {
52                                data.setText(day+"-"+(month+1)+"-"+year);
53                            }
54                        },year,month,day);
55                    }
56                });
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75                //Criar o banco de dados
76                db = openOrCreateDatabase("crud.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);
77
78                String tarefas = "CREATE TABLE IF NOT EXISTS tarefas (_id INTEGER PRIMARY KEY autoincrement, " +
79                        "tarefa VARCHAR(50), categoria VARCHAR(50), data VARCHAR(50), hora VARCHAR(50))";
80
81                db.execSQL(tarefas);
82
83
84                Button btnCliente = (Button) findViewById(R.id.btnCliente);
85                btnCliente.setOnClickListener(new View.OnClickListener() {
86                    @Override
87                    public void onClick(View v) {
88                        startActivity(new Intent(getBaseContext(), CadastroActivity.class));
89                    }
90                });
91            }
92
93        @Override
94        public void onResume(){
95            super.onResume();
96            //Prencher o ListView
97            Cursor cursor = db.query("tarefas", new String[]{"_id", "tarefa", "categoria", "data", "hora"}, null, null, null, null, "_id ASC", null);
98            String[] campos = {"_id", "tarefa", "categoria", "data", "hora"};
99            int[] ids = {R.id.txvID, R.id.txvTAREFA, R.id.txvCATEGORIA, R.id.txvDATA, R.id.txvHORA};
100            adt = new SimpleCursorAdapter(getBaseContext(), R.layout.model_clientes, cursor, campos, ids, 0);
101            ListView ltwDados = (ListView) findViewById(R.id.ltWdados);
102            ltwDados.setAdapter(adt);
103
104
105            ltwDados.setOnItemClickListener(new AdapterView.OnItemClickListener() {
106                @Override
107                public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
108                    Cursor retornoCursor = (Cursor) adt.getItem(position);
109                    Intent it = new Intent(getBaseContext(), EditarActivity.class);
110                    it.putExtra("codigo", retornoCursor.getInt(0));
111                    it.putExtra("tarefa", retornoCursor.getString(1));
112                    it.putExtra("categoria", retornoCursor.getString(2));
113                    it.putExtra("data", retornoCursor.getString(3));
114                    it.putExtra("hora", retornoCursor.getString(retornoCursor.getColumnIndex("hora")));
115                    startActivity(it);
116
117                }
118            });
119        }
120 }