public void onItemSelected(AdapterView<?> parent, View view, int pos, long id) { // Get Spinners Spinner jobsitespinner = (Spinner) findViewById(R.id.JobSiteSpinner); Spinner customerspinner = (Spinner) findViewById(R.id.CustomerSpinner); // Database access DataHelper dh = new DataHelper(getApplicationContext()); SQLiteDatabase db = dh.getWritableDatabase(); ArrayAdapter<String> adapterjobsite = new ArrayAdapter<String>(getApplicationContext(), android.R.layout.simple_spinner_item); adapterjobsite.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); jobsitespinner.setAdapter(adapterjobsite); Cursor results = db.rawQuery( "SELECT Site_Name FROM Jobsite WHERE Customer = '" + customerspinner.getSelectedItem().toString() + "';", null); int sitenameColumnIndex = results.getColumnIndexOrThrow("Site_Name"); if (results.moveToFirst()) { do { adapterjobsite.add(results.getString(sitenameColumnIndex)); } while (results.moveToNext()); } else { Toast.makeText(getApplicationContext(), "No Jobsites found!", 2).show(); } if (db != null) db.close(); }
/** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.createajob_layout); // Database access DataHelper dh = new DataHelper(getApplicationContext()); SQLiteDatabase db = dh.getWritableDatabase(); // Populate customer spinner Spinner customerspinner = (Spinner) findViewById(R.id.CustomerSpinner); ArrayAdapter<String> adaptercustomer = new ArrayAdapter<String>(this, android.R.layout.simple_spinner_item); adaptercustomer.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); customerspinner.setAdapter(adaptercustomer); String[] columns = new String[1]; columns[0] = "Customer_Name"; Cursor results = db.query("Customers", columns, null, null, null, null, null); int customernameColumnIndex = results.getColumnIndexOrThrow("Customer_Name"); if (results.moveToFirst()) { do { adaptercustomer.add(results.getString(customernameColumnIndex)); } while (results.moveToNext()); } else { Toast.makeText(getApplicationContext(), "No Customers found!", 2).show(); } customerspinner.setOnItemSelectedListener(new YourItemSelectedListener()); Button savenewjob = (Button) findViewById(R.id.SaveJob); savenewjob.setOnClickListener(buttonlistener); Button canceljob = (Button) findViewById(R.id.CancelJob); canceljob.setOnClickListener(buttonlistener); Button addcustomer = (Button) findViewById(R.id.AddCustomer); addcustomer.setOnClickListener(buttonlistener); Button addjobsite = (Button) findViewById(R.id.AddJobSite); addjobsite.setOnClickListener(buttonlistener); if (db != null) { db.close(); } }
public void onClick(View v) { switch (v.getId()) { case R.id.AddCustomer: startActivity(new Intent(CreateAJob.this, AddCustomer.class)); break; case R.id.AddJobSite: startActivity(new Intent(CreateAJob.this, AddJobSite.class)); break; case R.id.SaveJob: DataHelper dh = new DataHelper(getApplicationContext()); SQLiteDatabase db = dh.getWritableDatabase(); TextView JobNameView = (TextView) (findViewById(R.id.NewJob)); String JobName = JobNameView.getText().toString(); Spinner CustomerView = (Spinner) (findViewById(R.id.CustomerSpinner)); String Customer = CustomerView.getSelectedItem().toString(); Spinner JobSiteView = (Spinner) (findViewById(R.id.JobSiteSpinner)); String JobSite = JobSiteView.getSelectedItem().toString(); TextView DescripView = (TextView) (findViewById(R.id.NotesBox)); String Descrip = DescripView.getText().toString(); String query = "INSERT INTO Jobs (Job_Name, Customer, Job_Site, Description)" + "VALUES (\"" + JobName + "\",\"" + Customer + "\",\"" + JobSite + "\",\"" + Descrip + "\");"; db.execSQL(query); Toast.makeText(getApplicationContext(), "Job Saved", 3).show(); CreateAJob.this.finish(); break; case R.id.CancelJob: Toast.makeText(getApplicationContext(), "Job Canceled", 3).show(); CreateAJob.this.finish(); break; } }
// Open database to write public ShoppingDatabase openDB() { mHelper = new DataHelper(mContext); shoppingDB = mHelper.getWritableDatabase(); return this; }