public void sendList(View view) {
message = editText.getText().toString();
if (message.length() > 0) {
SQLiteDatabase db = NB.getReadableDatabase();
// String command = "select distict title from Notes";
Cursor C = db.query("TextTable", new String[] {"id", "text"}, null, null, null, null, null);
C.moveToLast();
int nextpos;
if (C.getCount() < 1) {
nextpos = 1;
} else {
nextpos = C.getInt(0);
nextpos++;
}
SQLiteDatabase dataB = NB.getWritableDatabase();
ContentValues vals = new ContentValues();
vals.put("id", nextpos);
vals.put("title", Title);
vals.put("text", message);
// isnew = true;
if (isnew) {
dataB.insert("TextTable", null, vals);
} else {
Toast.makeText(getApplicationContext(), "Updated", Toast.LENGTH_SHORT).show();
dataB.update("TextTable", vals, "title=? AND text=?", new String[] {Title, Text});
}
dataB.close();
} else {
Toast.makeText(getApplicationContext(), "Nothing Entered", Toast.LENGTH_SHORT).show();
}
editText.setText("");
NotesContentPage.NCP.finish();
try {
Class ourClass = Class.forName("com.example.notetest." + "NotesContentPage");
Intent intent1 = new Intent(NewNote.this, ourClass);
intent1.putExtra("NoteSelected", Title);
startActivity(intent1);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_new_note);
editText = (EditText) findViewById(R.id.editText1);
Title = getIntent().getExtras().getString("title");
String temp = getIntent().getExtras().getString("new");
if (temp.equals("no")) {
isnew = false;
} else {
isnew = true;
}
if (isnew) {
Text = "";
} else {
Text = getIntent().getExtras().getString("text");
}
setTitle("List: " + Title + ":EditMode");
NB = new NoteBase(this);
/*
SQLiteDatabase dataB = NB.getWritableDatabase();
ContentValues vals = new ContentValues();
vals.put("id", 4);
vals.put("title", "todo");
vals.put("text", "do math");
dataB.insert("TextTable", null, vals);
dataB.close();
*/
SQLiteDatabase db = NB.getReadableDatabase();
Cursor C =
db.query(
"TextTable",
new String[] {"id", "text"},
"title=? and text=?",
new String[] {Title, Text},
null,
null,
null);
if (C == null) {
// Toast.makeText(getApplicationContext(), "nope", Toast.LENGTH_SHORT).show();
} else if (!(C.moveToFirst()) || C.getCount() == 0) {
// Toast.makeText(getApplicationContext(), "empty", Toast.LENGTH_SHORT).show();
} else {
/// Toast.makeText(getApplicationContext(), "gto sometink", Toast.LENGTH_SHORT).show();
C.moveToLast();
do {
editText.setText(C.getString(1));
} while (C.moveToPrevious());
}
db.close();
NB.close();
String newtext = editText.getText().toString();
editText.setText("");
editText.append(newtext);
}
