public static void Initiate() { //db = new LiteDatabase(@Constants.appDbFilename); db = new LiteDatabase(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), Constants.appDbFilename)); // Si la base est vide il faut créer les collections et données de depart. // Vérifier lignes en users > 0 pour cela. var users = db.GetCollection <User>("Users"); if (users.Count() == 0) { ListEntry.Initiate(); User.Initiate(); SchoolTask.Initiate(); ListEntryForFood.Initiate(); ListEntrySport.Initiate(); ListEntryYOGA.Initiate(); FoodItem.Initiate(); Money.Initiate(); CollectionForMax.Initiate(); MyUser.isDefault = true; } var foodweek = db.GetCollection <Food>("EntriesforFood"); /*var data_list = foodweek.Find(Query.All(), 0, 20); * foreach (var row in data_list) * { * foodweek.Delete(row.Id); * * } */ var sizetest = foodweek.Count(); if (sizetest == 0) { MyFoodWeek.isDefault = true; Food.Initiate(); } MyUser.Initiate(); MyFoodWeek.Initiate(); //FoodItem.Initiate(); ThisMaxMoney.Initiate(); }
public async void OnButtonClicked(object sender, EventArgs args) { MyFoodWeek.UpdateFood(prot1.ListEntryList[Prot_1.SelectedIndex], prot2.ListEntryList[Prot_2.SelectedIndex], prot3.ListEntryList[Prot_3.SelectedIndex], carb1.ListEntryList[Carb_1.SelectedIndex], carb2.ListEntryList[Carb_2.SelectedIndex], carb3.ListEntryList[Carb_3.SelectedIndex], veggies1.ListEntryList[Veggies_1.SelectedIndex], veggies2.ListEntryList[Veggies_2.SelectedIndex], veggies3.ListEntryList[Veggies_3.SelectedIndex]); if (toggled) { //Search s'ils ne sont pas déjà présent //bool NotalreadySavede = true; var col = Database.db.GetCollection <FoodItem>("FoodForShoppingList"); //Results //__________________________ Prot var resultprot1 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeProt1), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeProt1))); bool prot1 = (resultprot1 == null); var resultprot2 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeProt2), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeProt2))); bool prot2 = (resultprot2 == null); var resultprot3 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeProt3), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeProt3))); bool prot3 = (resultprot3 == null); //__________________________ Carb var resultcarb1 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeCarb1), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeCarb1))); bool carb1 = (resultcarb1 == null); var resultcarb2 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeCarb2), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeCarb2))); bool carb2 = (resultcarb2 == null); var resultcarb3 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeCarb3), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeCarb3))); bool carb3 = (resultcarb1 == null); //___________________________ Veggies var resultveggie1 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeVeggies1), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeVeggies1))); bool veggie1 = (resultveggie1 == null); var resultveggie2 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeVeggies2), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeVeggies2))); bool veggie2 = (resultveggie2 == null); var resultveggie3 = col.FindOne(Query.And(Query.EQ("Code", MyFoodWeek.thisweek.FoodCategoryCodeVeggies3), Query.EQ("Type", MyFoodWeek.thisweek.FoodCategoryTypeVeggies3))); bool veggie3 = (resultveggie3 == null); GetShoppinForWeek(); await Navigation.PopAsync(); } }