· 6 years ago · Apr 21, 2019, 04:08 AM
1package com.example.surveyapp.RestAdapters;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.SQLException;
7import android.database.sqlite.SQLiteDatabase;
8import android.database.sqlite.SQLiteException;
9import android.database.sqlite.SQLiteOpenHelper;
10import android.util.Log;
11
12
13import com.example.surveyapp.PojoModel.Address;
14import com.example.surveyapp.PojoModel.Barangay;
15import com.example.surveyapp.PojoModel.Municipality;
16import com.example.surveyapp.PojoModel.Organization;
17import com.example.surveyapp.PojoModel.PeerAssigned;
18import com.example.surveyapp.PojoModel.PeerPartOne;
19import com.example.surveyapp.PojoModel.PeerPartThree;
20import com.example.surveyapp.PojoModel.PeerPartTwo;
21import com.example.surveyapp.PojoModel.Peers;
22import com.example.surveyapp.PojoModel.Province;
23import com.example.surveyapp.PojoModel.Questionnaire;
24import com.example.surveyapp.PojoModel.Region;
25import com.example.surveyapp.PojoModel.SelfAnswersFive;
26import com.example.surveyapp.PojoModel.SelfAnswersFour;
27import com.example.surveyapp.PojoModel.SelfAnswersOne;
28import com.example.surveyapp.PojoModel.SelfAnswersThree;
29import com.example.surveyapp.PojoModel.SelfAnswersTwo;
30import com.example.surveyapp.PojoModel.Selfs;
31import com.example.surveyapp.PojoModel.Users;
32
33import java.io.FileOutputStream;
34import java.io.IOException;
35import java.io.InputStream;
36import java.io.OutputStream;
37import java.util.ArrayList;
38import java.util.List;
39
40public class DatabaseHelper extends SQLiteOpenHelper {
41
42 public static final String DB_NAME = "leadership.db";
43 //public static final String TABLE_NAME = "leatra";
44 public static final String TABLE_PEERS = "peers";
45 public static final String TABLE_SELFS = "selfs";
46 public static final String TABLE_PEER_ASSIGNED = "peer_assigned";
47 public static final String TABLE_USERS = "users";
48 public static final String TABLE_PEER_PART_ONE = "peer_part_one";
49 public static final String TABLE_PEER_PART_TWO= "peer_part_two";
50 public static final String TABLE_PEER_PART_THREE = "peer_part_three";
51 public static final String TABLE_SELF_ANSWERS_ONE = "self_answers_one";
52 public static final String TABLE_SELF_ANSWERS_TWO = "self_answers_two";
53 public static final String TABLE_SELF_ANSWERS_THREE = "self_answers_three";
54 public static final String TABLE_SELF_ANSWERS_FOUR = "self_answers_four";
55 public static final String TABLE_SELF_ANSWERS_FIVE = "self_answers_five";
56 public static final String TABLE_QUESTIONNAIRE = "questionnaire";
57 public static final String TABLE_BARANGAY = "barangay";
58 public static final String TABLE_MUNICIPALITY = "municipality";
59 public static final String TABLE_PROVINCE = "province";
60 public static final String TABLE_REGION = "region";
61 public static final String TABLE_ORGANIZATION = "organization";
62 public static final String TABLE_QUESTIONS = "questions";
63 public static final String COLUMN_P1 = "p1_question";
64 public static final String COLUMN_P2 = "p2_question";
65 public static final String COLUMN_QID = "question_id";
66 public static final String COLUMN_USER_ID = "user_id";
67 public static final String COLUMN_USERNAME = "username";
68 public static final String COLUMN_PASSWORD = "password";
69 public static final String COLUMN_STATUS = "status";
70 public static final String TABLE_ANSWERS = "answers";
71 public static final String COLUMN_ANSWER1 = "answer1";
72 public static final String COLUMN_ANSWER2 = "answer2";
73 public static final String COLUMN_ANSWER3 = "answer3";
74 public static final String COLUMN_ANSWER4 = "answer4";
75 public static final String COLUMN_ANSWER5 = "answer5";
76 public static final String COLUMN_ID = "id";
77 public static final String COLUMN_NAME = "name";
78 public static final String COLUMN_EMAIL = "email";
79 public static final String COLUMN_USER_TYPE = "user_type";
80 public static final String COLUMN_COUNTRY_ID = "country_id";
81 public static final String COLUMN_LANGUAGE = "language";
82 public static final String COLUMN_SUB_ID = "sub_id";
83 public static final String COLUMN_FIRSTNAME = "firstname";
84 public static final String COLUMN_MIDDLENAME = "middlename";
85 public static final String COLUMN_LASTNAME = "lastname";
86 public static final String COLUMN_NICKNAME = "nickname";
87 public static final String COLUMN_COUNTRY = "country";
88 public static final String COLUMN_CONTACT_NUMBER = "contact_number";
89 public static final String COLUMN_BARANGAY_ID = "barangay_id";
90 public static final String COLUMN_MOBILE_NO = "mobile_no";
91 public static final String COLUMN_PEER_ID = "peer_id";
92 public static final String COLUMN_SELF_ID = "self_id";
93 public static final String COLUMN_SELF_ID_CODE = "self_id_code";
94 public static final String COLUMN_DATE_TAKE = "date_take";
95 public static final String COLUMN_RESULT1 = "result1";
96 public static final String COLUMN_RESULT2 = "result2";
97 public static final String COLUMN_RESULT3 = "result3";
98 public static final String COLUMN_RESULT4 = "result4";
99 public static final String COLUMN_RESULT5 = "result5";
100 public static final String COLUMN_RESULT6 = "result6";
101 public static final String COLUMN_RESULT7 = "result7";
102 public static final String COLUMN_RESULT8 = "result8";
103 public static final String COLUMN_RESULT9 = "result9";
104 public static final String COLUMN_RESULT10 = "result10";
105 public static final String COLUMN_RESULT11 = "result11";
106 public static final String COLUMN_RESULT12 = "result12";
107 public static final String COLUMN_RESULT13 = "result13";
108 public static final String COLUMN_RESULT14 = "result14";
109 public static final String COLUMN_RESULT15 = "result15";
110 public static final String COLUMN_RESULT16 = "result16";
111 public static final String COLUMN_RESULT17 = "result17";
112 public static final String COLUMN_RESULT18 = "result18";
113 public static final String COLUMN_RESULT19 = "result19";
114 public static final String COLUMN_RESULT20 = "result20";
115 public static final String COLUMN_IS_AGREE = "is_agree";
116 public static final String COLUMN_NUMBER = "number";
117 public static final String COLUMN_QUESTION = "question";
118 public static final String COLUMN_PART = "part";
119 public static final String COLUMN_TYPE = "type";
120 public static final String COLUMN_MUNICIPALITY_ID = "municipality_id";
121 public static final String COLUMN_AWS_MAIN = "aws_main";
122 public static final String COLUMN_AWS_SUMMARY = "aws_summary";
123 public static final String COLUMN_PROVINCE_ID = "province_id";
124 public static final String COLUMN_DESCRIPTION = "description";
125 public static final String COLUMN_REGION_ID = "region_id";
126 public static final String COLUMN_LONGITUDE = "longitude";
127 public static final String COLUMN_LATITUDE = "latitude";
128 public static final String COLUMN_OFFICE = "office";
129 public static final String COLUMN_ORGANIZATION = "organization";
130 public static final String COLUMN_MUNICIPALITY = "municipality";
131 public static final String COLUMN_PROVINCE = "province";
132 public static final String COLUMN_REGION = "region";
133 public static final String COLUMN_BARANGAY = "barangay";
134 public static final String COLUMN_ORGANIZATION_ID = "organization_id";
135 private static int DB_VERSION = 1;
136 private static String DB_PATH = "";
137 private Context context;
138 private SQLiteDatabase myDataBase;
139 public static final String DB_SUB_PATH = "/databases/" + DB_NAME;
140
141 public DatabaseHelper(Context context) {
142
143 super(context, DB_NAME, null, DB_VERSION = 1);
144 DB_PATH = context.getApplicationInfo().dataDir;
145 this.context = context;
146
147 }
148
149
150 public void copyDataBase() throws IOException {
151
152 //Open your local db as the input stream
153 InputStream myInput = context.getAssets().open(DB_NAME);
154
155 // Path to the just created empty db
156 String outFileName = DB_PATH + DB_SUB_PATH;
157 Log.d("db_path", outFileName);
158 //Open the empty db as the output stream
159 OutputStream myOutput = new FileOutputStream(outFileName);
160
161 //transfer bytes from the inputfile to the outputfile
162 byte[] buffer = new byte[1024];
163 int length;
164 while ((length = myInput.read(buffer))>0){
165 myOutput.write(buffer, 0, length);
166 }
167
168 //Close the streams
169 myOutput.flush();
170 myOutput.close();
171 myInput.close();
172
173 }
174
175 public void createDataBase() throws IOException{
176
177 boolean dbExist = checkDataBase();
178
179 if(dbExist){
180 //do nothing - database already exist
181 Log.d("check database", "createDataBase: already exist");
182 }else{
183
184 //By calling this method and empty database will be created into the default system path
185 //of your application so we are gonna be able to overwrite that database with our database.
186 this.getReadableDatabase();
187
188 try {
189 Log.d("check database", "createDataBase: copy database");
190 copyDataBase();
191
192 } catch (IOException e) {
193
194 throw new Error("Error copying database");
195
196 }
197 }
198
199 }
200
201 public boolean checkDataBase(){
202
203 SQLiteDatabase checkDB = null;
204
205 try{
206 String myPath = DB_PATH + DB_SUB_PATH;
207 checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);
208
209 }catch(SQLiteException e){
210
211 Log.d("check db", "checkDataBase: database not created yet");
212
213 }
214
215 if(checkDB != null){
216
217 checkDB.close();
218
219 }
220
221 return checkDB != null ? true : false;
222 }
223
224 public void openDataBase() throws SQLException{
225
226 //Open the database
227 String myPath = DB_PATH + DB_NAME;
228 myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);
229
230 }
231
232 @Override
233 public synchronized void close() {
234
235 if(myDataBase != null)
236 myDataBase.close();
237
238 super.close();
239
240 }
241
242 @Override
243 public void onCreate(SQLiteDatabase db) {
244 String create_users = "CREATE TABLE IF NOT EXISTS " + TABLE_USERS + "(" +
245 COLUMN_ID + " INTEGER PRIMARY KEY, " +
246 COLUMN_NAME + " VARCHAR, " +
247 COLUMN_EMAIL + " VARCHAR, " +
248 COLUMN_PASSWORD + " VARCHAR, " +
249 COLUMN_USER_TYPE + " VARCHAR, " +
250 COLUMN_COUNTRY_ID + " INTEGER, " +
251 COLUMN_LANGUAGE + " VARCHAR, " +
252 COLUMN_SUB_ID + " INTEGER);";
253
254 String create_selfs = "CREATE TABLE IF NOT EXISTS " + TABLE_SELFS + "(" +
255 COLUMN_ID + " INTEGER PRIMARY KEY, " +
256 COLUMN_SELF_ID_CODE + " VARCHAR, " +
257 COLUMN_FIRSTNAME + " VARCHAR, " +
258 COLUMN_MIDDLENAME + " VARCHAR, " +
259 COLUMN_LASTNAME + " VARCHAR, " +
260 COLUMN_NICKNAME + " VARCHAR, " +
261 COLUMN_COUNTRY + " INTEGER, " +
262 COLUMN_CONTACT_NUMBER + " VARCHAR, " +
263 COLUMN_EMAIL + " VARCHAR, " +
264 COLUMN_USER_ID + " INTEGER, " +
265 COLUMN_BARANGAY_ID + " INTEGER, " +
266 COLUMN_SUB_ID + " INTEGER, " +
267 COLUMN_ORGANIZATION_ID + " INTEGER);";
268
269 String create_peers = "CREATE TABLE IF NOT EXISTS " + TABLE_PEERS + "(" +
270 COLUMN_ID + " INTEGER PRIMARY KEY, " +
271 COLUMN_FIRSTNAME + " VARCHAR, " +
272 COLUMN_MIDDLENAME + " VARCHAR, " +
273 COLUMN_LASTNAME + " VARCHAR, " +
274 COLUMN_NICKNAME + " VARCHAR, " +
275 COLUMN_MOBILE_NO + " INTEGER, " +
276 COLUMN_EMAIL + " VARCHAR, " +
277 COLUMN_SUB_ID + " INTEGER, " +
278 COLUMN_USER_ID + " INTEGER, " +
279 COLUMN_BARANGAY_ID + " INTEGER, " +
280 COLUMN_ORGANIZATION_ID + " INTEGER);";
281
282 String create_peer_assigned = "CREATE TABLE IF NOT EXISTS " + TABLE_PEER_ASSIGNED + "(" +
283 COLUMN_ID + " INTEGER PRIMARY KEY, " +
284 COLUMN_PEER_ID + " INTEGER, " +
285 COLUMN_SELF_ID + " INTEGER);";
286
287 String create_peer_part1 = "CREATE TABLE IF NOT EXISTS " + TABLE_PEER_PART_ONE + "(" +
288 COLUMN_ID + " INTEGER PRIMARY KEY, " +
289 COLUMN_PEER_ID + " INTEGER, " +
290 COLUMN_SELF_ID + " INTEGER, " +
291 COLUMN_DATE_TAKE + " DATE, " +
292 COLUMN_RESULT1 + " INTEGER, " +
293 COLUMN_RESULT2 + " INTEGER, " +
294 COLUMN_RESULT3 + " INTEGER, " +
295 COLUMN_RESULT4 + " INTEGER, " +
296 COLUMN_RESULT5 + " INTEGER, " +
297 COLUMN_RESULT6 + " INTEGER, " +
298 COLUMN_RESULT7 + " INTEGER, " +
299 COLUMN_RESULT8 + " INTEGER, " +
300 COLUMN_RESULT9 + " INTEGER, " +
301 COLUMN_RESULT10 + " INTEGER, " +
302 COLUMN_RESULT11 + " INTEGER, " +
303 COLUMN_RESULT12 + " INTEGER, " +
304 COLUMN_RESULT13 + " INTEGER, " +
305 COLUMN_RESULT14 + " INTEGER, " +
306 COLUMN_RESULT15 + " INTEGER, " +
307 COLUMN_RESULT16 + " INTEGER, " +
308 COLUMN_RESULT17 + " INTEGER, " +
309 COLUMN_RESULT18 + " INTEGER, " +
310 COLUMN_RESULT19 + " INTEGER, " +
311 COLUMN_RESULT20 + " INTEGER, " +
312 COLUMN_SUB_ID + " INTEGER);";
313
314 String create_peer_part2 = "CREATE TABLE IF NOT EXISTS " + TABLE_PEER_PART_TWO + "(" +
315 COLUMN_ID + " INTEGER PRIMARY KEY, " +
316 COLUMN_PEER_ID + " INTEGER, " +
317 COLUMN_SELF_ID + " INTEGER, " +
318 COLUMN_DATE_TAKE + " DATE, " +
319 COLUMN_RESULT1 + " INTEGER, " +
320 COLUMN_RESULT2 + " INTEGER, " +
321 COLUMN_RESULT3 + " INTEGER, " +
322 COLUMN_RESULT4 + " INTEGER, " +
323 COLUMN_RESULT5 + " INTEGER, " +
324 COLUMN_RESULT6 + " INTEGER, " +
325 COLUMN_RESULT7 + " INTEGER, " +
326 COLUMN_RESULT8 + " INTEGER, " +
327 COLUMN_RESULT9 + " INTEGER, " +
328 COLUMN_RESULT10 + " INTEGER, " +
329 COLUMN_RESULT11 + " INTEGER, " +
330 COLUMN_RESULT12 + " INTEGER, " +
331 COLUMN_RESULT13 + " INTEGER, " +
332 COLUMN_RESULT14 + " INTEGER, " +
333 COLUMN_RESULT15 + " INTEGER, " +
334 COLUMN_RESULT16 + " INTEGER, " +
335 COLUMN_SUB_ID + " INTEGER);";
336
337 String create_peer_part3 ="CREATE TABLE IF NOT EXISTS " + TABLE_PEER_PART_THREE + "(" +
338 COLUMN_ID + " INTEGER PRIMARY KEY, " +
339 COLUMN_PEER_ID + " INTEGER, " +
340 COLUMN_SELF_ID + " INTEGER, " +
341 COLUMN_DATE_TAKE + " DATE, " +
342 COLUMN_RESULT1 + " INTEGER, " +
343 COLUMN_RESULT2 + " INTEGER, " +
344 COLUMN_RESULT3 + " INTEGER, " +
345 COLUMN_RESULT4 + " INTEGER, " +
346 COLUMN_RESULT5 + " INTEGER, " +
347 COLUMN_RESULT6 + " INTEGER, " +
348 COLUMN_RESULT7 + " INTEGER, " +
349 COLUMN_RESULT8 + " INTEGER, " +
350 COLUMN_RESULT9 + " INTEGER, " +
351 COLUMN_RESULT10 + " INTEGER, " +
352 COLUMN_RESULT11 + " INTEGER, " +
353 COLUMN_RESULT12 + " INTEGER, " +
354 COLUMN_RESULT13 + " INTEGER, " +
355 COLUMN_RESULT14 + " INTEGER, " +
356 COLUMN_RESULT15 + " INTEGER, " +
357 COLUMN_RESULT16 + " INTEGER, " +
358 COLUMN_SUB_ID + " INTEGER);";
359
360 String create_self_part1 = "CREATE TABLE IF NOT EXISTS " + TABLE_SELF_ANSWERS_ONE + "(" +
361 COLUMN_ID + " INTEGER PRIMARY KEY, " +
362 COLUMN_DATE_TAKE + " DATE, " +
363 COLUMN_SELF_ID + " INTEGER, " +
364 COLUMN_RESULT1 + " INTEGER, " +
365 COLUMN_RESULT2 + " INTEGER, " +
366 COLUMN_RESULT3 + " INTEGER, " +
367 COLUMN_RESULT4 + " INTEGER, " +
368 COLUMN_RESULT5 + " INTEGER, " +
369 COLUMN_RESULT6 + " INTEGER, " +
370 COLUMN_RESULT7 + " INTEGER, " +
371 COLUMN_RESULT8 + " INTEGER, " +
372 COLUMN_RESULT9 + " INTEGER, " +
373 COLUMN_RESULT10 + " INTEGER, " +
374 COLUMN_RESULT11 + " INTEGER, " +
375 COLUMN_RESULT12 + " INTEGER, " +
376 COLUMN_RESULT13 + " INTEGER, " +
377 COLUMN_RESULT14 + " INTEGER, " +
378 COLUMN_RESULT15 + " INTEGER, " +
379 COLUMN_RESULT16 + " INTEGER, " +
380 COLUMN_RESULT17 + " INTEGER, " +
381 COLUMN_RESULT18 + " INTEGER, " +
382 COLUMN_RESULT19 + " INTEGER, " +
383 COLUMN_RESULT20 + " INTEGER, " +
384 COLUMN_SUB_ID + " INTEGER);";
385
386 String create_self_part2 ="CREATE TABLE IF NOT EXISTS " + TABLE_SELF_ANSWERS_TWO + "(" +
387 COLUMN_ID + " INTEGER PRIMARY KEY, " +
388 COLUMN_DATE_TAKE + " DATE, " +
389 COLUMN_SELF_ID + " INTEGER, " +
390 COLUMN_RESULT1 + " INTEGER, " +
391 COLUMN_RESULT2 + " INTEGER, " +
392 COLUMN_RESULT3 + " INTEGER, " +
393 COLUMN_RESULT4 + " INTEGER, " +
394 COLUMN_RESULT5 + " INTEGER, " +
395 COLUMN_RESULT6 + " INTEGER, " +
396 COLUMN_RESULT7 + " INTEGER, " +
397 COLUMN_RESULT8 + " INTEGER, " +
398 COLUMN_RESULT9 + " INTEGER, " +
399 COLUMN_RESULT10 + " INTEGER, " +
400 COLUMN_RESULT11 + " INTEGER, " +
401 COLUMN_RESULT12 + " INTEGER, " +
402 COLUMN_RESULT13 + " INTEGER, " +
403 COLUMN_SUB_ID + " INTEGER);";
404
405 String create_self_part3 ="CREATE TABLE IF NOT EXISTS " + TABLE_SELF_ANSWERS_THREE + "(" +
406 COLUMN_ID + " INTEGER PRIMARY KEY, " +
407 COLUMN_DATE_TAKE + " DATE, " +
408 COLUMN_SELF_ID + " INTEGER, " +
409 COLUMN_RESULT1 + " INTEGER, " +
410 COLUMN_RESULT2 + " INTEGER, " +
411 COLUMN_RESULT3 + " INTEGER, " +
412 COLUMN_RESULT4 + " INTEGER, " +
413 COLUMN_RESULT5 + " INTEGER, " +
414 COLUMN_SUB_ID + " INTEGER);";
415
416 String create_self_part4 ="CREATE TABLE IF NOT EXISTS " + TABLE_SELF_ANSWERS_FOUR + "(" +
417 COLUMN_ID + " INTEGER PRIMARY KEY, " +
418 COLUMN_DATE_TAKE + " DATE, " +
419 COLUMN_SELF_ID + " INTEGER, " +
420 COLUMN_RESULT1 + " INTEGER, " +
421 COLUMN_RESULT2 + " INTEGER, " +
422 COLUMN_RESULT3 + " INTEGER, " +
423 COLUMN_RESULT4 + " INTEGER, " +
424 COLUMN_RESULT5 + " INTEGER, " +
425 COLUMN_RESULT6 + " INTEGER, " +
426 COLUMN_RESULT7 + " INTEGER, " +
427 COLUMN_RESULT8 + " INTEGER, " +
428 COLUMN_RESULT9 + " INTEGER, " +
429 COLUMN_RESULT10 + " INTEGER, " +
430 COLUMN_RESULT11 + " INTEGER, " +
431 COLUMN_RESULT12 + " INTEGER, " +
432 COLUMN_RESULT13 + " INTEGER, " +
433 COLUMN_RESULT14 + " INTEGER, " +
434 COLUMN_RESULT15 + " INTEGER, " +
435 COLUMN_RESULT16 + " INTEGER, " +
436 COLUMN_SUB_ID + " INTEGER);";
437
438 String create_self_part5 ="CREATE TABLE IF NOT EXISTS " + TABLE_SELF_ANSWERS_FIVE + "(" +
439 COLUMN_ID + " INTEGER PRIMARY KEY, " +
440 COLUMN_DATE_TAKE + " DATE, " +
441 COLUMN_SELF_ID + " INTEGER, " +
442 COLUMN_RESULT1 + " TEXT, " +
443 COLUMN_RESULT2 + " TEXT, " +
444 COLUMN_RESULT3 + " INTEGER, " +
445 COLUMN_RESULT4 + " TEXT, " +
446 COLUMN_RESULT5 + " TEXT, " +
447 COLUMN_RESULT6 + " INTEGER, " +
448 COLUMN_RESULT7 + " TEXT, " +
449 COLUMN_RESULT8 + " TEXT, " +
450 COLUMN_IS_AGREE + " VARCHAR, " +
451 COLUMN_SUB_ID + " INTEGER);";
452
453 String create_questionnaire ="CREATE TABLE IF NOT EXISTS " + TABLE_QUESTIONNAIRE + "(" +
454 COLUMN_ID + " INTEGER PRIMARY KEY, " +
455 COLUMN_NUMBER + " INTEGER, " +
456 COLUMN_QUESTION + " TEXT, " +
457 COLUMN_PART + " INTEGER, " +
458 COLUMN_TYPE + " VARCHAR, " +
459 COLUMN_LANGUAGE + " VARCHAR);";
460
461 String create_barangay ="CREATE TABLE IF NOT EXISTS " + TABLE_BARANGAY + "(" +
462 COLUMN_ID + " INTEGER PRIMARY KEY, " +
463 COLUMN_NAME + " VARCHAR, " +
464 COLUMN_MUNICIPALITY_ID + " INTEGER);";
465
466 String create_municipality ="CREATE TABLE IF NOT EXISTS " + TABLE_MUNICIPALITY + "(" +
467 COLUMN_ID + " INTEGER PRIMARY KEY, " +
468 COLUMN_NAME + " VARCHAR, " +
469 COLUMN_AWS_MAIN + " TEXT, " +
470 COLUMN_AWS_SUMMARY + " TEXT, " +
471 COLUMN_PROVINCE_ID + " INTEGER);";
472
473 String create_organization ="CREATE TABLE IF NOT EXISTS " + TABLE_ORGANIZATION + "(" +
474 COLUMN_ID + " INTEGER PRIMARY KEY, " +
475 COLUMN_DESCRIPTION + " VARCHAR, " +
476 COLUMN_SUB_ID + " INTEGER);";
477
478 String create_province ="CREATE TABLE IF NOT EXISTS " + TABLE_PROVINCE + "(" +
479 COLUMN_ID + " INTEGER PRIMARY KEY, " +
480 COLUMN_NAME + " VARCHAR, " +
481 COLUMN_REGION_ID + " INTEGER);";
482
483 String create_region ="CREATE TABLE IF NOT EXISTS " + TABLE_REGION + "(" +
484 COLUMN_ID + " INTEGER PRIMARY KEY, " +
485 COLUMN_NAME+ " VARCHAR, " +
486 COLUMN_LONGITUDE + " DECIMAL, " +
487 COLUMN_LATITUDE + " DECIMAL, " +
488 COLUMN_OFFICE + " VARCHAR);";
489
490
491
492 db.execSQL(create_users);
493 db.execSQL(create_peers);
494 db.execSQL(create_selfs);
495 db.execSQL(create_peer_assigned);
496 db.execSQL(create_peer_part1);
497 db.execSQL(create_peer_part2);
498 db.execSQL(create_peer_part3);
499 db.execSQL(create_self_part1);
500 db.execSQL(create_self_part2);
501 db.execSQL(create_self_part3);
502 db.execSQL(create_self_part3);
503 db.execSQL(create_self_part4);
504 db.execSQL(create_self_part5);
505 db.execSQL(create_questionnaire);
506 db.execSQL(create_barangay);
507 db.execSQL(create_municipality);
508 db.execSQL(create_organization);
509 db.execSQL(create_province);
510 db.execSQL(create_region);
511
512 }
513
514 @Override
515 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
516 String drop_users = "DROP TABLE IF EXISTS " + TABLE_USERS;
517 String drop_peers = "DROP TABLE IF EXISTS " + TABLE_PEERS;
518 String drop_selfs = "DROP TABLE IF EXISTS " + TABLE_SELFS;
519 String drop_peer_assigned = "DROP TABLE IF EXISTS " + TABLE_PEER_ASSIGNED;
520 String drop_peer_part_one = "DROP TABLE IF EXISTS " + TABLE_PEER_PART_ONE;
521 String drop_peer_part_two = "DROP TABLE IF EXISTS " + TABLE_PEER_PART_TWO;
522 String drop_peer_part_three = "DROP TABLE IF EXISTS " + TABLE_PEER_PART_THREE;
523 String drop_self_answers_one = "DROP TABLE IF EXISTS " + TABLE_SELF_ANSWERS_ONE;
524 String drop_self_answers_two = "DROP TABLE IF EXISTS " + TABLE_SELF_ANSWERS_TWO;
525 String drop_self_answers_three = "DROP TABLE IF EXISTS " + TABLE_SELF_ANSWERS_THREE;
526 String drop_self_answers_four = "DROP TABLE IF EXISTS " + TABLE_SELF_ANSWERS_FOUR;
527 String drop_self_answers_five = "DROP TABLE IF EXISTS " + TABLE_SELF_ANSWERS_FIVE;
528 String drop_questionnaire = "DROP TABLE IF EXISTS " + TABLE_QUESTIONNAIRE;
529 String drop_barangay = "DROP TABLE IF EXISTS " + TABLE_BARANGAY;
530 String drop_municipality = "DROP TABLE IF EXISTS " + TABLE_MUNICIPALITY;
531 String drop_organization = "DROP TABLE IF EXISTS " + TABLE_ORGANIZATION;
532 String drop_province = "DROP TABLE IF EXISTS " + TABLE_PROVINCE;
533 String drop_region = "DROP TABLE IF EXISTS " + TABLE_REGION;
534
535 db.execSQL(drop_users);
536 db.execSQL(drop_peers);
537 db.execSQL(drop_selfs);
538 db.execSQL(drop_peer_assigned);
539 db.execSQL(drop_peer_part_one);
540 db.execSQL(drop_peer_part_two);
541 db.execSQL(drop_peer_part_three);
542 db.execSQL(drop_self_answers_one);
543 db.execSQL(drop_self_answers_two);
544 db.execSQL(drop_self_answers_three);
545 db.execSQL(drop_self_answers_four);
546 db.execSQL(drop_self_answers_five);
547 db.execSQL(drop_questionnaire);
548 db.execSQL(drop_barangay);
549 db.execSQL(drop_municipality);
550 db.execSQL(drop_organization);
551 db.execSQL(drop_province);
552 db.execSQL(drop_region);
553
554 onCreate(db);
555 }
556
557 public void storeBarangayFromRemoteServer(List<Barangay.BarangayList> barangayLists){
558 SQLiteDatabase db = this.getReadableDatabase();
559 ContentValues values = new ContentValues();
560 for (int i = 0 ; i < barangayLists.size(); i++){
561 values.clear();
562 values.put(COLUMN_ID, barangayLists.get(i).getId());
563 values.put(COLUMN_NAME, barangayLists.get(i).getName());
564 values.put(COLUMN_MUNICIPALITY_ID, barangayLists.get(i).getMunicipality_id());
565 db.insert(TABLE_BARANGAY, null, values);
566 }
567 db.close();
568 }
569 public void storeMunicipalityFromRemoteServer(List<Municipality.MunicipalityList> municipalityLists){
570 SQLiteDatabase db = this.getReadableDatabase();
571 ContentValues values = new ContentValues();
572 for (int i = 0 ; i < municipalityLists.size(); i++){
573 values.clear();
574 values.put(COLUMN_ID, municipalityLists.get(i).getId());
575 values.put(COLUMN_NAME, municipalityLists.get(i).getName());
576 values.put(COLUMN_AWS_MAIN, municipalityLists.get(i).getAws_main());
577 values.put(COLUMN_AWS_SUMMARY, municipalityLists.get(i).getAws_summary());
578 values.put(COLUMN_PROVINCE_ID, municipalityLists.get(i).getProvince_id());
579 db.insert(TABLE_MUNICIPALITY, null, values);
580 }
581 db.close();
582 }
583 public void storeOrganizationFromRemoteServer(List<Organization.OrganizationList> organizationLists){
584 SQLiteDatabase db = this.getReadableDatabase();
585 ContentValues values = new ContentValues();
586 for (int i = 0 ; i < organizationLists.size(); i++){
587 values.clear();
588 values.put(COLUMN_ID, organizationLists.get(i).getId());
589 values.put(COLUMN_DESCRIPTION, organizationLists.get(i).getDescription());
590 values.put(COLUMN_SUB_ID, organizationLists.get(i).getSub_id());
591 db.insert(TABLE_ORGANIZATION, null, values);
592 }
593 db.close();
594 }
595 public void storeProvinceFromRemoteServer(List<Province.ProvinceList> provinceLists){
596 SQLiteDatabase db = this.getReadableDatabase();
597 ContentValues values = new ContentValues();
598 for (int i = 0 ; i < provinceLists.size(); i++){
599 values.clear();
600 values.put(COLUMN_ID, provinceLists.get(i).getId());
601 values.put(COLUMN_NAME, provinceLists.get(i).getName());
602 values.put(COLUMN_REGION_ID, provinceLists.get(i).getRegion_id());
603 db.insert(TABLE_PROVINCE, null, values);
604 }
605 db.close();
606 }
607 public void storeRegionFromRemoteServer(List<Region.RegionList> regionLists){
608 SQLiteDatabase db = this.getReadableDatabase();
609 ContentValues values = new ContentValues();
610 for (int i = 0 ; i < regionLists.size(); i++){
611 values.clear();
612 values.put(COLUMN_ID, regionLists.get(i).getId());
613 values.put(COLUMN_NAME, regionLists.get(i).getName());
614 values.put(COLUMN_LONGITUDE, regionLists.get(i).getLongitude());
615 values.put(COLUMN_LATITUDE, regionLists.get(i).getLatitude());
616 values.put(COLUMN_OFFICE, regionLists.get(i).getOffice());
617 db.insert(TABLE_REGION, null, values);
618 }
619 db.close();
620 }
621
622 public void storePeersFromRemoteServer(List<Peers.PeersList> peers){
623 SQLiteDatabase db = this.getReadableDatabase();
624 ContentValues values = new ContentValues();
625 for (int i = 0 ; i < peers.size(); i++){
626 values.clear();
627 values.put(COLUMN_ID, peers.get(i).getId());
628 values.put(COLUMN_FIRSTNAME, peers.get(i).getFirstname());
629 values.put(COLUMN_MIDDLENAME, peers.get(i).getMiddlename());
630 values.put(COLUMN_LASTNAME, peers.get(i).getLastname());
631 values.put(COLUMN_NICKNAME, peers.get(i).getNickname());
632 values.put(COLUMN_MOBILE_NO, peers.get(i).getMobile_no());
633 values.put(COLUMN_EMAIL, peers.get(i).getEmail());
634 values.put(COLUMN_SUB_ID, peers.get(i).getSub_id());
635 values.put(COLUMN_USER_ID, peers.get(i).getUser_id());
636 values.put(COLUMN_BARANGAY_ID, peers.get(i).getBarangay_id());
637 values.put(COLUMN_ORGANIZATION_ID, peers.get(i).getOrganization_id());
638 db.insert(TABLE_PEERS, null, values);
639 }
640 db.close();
641 }
642
643 public void storeSelfsFromRemoteServer(List<Selfs.SelfsList> selfs){
644 SQLiteDatabase db = this.getReadableDatabase();
645 ContentValues values = new ContentValues();
646 for (int i = 0 ; i < selfs.size(); i++){
647 values.clear();
648 values.put(COLUMN_ID, selfs.get(i).getId());
649 values.put(COLUMN_SELF_ID_CODE, selfs.get(i).getSelf_id_code());
650 values.put(COLUMN_FIRSTNAME, selfs.get(i).getFirstname());
651 values.put(COLUMN_MIDDLENAME, selfs.get(i).getMiddlename());
652 values.put(COLUMN_LASTNAME, selfs.get(i).getLastname());
653 values.put(COLUMN_NICKNAME, selfs.get(i).getNickname());
654 values.put(COLUMN_COUNTRY, selfs.get(i).getCountry());
655 values.put(COLUMN_CONTACT_NUMBER, selfs.get(i).getContact_number());
656 values.put(COLUMN_EMAIL, selfs.get(i).getEmail());
657 values.put(COLUMN_USER_ID, selfs.get(i).getUser_id());
658 values.put(COLUMN_BARANGAY_ID, selfs.get(i).getBarangay_id());
659 values.put(COLUMN_SUB_ID, selfs.get(i).getSub_id());
660 values.put(COLUMN_ORGANIZATION_ID, selfs.get(i).getOrganization_id());
661 db.insert(TABLE_SELFS, null, values);
662 }
663 db.close();
664 }
665
666 public void storePeerAssignedFromRemoteServer(List<PeerAssigned.PeerAssignedList> peerAssigneds){
667 SQLiteDatabase db = this.getReadableDatabase();
668 ContentValues values = new ContentValues();
669 for (int i = 0 ; i < peerAssigneds.size(); i++){
670 values.clear();
671 values.put(COLUMN_ID, peerAssigneds.get(i).getId());
672 values.put(COLUMN_PEER_ID, peerAssigneds.get(i).getPeer_id());
673 values.put(COLUMN_SELF_ID, peerAssigneds.get(i).getSelf_id());
674 db.insert(TABLE_PEER_ASSIGNED, null, values);
675 }
676 db.close();
677 }
678 public void storeUsersFromRemoteServer(List<Users> users){
679 SQLiteDatabase db = this.getReadableDatabase();
680 ContentValues values = new ContentValues();
681 for (int i = 0 ; i < users.size(); i++){
682 values.clear();
683 values.put(COLUMN_ID, users.get(i).getId());
684 values.put(COLUMN_NAME, users.get(i).getName());
685 values.put(COLUMN_EMAIL, users.get(i).getEmail());
686 values.put(COLUMN_PASSWORD, users.get(i).getPassword());
687 values.put(COLUMN_USER_TYPE, users.get(i).getUser_type());
688 values.put(COLUMN_COUNTRY_ID, users.get(i).getCountry_id());
689 values.put(COLUMN_LANGUAGE, users.get(i).getLanguage());
690 values.put(COLUMN_SUB_ID, users.get(i).getSub_id());
691 db.insert(TABLE_USERS, null, values);
692 }
693 db.close();
694 }
695
696 public void storePeerPartOneFromRemoteServer(List<PeerPartOne.PeerPartOneList> peerPartOneLists){
697 SQLiteDatabase db = this.getReadableDatabase();
698 ContentValues values = new ContentValues();
699 for (int i = 0 ; i < peerPartOneLists.size(); i++){
700 values.clear();
701 values.put(COLUMN_ID, peerPartOneLists.get(i).getId());
702 values.put(COLUMN_PEER_ID, peerPartOneLists.get(i).getPeer_id());
703 values.put(COLUMN_SELF_ID, peerPartOneLists.get(i).getSelf_id());
704 values.put(COLUMN_DATE_TAKE, peerPartOneLists.get(i).getDate_take());
705 values.put(COLUMN_RESULT1, peerPartOneLists.get(i).getResult1());
706 values.put(COLUMN_RESULT2, peerPartOneLists.get(i).getResult2());
707 values.put(COLUMN_RESULT3, peerPartOneLists.get(i).getResult3());
708 values.put(COLUMN_RESULT4, peerPartOneLists.get(i).getResult4());
709 values.put(COLUMN_RESULT5, peerPartOneLists.get(i).getResult5());
710 values.put(COLUMN_RESULT6, peerPartOneLists.get(i).getResult6());
711 values.put(COLUMN_RESULT7, peerPartOneLists.get(i).getResult7());
712 values.put(COLUMN_RESULT8, peerPartOneLists.get(i).getResult8());
713 values.put(COLUMN_RESULT9, peerPartOneLists.get(i).getResult9());
714 values.put(COLUMN_RESULT10, peerPartOneLists.get(i).getResult10());
715 values.put(COLUMN_RESULT11, peerPartOneLists.get(i).getResult11());
716 values.put(COLUMN_RESULT12, peerPartOneLists.get(i).getResult12());
717 values.put(COLUMN_RESULT13, peerPartOneLists.get(i).getResult13());
718 values.put(COLUMN_RESULT14, peerPartOneLists.get(i).getResult14());
719 values.put(COLUMN_RESULT15, peerPartOneLists.get(i).getResult15());
720 values.put(COLUMN_RESULT16, peerPartOneLists.get(i).getResult16());
721 values.put(COLUMN_RESULT17, peerPartOneLists.get(i).getResult17());
722 values.put(COLUMN_RESULT18, peerPartOneLists.get(i).getResult18());
723 values.put(COLUMN_RESULT19, peerPartOneLists.get(i).getResult19());
724 values.put(COLUMN_RESULT20, peerPartOneLists.get(i).getResult20());
725 values.put(COLUMN_SUB_ID, peerPartOneLists.get(i).getSub_id());
726 db.insert(TABLE_PEER_PART_ONE, null, values);
727 }
728 db.close();
729 }
730 public void storePeerPartTwoFromRemoteServer(List<PeerPartTwo.PeerPartTwoList> peerPartTwoLists){
731 SQLiteDatabase db = this.getReadableDatabase();
732 ContentValues values = new ContentValues();
733 for (int i = 0 ; i < peerPartTwoLists.size(); i++){
734 values.clear();
735 values.put(COLUMN_ID, peerPartTwoLists.get(i).getId());
736 values.put(COLUMN_PEER_ID, peerPartTwoLists.get(i).getPeer_id());
737 values.put(COLUMN_SELF_ID, peerPartTwoLists.get(i).getSelf_id());
738 values.put(COLUMN_DATE_TAKE, peerPartTwoLists.get(i).getDate_take());
739 values.put(COLUMN_RESULT1, peerPartTwoLists.get(i).getResult1());
740 values.put(COLUMN_RESULT2, peerPartTwoLists.get(i).getResult2());
741 values.put(COLUMN_RESULT3, peerPartTwoLists.get(i).getResult3());
742 values.put(COLUMN_RESULT4, peerPartTwoLists.get(i).getResult4());
743 values.put(COLUMN_RESULT5, peerPartTwoLists.get(i).getResult5());
744 values.put(COLUMN_RESULT6, peerPartTwoLists.get(i).getResult6());
745 values.put(COLUMN_RESULT7, peerPartTwoLists.get(i).getResult7());
746 values.put(COLUMN_RESULT8, peerPartTwoLists.get(i).getResult8());
747 values.put(COLUMN_RESULT9, peerPartTwoLists.get(i).getResult9());
748 values.put(COLUMN_RESULT10, peerPartTwoLists.get(i).getResult10());
749 values.put(COLUMN_RESULT11, peerPartTwoLists.get(i).getResult11());
750 values.put(COLUMN_RESULT12, peerPartTwoLists.get(i).getResult12());
751 values.put(COLUMN_RESULT13, peerPartTwoLists.get(i).getResult13());
752 values.put(COLUMN_SUB_ID, peerPartTwoLists.get(i).getSub_id());
753 db.insert(TABLE_PEER_PART_TWO, null, values);
754 }
755 db.close();
756 }
757 public void storePeerPartThreeFromRemoteServer(List<PeerPartThree.PeerPartThreeList> peerPartThreeLists){
758 SQLiteDatabase db = this.getReadableDatabase();
759 ContentValues values = new ContentValues();
760 for (int i = 0 ; i < peerPartThreeLists.size(); i++){
761 values.clear();
762 values.put(COLUMN_ID, peerPartThreeLists.get(i).getId());
763 values.put(COLUMN_PEER_ID, peerPartThreeLists.get(i).getPeer_id());
764 values.put(COLUMN_SELF_ID, peerPartThreeLists.get(i).getSelf_id());
765 values.put(COLUMN_DATE_TAKE, peerPartThreeLists.get(i).getDate_take());
766 values.put(COLUMN_RESULT1, peerPartThreeLists.get(i).getResult1());
767 values.put(COLUMN_RESULT2, peerPartThreeLists.get(i).getResult2());
768 values.put(COLUMN_RESULT3, peerPartThreeLists.get(i).getResult3());
769 values.put(COLUMN_RESULT4, peerPartThreeLists.get(i).getResult4());
770 values.put(COLUMN_RESULT5, peerPartThreeLists.get(i).getResult5());
771 values.put(COLUMN_RESULT6, peerPartThreeLists.get(i).getResult6());
772 values.put(COLUMN_RESULT7, peerPartThreeLists.get(i).getResult7());
773 values.put(COLUMN_RESULT8, peerPartThreeLists.get(i).getResult8());
774 values.put(COLUMN_RESULT9, peerPartThreeLists.get(i).getResult9());
775 values.put(COLUMN_RESULT10, peerPartThreeLists.get(i).getResult10());
776 values.put(COLUMN_RESULT11, peerPartThreeLists.get(i).getResult11());
777 values.put(COLUMN_RESULT12, peerPartThreeLists.get(i).getResult12());
778 values.put(COLUMN_RESULT13, peerPartThreeLists.get(i).getResult13());
779 values.put(COLUMN_SUB_ID, peerPartThreeLists.get(i).getSub_id());
780 db.insert(TABLE_PEER_PART_THREE, null, values);
781 }
782 db.close();
783 }
784 public void storeSelfAnswersOneFromRemoteServer(List<SelfAnswersOne.SelfAnswersOneList> selfAnswersOneLists){
785 SQLiteDatabase db = this.getReadableDatabase();
786 ContentValues values = new ContentValues();
787 for (int i = 0 ; i < selfAnswersOneLists.size(); i++){
788 values.clear();
789 values.put(COLUMN_ID, selfAnswersOneLists.get(i).getId());
790 values.put(COLUMN_DATE_TAKE, selfAnswersOneLists.get(i).getDate_take());
791 values.put(COLUMN_SELF_ID, selfAnswersOneLists.get(i).getSelf_id());
792 values.put(COLUMN_RESULT1, selfAnswersOneLists.get(i).getResult1());
793 values.put(COLUMN_RESULT2, selfAnswersOneLists.get(i).getResult2());
794 values.put(COLUMN_RESULT3, selfAnswersOneLists.get(i).getResult3());
795 values.put(COLUMN_RESULT4, selfAnswersOneLists.get(i).getResult4());
796 values.put(COLUMN_RESULT5, selfAnswersOneLists.get(i).getResult5());
797 values.put(COLUMN_RESULT6, selfAnswersOneLists.get(i).getResult6());
798 values.put(COLUMN_RESULT7, selfAnswersOneLists.get(i).getResult7());
799 values.put(COLUMN_RESULT8, selfAnswersOneLists.get(i).getResult8());
800 values.put(COLUMN_RESULT9, selfAnswersOneLists.get(i).getResult9());
801 values.put(COLUMN_RESULT10, selfAnswersOneLists.get(i).getResult10());
802 values.put(COLUMN_RESULT11, selfAnswersOneLists.get(i).getResult11());
803 values.put(COLUMN_RESULT12, selfAnswersOneLists.get(i).getResult12());
804 values.put(COLUMN_RESULT13, selfAnswersOneLists.get(i).getResult13());
805 values.put(COLUMN_RESULT14, selfAnswersOneLists.get(i).getResult14());
806 values.put(COLUMN_RESULT15, selfAnswersOneLists.get(i).getResult15());
807 values.put(COLUMN_RESULT16, selfAnswersOneLists.get(i).getResult16());
808 values.put(COLUMN_RESULT17, selfAnswersOneLists.get(i).getResult17());
809 values.put(COLUMN_RESULT18, selfAnswersOneLists.get(i).getResult18());
810 values.put(COLUMN_RESULT19, selfAnswersOneLists.get(i).getResult19());
811 values.put(COLUMN_RESULT20, selfAnswersOneLists.get(i).getResult20());
812 values.put(COLUMN_SUB_ID, selfAnswersOneLists.get(i).getSub_id());
813 db.insert(TABLE_SELF_ANSWERS_ONE, null, values);
814 }
815 db.close();
816 }
817 public void storeSelfAnswersTwoFromRemoteServer(List<SelfAnswersTwo.SelfAnswersTwoList> selfAnswersTwoLists) {
818 SQLiteDatabase db = this.getReadableDatabase();
819 ContentValues values = new ContentValues();
820 for (int i = 0; i < selfAnswersTwoLists.size(); i++) {
821 values.clear();
822 values.put(COLUMN_ID, selfAnswersTwoLists.get(i).getId());
823 values.put(COLUMN_DATE_TAKE, selfAnswersTwoLists.get(i).getDate_take());
824 values.put(COLUMN_SELF_ID, selfAnswersTwoLists.get(i).getSelf_id());
825 values.put(COLUMN_RESULT1, selfAnswersTwoLists.get(i).getResult1());
826 values.put(COLUMN_RESULT2, selfAnswersTwoLists.get(i).getResult2());
827 values.put(COLUMN_RESULT3, selfAnswersTwoLists.get(i).getResult3());
828 values.put(COLUMN_RESULT4, selfAnswersTwoLists.get(i).getResult4());
829 values.put(COLUMN_RESULT5, selfAnswersTwoLists.get(i).getResult5());
830 values.put(COLUMN_RESULT6, selfAnswersTwoLists.get(i).getResult6());
831 values.put(COLUMN_RESULT7, selfAnswersTwoLists.get(i).getResult7());
832 values.put(COLUMN_RESULT8, selfAnswersTwoLists.get(i).getResult8());
833 values.put(COLUMN_RESULT9, selfAnswersTwoLists.get(i).getResult9());
834 values.put(COLUMN_RESULT10, selfAnswersTwoLists.get(i).getResult10());
835 values.put(COLUMN_RESULT11, selfAnswersTwoLists.get(i).getResult11());
836 values.put(COLUMN_RESULT12, selfAnswersTwoLists.get(i).getResult12());
837 values.put(COLUMN_RESULT13, selfAnswersTwoLists.get(i).getResult13());
838 values.put(COLUMN_SUB_ID, selfAnswersTwoLists.get(i).getSub_id());
839 db.insert(TABLE_SELF_ANSWERS_TWO, null, values);
840 }
841 db.close();
842 }
843 public void storeSelfAnswersThreeFromRemoteServer(List<SelfAnswersThree.SelfAnswersThreeList> selfAnswersThreeLists){
844 SQLiteDatabase db = this.getReadableDatabase();
845 ContentValues values = new ContentValues();
846 for (int i = 0; i < selfAnswersThreeLists.size(); i++) {
847 values.clear();
848 values.put(COLUMN_ID, selfAnswersThreeLists.get(i).getId());
849 values.put(COLUMN_DATE_TAKE, selfAnswersThreeLists.get(i).getDate_take());
850 values.put(COLUMN_SELF_ID, selfAnswersThreeLists.get(i).getSelf_id());
851 values.put(COLUMN_RESULT1, selfAnswersThreeLists.get(i).getResult1());
852 values.put(COLUMN_RESULT2, selfAnswersThreeLists.get(i).getResult2());
853 values.put(COLUMN_RESULT3, selfAnswersThreeLists.get(i).getResult3());
854 values.put(COLUMN_RESULT4, selfAnswersThreeLists.get(i).getResult4());
855 values.put(COLUMN_RESULT5, selfAnswersThreeLists.get(i).getResult5());
856 values.put(COLUMN_SUB_ID, selfAnswersThreeLists.get(i).getSub_id());
857 db.insert(TABLE_SELF_ANSWERS_THREE, null, values);
858 }
859 db.close();
860 }
861 public void storeSelfAnswersFourFromRemoteServer(List<SelfAnswersFour.SelfAnswersFourList> selfAnswersFourLists) {
862 SQLiteDatabase db = this.getReadableDatabase();
863 ContentValues values = new ContentValues();
864 for (int i = 0; i < selfAnswersFourLists.size(); i++) {
865 values.clear();
866 values.put(COLUMN_ID, selfAnswersFourLists.get(i).getId());
867 values.put(COLUMN_DATE_TAKE, selfAnswersFourLists.get(i).getDate_take());
868 values.put(COLUMN_SELF_ID, selfAnswersFourLists.get(i).getSelf_id());
869 values.put(COLUMN_RESULT1, selfAnswersFourLists.get(i).getResult1());
870 values.put(COLUMN_RESULT2, selfAnswersFourLists.get(i).getResult2());
871 values.put(COLUMN_RESULT3, selfAnswersFourLists.get(i).getResult3());
872 values.put(COLUMN_RESULT4, selfAnswersFourLists.get(i).getResult4());
873 values.put(COLUMN_RESULT5, selfAnswersFourLists.get(i).getResult5());
874 values.put(COLUMN_RESULT6, selfAnswersFourLists.get(i).getResult6());
875 values.put(COLUMN_RESULT7, selfAnswersFourLists.get(i).getResult7());
876 values.put(COLUMN_RESULT8, selfAnswersFourLists.get(i).getResult8());
877 values.put(COLUMN_RESULT9, selfAnswersFourLists.get(i).getResult9());
878 values.put(COLUMN_RESULT10, selfAnswersFourLists.get(i).getResult10());
879 values.put(COLUMN_RESULT11, selfAnswersFourLists.get(i).getResult11());
880 values.put(COLUMN_RESULT12, selfAnswersFourLists.get(i).getResult12());
881 values.put(COLUMN_RESULT13, selfAnswersFourLists.get(i).getResult13());
882 values.put(COLUMN_SUB_ID, selfAnswersFourLists.get(i).getSub_id());
883 db.insert(TABLE_SELF_ANSWERS_FOUR, null, values);
884 }
885 db.close();
886 }
887 public void storeSelfAnswersFiveFromRemoteServer(List<SelfAnswersFive.SelfAnswersFiveList> selfAnswersFiveLists){
888 SQLiteDatabase db = this.getReadableDatabase();
889 ContentValues values = new ContentValues();
890 for (int i = 0; i < selfAnswersFiveLists.size(); i++) {
891 values.clear();
892 values.put(COLUMN_ID, selfAnswersFiveLists.get(i).getId());
893 values.put(COLUMN_DATE_TAKE, selfAnswersFiveLists.get(i).getDate_take());
894 values.put(COLUMN_SELF_ID, selfAnswersFiveLists.get(i).getSelf_id());
895 values.put(COLUMN_RESULT1, selfAnswersFiveLists.get(i).getResult1());
896 values.put(COLUMN_RESULT2, selfAnswersFiveLists.get(i).getResult2());
897 values.put(COLUMN_RESULT3, selfAnswersFiveLists.get(i).getResult3());
898 values.put(COLUMN_RESULT4, selfAnswersFiveLists.get(i).getResult4());
899 values.put(COLUMN_RESULT5, selfAnswersFiveLists.get(i).getResult5());
900 values.put(COLUMN_RESULT6, selfAnswersFiveLists.get(i).getResult6());
901 values.put(COLUMN_RESULT7, selfAnswersFiveLists.get(i).getResult7());
902 values.put(COLUMN_RESULT8, selfAnswersFiveLists.get(i).getResult8());
903 values.put(COLUMN_IS_AGREE, selfAnswersFiveLists.get(i).getIs_agree());
904 values.put(COLUMN_SUB_ID, selfAnswersFiveLists.get(i).getSub_id());
905 db.insert(TABLE_SELF_ANSWERS_FIVE, null, values);
906 }
907 db.close();
908 }
909
910 public void storePeerAnswersOneFromSurvey(List<PeerPartOne.PeerPartOneList> peerPartOneLists){
911 SQLiteDatabase db = this.getReadableDatabase();
912 ContentValues values = new ContentValues();
913 for (int i = 0 ; i < peerPartOneLists.size(); i++){
914 values.clear();
915 values.put(COLUMN_PEER_ID, peerPartOneLists.get(i).getPeer_id());
916 values.put(COLUMN_SELF_ID, peerPartOneLists.get(i).getSelf_id());
917 values.put(COLUMN_DATE_TAKE, peerPartOneLists.get(i).getDate_take());
918 values.put(COLUMN_RESULT1, peerPartOneLists.get(i).getResult1());
919 values.put(COLUMN_RESULT2, peerPartOneLists.get(i).getResult2());
920 values.put(COLUMN_RESULT3, peerPartOneLists.get(i).getResult3());
921 values.put(COLUMN_RESULT4, peerPartOneLists.get(i).getResult4());
922 values.put(COLUMN_RESULT5, peerPartOneLists.get(i).getResult5());
923 values.put(COLUMN_RESULT6, peerPartOneLists.get(i).getResult6());
924 values.put(COLUMN_RESULT7, peerPartOneLists.get(i).getResult7());
925 values.put(COLUMN_RESULT8, peerPartOneLists.get(i).getResult8());
926 values.put(COLUMN_RESULT9, peerPartOneLists.get(i).getResult9());
927 values.put(COLUMN_RESULT10, peerPartOneLists.get(i).getResult10());
928 values.put(COLUMN_RESULT11, peerPartOneLists.get(i).getResult11());
929 values.put(COLUMN_RESULT12, peerPartOneLists.get(i).getResult12());
930 values.put(COLUMN_RESULT13, peerPartOneLists.get(i).getResult13());
931 values.put(COLUMN_RESULT14, peerPartOneLists.get(i).getResult14());
932 values.put(COLUMN_RESULT15, peerPartOneLists.get(i).getResult15());
933 values.put(COLUMN_RESULT16, peerPartOneLists.get(i).getResult16());
934 values.put(COLUMN_RESULT17, peerPartOneLists.get(i).getResult17());
935 values.put(COLUMN_RESULT18, peerPartOneLists.get(i).getResult18());
936 values.put(COLUMN_RESULT19, peerPartOneLists.get(i).getResult19());
937 values.put(COLUMN_RESULT20, peerPartOneLists.get(i).getResult20());
938 values.put(COLUMN_SUB_ID, peerPartOneLists.get(i).getSub_id());
939 db.insert(TABLE_PEER_PART_ONE, null, values);
940 }
941 db.close();
942 }
943 public void storePeerAnswersTwoFromSurvey(List <PeerPartTwo.PeerPartTwoList> peerPartTwoLists){
944 SQLiteDatabase db = this.getReadableDatabase();
945 ContentValues values = new ContentValues();
946 for (int i = 0 ; i < peerPartTwoLists.size(); i++){
947 values.clear();
948 values.put(COLUMN_PEER_ID, peerPartTwoLists.get(i).getPeer_id());
949 values.put(COLUMN_SELF_ID, peerPartTwoLists.get(i).getSelf_id());
950 values.put(COLUMN_DATE_TAKE, peerPartTwoLists.get(i).getDate_take());
951 values.put(COLUMN_RESULT1, peerPartTwoLists.get(i).getResult1());
952 values.put(COLUMN_RESULT2, peerPartTwoLists.get(i).getResult2());
953 values.put(COLUMN_RESULT3, peerPartTwoLists.get(i).getResult3());
954 values.put(COLUMN_RESULT4, peerPartTwoLists.get(i).getResult4());
955 values.put(COLUMN_RESULT5, peerPartTwoLists.get(i).getResult5());
956 values.put(COLUMN_RESULT6, peerPartTwoLists.get(i).getResult6());
957 values.put(COLUMN_RESULT7, peerPartTwoLists.get(i).getResult7());
958 values.put(COLUMN_RESULT8, peerPartTwoLists.get(i).getResult8());
959 values.put(COLUMN_RESULT9, peerPartTwoLists.get(i).getResult9());
960 values.put(COLUMN_RESULT10, peerPartTwoLists.get(i).getResult10());
961 values.put(COLUMN_RESULT11, peerPartTwoLists.get(i).getResult11());
962 values.put(COLUMN_RESULT12, peerPartTwoLists.get(i).getResult12());
963 values.put(COLUMN_RESULT13, peerPartTwoLists.get(i).getResult13());
964 values.put(COLUMN_SUB_ID, peerPartTwoLists.get(i).getSub_id());
965 db.insert(TABLE_PEER_PART_TWO, null, values);
966 }
967 db.close();
968 }
969 public void storePeerAnswersThreeFromSurvey(List<PeerPartThree.PeerPartThreeList> peerPartThreeLists){
970 SQLiteDatabase db = this.getReadableDatabase();
971 ContentValues values = new ContentValues();
972 for (int i = 0 ; i < peerPartThreeLists.size(); i++){
973 values.clear();
974 values.put(COLUMN_PEER_ID, peerPartThreeLists.get(i).getPeer_id());
975 values.put(COLUMN_SELF_ID, peerPartThreeLists.get(i).getSelf_id());
976 values.put(COLUMN_DATE_TAKE, peerPartThreeLists.get(i).getDate_take());
977 values.put(COLUMN_RESULT1, peerPartThreeLists.get(i).getResult1());
978 values.put(COLUMN_RESULT2, peerPartThreeLists.get(i).getResult2());
979 values.put(COLUMN_RESULT3, peerPartThreeLists.get(i).getResult3());
980 values.put(COLUMN_RESULT4, peerPartThreeLists.get(i).getResult4());
981 values.put(COLUMN_RESULT5, peerPartThreeLists.get(i).getResult5());
982 values.put(COLUMN_RESULT6, peerPartThreeLists.get(i).getResult6());
983 values.put(COLUMN_RESULT7, peerPartThreeLists.get(i).getResult7());
984 values.put(COLUMN_RESULT8, peerPartThreeLists.get(i).getResult8());
985 values.put(COLUMN_RESULT9, peerPartThreeLists.get(i).getResult9());
986 values.put(COLUMN_RESULT10, peerPartThreeLists.get(i).getResult10());
987 values.put(COLUMN_RESULT11, peerPartThreeLists.get(i).getResult11());
988 values.put(COLUMN_RESULT12, peerPartThreeLists.get(i).getResult12());
989 values.put(COLUMN_RESULT13, peerPartThreeLists.get(i).getResult13());
990 values.put(COLUMN_SUB_ID, peerPartThreeLists.get(i).getSub_id());
991 db.insert(TABLE_PEER_PART_THREE, null, values);
992 }
993 db.close();
994 }
995 public void storeSelfAnswersOneFromSurvey(List<SelfAnswersOne.SelfAnswersOneList> selfAnswersOneLists){
996 SQLiteDatabase db = this.getReadableDatabase();
997 ContentValues values = new ContentValues();
998 for (int i = 0 ; i < selfAnswersOneLists.size(); i++){
999 values.clear();
1000 values.put(COLUMN_DATE_TAKE, selfAnswersOneLists.get(i).getDate_take());
1001 values.put(COLUMN_SELF_ID, selfAnswersOneLists.get(i).getSelf_id());
1002 values.put(COLUMN_RESULT1, selfAnswersOneLists.get(i).getResult1());
1003 values.put(COLUMN_RESULT2, selfAnswersOneLists.get(i).getResult2());
1004 values.put(COLUMN_RESULT3, selfAnswersOneLists.get(i).getResult3());
1005 values.put(COLUMN_RESULT4, selfAnswersOneLists.get(i).getResult4());
1006 values.put(COLUMN_RESULT5, selfAnswersOneLists.get(i).getResult5());
1007 values.put(COLUMN_RESULT6, selfAnswersOneLists.get(i).getResult6());
1008 values.put(COLUMN_RESULT7, selfAnswersOneLists.get(i).getResult7());
1009 values.put(COLUMN_RESULT8, selfAnswersOneLists.get(i).getResult8());
1010 values.put(COLUMN_RESULT9, selfAnswersOneLists.get(i).getResult9());
1011 values.put(COLUMN_RESULT10, selfAnswersOneLists.get(i).getResult10());
1012 values.put(COLUMN_RESULT11, selfAnswersOneLists.get(i).getResult11());
1013 values.put(COLUMN_RESULT12, selfAnswersOneLists.get(i).getResult12());
1014 values.put(COLUMN_RESULT13, selfAnswersOneLists.get(i).getResult13());
1015 values.put(COLUMN_RESULT14, selfAnswersOneLists.get(i).getResult14());
1016 values.put(COLUMN_RESULT15, selfAnswersOneLists.get(i).getResult15());
1017 values.put(COLUMN_RESULT16, selfAnswersOneLists.get(i).getResult16());
1018 values.put(COLUMN_RESULT17, selfAnswersOneLists.get(i).getResult17());
1019 values.put(COLUMN_RESULT18, selfAnswersOneLists.get(i).getResult18());
1020 values.put(COLUMN_RESULT19, selfAnswersOneLists.get(i).getResult19());
1021 values.put(COLUMN_RESULT20, selfAnswersOneLists.get(i).getResult20());
1022 values.put(COLUMN_SUB_ID, selfAnswersOneLists.get(i).getSub_id());
1023 db.insert(TABLE_SELF_ANSWERS_ONE, null, values);
1024 }
1025 db.close();
1026 }
1027 public void storeSelfAnswersTwoFromSurvey(List<SelfAnswersTwo.SelfAnswersTwoList> selfAnswersTwoLists){
1028 SQLiteDatabase db = this.getReadableDatabase();
1029 ContentValues values = new ContentValues();
1030 for (int i = 0; i < selfAnswersTwoLists.size(); i++) {
1031 values.clear();
1032 values.put(COLUMN_DATE_TAKE, selfAnswersTwoLists.get(i).getDate_take());
1033 values.put(COLUMN_SELF_ID, selfAnswersTwoLists.get(i).getSelf_id());
1034 values.put(COLUMN_RESULT1, selfAnswersTwoLists.get(i).getResult1());
1035 values.put(COLUMN_RESULT2, selfAnswersTwoLists.get(i).getResult2());
1036 values.put(COLUMN_RESULT3, selfAnswersTwoLists.get(i).getResult3());
1037 values.put(COLUMN_RESULT4, selfAnswersTwoLists.get(i).getResult4());
1038 values.put(COLUMN_RESULT5, selfAnswersTwoLists.get(i).getResult5());
1039 values.put(COLUMN_RESULT6, selfAnswersTwoLists.get(i).getResult6());
1040 values.put(COLUMN_RESULT7, selfAnswersTwoLists.get(i).getResult7());
1041 values.put(COLUMN_RESULT8, selfAnswersTwoLists.get(i).getResult8());
1042 values.put(COLUMN_RESULT9, selfAnswersTwoLists.get(i).getResult9());
1043 values.put(COLUMN_RESULT10, selfAnswersTwoLists.get(i).getResult10());
1044 values.put(COLUMN_RESULT11, selfAnswersTwoLists.get(i).getResult11());
1045 values.put(COLUMN_RESULT12, selfAnswersTwoLists.get(i).getResult12());
1046 values.put(COLUMN_RESULT13, selfAnswersTwoLists.get(i).getResult13());
1047 values.put(COLUMN_SUB_ID, selfAnswersTwoLists.get(i).getSub_id());
1048 db.insert(TABLE_SELF_ANSWERS_TWO, null, values);
1049 }
1050 db.close();
1051 }
1052 public void storeSelfAnswersThreeFromSurvey(List<SelfAnswersThree.SelfAnswersThreeList> selfAnswersThreeLists){
1053 SQLiteDatabase db = this.getReadableDatabase();
1054 ContentValues values = new ContentValues();
1055 for (int i = 0; i < selfAnswersThreeLists.size(); i++) {
1056 values.clear();
1057 values.put(COLUMN_DATE_TAKE, selfAnswersThreeLists.get(i).getDate_take());
1058 values.put(COLUMN_SELF_ID, selfAnswersThreeLists.get(i).getSelf_id());
1059 values.put(COLUMN_RESULT1, selfAnswersThreeLists.get(i).getResult1());
1060 values.put(COLUMN_RESULT2, selfAnswersThreeLists.get(i).getResult2());
1061 values.put(COLUMN_RESULT3, selfAnswersThreeLists.get(i).getResult3());
1062 values.put(COLUMN_RESULT4, selfAnswersThreeLists.get(i).getResult4());
1063 values.put(COLUMN_RESULT5, selfAnswersThreeLists.get(i).getResult5());
1064 values.put(COLUMN_SUB_ID, selfAnswersThreeLists.get(i).getSub_id());
1065 db.insert(TABLE_SELF_ANSWERS_THREE, null, values);
1066 }
1067 db.close();
1068 }
1069 public void storeSelfAnswersFourFromSurvey(List<SelfAnswersFour.SelfAnswersFourList> selfAnswersFourLists){
1070 SQLiteDatabase db = this.getReadableDatabase();
1071 ContentValues values = new ContentValues();
1072 for (int i = 0; i < selfAnswersFourLists.size(); i++) {
1073 values.clear();
1074 values.put(COLUMN_DATE_TAKE, selfAnswersFourLists.get(i).getDate_take());
1075 values.put(COLUMN_SELF_ID, selfAnswersFourLists.get(i).getSelf_id());
1076 values.put(COLUMN_RESULT1, selfAnswersFourLists.get(i).getResult1());
1077 values.put(COLUMN_RESULT2, selfAnswersFourLists.get(i).getResult2());
1078 values.put(COLUMN_RESULT3, selfAnswersFourLists.get(i).getResult3());
1079 values.put(COLUMN_RESULT4, selfAnswersFourLists.get(i).getResult4());
1080 values.put(COLUMN_RESULT5, selfAnswersFourLists.get(i).getResult5());
1081 values.put(COLUMN_RESULT6, selfAnswersFourLists.get(i).getResult6());
1082 values.put(COLUMN_RESULT7, selfAnswersFourLists.get(i).getResult7());
1083 values.put(COLUMN_RESULT8, selfAnswersFourLists.get(i).getResult8());
1084 values.put(COLUMN_RESULT9, selfAnswersFourLists.get(i).getResult9());
1085 values.put(COLUMN_RESULT10, selfAnswersFourLists.get(i).getResult10());
1086 values.put(COLUMN_RESULT11, selfAnswersFourLists.get(i).getResult11());
1087 values.put(COLUMN_RESULT12, selfAnswersFourLists.get(i).getResult12());
1088 values.put(COLUMN_RESULT13, selfAnswersFourLists.get(i).getResult13());
1089 values.put(COLUMN_SUB_ID, selfAnswersFourLists.get(i).getSub_id());
1090 db.insert(TABLE_SELF_ANSWERS_FOUR, null, values);
1091 }
1092 db.close();
1093 }
1094 public void storeSelfAnswersFiveFromSurvey(List<SelfAnswersFive.SelfAnswersFiveList> selfAnswersFiveLists){}
1095 public void storeQuestionnaireFromRemoteServer(List<Questionnaire.QuestionnaireList> questionnaireLists){
1096 SQLiteDatabase db = this.getReadableDatabase();
1097 ContentValues values = new ContentValues();
1098 for (int i = 0; i < questionnaireLists.size(); i++) {
1099 values.clear();
1100 values.put(COLUMN_ID, questionnaireLists.get(i).getId());
1101 values.put(COLUMN_NUMBER, questionnaireLists.get(i).getNumber());
1102 values.put(COLUMN_QUESTION, questionnaireLists.get(i).getQuestion());
1103 values.put(COLUMN_PART, questionnaireLists.get(i).getPart());
1104 values.put(COLUMN_TYPE, questionnaireLists.get(i).getType());
1105 values.put(COLUMN_LANGUAGE, questionnaireLists.get(i).getLanguage());
1106 db.insert(TABLE_QUESTIONNAIRE, null, values);
1107 }
1108 db.close();
1109 }
1110
1111 public boolean checkPeerAnswerOne(int peer_id, int self_id){
1112 SQLiteDatabase db = this.getReadableDatabase();
1113 Cursor cursor = db.rawQuery("SELECT * FROM peer_part_one WHERE peer_id = ? AND self_id = ? ", new String[]{String.valueOf(peer_id),String.valueOf(self_id)});
1114
1115 if(cursor!=null && cursor.getCount()>0){
1116 return true;
1117 }
1118 else{
1119 return false;
1120 }
1121 }
1122 public boolean checkPeerAnswerTwo(int peer_id, int self_id){
1123 SQLiteDatabase db = this.getReadableDatabase();
1124 Cursor cursor = db.rawQuery("SELECT * FROM peer_part_two WHERE peer_id = ? AND self_id = ? ", new String[]{String.valueOf(peer_id),String.valueOf(self_id)});
1125
1126 if(cursor!=null && cursor.getCount()>0){
1127 return true;
1128 }
1129 else{
1130 return false;
1131 }
1132 }
1133 public boolean checkPeerAnswerThree(int peer_id, int self_id){
1134 SQLiteDatabase db = this.getReadableDatabase();
1135 Cursor cursor = db.rawQuery("SELECT * FROM peer_part_three WHERE peer_id = ? AND self_id = ? ", new String[]{String.valueOf(peer_id),String.valueOf(self_id)});
1136
1137 if(cursor!=null && cursor.getCount()>0){
1138 return true;
1139 }
1140 else{
1141 return false;
1142 }
1143 }
1144
1145 public boolean checkSelfAnswerOne(int self_id){
1146 SQLiteDatabase db = this.getReadableDatabase();
1147 Cursor cursor = db.rawQuery("SELECT * FROM self_answers_one WHERE self_id = ?", new String[]{String.valueOf(self_id)});
1148
1149 if(cursor!=null && cursor.getCount()>0){
1150 return true;
1151 }
1152 else{
1153 return false;
1154 }
1155 }
1156
1157 public boolean checkSelfAnswerTwo(int self_id){
1158 SQLiteDatabase db = this.getReadableDatabase();
1159 Cursor cursor = db.rawQuery("SELECT * FROM self_answers_two WHERE self_id = ?", new String[]{String.valueOf(self_id)});
1160
1161 if(cursor!=null && cursor.getCount()>0){
1162 return true;
1163 }
1164 else{
1165 return false;
1166 }
1167 }
1168 public boolean checkSelfAnswerThree(int self_id){
1169 SQLiteDatabase db = this.getReadableDatabase();
1170 Cursor cursor = db.rawQuery("SELECT * FROM self_answers_three WHERE self_id = ?", new String[]{String.valueOf(self_id)});
1171
1172 if(cursor!=null && cursor.getCount()>0){
1173 return true;
1174 }
1175 else{
1176 return false;
1177 }
1178 }
1179 public boolean checkSelfAnswerFour(int self_id){
1180 SQLiteDatabase db = this.getReadableDatabase();
1181 Cursor cursor = db.rawQuery("SELECT * FROM self_answers_four WHERE self_id = ?", new String[]{String.valueOf(self_id)});
1182
1183 if(cursor!=null && cursor.getCount()>0){
1184 return true;
1185 }
1186 else{
1187 return false;
1188 }
1189 }
1190 public boolean checkSelfAnswerFive(int self_id){
1191 SQLiteDatabase db = this.getReadableDatabase();
1192 Cursor cursor = db.rawQuery("SELECT * FROM self_answers_five WHERE self_id = ?", new String[]{String.valueOf(self_id)});
1193
1194 if(cursor!=null && cursor.getCount()>0){
1195 return true;
1196 }
1197 else{
1198 return false;
1199 }
1200 }
1201
1202 public List<Peers.PeersList> peerProfile(int id){
1203 SQLiteDatabase db = this.getReadableDatabase();
1204 List<Peers.PeersList> peersLists = new ArrayList<>();
1205 Peers.PeersList mPeersList;
1206
1207 Cursor cursor = db.rawQuery("SELECT * FROM peers WHERE user_id = ?", new String[]{String.valueOf(id)});
1208 if (cursor != null){
1209
1210 while(cursor.moveToNext()){
1211 mPeersList = new Peers.PeersList(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)), cursor.getString(cursor.getColumnIndex(COLUMN_FIRSTNAME)),
1212 cursor.getString(cursor.getColumnIndex(COLUMN_MIDDLENAME)), cursor.getString(cursor.getColumnIndex(COLUMN_LASTNAME)),
1213 cursor.getString(cursor.getColumnIndex(COLUMN_NICKNAME)), cursor.getString(cursor.getColumnIndex(COLUMN_MOBILE_NO)),
1214 cursor.getString(cursor.getColumnIndex(COLUMN_EMAIL)), cursor.getInt(cursor.getColumnIndex(COLUMN_SUB_ID)),
1215 cursor.getInt(cursor.getColumnIndex(COLUMN_USER_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_BARANGAY_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_ORGANIZATION_ID)));
1216 peersLists.add(mPeersList);
1217 }
1218 cursor.close();
1219 db.close();
1220 }
1221 return peersLists;
1222 }
1223
1224
1225
1226 public List<Address.AddressList> PeerAddressLists(int peer_id){
1227 SQLiteDatabase db = this.getReadableDatabase();
1228 List<Address.AddressList> addressLists = new ArrayList<>();
1229 Address.AddressList mAddressList;
1230
1231 Cursor cursor = db.rawQuery(" SELECT p.id, p.firstname, p.middlename, p.lastname, o.description AS organization, b.name AS barangay, m.name AS municipality, pro.name AS province, r.name AS region, r.office FROM peers p \n" +
1232 "INNER JOIN organization o ON p.organization_id = o.id\n" +
1233 "INNER JOIN barangay b ON p.barangay_id = b.id\n" +
1234 "INNER JOIN municipality m ON b.municipality_id = m.id\n" +
1235 "INNER JOIN province pro ON m.province_id = pro.id\n" +
1236 "INNER JOIN region r ON pro.region_id = r.id\n" +
1237 "WHERE p.id = ?", new String[] {String.valueOf(peer_id)});
1238
1239 if (cursor != null){
1240 while(cursor.moveToNext()){
1241 mAddressList = new Address.AddressList(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)), cursor.getString(cursor.getColumnIndex(COLUMN_FIRSTNAME)),
1242 cursor.getString(cursor.getColumnIndex(COLUMN_MIDDLENAME)), cursor.getString(cursor.getColumnIndex(COLUMN_LASTNAME)),
1243 cursor.getString(cursor.getColumnIndex(COLUMN_ORGANIZATION)), cursor.getString(cursor.getColumnIndex(COLUMN_BARANGAY)),
1244 cursor.getString(cursor.getColumnIndex(COLUMN_MUNICIPALITY)), cursor.getString(cursor.getColumnIndex(COLUMN_PROVINCE)),
1245 cursor.getString(cursor.getColumnIndex(COLUMN_REGION)), cursor.getString(cursor.getColumnIndex(COLUMN_OFFICE)));
1246 addressLists.add(mAddressList);
1247 }
1248 cursor.close();
1249 db.close();
1250 }
1251 return addressLists;
1252 }
1253
1254 public List<Address.AddressList> SelfAddressList(int self_id){
1255 SQLiteDatabase db = this.getReadableDatabase();
1256 List<Address.AddressList> addressLists = new ArrayList<>();
1257 Address.AddressList mAddressList;
1258
1259 Cursor cursor = db.rawQuery(" SELECT s.id, s.firstname, s.middlename, s.lastname, o.description AS organization, b.name AS barangay, m.name AS municipality, pro.name AS province, r.name AS region, r.office FROM selfs s \n" +
1260 "INNER JOIN organization o ON s.organization_id = o.id\n" +
1261 "INNER JOIN barangay b ON s.barangay_id = b.id\n" +
1262 "INNER JOIN municipality m ON b.municipality_id = m.id\n" +
1263 "INNER JOIN province pro ON m.province_id = pro.id\n" +
1264 "INNER JOIN region r ON pro.region_id = r.id\n" +
1265 "WHERE s.id = ?", new String[] {String.valueOf(self_id)});
1266
1267 if (cursor != null){
1268 while(cursor.moveToNext()){
1269 mAddressList = new Address.AddressList(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)), cursor.getString(cursor.getColumnIndex(COLUMN_FIRSTNAME)),
1270 cursor.getString(cursor.getColumnIndex(COLUMN_MIDDLENAME)), cursor.getString(cursor.getColumnIndex(COLUMN_LASTNAME)),
1271 cursor.getString(cursor.getColumnIndex(COLUMN_ORGANIZATION)), cursor.getString(cursor.getColumnIndex(COLUMN_BARANGAY)),
1272 cursor.getString(cursor.getColumnIndex(COLUMN_MUNICIPALITY)), cursor.getString(cursor.getColumnIndex(COLUMN_PROVINCE)),
1273 cursor.getString(cursor.getColumnIndex(COLUMN_REGION)), cursor.getString(cursor.getColumnIndex(COLUMN_OFFICE)));
1274 addressLists.add(mAddressList);
1275 }
1276 cursor.close();
1277 db.close();
1278 }
1279 return addressLists;
1280 }
1281
1282
1283 public List<Selfs.SelfsList> selfProfile(int id){
1284 SQLiteDatabase db = this.getReadableDatabase();
1285 List<Selfs.SelfsList> selfsLists = new ArrayList<>();
1286 Selfs.SelfsList mSelfsList;
1287
1288 Cursor cursor = db.rawQuery("SELECT * FROM selfs WHERE id = ? ", new String[]{String.valueOf(id)});
1289 if (cursor != null){
1290 while(cursor.moveToNext()){
1291 mSelfsList = new Selfs.SelfsList(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)), cursor.getString(cursor.getColumnIndex(COLUMN_SELF_ID_CODE)),
1292 cursor.getString(cursor.getColumnIndex(COLUMN_FIRSTNAME)), cursor.getString(cursor.getColumnIndex(COLUMN_MIDDLENAME)),
1293 cursor.getString(cursor.getColumnIndex(COLUMN_LASTNAME)), cursor.getString(cursor.getColumnIndex(COLUMN_NICKNAME)),
1294 cursor.getString(cursor.getColumnIndex(COLUMN_COUNTRY)), cursor.getString(cursor.getColumnIndex(COLUMN_CONTACT_NUMBER)),
1295 cursor.getString(cursor.getColumnIndex(COLUMN_EMAIL)), cursor.getInt(cursor.getColumnIndex(COLUMN_USER_ID)),
1296 cursor.getInt(cursor.getColumnIndex(COLUMN_BARANGAY_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_SUB_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_ORGANIZATION_ID)));
1297 selfsLists.add(mSelfsList);
1298 }
1299 cursor.close();
1300 db.close();
1301 }
1302 return selfsLists;
1303 }
1304
1305 public List<Selfs.SelfsList> evaluateeProfile(int id){
1306 SQLiteDatabase db = this.getReadableDatabase();
1307 List<Selfs.SelfsList> selfsLists = new ArrayList<>();
1308 Selfs.SelfsList mSelfsList;
1309
1310 Cursor cursor = db.rawQuery("SELECT s.* FROM peer_assigned pa INNER JOIN selfs s ON pa.self_id = s.id WHERE pa.peer_id = ? ", new String[]{String.valueOf(id)});
1311 if (cursor != null){
1312 while(cursor.moveToNext()){
1313 mSelfsList = new Selfs.SelfsList(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)), cursor.getString(cursor.getColumnIndex(COLUMN_SELF_ID_CODE)),
1314 cursor.getString(cursor.getColumnIndex(COLUMN_FIRSTNAME)), cursor.getString(cursor.getColumnIndex(COLUMN_MIDDLENAME)),
1315 cursor.getString(cursor.getColumnIndex(COLUMN_LASTNAME)), cursor.getString(cursor.getColumnIndex(COLUMN_NICKNAME)),
1316 cursor.getString(cursor.getColumnIndex(COLUMN_COUNTRY)), cursor.getString(cursor.getColumnIndex(COLUMN_CONTACT_NUMBER)),
1317 cursor.getString(cursor.getColumnIndex(COLUMN_EMAIL)), cursor.getInt(cursor.getColumnIndex(COLUMN_USER_ID)),
1318 cursor.getInt(cursor.getColumnIndex(COLUMN_BARANGAY_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_SUB_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_ORGANIZATION_ID)));
1319 selfsLists.add(mSelfsList);
1320 }
1321 cursor.close();
1322 db.close();
1323 }
1324 return selfsLists;
1325 }
1326
1327 public List<Questionnaire.QuestionnaireList> questionnaireLists (String type, int part){
1328 SQLiteDatabase db = this.getReadableDatabase();
1329 List<Questionnaire.QuestionnaireList> questionnaireLists = new ArrayList<>();
1330 Questionnaire.QuestionnaireList mQuestionnaireList;
1331
1332 Cursor cursor = db.rawQuery("SELECT * FROM questionnaire WHERE type = ? AND part = ? ", new String[]{type, String.valueOf(part)});
1333 if (cursor != null){
1334 while(cursor.moveToNext()){
1335 mQuestionnaireList = new Questionnaire.QuestionnaireList(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)), cursor.getInt(cursor.getColumnIndex(COLUMN_NUMBER)),
1336 cursor.getString(cursor.getColumnIndex(COLUMN_QUESTION)), cursor.getInt(cursor.getColumnIndex(COLUMN_PART)),
1337 cursor.getString(cursor.getColumnIndex(COLUMN_TYPE)), cursor.getString(cursor.getColumnIndex(COLUMN_LANGUAGE)));
1338 questionnaireLists.add(mQuestionnaireList);
1339 }
1340 cursor.close();
1341 db.close();
1342 }
1343 return questionnaireLists;
1344 }
1345
1346}