HillInfo.java

/*
    Copyright 2012 Nik Cain nik@showmehills.com
    
    This file is part of ShowMeHills.

    ShowMeHills is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    ShowMeHills is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with ShowMeHills.  If not, see <http://www.gnu.org/licenses/>.
 */

package com.showmehills;

import com.showmehills.R;

import android.app.Activity;
import android.database.Cursor;
import android.database.SQLException;
import android.os.Bundle;
import android.util.Log;
import android.widget.TextView;

public class HillInfo extends Activity{

	private HillDatabase myDbHelper;
	
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);

	    setContentView(R.layout.mountaininfo);
	    
		Bundle b = getIntent().getExtras();
		int hillid = b.getInt("key", 0);		

		myDbHelper = new HillDatabase(this, getString(R.string.dbname), getString(R.string.dbpath)); 
		myDbHelper.createDataBase(); 
		
		// if database couldn't be created then we can't do much
		if (!myDbHelper.checkDataBase()) return;
		String qu = "select * from mountains where _id = '"+hillid+"'";
		Log.d("showmehills", "query: "+qu);
		Cursor cursor = myDbHelper.getReadableDatabase().rawQuery( qu, null);
		if (cursor.moveToFirst())
		{
			TextView t = (TextView) findViewById(R.id.hillname);
			String n = cursor.getString(cursor.getColumnIndex("name"));
			t.setText(n);
			
			t = (TextView) findViewById(R.id.hillheight);
			int h = cursor.getInt(cursor.getColumnIndex("height"));
			if (h>0)
			{
				t.setText(""+h+" meters");
			}
			else
			{
				t.setText("");
			}
			
			t = (TextView) findViewById(R.id.infolink);
			String webid = cursor.getString(cursor.getColumnIndex("webid"));
			int linktype = cursor.getInt(cursor.getColumnIndex("linktype"));
			switch (linktype) {
				case 1: // DoBH first link type
					t.setText("web: http://www.hill-bagging.co.uk/mountaindetails.php?qu=S&rf=" + webid);
					break;
				case 2: // DoBH second link type
					t.setText("web: http://www.hill-bagging.co.uk/googlemaps.php?qu=S&rf=" + webid);
					break;
				case 3: // OSM
					t.setText("web: http://www.openstreetmap.org/browse/node/" + webid);
					break;

				default:
					break;
			}
		}
		else
		{
			Log.d("showmehills", "zero item count.");
		}
		cursor.close();
	}
	
	@Override
	protected void onResume() {
		super.onResume();
		
		try {	 
			myDbHelper.checkDataBase();	 
		}catch(SQLException sqle){	 
			throw sqle;	 
		}
	}

	@Override
	protected void onPause() {
		super.onPause();
		
		try {	 
			myDbHelper.close();	 
		}catch(SQLException sqle){	 
			throw sqle;	 
		}
	}
	
	@Override
	protected void onStop()
	{
		try {	 
			myDbHelper.close();	 
		}catch(SQLException sqle){	 
			throw sqle;	 
		}
		super.onStop();
	}
}