public void addContact(Contact contact) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(CONTACTS_COLUMN_CONTACT_ID, contact.getId());
values.put(CONTACTS_COLUMN_NAME, contact.getName()); // Contact Name
values.put(CONTACTS_COLUMN_PHONE, contact.getPhone()); // Contact Phone
// Number
values.put(CONTACTS_COLUMN_EMAIL, contact.getEmail());
values.put(CONTACTS_COLUMN_CATEGORY, contact.getCategory());
// Inserting Row
db.insert(CONTACTS_TABLE_NAME, null, values);
db.close(); // Closing database connection
}
public int updateContact(Contact contact) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(CONTACTS_COLUMN_NAME, contact.getName());
values.put(CONTACTS_COLUMN_PHONE, contact.getPhone());
values.put(CONTACTS_COLUMN_EMAIL, contact.getEmail());
values.put(CONTACTS_COLUMN_CATEGORY, contact.getCategory());
// updating row
return db.update(
CONTACTS_TABLE_NAME,
values,
CONTACTS_COLUMN_ID + " = ?",
new String[] {String.valueOf(contact.getId())});
}
public void action() {
Contact contact = new Contact();
String name, phone;
name = JOptionPane.showInputDialog("Ange namn");
contact.setName(name);
phone = JOptionPane.showInputDialog("Ange hemtelefon");
contact.setPhone(phone);
contact.setMobile(JOptionPane.showInputDialog("Ange mobil"));
contact.setEmail(JOptionPane.showInputDialog("Ange mail-adress"));
JOptionPane.showMessageDialog(null, contact.toString());
JOptionPane.showMessageDialog(
null,
contact.getName()
+ "\n"
+ contact.getPhone()
+ "\n"
+ contact.getMobile()
+ "\n"
+ contact.getEmail());
}
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_edit_contact);
Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
final EditText name = (EditText) findViewById(R.id.edit_name);
final EditText phone = (EditText) findViewById(R.id.edit_phone);
final EditText email = (EditText) findViewById(R.id.edit_email);
final EditText address = (EditText) findViewById(R.id.edit_address);
final EditText digicode = (EditText) findViewById(R.id.edit_digicode);
Bundle extra = getIntent().getExtras();
if (extra != null) {
final int id = extra.getInt("id");
Contact contact = db.getContact(id);
name.setText(contact.getName());
phone.setText(contact.getPhone());
email.setText(contact.getEmail());
address.setText(contact.getAddress());
digicode.setText(contact.getDigicode());
FloatingActionButton update = (FloatingActionButton) findViewById(R.id.update_btn);
update.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View view) {
db.updateContact(
id,
name.getText().toString(),
phone.getText().toString(),
email.getText().toString(),
address.getText().toString(),
digicode.getText().toString());
Intent i = new Intent(EditContact.this, MainActivity.class);
startActivity(i);
}
});
}
}
private void getUpdatedContactInfo(Contact currentContact) {
EditText editText = (EditText) this.findViewById(R.id.contactName);
currentContact.setName(editText.getText().toString());
EditText aliasText = (EditText) this.findViewById(R.id.alias);
currentContact.setAlias(aliasText.getText().toString());
EditText businessText = (EditText) this.findViewById(R.id.business_edit);
currentContact.setBusiness(businessText.getText().toString());
final EditText phoneText = (EditText) this.findViewById(R.id.phone_edit);
final Spinner phoneOptions = (Spinner) this.findViewById(R.id.phone_spinner);
currentContact.setPhone(new HashMap<String, String>());
currentContact
.getPhone()
.put(phoneOptions.getSelectedItem().toString(), phoneText.getText().toString());
final EditText emailText = (EditText) this.findViewById(R.id.email_edit);
final Spinner emailOptions = (Spinner) this.findViewById(R.id.email_spinner);
currentContact.setEmail(new HashMap<String, String>());
currentContact
.getEmail()
.put(emailOptions.getSelectedItem().toString(), emailText.getText().toString());
final EditText streetText = (EditText) this.findViewById(R.id.address1_edit);
final EditText cityText = (EditText) this.findViewById(R.id.address_city_edit);
final EditText zipText = (EditText) this.findViewById(R.id.zip_code_edit);
final Spinner stateOptions = (Spinner) this.findViewById(R.id.state_spinner);
final Spinner addressOptions = (Spinner) this.findViewById(R.id.address_spinner);
currentContact.setAddresses(new HashMap<String, Address>());
currentContact
.getAddresses()
.put(
addressOptions.getSelectedItem().toString(),
new Address(
streetText.getText().toString(),
cityText.getText().toString(),
stateOptions.getSelectedItem().toString(),
zipText.getText().toString()));
}
public void updateCategory(Contact contact) {
SQLiteDatabase db = this.getWritableDatabase();
String selectQuery =
"UPDATE "
+ CONTACTS_TABLE_NAME
+ " SET category='"
+ contact.getCategory()
+ "'"
+ " WHERE name='"
+ contact.getName()
+ "' AND "
+ "phone='"
+ contact.getPhone()
+ "' AND "
+ "email='"
+ contact.getEmail()
+ "';";
// String selectQuery = "UPDATE " + CONTACTS_TABLE_NAME
// + " SET category='" + contact.getCategory() + "';";
db.execSQL(selectQuery);
}
