コード例 #1
0
ファイル: AddLentOut.java プロジェクト: mikebal/MyVinyls
  private void lendOutRecord(MyDBHandler dbHandler) {

    int currentID = 1;
    EditText name = (EditText) findViewById(R.id.editTextLendoutName);
    Button dateOut = (Button) findViewById(R.id.editTextLentoutDateOut);
    Button dateDue = (Button) findViewById(R.id.editTextLentoutDue);

    if (name == null || dateDue == null || dateOut == null) return;

    String nameStr = name.getText().toString();
    ArrayList<String> listOfIDs = dbHandler.dbReturnListStrings("SELECT * FROM lentout", "_id");
    if (listOfIDs != null && listOfIDs.size() != 0) currentID += findLargestString(listOfIDs);
    String currentIDStr = String.valueOf(currentID);
    String dateOutStr = dateOut.getText().toString();
    if (dateOutStr.equals("Today")) {
      dateOutStr = getDateFromDatePicker((DatePicker) findViewById(R.id.datePickerLentOut));
    }
    String dateDueStr = dateDue.getText().toString();
    if (dateDueStr.equals("Unset")) {
      dateDueStr = "12/12/2025";
    }
    dbHandler.runRawQueryNoResult(
        "insert into lentout (_id,album_id,lentout,dateout,dueback) values ("
            + currentIDStr
            + ","
            + recordID
            + ",'"
            + nameStr
            + "','"
            + dateOutStr
            + "','"
            + dateDueStr
            + "');");
    finish();
  }