import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "tasks.db";
    public static final String TABLE_NAME = "task_table";
    public static final String ID_COL = "ID";
    public static final String NAME_COL = "NAME";
    public static final String CATEGORY_COL = "CATEGORY";
    public static final String DURATION_COL = "DURATION";
    public static final String DATETIME_COL = "DATETIME";
    public static final String DESCRIPTION_COL = "DATETIME";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String CREATE_TABLE_TASKS = "CREATE TABLE " + TABLE_NAME  + "("
                + ID_COL + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
                + NAME_COL + " TEXT, "
                + DATETIME_COL + " TEXT,"
                + DURATION_COL + " INTEGER,"
                + CATEGORY_COL + " TEXT,"
                + DESCRIPTION_COL + " TEXT " + ")";


        db.execSQL(CREATE_TABLE_TASKS);

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
        onCreate(db);
    }

    public boolean insertData(Task task) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(NAME_COL,task.getName());
        contentValues.put(CATEGORY_COL,task.getCategory().toString());
        contentValues.put(DATETIME_COL,task.getDateTime());
        contentValues.put(DURATION_COL,task.getDuration());
        contentValues.put(DESCRIPTION_COL,task.getDescription());

        long result = db.insert(TABLE_NAME,null ,contentValues);
        if(result == -1)
            return false;
        else
            return true;
    }

    public Cursor getAllData() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
        return res;
    }

    public boolean updateData(String id,Task task) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(ID_COL,id);
        contentValues.put(CATEGORY_COL,task.getCategory().toString());
        contentValues.put(DATETIME_COL,task.getDateTime());
        contentValues.put(DURATION_COL,task.getDuration());
        contentValues.put(DESCRIPTION_COL,task.getDescription());

        db.update(TABLE_NAME, contentValues, "ID = ?",new String[] { id });
        return true;
    }

    public Integer deleteData (String id) {
        SQLiteDatabase db = this.getWritableDatabase();
        return db.delete(TABLE_NAME, "ID = ?",new String[] {id});
    }



}


package com.example.tareq.tasks2do;


import android.content.ClipData;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.view.View;

public class MainActivity extends AppCompatActivity {
    DatabaseHelper data;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
         data = new DatabaseHelper(this);
        setContentView(R.layout.activity_main);
    }


    @Override
    public boolean onCreateOptionsMenu(Menu menu){

    getMenuInflater().inflate(R.menu.item,menu);
    Intent intent = new Intent(MainActivity.this, addActivity.class);
   // startActivity(intent);
    return super.onCreateOptionsMenu(menu);

}


    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        switch (item.getItemId()) {
            case R.id.add:

                Intent  intent = new Intent(MainActivity.this,addActivity.class);
                startActivity(intent);
        }
        return super.onOptionsItemSelected(item);
    }
}

public DatabaseHelper(Context context) {
    super(context, DATABASE_NAME, null, 1);
    this.getWriteableDatabase();
}