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