void acctSelected(ServiceAcctInfo info) { Account acct = new Account(); acct.name = info.desc; acct.service = info; DialogInterface.OnClickListener emptyClickListener = new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }; AcctTables db = new AcctTables(this); try { db.openWritable(); try { db.pushAccount(acct); } catch (SQLiteException e) { AlertDialog dlg = Utilities.buildAlert( this, e, "Unable to add account", "Internal Error", emptyClickListener); dlg.show(); return; } } finally { db.close(); } Intent i = getIntent(); i.putExtra("acct_id", acct.ID); setResult(RESULT_OK, i); finish(); }
public void establishAccount(ServiceAcctInfo acct) { String[] args = {Integer.toString(acct.ID)}; Cursor cur = db.query("acct", AC_COLS, "service_id=?", args, null, null, null); try { if (cur.moveToNext()) return; } finally { cur.close(); } Account newAcct = new Account(); newAcct.serviceId = acct.ID; newAcct.name = acct.desc; addAccount(newAcct); }
public Account getAccountFromCursor(Cursor cur) { Account acct = new Account(); acct.ID = cur.getInt(0); acct.serviceId = cur.getInt(1); acct.name = cur.getString(2); String iAge = cur.getString(3); acct.lastUpdate = (iAge != null) ? new Date(Long.parseLong(iAge)) : null; acct.curBalAmt = cur.getDouble(4); iAge = cur.getString(5); acct.curBalDate = (iAge != null) ? new Date(Long.parseLong(iAge)) : null; acct.availBalAmt = cur.getDouble(6); iAge = cur.getString(7); acct.availBalDate = (iAge != null) ? new Date(Long.parseLong(iAge)) : null; iAge = cur.getString(8); acct.lastTrans = (iAge != null) ? new Date(Long.parseLong(iAge)) : null; return acct; }
private int addAccount(Account acct) { db.beginTransaction(); int acct_id; try { ContentValues newValue = acctValues(acct); acct_id = (int) db.insertOrThrow("acct", "name", newValue); acct.ID = acct_id; db.setTransactionSuccessful(); } finally { db.endTransaction(); } return acct_id; }