/// <summary> /// Méthode permettant d'ajouter une liste de courses à la base de données /// </summary> /// <param name="shoppingList">La liste de courses</param> /// <example> /// Méthode de mise en oeuvre : /// <code> /// Database bdd = new Database("Shopping"); /// bdd.AddShoppingList(new ShoppingList("Test Liste, 255, 255, 255)); /// </code> /// </example> public void AddShoppingList(ShoppingList shoppingList) { try { Log.Debug("Database", "Valeurs : " + shoppingList.ToString()); sqldb_query = "INSERT INTO PersonnalShopping (nom, red, green, blue) VALUES ('" + shoppingList.Nom + "', " + shoppingList.Red + ", " + shoppingList.Green + ", " + shoppingList.Blue + ");"; Log.Debug("SQL", "Request : " + sqldb_query); sqldb.ExecSQL(sqldb_query); sqldb_message = "Ajout de la liste de courses effectué !"; } catch (SQLiteException ex) { sqldb_message = ex.Message; } }
/// <summary> /// Méthode permettant de récupérer toutes les listes de courses présentes en base de données. /// </summary> /// <returns>Les listes de courses si elles existent, null sinon</returns> /// <example> /// Méthode de mise en oeuvre : /// <code> /// Database baseDeDonnees = new Database("Shopping"); /// baseDeDonnees.GetAllShoppinLists(); /// </code> /// </example> public List <ShoppingList> GetAllShoppingLists() { List <ShoppingList> listeShopping = new List <ShoppingList>(); Android.Database.ICursor sqldb_cursor = null; try { sqldb_query = "SELECT * FROM PersonnalShopping;"; sqldb_cursor = sqldb.RawQuery(sqldb_query, null); if (!(sqldb_cursor != null)) { sqldb_message = "Pas de liste de courses trouvées ! "; listeShopping = null; sqldb_cursor.Close(); } else { sqldb_message = "Listes de courses trouvées ! "; sqldb_cursor.MoveToFirst(); for (int i = 0; i < sqldb_cursor.Count; i++) { ShoppingList shoppingList = new ShoppingList(); shoppingList.IdShoppingList = sqldb_cursor.GetInt(sqldb_cursor.GetColumnIndex("_id")); shoppingList.Nom = sqldb_cursor.GetString(sqldb_cursor.GetColumnIndex("nom")); shoppingList.Red = sqldb_cursor.GetInt(sqldb_cursor.GetColumnIndex("red")); shoppingList.Green = sqldb_cursor.GetInt(sqldb_cursor.GetColumnIndex("green")); shoppingList.Blue = sqldb_cursor.GetInt(sqldb_cursor.GetColumnIndex("blue")); Log.Debug("Database", "Valeurs : " + sqldb_cursor.GetInt(sqldb_cursor.GetColumnIndex("_id"))); listeShopping.Add(shoppingList); sqldb_cursor.MoveToNext(); } sqldb_cursor.Close(); } } catch (SQLiteException ex) { sqldb_message = ex.Message; } return(listeShopping); }