sqlite - tasks app

sqliteDb.java
=========================================
package comq.example.amitk.a1_2_sampleapp_home.databases;

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

import comq.example.amitk.a1_2_sampleapp_home.databases.models.taskDetalis;
import comq.example.amitk.a1_2_sampleapp_home.databases.models.userDetails;



public class sqliteDb extends SQLiteOpenHelper {


// Logcat tag
    private static final String TAG= "sqliteDatabaseHelper";

    // Database Version
    public static final int DATABASE_VERSION = 1;

    // Database Name
    public static final String DATABASE_NAME = "taskApp.db";

    SQLiteDatabase db;
    Context context;

    // Table Names
    private static final String TABLE_USERS = "users";
    private static final String TABLE_TASKS = "tasks";
    private static final String TABLE_USER_TASK = "users_task";

    private static final String KEY_ID = "id";

    // Users Table - column names
    private static final String USERNAME="UserName";
    private static final String PASSWORD="password";
    private static final String EMAIL="email";
    private static final String NAME="name";
    private static final String GENDER="gender";
    private static final String COUNTRY="country";
    private static final String PHOTO="photo";


    // Task Table - column names

    private static final String TASKNAME = "task_name";
    private static final String TASKDETALIS= "task_detalis";
    private static final String TASKSTARTDATE="task_start_date";
    private static final String TASKSTARTHOURE="task_start_hour";
    private static final String TASKSESTIMATEDENDDATE="task_estimated_end_date";
    private static final String TASKSESTIMATEDENDHOUR="task_estimated_end_hour";
    private static final String TASKENDDATE="task_end_date";
    private static final String TASKENDHOUR="task_end_hour";
    private static final String ISTASKDONE="is_task_done";

    // user_task Table - column names
    private static final String KEY_USER_ID = "user_id";
    private static final String KEY_TASK_ID = "task_id";

    // Table users Create Statements
    private static final String CREATE_TABLE_USERS = "CREATE TABLE IF NOT EXISTS "
            + TABLE_USERS + "(" + KEY_ID + " INTEGER PRIMARY KEY," + USERNAME
            + " TEXT," + PASSWORD + " TEXT," + EMAIL
            + " TEXT," + NAME + " TEXT," + GENDER
            + " TEXT," + COUNTRY + " TEXT," + PHOTO
            + " BLOB"+ ")";

    // TASK table create statement

    private static final String CREATE_TABLE_TASKS = "CREATE TABLE IF NOT EXISTS " + TABLE_TASKS
            + "(" + KEY_ID + " INTEGER PRIMARY KEY," + USERNAME + " TEXT,"+ TASKNAME + " TEXT,"
            + TASKDETALIS + " TEXT," + TASKSTARTDATE + " DATETIME," + TASKSESTIMATEDENDDATE + " DATETIME,"
             + TASKENDDATE + " DATETIME,"+ ISTASKDONE + " INTEGER" + ")";

 //constructor
public sqliteDb(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        this.context=context;
        this.db=getWritableDatabase();
    }


    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL(CREATE_TABLE_USERS);
        db.execSQL(CREATE_TABLE_TASKS);

        Log.e(TAG,"tables\n"+"users:"+CREATE_TABLE_USERS+"\ntasks:"+CREATE_TABLE_TASKS);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        db.execSQL("DROP TABLE IF EXISTS " + TABLE_USERS);
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_TASKS);

        // create new tables
        onCreate(db);
    }

    //*****************************************users*****************************************************************//

    //check if user exists
    public boolean checkUser(String username) throws SQLException {
        Cursor c = db.rawQuery("SELECT * FROM "+TABLE_USERS+" WHERE "+USERNAME+ "= '" + username + "'", null);
        if (c.getCount() > 0) {
            return true;
        }
        else{
            return  false;
        }
    }

    //check if email already exists
    public boolean checkEmail(String email) throws SQLException {
        Cursor c = db.rawQuery("SELECT * FROM "+TABLE_USERS+" WHERE "+EMAIL+ " = '" + email + "'", null);
        if (c.getCount() > 0) {
            return true;
        }
        else{
            return  false;
        }
    }

    //get password for given user
    public String getPassword(String userName)
    {
        Cursor cursor=db.query(TABLE_USERS, null, " userName=?", new String[]{userName}, null, null, null);

        cursor.moveToFirst();
        String password= cursor.getString(cursor.getColumnIndex(PASSWORD));
        cursor.close();
        return password;
    }

    public void addUser(userDetails u)
    {
        try {

            ContentValues values = new ContentValues();
            values.put(USERNAME,u.getUsername());
            values.put(EMAIL,u.getMail());
            values.put(PASSWORD,u.getPassword());

            db.insert(TABLE_USERS,null,values);

        } catch (Exception e) {
            Log.e(TAG, e.getMessage().toString());
        }


    }

    //*****************************************tasks*****************************************************************//

    public boolean checkTaskName(String taskName) throws SQLException {
        Cursor c = db.rawQuery("SELECT * FROM "+TABLE_TASKS+" WHERE "+TASKNAME+ "= '" + taskName + "'", null);
        if (c.getCount() > 0) {
            return true;
        }
        else{
            return  false;
        }
    }
      public void addTask(taskDetalis t)
      {
        try {
            ContentValues values = new ContentValues();
            values.put(USERNAME,t.getUserName());
            values.put(TASKNAME,t.getTaskName());
            values.put(TASKDETALIS,t.getTaskDetalis());
            values.put(TASKSTARTDATE, String.valueOf(t.getStartDate()));
            values.put(TASKSESTIMATEDENDDATE, String.valueOf(t.getEstimatedEndDate()));
            values.put(TASKENDDATE, String.valueOf(t.getEndDate()));
            values.put(ISTASKDONE, (t.isTaskDone())? 1 : 0);

            db.insert(TABLE_TASKS,null,values);

        } catch (Exception e) {
            Log.e(TAG, e.getMessage().toString());
        }
    }

//    get all task for a given user
    public Cursor getAllTasksForUser(String userName)
    {
        String query="SELECT * FROM "+TABLE_TASKS+" WHERE "+USERNAME+ "= '" + userName + "'";
        Cursor cursor=db.rawQuery(query,null);
        return cursor;
    }


    public Cursor getFinishedTasksForUser(String userName,int status)
    {
        String query="SELECT * FROM "+TABLE_TASKS+" WHERE "+USERNAME+ "= '" + userName + "'"+" AND "+ISTASKDONE+" = "+ status;
        Cursor cursor=db.rawQuery(query,null);
        return cursor;
    }
    //get current task
    public Cursor getCurrentTasksForUser(String userName,int status)
    {
        String query="SELECT * FROM "+TABLE_TASKS+" WHERE "+USERNAME+ "= '" + userName + "'"+" AND "+ISTASKDONE+" = "+ status;
        Cursor cursor=db.rawQuery(query,null);
        return cursor;
    }

    public Cursor getTasksByDate(String userName)
    {
        String query="SELECT * FROM "+TABLE_TASKS+" WHERE "+USERNAME+ "= '" + userName + "'"+" ORDER BY "+ TASKSTARTDATE +" ASC";
        Cursor cursor=db.rawQuery(query,null);
        return cursor;
    }
    public void updateTaskFinish(String taskName){
        String query="UPDATE "+TABLE_TASKS+" SET "+ISTASKDONE+ " = "+ 1 +" WHERE "+TASKNAME+ "= '" + taskName + "'";
        db.execSQL(query);
        db.close();
    }
    public void updateTaskResume(String taskName){
        String query="UPDATE "+TABLE_TASKS+" SET "+ISTASKDONE+ " = "+ 0 +" WHERE "+TASKNAME+ "= '" + taskName + "'";
        db.execSQL(query);
        db.close();
    }

    public void updateTaskEndDate(String taskName, String  endDate){
        String query="UPDATE "+TABLE_TASKS+" SET "+TASKENDDATE+ " = "+ endDate +" WHERE "+TASKNAME+ "= '" + taskName + "'";
        db.execSQL(query);
        db.close();
    }

    public void deleteTask(String taskName) {
        db.delete(TABLE_TASKS, TASKNAME + " = ?",
                new String[] { taskName});
        db.close();
    }
    public void removeAllTasks(String userName)
    {
        String query = "delete from "+TABLE_TASKS+" WHERE "+USERNAME+ "= '" + userName + "'";
        db.execSQL(query);
        db.close();
    }


}