/// <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);
}
