API tools faq
paste
Advertisement
Guest User

databaseHelper

a guest
Apr 20th, 2019
294
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 72.42 KB | None | 0 0
raw download clone embed print report
  1. package com.example.surveyapp.RestAdapters;
  2.  
  3. import android.content.ContentValues;
  4. import android.content.Context;
  5. import android.database.Cursor;
  6. import android.database.SQLException;
  7. import android.database.sqlite.SQLiteDatabase;
  8. import android.database.sqlite.SQLiteException;
  9. import android.database.sqlite.SQLiteOpenHelper;
  10. import android.util.Log;
  11.  
  12.  
  13. import com.example.surveyapp.PojoModel.Address;
  14. import com.example.surveyapp.PojoModel.Barangay;
  15. import com.example.surveyapp.PojoModel.Municipality;
  16. import com.example.surveyapp.PojoModel.Organization;
  17. import com.example.surveyapp.PojoModel.PeerAssigned;
  18. import com.example.surveyapp.PojoModel.PeerPartOne;
  19. import com.example.surveyapp.PojoModel.PeerPartThree;
  20. import com.example.surveyapp.PojoModel.PeerPartTwo;
  21. import com.example.surveyapp.PojoModel.Peers;
  22. import com.example.surveyapp.PojoModel.Province;
  23. import com.example.surveyapp.PojoModel.Questionnaire;
  24. import com.example.surveyapp.PojoModel.Region;
  25. import com.example.surveyapp.PojoModel.SelfAnswersFive;
  26. import com.example.surveyapp.PojoModel.SelfAnswersFour;
  27. import com.example.surveyapp.PojoModel.SelfAnswersOne;
  28. import com.example.surveyapp.PojoModel.SelfAnswersThree;
  29. import com.example.surveyapp.PojoModel.SelfAnswersTwo;
  30. import com.example.surveyapp.PojoModel.Selfs;
  31. import com.example.surveyapp.PojoModel.Users;
  32.  
  33. import java.io.FileOutputStream;
  34. import java.io.IOException;
  35. import java.io.InputStream;
  36. import java.io.OutputStream;
  37. import java.util.ArrayList;
  38. import java.util.List;
  39.  
  40. public 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. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!