com.awt.supark.CarListFragment.java Source code

Introduction

Here is the source code for com.awt.supark.CarListFragment.java

Source

package com.awt.supark;

/**
 * Created by Mark on 11/4/2015.
 */

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.annotation.Nullable;
import android.support.v4.app.Fragment;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ListView;

import com.awt.supark.Adapter.CarListAdapter;
import com.awt.supark.Model.Car;

import java.util.ArrayList;

public class CarListFragment extends Fragment {

    public ArrayList<Car> carArray = new ArrayList<>();
    View view;
    ListView listview;
    CarListAdapter adapter;
    SQLiteDatabase db;

    @Nullable
    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
        view = inflater.inflate(R.layout.fragment_list_layout, container, false);
        listview = (ListView) view.findViewById(R.id.listview);

        // Creating database if it's not exist yet
        db = SQLiteDatabase.openDatabase(getContext().getFilesDir().getPath() + "/carDB.db", null,
                SQLiteDatabase.CREATE_IF_NECESSARY);

        //------------------------ Creating the car list ---------------------------
        Cursor d = db.rawQuery("SELECT * FROM cars", null);

        for (d.moveToFirst(); !d.isAfterLast(); d.moveToNext()) {
            Car car = new Car();

            car.setName(d.getString(d.getColumnIndex("car_name"))); // set name
            car.setLicens(d.getString(d.getColumnIndex("car_license"))); // set license
            car.setSqlid(d.getInt(d.getColumnIndex("car_id")));
            car.setGeneric(d.getInt(d.getColumnIndex("isgeneric")));

            // Retrieves the parking state of the car
            switch (d.getInt(d.getColumnIndex("parkedstate"))) {
            case 0:
                car.setState(getResources().getString(R.string.free));
                break;
            case 1:
                car.setState(getResources().getString(R.string.parked));
                break;
            }
            car.setRemaining(
                    (int) (d.getLong(d.getColumnIndex("parkeduntil")) - ((System.currentTimeMillis() / 1000L))));
            carArray.add(car);
        }

        d.close();
        db.close();

        // List adapter
        adapter = new CarListAdapter(getActivity(), carArray);

        // Turning off dividers
        listview.setDivider(null);
        listview.setDividerHeight(0);
        listview.setClipToPadding(false);
        listview.setPadding(0, 10, 0, 100);
        listview.setAdapter(adapter);

        return view;
    }

    // On exit we have to sync car data between this and main activity in order to keep everything up do date
    @Override
    public void onDestroyView() {
        super.onDestroyView();
        ((MainActivity) getActivity()).CarHandler.updateLicense(((MainActivity) getActivity()));
    }
}