Comparison of an edttext with an Sqlite Bank value

Question

I’m developing an application on android but do not know how to prevent the user register two equal times.

Bench:

 String sql4 ="CREATE TABLE "+TABELAAGE+"("
                +IDAGE+ " integer primary key autoincrement,"
                +NOMECLIAGE+ " text not null,"
                +DATA+ " text not null,"
                +HORA+ " text not null,"
                +SERVICO+ " text not null,"
                        +VALOR+ " text not null"
                +")";

I cannot let the user schedule two equal times on the same date

Answer 1

This requires a consultation!

This will return the ID (if there is) an object with the same DATA and HORA!

If there is no record, this method will return -1

    public Integer validarData(final String DATA, final String HORA){

        final SQLiteDatabase db = getWritableDatabase();
        final Cursor cursor = db.query(TABELAAGE, new String[]{"id"}, "DATA = ? AND HORA =?", new String[]{DATA, HORA}, null, null, null, null);
       //se nulo ou vazio não encontrou nenhum com a mesma data e hora, retorna -1
        if (null == cursor || !cursor.moveToFirst()) return -1;

        final Integer id = cursor.getInt(0);
        cursor.close();
        return id;
    }

If you are changing the Object, check if the ID returned is equal to the object ID.

Follows :

  public void validar(){
        Integer idComDataEHora = validarData("01/12/2016", "17:18:19");
        if(idComDataEHora.equals(-1)){
            // não exite nenhum registro
        }else{
            /// Se vc está editando, verifique se o id é igual ao que está editando!

        }

    }