DBHelper.java

package com.app.yourrestaurantapp.utilities;

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 java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;

public class DBHelper extends SQLiteOpenHelper {

    private final static String DB_NAME = "restaurant_db";
    public final static int DB_VERSION = 1;
    public static SQLiteDatabase db;
    private final Context context;
    private String DB_PATH;

    private final String TABLE_CART = "tbl_cart";
    private final String CART_ID = "id";
    private final String PRODUCT_NAME = "product_name";
    private final String QUANTITY = "quantity";
    private final String TOTAL_PRICE = "total_price";
    private final String PRODUCT_IMAGE = "product_image";
    private final String PRODUCT_DATE = "date_time";

    private final String TABLE_HISTORY = "tbl_history";
    private final String HISTORY_ID = "id";
    private final String CODE = "code";
    private final String ORDER_LIST = "order_list";
    private final String ORDER_TOTAL = "order_total";
    private final String DATE_TIME = "date_time";

    public DBHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
        this.context = context;
        DB_PATH = "/data/data/" + context.getPackageName() + "/" + "databases/";
    }

    public void createDataBase() throws IOException {
        boolean dbExist = checkDataBase();
        SQLiteDatabase db_Read = null;
        if (dbExist) {
        } else {
            db_Read = this.getReadableDatabase();
            db_Read.close();
            try {
                copyDataBase();
            } catch (IOException e) {
                throw new Error("Error copying database: " + e.getMessage());
            }
        }
    }

    private boolean checkDataBase() {
        File dbFile = new File(DB_PATH + DB_NAME);
        return dbFile.exists();

    }

    private void copyDataBase() throws IOException {
        InputStream myInput = context.getAssets().open(DB_NAME);
        String outFileName = DB_PATH + DB_NAME;
        OutputStream myOutput = new FileOutputStream(outFileName);
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myInput.read(buffer)) > 0) {
            myOutput.write(buffer, 0, length);
        }
        myOutput.flush();
        myOutput.close();
        myInput.close();

    }

    public void openDataBase() throws SQLException {
        String myPath = DB_PATH + DB_NAME;
        db = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);
    }

    @Override
    public void close() {
        db.close();
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

    }

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

    }

    public ArrayList<ArrayList<Object>> getAllData() {
        ArrayList<ArrayList<Object>> dataArrays = new ArrayList<ArrayList<Object>>();
        Cursor cursor = null;
        try {
            cursor = db.query(TABLE_CART, new String[]{CART_ID, PRODUCT_NAME, QUANTITY, TOTAL_PRICE, PRODUCT_IMAGE, PRODUCT_DATE},
                    null, null, null, null, "date_time DESC");
            cursor.moveToFirst();
            if (!cursor.isAfterLast()) {
                do {
                    ArrayList<Object> dataList = new ArrayList<Object>();
                    dataList.add(cursor.getLong(0));
                    dataList.add(cursor.getString(1));
                    dataList.add(cursor.getString(2));
                    dataList.add(cursor.getString(3));
                    dataList.add(cursor.getString(4));
                    dataList.add(cursor.getString(5));
                    dataArrays.add(dataList);
                }
                while (cursor.moveToNext());
            }
            cursor.close();
        } catch (SQLException e) {
            Log.e("DB Error", e.toString());
            e.printStackTrace();
        }
        return dataArrays;
    }

    public ArrayList<ArrayList<Object>> getAllDataHistory() {
        ArrayList<ArrayList<Object>> dataArrays = new ArrayList<ArrayList<Object>>();
        Cursor cursor = null;
        try {
            cursor = db.query(TABLE_HISTORY, new String[]{HISTORY_ID, CODE, ORDER_LIST, ORDER_TOTAL, DATE_TIME},
                    null, null, null, null, "id DESC");
            cursor.moveToFirst();
            if (!cursor.isAfterLast()) {
                do {
                    ArrayList<Object> dataList = new ArrayList<Object>();
                    dataList.add(cursor.getLong(0));
                    dataList.add(cursor.getString(1));
                    dataList.add(cursor.getString(2));
                    dataList.add(cursor.getString(3));
                    dataList.add(cursor.getString(4));
                    dataArrays.add(dataList);
                }
                while (cursor.moveToNext());
            }
            cursor.close();
        } catch (SQLException e) {
            Log.e("DB Error", e.toString());
            e.printStackTrace();
        }
        return dataArrays;
    }

    public boolean isDataExist(long id) {
        boolean exist = false;
        Cursor cursor = null;
        try {
            cursor = db.query(TABLE_CART, new String[]{CART_ID}, CART_ID + "=" + id, null, null, null, null);
            if (cursor.getCount() > 0) {
                exist = true;
            }
            cursor.close();
        } catch (SQLException e) {
            Log.e("DB Error", e.toString());
            e.printStackTrace();
        }
        return exist;
    }

    public boolean isDataHistoryExist(long id) {
        boolean exist = false;
        Cursor cursor = null;
        try {
            cursor = db.query(TABLE_HISTORY, new String[]{HISTORY_ID}, HISTORY_ID + "=" + id, null, null, null, null);
            if (cursor.getCount() > 0) {
                exist = true;
            }
            cursor.close();
        } catch (SQLException e) {
            Log.e("DB Error", e.toString());
            e.printStackTrace();
        }
        return exist;
    }

    public boolean isPreviousDataExist() {
        boolean exist = false;
        Cursor cursor = null;
        try {
            cursor = db.query(TABLE_CART, new String[]{CART_ID}, null, null, null, null, null);
            if (cursor.getCount() > 0) {
                exist = true;
            }
            cursor.close();
        } catch (SQLException e) {
            Log.e("DB Error", e.toString());
            e.printStackTrace();
        }

        return exist;
    }

    public void addData(long id, String product_name, int quantity, double total_price, String product_image, String date_time) {
        ContentValues values = new ContentValues();
        values.put(CART_ID, id);
        values.put(PRODUCT_NAME, product_name);
        values.put(QUANTITY, quantity);
        values.put(TOTAL_PRICE, total_price);
        values.put(PRODUCT_IMAGE, product_image);
        values.put(PRODUCT_DATE, date_time);
        try {
            db.insert(TABLE_CART, null, values);
        } catch (Exception e) {
            Log.e("DB ERROR", e.toString());
            e.printStackTrace();
        }
    }

    public void addDataHistory(String code, String order_list, String order_total, String date_time) {
        ContentValues values = new ContentValues();
        values.put(CODE, code);
        values.put(ORDER_LIST, order_list);
        values.put(ORDER_TOTAL, order_total);
        values.put(DATE_TIME, date_time);
        try {
            db.insert(TABLE_HISTORY, null, values);
        } catch (Exception e) {
            Log.e("DB ERROR", e.toString());
            e.printStackTrace();
        }
    }

    public void deleteData(long id) {
        try {
            db.delete(TABLE_CART, CART_ID + "=" + id, null);
        } catch (Exception e) {
            Log.e("DB ERROR", e.toString());
            e.printStackTrace();
        }
    }

    public void deleteDataHistory(long id) {
        try {
            db.delete(TABLE_HISTORY, HISTORY_ID + "=" + id, null);
        } catch (Exception e) {
            Log.e("DB ERROR", e.toString());
            e.printStackTrace();
        }
    }

    public void deleteAllData() {
        try {
            db.delete(TABLE_CART, null, null);
        } catch (Exception e) {
            Log.e("DB ERROR", e.toString());
            e.printStackTrace();
        }
    }

    public void deleteAllDataHistory() {
        try {
            db.delete(TABLE_HISTORY, null, null);
        } catch (Exception e) {
            Log.e("DB ERROR", e.toString());
            e.printStackTrace();
        }
    }

    public void updateData(long id, int quantity, double total_price) {
        ContentValues values = new ContentValues();
        values.put(QUANTITY, quantity);
        values.put(TOTAL_PRICE, total_price);
        try {
            db.update(TABLE_CART, values, CART_ID + "=" + id, null);
        } catch (Exception e) {
            Log.e("DB Error", e.toString());
            e.printStackTrace();
        }
    }

}