Summary 4
diff --git a/src/org/climbingguide/dao/SectorDao.java b/src/org/climbingguide/dao/SectorDao.java
index 6c3f1b2..e58e0f0 100644
--- a/src/org/climbingguide/dao/SectorDao.java
+++ b/src/org/climbingguide/dao/SectorDao.java
@@ -153,4 +153,22 @@
return sectorList;
}
+
+ public Sector getSectorById(int id){
+ String selectQuery = " SELECT * FROM " + SQLHelper.TABLE_SECTOR + " WHERE "+SQLHelper.ID_OF_AREA + " = " + "'"+ id +"'" ;
+ Log.i(LOG, selectQuery);
+
+ Cursor c = db.rawQuery(selectQuery,null);
+
+ Sector sector = new Sector();
+
+ sector.setId(c.getInt(c.getColumnIndex(SQLHelper.ID_SECTOR)));
+ sector.setName(c.getString(c.getColumnIndex(SQLHelper.SECTOR_NAME)));
+ sector.setIdOfArea(c.getInt(c.getColumnIndex(SQLHelper.ID_OF_AREA)));
+
+
+ return sector;
+
+
+ }
}
diff --git a/src/org/climbingguide/gui/FragmentCreateRoute.java b/src/org/climbingguide/gui/FragmentCreateRoute.java
index 384ebcf..6c0a1cd 100644
--- a/src/org/climbingguide/gui/FragmentCreateRoute.java
+++ b/src/org/climbingguide/gui/FragmentCreateRoute.java
@@ -2,9 +2,13 @@
import java.util.ArrayList;
import java.util.List;
+
+import org.climbingguide.dao.SectorDao;
import org.climbingguide.main.R;
+import org.climbingguide.model.Sector;
import org.json.JSONException;
import org.json.JSONObject;
+
import android.annotation.SuppressLint;
import android.app.Fragment;
import android.os.Bundle;
@@ -23,13 +27,20 @@
@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container,
Bundle savedInstanceState) {
- getActivity().setTitle("Create");
+ getActivity().setTitle("CreateRoute");
View view = inflater.inflate(R.layout.create_route,container, false);
-
+ int i = getArguments().getInt("idOfSector");
Button b1 = (Button) view.findViewById(R.id.button1);
+ SectorDao dao = new SectorDao(getActivity());
+ dao.open();
+ List<Sector> sectorList = dao.getAllSectors();
+ dao.close();
+
b1.setOnClickListener(onClickListener);
-
+ EditText e2 = (EditText)view.findViewById(R.id.editText2);
+ e2.setText(sectorList.get(i).getName());
+ e2.setClickable(false);
return view;
}
@@ -37,7 +48,7 @@
@Override
public void onClick(final View v) {
EditText e1 = (EditText)v.findViewById(R.id.editText1);
- EditText e2 = (EditText)v.findViewById(R.id.editText2);
+
// e2.setText(text);
EditText e3 = (EditText)v.findViewById(R.id.editText3);
EditText e4 = (EditText)v.findViewById(R.id.editText4);
@@ -53,7 +64,7 @@
try {
json.put("route_name", e1.getText().toString());
- json.put("sector", e2.getText().toString());
+ //json.put("sector", e2.getText().toString());
json.put("difficulty", e3.getText().toString());
json.put("bolts", e4.getText().toString());
json.put("length", e5.getText().toString());
diff --git a/src/org/climbingguide/main/MainActivity.java b/src/org/climbingguide/main/MainActivity.java
index c5bd296..4796c72 100644
--- a/src/org/climbingguide/main/MainActivity.java
+++ b/src/org/climbingguide/main/MainActivity.java
@@ -226,7 +226,6 @@
if(areaAll != null && areaAll.isVisible()){
SearchAreas fragment = new SearchAreas();
- fragment.setArguments(bundle);
FragmentTransaction transaction = getFragmentManager().beginTransaction();
tagFragment = "AreasSearch";
transaction.replace(R.id.frame_container, fragment,tagFragment);
@@ -241,8 +240,6 @@
if(sectorAll != null && sectorAll.isVisible()){
SearchSectors fragment = new SearchSectors();
- bundle.putInt("idOfArea",-1);
- fragment.setArguments(bundle);
tagFragment="SectorsSearch";
FragmentTransaction transaction = getFragmentManager().beginTransaction();
transaction.replace(R.id.frame_container, fragment,tagFragment);
@@ -256,8 +253,6 @@
if(routeAll != null && routeAll.isVisible()){
SearchRoutes fragment = new SearchRoutes();
- bundle.putInt("idOfSector",-1);
- fragment.setArguments(bundle);
FragmentTransaction transaction = getFragmentManager().beginTransaction();
tagFragment="RoutesSearch";
transaction.replace(R.id.frame_container, fragment,tagFragment);
@@ -271,8 +266,6 @@
if(sector != null && sector.isVisible()){
SearchSectors fragment = new SearchSectors();
- bundle.putInt("idOfArea",sector.getIdOfArea());
- fragment.setArguments(bundle);
tagFragment = "SectorsSearch";
FragmentTransaction transaction = getFragmentManager().beginTransaction();
transaction.replace(R.id.frame_container, fragment,tagFragment);
@@ -286,8 +279,6 @@
if(route != null && route.isVisible() ){
SearchRoutes fragment = new SearchRoutes();
- bundle.putInt("idOfSector",route.getIdOfSector());
- fragment.setArguments(bundle);
tagFragment = "RoutesSearch";
FragmentTransaction transaction = getFragmentManager().beginTransaction();
transaction.replace(R.id.frame_container, fragment,tagFragment);