Assignment 3 – Car Maintenance

Car Maintenance

Version: 0.1

By: James Burton

This program implements a database that keeps track of maintenance for your various vehicles. It can be used by an individual, a family, or a fleet/motor pool.

Add information into the tables on the screen. Each screen corresponds to a table in the schema.

Database Schema

Assignment3

Vehicle: Vehicle (e.g. Batmobile)

Item: Maintenance Item (e.g. Change the oil every 5000 miles or 6 months.)

Location: Service shop. (e.g. Jiffy Lube)

Receipt: All work done at a location, and date (e.g. Service at Jiffy Lube on 2/22/2014)

Work: Work performed (e.g. Change the oil as part of service done at Jiffy Lube on 2/22/2014 for Batmobile).

(Note: The menu option Create Data on the main screen creates a sample database for testing purposes.)

Download

Source: https://github.com/jdburton/CarMaintenance

Latest Binary: https://github.com/jdburton/CarMaintenance/blob/master/bin/CarMaintenance.apk

Screenshots

Home Screen

Home Screen

Vehicle Screen

Vehicle Screen

Work screen. Note Spinner button for item selection.

Work screen. Note Spinner button for item selection.

Screen Shot 2014-02-22 at 10.28.20 PM

New Row Added (From (+) icon in the Action bar)

New Row Saved. (Note Change in from Clear to Delete.)

New Row Saved. (Note Change in from Clear to Delete.)

Table Filtered by Spinner

Table Filtered by Spinner

Delete all table entries. (Trash icon in menu bar.)

Delete all table entries. (Trash icon in menu bar.)

Receipt view filtered by spinner. Note image in view.

Receipt view filtered by spinner. Note image in view.

Android image picker. Activated by clicking on image on Receipt screen.

Android image picker. Activated by clicking on image on Receipt screen.

Screen Shot 2014-02-22 at 10.30.23 PM

Date Picker Dialog. For picking dates on the Receipt screen.

Item View

Item View

Screen Shot 2014-02-22 at 11.39.32 PM

About Page

 

 

 

 

 

 

Cool Stuff

Date Picker Dialog
Image Selection from Android gallery
Dynamically generated spinners
Dynamic table generation
HTML about page
Multiple action bars

Acknowledgements

Richard Kelly for pointing me to FluidUi for user interface design https://www.fluidui.com/

MySqlWorkbench for table generation. http://www.mysql.com/products/workbench/

Thomas Henlich’s SQLite plugin for MySQLWorkBench http://www.henlich.de/software/sqlite-export-plugin-for-mysql-workbench/

Vogella Tutorials for the Image Picker http://blog.vogella.com/2011/09/13/android-how-to-get-an-image-via-an-intent/

Database handler from http://www.androidhive.info/2011/11/android-sqlite-database-tutorial/

Create spinner from array http://stackoverflow.com/questions/2784081/android-create-spinner-programmatically-from-array

Date picker dialog from http://www.learn-android-easily.com/2013/06/datepicker-and-timepicker-dialog-in.html

And TONS more from http://stackoverflow.com and http://developer.android.com/

All icons (besides those that come with Android) were downloaded from http://findicons.com/

Plus, Eclipse is just awesome, in case you didn’t know that by now.

Advertisements
Posted in Android Development

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: