Subversion Repositories SmartDukaan

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
21480 rajender 1 
package com.saholic.profittill.Database;
2 
 
3 
import android.content.ContentValues;
4 
import android.content.Context;
5 
import android.database.Cursor;
6 
import android.database.sqlite.SQLiteDatabase;
7 
import android.database.sqlite.SQLiteOpenHelper;
8 
import android.util.Log;
9 
 
10 
import org.apache.http.NameValuePair;
11 
import org.apache.http.message.BasicNameValuePair;
12 
 
13 
import java.util.ArrayList;
14 
import java.util.List;
15 
 
16 
public class OrderTransactionDetails extends SQLiteOpenHelper {
17 
    public static final String DATABASE_NAME = "UrlTestData";
18 
    public static final int DATABASE_VERSION = 2;
19 
    ArrayList<NameValuePair> nameValuePairs;
20 
    public OrderTransactionDetails(Context context){
21 
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
22 
 
23 
    }
24 
    @Override
25 
    public void onCreate(SQLiteDatabase db) {
26 
        db.execSQL("create table "
27 
                + "OrderDetails (user_id text not null, store_id not null, order_url text not null, sub_tag text null, rawhtml not null);");
28 
    }
29 
 
30 
    @Override
31 
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
32 
      /*  db.execSQL("drop table HistroyData;");
33 
        onCreate(db);*/
34 
    }
35 
 
36 
    public long insertOrderDetails(ArrayList<NameValuePair> orderDetails){
37 
        SQLiteDatabase db = this.getWritableDatabase();
38 
        ContentValues contentValues = new ContentValues();
39 
        for (NameValuePair nvp:orderDetails){
40 
            contentValues.put(nvp.getName(),nvp.getValue());
41 
        }
42 
        long x = db.insert("OrderDetails", null, contentValues);
43 
        Log.d("inserting into database","Status " + x);
44 
        return x;
45 
    }
46 
 
47 
    public List<List<NameValuePair>> readData1(){
48 
        SQLiteDatabase db = this.getReadableDatabase();
49 
        List<List<NameValuePair>> orderDetails =  new ArrayList<List<NameValuePair>>();
50 
        Cursor res =  db.rawQuery( "select user_id,store_id,order_url,sub_tag,rawhtml from OrderDetails", null );
51 
        if (res.moveToFirst()) {
52 
            do {
53 
                List<NameValuePair> orderDetail=new ArrayList<>();
54 
               /* Log.d("inserting into database","1 " + res.getString(0));
55 
                Log.d("inserting into database","2 " + res.getString(1));
56 
                Log.d("inserting into database","3 " + res.getString(2));
57 
                Log.d("inserting into database","4 " + res.getString(3));
58 
                Log.d("inserting into database","5 " + res.getString(4));*/
59 
                orderDetail.add(new BasicNameValuePair("user_id",res.getString(0)));
60 
                orderDetail.add(new BasicNameValuePair("store_id",res.getString(1)));
61 
                orderDetail.add(new BasicNameValuePair("order_url",res.getString(2)));
62 
                orderDetail.add(new BasicNameValuePair("sub_tag",res.getString(3)));
63 
                orderDetail.add(new BasicNameValuePair("rawhtml",res.getString(4)));
64 
                orderDetails.add(orderDetail);
65 
                } while (res.moveToNext());
66 
        }
67 
        Log.d("Returning order size","Size " + orderDetails.size());
68 
        return orderDetails;
69 
    }
70 
 
71 
    public List<List<NameValuePair>> readData(){
72 
        SQLiteDatabase db = this.getReadableDatabase();
73 
        List<List<NameValuePair>> orderDetails =  new ArrayList<List<NameValuePair>>();
74 
        Cursor res =  db.rawQuery( "select user_id,store_id,order_url,sub_tag,rawhtml from OrderDetails", null );
75 
        if (res.moveToFirst()) {
76 
            do {
77 
                List<NameValuePair> orderDetail=new ArrayList<>();
78 
               /* Log.d("inserting into database","1 " + res.getString(0));
79 
                Log.d("inserting into database","2 " + res.getString(1));
80 
                Log.d("inserting into database","3 " + res.getString(2));
81 
                Log.d("inserting into database","4 " + res.getString(3));
82 
                Log.d("inserting into database","5 " + res.getString(4));*/
83 
                orderDetail.add(new BasicNameValuePair("user_id",res.getString(0)));
84 
                orderDetail.add(new BasicNameValuePair("store_id",res.getString(1)));
85 
                orderDetail.add(new BasicNameValuePair("order_url",res.getString(2)));
86 
                orderDetail.add(new BasicNameValuePair("sub_tag",res.getString(3)));
87 
                orderDetail.add(new BasicNameValuePair("rawhtml",res.getString(4)));
88 
                orderDetails.add(orderDetail);
89 
            } while (res.moveToNext());
90 
        }
91 
        return orderDetails;
92 
    }
93 
 
94 
 
95 
    public int countTotalRecords()
96 
    {
97 
        SQLiteDatabase db = this.getReadableDatabase();
98 
        Cursor res =  db.rawQuery( "select * from OrderDetails", null );
99 
        return res.getCount();
100 
    }
101 
 
102 
    public int deleterecords(){
103 
        SQLiteDatabase db = this.getWritableDatabase();
104 
        int status = db.delete("OrderDetails",null,null);
105 
        if(status!=0)
106 
            return 1;
107 
        else
108 
            return 0;
109 
    }
110 
    public int deleteRecord(String KEY_NAME, String[] KEY_VALUE){
111 
        Log.d("Deleting item ","Items to be deleted"  + KEY_NAME + KEY_VALUE);
112 
        SQLiteDatabase db = this.getWritableDatabase();
113 
        return db.delete("OrderDetails",KEY_NAME + "=?",KEY_VALUE);
114 
 
115 
    }
116 
}