Subversion Repositories SmartDukaan

package com.saholic.profittill.Database;

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

import org.apache.http.NameValuePair;
import org.apache.http.message.BasicNameValuePair;

import java.util.ArrayList;
import java.util.List;

public class OrderTransactionDetails extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "UrlTestData";
    public static final int DATABASE_VERSION = 2;
    ArrayList<NameValuePair> nameValuePairs;
    public OrderTransactionDetails(Context context){
        super(context, DATABASE_NAME, null, DATABASE_VERSION);

    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table "
                + "OrderDetails (user_id text not null, store_id not null, order_url text not null, sub_tag text null, rawhtml not null);");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      /*  db.execSQL("drop table HistroyData;");
        onCreate(db);*/
    }

    public long insertOrderDetails(ArrayList<NameValuePair> orderDetails){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        for (NameValuePair nvp:orderDetails){
            contentValues.put(nvp.getName(),nvp.getValue());
        }
        long x = db.insert("OrderDetails", null, contentValues);
        Log.d("inserting into database","Status " + x);
        return x;
    }

    public List<List<NameValuePair>> readData1(){
        SQLiteDatabase db = this.getReadableDatabase();
        List<List<NameValuePair>> orderDetails =  new ArrayList<List<NameValuePair>>();
        Cursor res =  db.rawQuery( "select user_id,store_id,order_url,sub_tag,rawhtml from OrderDetails", null );
        if (res.moveToFirst()) {
            do {
                List<NameValuePair> orderDetail=new ArrayList<>();
               /* Log.d("inserting into database","1 " + res.getString(0));
                Log.d("inserting into database","2 " + res.getString(1));
                Log.d("inserting into database","3 " + res.getString(2));
                Log.d("inserting into database","4 " + res.getString(3));
                Log.d("inserting into database","5 " + res.getString(4));*/
                orderDetail.add(new BasicNameValuePair("user_id",res.getString(0)));
                orderDetail.add(new BasicNameValuePair("store_id",res.getString(1)));
                orderDetail.add(new BasicNameValuePair("order_url",res.getString(2)));
                orderDetail.add(new BasicNameValuePair("sub_tag",res.getString(3)));
                orderDetail.add(new BasicNameValuePair("rawhtml",res.getString(4)));
                orderDetails.add(orderDetail);
                } while (res.moveToNext());
        }
        Log.d("Returning order size","Size " + orderDetails.size());
        return orderDetails;
    }

    public List<List<NameValuePair>> readData(){
        SQLiteDatabase db = this.getReadableDatabase();
        List<List<NameValuePair>> orderDetails =  new ArrayList<List<NameValuePair>>();
        Cursor res =  db.rawQuery( "select user_id,store_id,order_url,sub_tag,rawhtml from OrderDetails", null );
        if (res.moveToFirst()) {
            do {
                List<NameValuePair> orderDetail=new ArrayList<>();
               /* Log.d("inserting into database","1 " + res.getString(0));
                Log.d("inserting into database","2 " + res.getString(1));
                Log.d("inserting into database","3 " + res.getString(2));
                Log.d("inserting into database","4 " + res.getString(3));
                Log.d("inserting into database","5 " + res.getString(4));*/
                orderDetail.add(new BasicNameValuePair("user_id",res.getString(0)));
                orderDetail.add(new BasicNameValuePair("store_id",res.getString(1)));
                orderDetail.add(new BasicNameValuePair("order_url",res.getString(2)));
                orderDetail.add(new BasicNameValuePair("sub_tag",res.getString(3)));
                orderDetail.add(new BasicNameValuePair("rawhtml",res.getString(4)));
                orderDetails.add(orderDetail);
            } while (res.moveToNext());
        }
        return orderDetails;
    }


    public int countTotalRecords()
    {
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor res =  db.rawQuery( "select * from OrderDetails", null );
        return res.getCount();
    }

    public int deleterecords(){
        SQLiteDatabase db = this.getWritableDatabase();
        int status = db.delete("OrderDetails",null,null);
        if(status!=0)
            return 1;
        else
            return 0;
    }
    public int deleteRecord(String KEY_NAME, String[] KEY_VALUE){
        Log.d("Deleting item ","Items to be deleted"  + KEY_NAME + KEY_VALUE);
        SQLiteDatabase db = this.getWritableDatabase();
        return db.delete("OrderDetails",KEY_NAME + "=?",KEY_VALUE);

    }
}