package com.dbapplication;

import android.app.DatePickerDialog;
import android.content.ContentValues;
import android.content.Context;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.net.Uri;
import android.os.Bundle;
import android.provider.BaseColumns;
import android.support.v4.app.Fragment;
import android.view.LayoutInflater;
import android.view.MotionEvent;
import android.view.View;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.TextView;
import android.widget.Toast;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

/**
* A simple {@link Fragment} subclass.
* Activities that contain this fragment must implement the
* to handle interaction events.
* create an instance of this fragment.
*/
public class UserInfoFragment extends Fragment {

private EditText mFirstName;
private EditText mLastName;
private RadioGroup mRadioGroup;
private Button mButtonContinue;
private Button mDOB;
private TextView txtDate;

private static final String SQL_CREATE_USER_INFO =
         "CREATE TABLE " + UserInfoContract.UserEntry.TABLE_NAME + " (" +
               UserInfoContract.UserEntry._ID + " INTEGER PRIMARY KEY," +
               UserInfoContract.UserEntry.COLUMN_FIRST_NAME + " TEXT," +
               UserInfoContract.UserEntry.COLUMN_LAST_NAME + " TEXT," +
               UserInfoContract.UserEntry.COLUMN_GENDER + " TEXT," +
               UserInfoContract.UserEntry.COLUMN_DOB + " TEXT)";

private static final String SQL_DELETE_USER =
         "DROP TABLE IF EXISTS " + UserInfoContract.UserEntry.TABLE_NAME;
private UserInfoWriter dbWriter;

public UserInfoFragment() {
   // Required empty public constructor
}

@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container,
                        Bundle savedInstanceState) {
   final View view = inflater.inflate(R.layout.fragment_user_info, container, false);

   mButtonContinue = (Button) view.findViewById(R.id.btn_continue);

   mFirstName = (EditText) view.findViewById(R.id.first_name);

   mLastName = (EditText) view.findViewById(R.id.last_name);

   dbWriter = new UserInfoWriter(getContext());

   mButtonContinue.setOnClickListener(new View.OnClickListener() {
         @Override
         public void onClick(View v) {
            if(mFirstName.getText() != null
                     && !mFirstName.getText().toString().trim().isEmpty()
                     && mLastName.getText() != null
                     && txtDate.getText() != null
                     && !mLastName.getText().toString().trim().isEmpty()
                     && !txtDate.getText().toString().trim().isEmpty()) {

               SimpleDateFormat sdf = new SimpleDateFormat("dd-mm-yyyy");

               try {
                     Date date = sdf.parse(txtDate.getText().toString());

                     Calendar calendar = Calendar.getInstance();
                     int mYear = calendar.get(Calendar.YEAR);
                     int mMonth = calendar.get(Calendar.MONTH);
                     int mDay = calendar.get(Calendar.DAY_OF_MONTH);

                     Date today = sdf.parse(""+mDay+"-"+mMonth+"-"+mYear);

                     if(getDiffYears(date, today) >= 18) {

                        int selectedId = mRadioGroup.getCheckedRadioButtonId();
                        RadioButton radioSexButton = (RadioButton) view.findViewById(selectedId);
                        String gender = radioSexButton.getText().toString();

                        SQLiteDatabase db = dbWriter.getWritableDatabase();

                        ContentValues values = new ContentValues();
                        values.put(UserInfoContract.UserEntry.COLUMN_FIRST_NAME, mFirstName.getText().toString());
                        values.put(UserInfoContract.

Instructions: Create a web browser that can have multiple â€œtab...