Check if available before save

[Gil Carvalho]

Hi

I need some help
I would like to check if room is available before the user save it.

This is my code

public class ReservasSalasFragment extends Fragment {
    private static final String KEY_SUCCESS = "success";
    private static final String KEY_ERROR = "error";
    private final UserFunctions userFunctions = new UserFunctions();
    private final OnDateSetListener ondate = new OnDateSetListener() {

        public void onDateSet(DatePicker view, int year, int monthOfYear,
                              int dayOfMonth) {

            dataEscolhida.setText(String.valueOf(dayOfMonth) + "-" + String.valueOf(monthOfYear + 1)
                    + "-" + String.valueOf(year));
        }
    };
    private ProgressDialog pDialog;
    private Spinner spinnerSalas, spinnerInit, spinnerFim;
    private ArrayList<Salas> salasList;
    private ArrayList<Tempos> inicioList;
    private ArrayList<Tempos> fimList;
    private EditText dataEscolhida;

    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
        View rootView = inflater.inflate(R.layout.reqsalas, container, false);
        setHasOptionsMenu(true);
        if (userFunctions.isUserLoggedIn(getActivity())) {
            if (this.getResources().getConfiguration().orientation == Configuration.ORIENTATION_LANDSCAPE) {
                rootView = inflater.inflate(R.layout.reqsalas_land, container, false);
            }
            spinnerSalas = (Spinner) rootView.findViewById(R.id.spinnerSala);
            spinnerInit = (Spinner) rootView.findViewById(R.id.spinnerInit);
            spinnerFim = (Spinner) rootView.findViewById(R.id.spinnerFim);
            salasList = new ArrayList<Salas>();
            inicioList = new ArrayList<Tempos>();
            fimList = new ArrayList<Tempos>();
            new GetDadosFormulario().execute();
            dataEscolhida = (EditText) rootView.findViewById(R.id.escolhaData);
        }
        return rootView;
    }

    private void guardaReserva() throws ParseException {
        MainActivity activity = (MainActivity) getActivity();
        final String idUser = activity.getMyUserId();
        final String sala = spinnerSalas.getSelectedItem().toString();
        final String inicio = spinnerInit.getSelectedItem().toString();
        final String fim = spinnerFim.getSelectedItem().toString();
        String horasErradas = "A hora final não pode ser inferior a inicial";
        String DataErradas = "Requisições devem ser feitas 48 horas antes!";
        String pattern = "HH:mm";
        SimpleDateFormat sdf = new SimpleDateFormat(pattern);
        SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy");
        final Date dataReserva;
        Date Datahoje;
        Date dt1 = sdf.parse(inicio);
        Date dt2 = sdf.parse(fim);
        dataReserva = df.parse(dataEscolhida.getText().toString());
        Log.v("Data Escolhida", "" + dataReserva.getTime());
        Datahoje = new Date();
        Datahoje.getTime();
        Log.v("Data Hoje", "" + Datahoje.getTime());
        Date limiteReserva = new Date(dataReserva.getTime() + 172800000L);
        Log.v("Data Limite", "" + limiteReserva.getTime());
        Long comparar = (limiteReserva.getTime() - Datahoje.getTime());
        Log.v("Valor", "" + comparar);
        if (dt2.compareTo(dt1) < 0) {
            Toast.makeText(getActivity(), horasErradas, Toast.LENGTH_LONG).show();
        }
        if (comparar < 172800000) {
            Toast.makeText(getActivity(), DataErradas, Toast.LENGTH_LONG).show();
        }
            final Dialog dialog = new Dialog(getActivity());
            dialog.getWindow().requestFeature(Window.FEATURE_NO_TITLE);
            dialog.getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_LAYOUT_IN_SCREEN);
            dialog.setContentView(R.layout.dialog_layout_confirm);
            dialog.getWindow().setBackgroundDrawable(new ColorDrawable(Color.TRANSPARENT));
            dialog.show();
            Button img = (Button) dialog.findViewById(R.id.close_button);
            Button confirm = (Button) dialog.findViewById(R.id.confirm);
            TextView data = (TextView) dialog.findViewById(R.id.data);
            TextView sala1 = (TextView) dialog.findViewById(R.id.sala);
            TextView hora = (TextView) dialog.findViewById(R.id.hora_inicial);
            TextView fim1 = (TextView) dialog.findViewById(R.id.hora_final);
            String dataFormatData = sdf.format(dataReserva);
            data.setText(dataFormatData);
            sala1.setText(sala);
            hora.setText(inicio);
            fim1.setText(fim);
            img.setOnClickListener(new OnClickListener() {
                @Override
                public void onClick(View v) {
                    dialog.dismiss();
                }
            });
            confirm.setOnClickListener(new OnClickListener() {
                @Override
                public void onClick(View view) {
                    JSONObject jsonReqSala = userFunctions.reqSalas(idUser, sala, inicio, fim, dataReserva);
                    dialog.cancel();
                    try {
                        String res = jsonReqSala.getString(KEY_SUCCESS);
                        String error = jsonReqSala.getString(KEY_ERROR);
                        if (Integer.parseInt(res) == 1) {
                            Log.d(KEY_SUCCESS, res);
                            LayoutInflater inflater = getActivity().getLayoutInflater();
                            View layout = inflater.inflate(R.layout.toast_ok, (ViewGroup) getActivity().findViewById(R.id.toast_layout_root));
                            TextView text = (TextView) layout.findViewById(R.id.text);
                            text.setText("Reserva efetuada");
                            Toast toast = new Toast(getActivity());
                            toast.setGravity(Gravity.TOP, 20, 1200);
                            toast.setDuration(Toast.LENGTH_SHORT);
                            toast.setView(layout);
                            toast.show();
                            verReservas();
                        } else {
                            Log.d(KEY_ERROR, error);
                            if (Integer.parseInt(error) == 0) {
                                Log.d(KEY_ERROR, error);

                            }
                            if (Integer.parseInt(error) == 2) {
                                Log.d(KEY_ERROR, error);
                            }
                        }

                    } catch (JSONException e) {
                        e.printStackTrace();
                    }
                }

            });

        }


    private void novaReservas() {
        Fragment fragment = new ReservasSalasFragment();
        FragmentTransaction fragmentTransaction = getActivity().getFragmentManager().beginTransaction();
        fragmentTransaction.replace(R.id.frame_container, fragment);
        fragmentTransaction.commit();
    }

    private void verReservas() {
        Fragment fragment = new VerFragment();
        FragmentTransaction fragmentTransaction = getActivity().getFragmentManager().beginTransaction();
        fragmentTransaction.replace(R.id.frame_container, fragment);
        fragmentTransaction.commit();
    }

    public void onViewCreated(View view, Bundle savedInstanceState) {
        super.onViewCreated(view, savedInstanceState);
        dataEscolhida.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                showDatePicker();
            }
        });
    }

    private void populateSpinnerSalas() {
        List<String> salaNome = new ArrayList<String>();
        for (int i = 0; i < salasList.size(); i++) {
            salaNome.add(salasList.get(i).getNome());
        }
        ArrayAdapter<String> spinnerAdapter = new ArrayAdapter<String>(getActivity(),
                android.R.layout.simple_spinner_item, salaNome);
        spinnerAdapter
                .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinnerSalas.setAdapter(spinnerAdapter);
    }

    private void populateSpinnerInicio() {
        List<String> tempoInicio = new ArrayList<String>();
        for (int i = 0; i < inicioList.size(); i++) {
            tempoInicio.add(inicioList.get(i).getInicio());
        }
        ArrayAdapter<String> spinnerAdapter = new ArrayAdapter<String>(getActivity(),
                android.R.layout.simple_spinner_item, tempoInicio);
        spinnerAdapter
                .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinnerInit.setAdapter(spinnerAdapter);
    }

    private void populateSpinnerFim() {
        List<String> tempoFim = new ArrayList<String>();
        for (int i = 0; i < fimList.size(); i++) {
            tempoFim.add(fimList.get(i).getFim());
        }
        ArrayAdapter<String> spinnerAdapter = new ArrayAdapter<String>(getActivity(),
                android.R.layout.simple_spinner_item, tempoFim);
        spinnerAdapter
                .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinnerFim.setAdapter(spinnerAdapter);
    }

    private void showDatePicker() {
        DatePickerFragment date = new DatePickerFragment();
        Calendar calender = Calendar.getInstance();
        Bundle args = new Bundle();
        args.putInt("year", calender.get(Calendar.YEAR));
        args.putInt("month", calender.get(Calendar.MONTH));
        args.putInt("day", calender.get(Calendar.DAY_OF_MONTH));
        date.setArguments(args);
        date.setCallBack(ondate);
        date.show(getFragmentManager(), "Date Picker");
    }

    @Override
    public void onCreateOptionsMenu(
            Menu menu, MenuInflater inflater) {
        inflater.inflate(R.menu.reservasalas, menu);
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        switch (item.getItemId()) {
            case R.id.save_item:
                try {
                    guardaReserva();
                } catch (ParseException e) {
                    e.printStackTrace();
                }
                return true;
            case R.id.reload_list:
                novaReservas();
                return true;
            default:
                return super.onOptionsItemSelected(item);
        }
    }

    /**
     * Async task to get all food categories
     */
    private class GetDadosFormulario extends AsyncTask<Void, Void, Void> {

        @Override
        protected void onPreExecute() {
            super.onPreExecute();
            pDialog = new ProgressDialog(getActivity());
            pDialog.setMessage("Fetching dados disponíveis..");
            pDialog.setCancelable(false);
            pDialog.show();

        }

        @Override
        protected Void doInBackground(Void... arg0) {
            ServiceHandler jsonParser = new ServiceHandler();
            String URL_SALAS = "http://www.ebspma.edu.pt/ebspmamobile/include/get_Salas.php";
            String jsonSalas = jsonParser.makeServiceCall(URL_SALAS,
                    ServiceHandler.GET);
            String URL_INICIO = "http://www.ebspma.edu.pt/ebspmamobile/include/get_Tempos.php";
            String jsonInicio = jsonParser.makeServiceCall(URL_INICIO,
                    ServiceHandler.GET);
            String jsonFim = jsonParser.makeServiceCall(URL_INICIO,
                    ServiceHandler.GET);
            Log.e("Response: ", "> " + jsonSalas);
            if (jsonSalas != null) {
                try {
                    JSONObject jsonObj = new JSONObject(jsonSalas);
                    JSONArray salas = jsonObj.getJSONArray("salas");
                    for (int i = 0; i < salas.length(); i++) {
                        JSONObject salaObj = salas.getJSONObject(i);
                        Salas sala = new Salas(salaObj.getInt("idsala"),
                                salaObj.getString("sala"),
                                salaObj.getString("piso"));
                        salasList.add(sala);
                    }

                } catch (JSONException e) {
                    e.printStackTrace();
                }

            } else {
                Log.e("JSON Data", "Didn't receive any data from server!");
            }
            if (jsonInicio != null) {
                try {
                    JSONObject jsonObj = new JSONObject(jsonInicio);
                    JSONArray inicio = jsonObj.getJSONArray("tempos");
                    for (int i = 0; i < inicio.length(); i++) {
                        JSONObject salaObj = inicio.getJSONObject(i);
                        Tempos tempo = new Tempos(
                                salaObj.getInt("idtempo"),
                                salaObj.getString("inicio"),
                                salaObj.getString("fim"));
                        inicioList.add(tempo);
                    }

                } catch (JSONException e) {
                    e.printStackTrace();
                }

            } else {
                Log.e("JSON Data", "Didn't receive any data from server!");
            }
            if (jsonFim != null) {
                try {
                    JSONObject jsonObj = new JSONObject(jsonFim);
                    JSONArray fim = jsonObj.getJSONArray("tempos");
                    for (int i = 0; i < fim.length(); i++) {
                        JSONObject salaObj = fim.getJSONObject(i);
                        Tempos tempo = new Tempos(
                                salaObj.getInt("idtempo"),
                                salaObj.getString("inicio"),
                                salaObj.getString("fim"));
                        fimList.add(tempo);
                    }

                } catch (JSONException e) {
                    e.printStackTrace();
                }

            } else {
                Log.e("JSON Data", "Didn't receive any data from server!");
            }
            return null;
        }

        @Override
        protected void onPostExecute(Void result) {
            super.onPostExecute(result);
            if (pDialog.isShowing())
                pDialog.dismiss();
            populateSpinnerSalas();
            populateSpinnerInicio();
            populateSpinnerFim();
        }
    }
}

And this is my layout

<?xml version="1.0" encoding="utf-8"?>
<!--suppress ALL -->
<LinearLayout
    xmlns:android="http://schemas.android.com/apk/res/android"
    style="@style/match_match.margin_none.padding_big.vertical"
    android:background="@color/ff_salmon_light"
    android:id="@+id/reqsalasFragment">

    <TextView
        android:id="@+id/sala"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/sala"
        android:textSize="@dimen/texto" />

    <LinearLayout
        style="@style/match_wrap.margin_none.padding_normal"
        android:layout_marginTop="@dimen/margin_big"
        android:background="@drawable/ff_bg_white_border_grayborder">

        <Spinner
            android:id="@+id/spinnerSala"
            android:layout_width="wrap_content"
            android:layout_height="40dp" />
    </LinearLayout>

    <TextView
        android:id="@+id/init"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@+string/inicio"
        android:textSize="@dimen/texto" />

    <LinearLayout
        style="@style/match_wrap.margin_none.padding_normal"
        android:layout_marginTop="@dimen/margin_big"
        android:background="@drawable/ff_bg_white_border_grayborder">

        <Spinner
            android:id="@+id/spinnerInit"
            android:layout_width="wrap_content"
            android:layout_height="40dp" />
    </LinearLayout>

    <TextView
        android:id="@+id/fim"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@+string/fim"
        android:textSize="@dimen/texto" />

    <LinearLayout
        style="@style/match_wrap.margin_none.padding_normal"
        android:layout_marginTop="@dimen/margin_big"
        android:background="@drawable/ff_bg_white_border_grayborder">

        <Spinner
            android:id="@+id/spinnerFim"
            android:layout_width="wrap_content"
            android:layout_height="40dp" />
    </LinearLayout>


    <TextView
        android:id="@+id/titulo_data"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@+string/data"
        android:textSize="@dimen/texto" />

    <LinearLayout
        style="@style/match_wrap.margin_none.padding_normal"
        android:layout_marginTop="@dimen/margin_big"
        android:background="@drawable/ff_bg_white_border_grayborder">

        <EditText
            android:id="@+id/escolhaData"
            android:layout_width="wrap_content"
            android:layout_height="40dp"
            android:ems="10"
            android:hint="Escolha a data"
            android:inputType="date">
            <requestFocus />
        </EditText>
    </LinearLayout>

</LinearLayout>

But before that i would like to kown if it isn't already taken like when i register in a website and the username is checked if not in use..any help?

Thanks