private void copyOldData() { SharedPreferences preferences = null; try { preferences = getSharedPreferences("tests", 0); } catch (Exception e) { } if (preferences != null) { DatabaseHelper db = new DatabaseHelper(this); try { db.openDataBase(true); } catch (SQLException e) { e.printStackTrace(); } for (int i = 1; i <= 62; ++i) { String name = "Test" + String.valueOf(i); String percent = preferences.getString(name, null); if (percent != null) { int progress = Integer.parseInt(percent.substring(0, percent.length() - 1)); if (progress != db.getTests().get(i - 1).getProgress()) db.updateProgress(i, progress); } } db.close(); preferences.edit().clear().commit(); } }
private void copyBetweenDatabases() { DatabaseHelper dbHelper = new DatabaseHelper(this); try { dbHelper.openDataBase(false); } catch (SQLException e) { e.printStackTrace(); } List<TestContainer> list = dbHelper.getTests(); dbHelper.close(); DatabaseHelper.DB_NAME = DatabaseHelper.DB_NAME.equals(DatabaseHelper.DB_AM) ? DatabaseHelper.DB_RU : DatabaseHelper.DB_AM; dbHelper = new DatabaseHelper(this); try { dbHelper.openDataBase(true); } catch (SQLException e) { e.printStackTrace(); } for (int i = 0; i < list.size(); i++) { int newDbProgress = dbHelper.getTests().get(i).getProgress(); int oldDbProgress = list.get(i).getProgress(); if (oldDbProgress != newDbProgress) { dbHelper.updateProgress(i + 1, oldDbProgress); } } dbHelper.close(); }
@Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); DatabaseHelper dbHelper = new DatabaseHelper(this); try { dbHelper.createDataBase(); dbHelper.openDataBase(false); } catch (IOException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } copyOldData(); dbHelper.close(); dialogLanguage(); setLocale(this); if (savedInstanceState != null) { position = savedInstanceState.getInt("position"); } setContentView(R.layout.activity_main); mPager = (ViewPager) findViewById(R.id.ViewPager_mainPager); mPager.setOffscreenPageLimit(2); mPager.setAdapter(new MFragmentAdapter(getSupportFragmentManager())); UnderlinePageIndicator indicator = (UnderlinePageIndicator) findViewById(R.id.CirclePageIndicator_indicator); indicator.setViewPager(mPager); SharedPreferences pref = getSharedPreferences("reset", 0); position = pref.getInt("position", 0); mPager.setCurrentItem(position); testIndicatorIcon = (ImageView) findViewById(R.id.indicator_Test); contentIndicatorIcon = (ImageView) findViewById(R.id.indicator_Content); schoolInidcatorIcon = (ImageView) findViewById(R.id.indicator_Schools); setTitleButtons(); testIndicatorIcon.setOnClickListener( new View.OnClickListener() { @Override public void onClick(View v) { mPager.setCurrentItem(0); setTitleButtons(); } }); contentIndicatorIcon.setOnClickListener( new View.OnClickListener() { @Override public void onClick(View v) { mPager.setCurrentItem(1); setTitleButtons(); } }); schoolInidcatorIcon.setOnClickListener( new View.OnClickListener() { @Override public void onClick(View v) { mPager.setCurrentItem(2); setTitleButtons(); } }); indicator.setOnPageChangeListener( new ViewPager.OnPageChangeListener() { @Override public void onPageScrolled( int position, float positionOffset, int positionOffsetPixels) {} @Override public void onPageSelected(int position) { setTitleButtons(); } @Override public void onPageScrollStateChanged(int state) {} }); }