hGRNZyrm

1bdutils
2
3
4public class DataBaseUtils {
5    private static boolean isExists(SQLiteDatabase database, String primaryKeyValue, String tableName,
6                                    String primaryKey) {
7        boolean isExists = false;
8        Cursor cursor = database.query(tableName, null, primaryKey + "=?", new String[]{"" + primaryKeyValue}, null,
9                null, null);
10        if (cursor != null) {
11            if (cursor.getCount() > 0) {
12                isExists = true;
13            }
14        }
15        cursor.close();
16        return isExists;
17    }
18    public static void insertUserDetails(Context context, ModelLoginResponse loginResponse) {
19        SQLiteDatabase database = DatabaseOpenHelper.getInstance(context);
20        database.beginTransaction();
21
22        try {
23            ModelUser userDetails = loginResponse.getUser();
24            ContentValues values = new ContentValues();
25            values.put(DatabaseTableHelper.User.USER_ID, userDetails.getUserId());
26            values.put(DatabaseTableHelper.User.PASSWORD, userDetails.getPassword());
27            values.put(DatabaseTableHelper.User.TMID, userDetails.getTmID());
28            values.put(DatabaseTableHelper.User.RGM, userDetails.getRegMobileNum());
29            if (!isExists(database, userDetails.getUserId(), DatabaseTableHelper.User.TABLE_NAME,
30                    DatabaseTableHelper.User.USER_ID)) {
31                database.insert(DatabaseTableHelper.User.TABLE_NAME, null, values);
32            } else {
33                database.update(DatabaseTableHelper.User.TABLE_NAME, values, DatabaseTableHelper.User.USER_ID + "=?",
34                        new String[]{userDetails.getUserId()});
35            }
36        } catch (Exception e) {
37            Logger.log(e);
38        }
39
40        database.setTransactionSuccessful();
41        database.endTransaction();
42    }
43
44private static String getParamValues(String serverOfferID,Context context) {
45        String paramValue ="";
46        SQLiteDatabase database = DatabaseOpenHelper.getInstance(context);
47        String query = "Select * from " + DatabaseTableHelper.Offers.TABLE_NAME + " where " + DatabaseTableHelper.Offers.SERVEROFFERID  +" = '" + serverOfferID+"'";
48        Cursor cursor = database.rawQuery(query, null);
49        if (cursor != null) {
50            if (cursor.getCount() > 0) {
51                cursor.moveToFirst();
52                paramValue = cursor.getString(cursor.getColumnIndex(DatabaseTableHelper.Offers.PARAM_VALUES));
53            }
54        }
55        cursor.close();
56        return paramValue;
57    }
58
59}
60///////////////////////////////////////////////////////////////////
61dbopenhelper
62public class DatabaseOpenHelper extends SQLiteOpenHelper {
63
64    private static DatabaseOpenHelper _instance;
65    private static SQLiteDatabase _database;
66
67    private DatabaseOpenHelper(Context context) {
68        super(context, DatabaseHelper.DATABASE_NAME, null, DatabaseHelper.DATABASE_VERSION_4);
69
70    }
71
72    public static SQLiteDatabase getInstance(Context context) {
73        if (_instance == null) {
74            _instance = new DatabaseOpenHelper(context);
75        }
76        if (_database == null) {
77            _database = _instance.getWritableDatabase();
78        }
79        return _database;
80    }
81    @Override
82    public void onCreate(SQLiteDatabase db) {
83        if (!db.isReadOnly()) {
84            db.execSQL("PRAGMA foreign_keys=ON;");
85        }
86
87        // Create User Table;
88        db.execSQL("CREATE TABLE IF NOT EXISTS "
89                + DatabaseTableHelper.User.TABLE_NAME + " ("
90                + DatabaseTableHelper.User.USER_ID + " TEXT, "
91                + DatabaseTableHelper.User.PASSWORD + " TEXT, "
92                + DatabaseTableHelper.User.RGM + " TEXT, "
93                + DatabaseTableHelper.User.TMID + " TEXT )");
94
95        try {
96            db.execSQL("CREATE TABLE IF NOT EXISTS " + DatabaseTableHelper.OrderTypes.TABLE_NAME + " ("
97                    + DatabaseTableHelper.OrderTypes.ORDER_TYPES + " TEXT,"
98                    + DatabaseTableHelper.OrderTypes.ORDER_TYPE_CODE + " TEXT) "
99            );
100        }catch(Exception e){}
101    }
102
103    @Override
104    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
105        if(newVersion == DatabaseHelper.DATABASE_VERSION_2){
106            runVersion2Script(db,1);
107        }
108    }
109    private void runVersion2Script(SQLiteDatabase db, int oldVersion) {
110
111        try {
112            String modifyCommodityMasterTable = "ALTER TABLE " + DatabaseTableHelper.OrderTypes.TABLE_NAME + " ADD COLUMN "
113                    + DatabaseTableHelper.OrderTypes.ORDER_TYPE_CODE + " TEXT ";
114            db.execSQL(modifyCommodityMasterTable);
115        } catch (SQLException e) {
116        }
117
118    }
119
120    public interface DatabaseHelper {
121        String DATABASE_NAME = "NeMLDirectSell.db3";
122        //public final String DATABASE_NAME = Environment.getExternalStorageDirectory().getAbsolutePath()+"/Aishwarya/NeMLDirectSell.db3";
123        int DATABASE_VERSION_1 = 1;
124        int DATABASE_VERSION_2 = 2;
125        int DATABASE_VERSION_3 = 3;
126        int DATABASE_VERSION_4= 4;
127    }
128}
129
130/////////////////////////////////////////////////////////////////
131dbtable helper
132
133public class DatabaseTableHelper {
134
135    public interface User {
136        String TABLE_NAME = "User";
137        String USER_ID = "UserID";
138        String PASSWORD = "Password";
139        String RGM = "RegisteredMobileNumber";
140        String TMID = "TMID";
141    }
142
143    public interface OrderTypes{
144        String TABLE_NAME = "OrderTypes";
145        String ORDER_TYPES = "OrderType";
146        String ORDER_TYPE_CODE="OrderTypeCode";
147
148    }
149}