public void insertData(String nom, String prenom, String adresse, String email, String mdp)
{
RequestQueue requestQueue = Volley.newRequestQueue(this);
Log.i("responseD", "ok");
StringRequest jsonObjectRequest = new StringRequest
(Request.Method.GET, url, new Response.Listener<String>() {
@Override
public void onResponse(String response) {
}
}, new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
// TODO: Handle error
}
}) {
@Override
protected Map<String, String> getParams() {
Map<String, String> params = new HashMap<String, String>();
params.put("email", email);
params.put("password", mdp);
params.put("firstname", nom);
params.put("lastname", prenom);
params.put("adresse", adresse);
return params;
}
};
requestQueue.add(jsonObjectRequest);
}
public void getData(String email, String mdp)
{
RequestQueue requestQueue = Volley.newRequestQueue(this);
String urlB = url + email + "&mdp=" + mdp;
Log.i("responseD", "ok");
JsonObjectRequest jsonObjectRequest = new JsonObjectRequest
(Request.Method.GET, urlB, null, new Response.Listener<JSONObject>() {
@Override
public void onResponse(JSONObject response) {
Log.i("URLB: ", urlB);
Log.i("ResponseR: ", response.toString());
Gson gson = new Gson();
User user = gson.fromJson(response.toString(), User.class);
Log.i("emailR: ", user.getEmail());
}
}, new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
// TODO: Handle error
}
});
requestQueue.add(jsonObjectRequest);
}
public static List<User> getHistoriqueList() {
//Open connection to read only
SQLiteDatabase bdd = MyApplication.getMaBaseSQLite().getWritableDatabase();
List<User> userList = new ArrayList<>();
Cursor cursor = bdd.query(TABLE_USER, new String[]{COL_ID, COL_NOM,COL_PRENOM,COL_EMAIL }, null,null,null,null,null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
User his = new User();
//on lui affecte toutes les infos grâce aux infos contenues dans le Cursor
his.setId(cursor.getInt(cursor.getColumnIndex(COL_ID)));
his.setNom(cursor.getString(cursor.getColumnIndex(COL_NOM)));
his.setPrenom(cursor.getString(cursor.getColumnIndex(COL_PRENOM)));
his.setEmail(cursor.getString(cursor.getColumnIndex(COL_EMAIL)));
userList.add(his);
} while (cursor.moveToNext());
}
cursor.close();
bdd.close();
return userList;
}
public static boolean insertUser(User user)
{
SQLiteDatabase bdd = MyApplication.getMaBaseSQLite().getWritableDatabase();
//bdd.execSQL(SQL_CREATION_TABLE);
ContentValues values=new ContentValues();
values.put(COL_NOM, user.getNom());
values.put(COL_PRENOM,user.getPrenom());
values.put(COL_EMAIL,user.getEmail());
values.put(COL_PASSWORD,user.getPassword());
Log.v("message",SQL_CREATION_TABLE);
user.setId((int) bdd.insert(TABLE_USER,null,values));
bdd.close();
if(user.getId()<=0)
{
Log.v("TAG_SQL", "Aucune insertion n'a été réalisée");
return false;
}
else
{
Log.v("TAG_SQL", "Insertion a été bien réalisée");
return true;
}
}
public static boolean updateUser(String nom, String prenom,String email, int id)
{
SQLiteDatabase bdd = MyApplication.getMaBaseSQLite().getWritableDatabase();
String query="UPDATE "+TABLE_USER+" SET "+COL_NOM+
"= '" +nom+"' ,"+COL_PRENOM+
"= '"+prenom+"' ,"+COL_EMAIL+
"= '"+email+"' WHERE "+COL_ID+" = '"+ id+"' ";
Log.v("message", query);
Log.d("Nom à mettre à jour :",nom);
bdd.execSQL(query);
// historique.setId(bdd.update(TABLE_HISTORIQUE,null,values));
bdd.close();
return true;
}