public async void Adding() { exer.Name = JourneyExerciseViewModel.Name; exer.ExerciseType = "Running"; bool NameCorrect = (exer.Name != null && exer.Name != ""); bool DistanceCorrect = true; int DistanceVal = 0; DistanceCorrect = int.TryParse(Distance, out DistanceVal); exer.Distance = DistanceVal; bool DurationCorrect = true; int DurationVal = 0; DurationCorrect = int.TryParse(Duration, out DurationVal); exer.Duration = DurationVal; bool BurnedCorrect = true; int BurnedVal = 0; BurnedCorrect = int.TryParse(BurnedCalories, out BurnedVal); exer.Calories = BurnedVal; bool correctValues = (NameCorrect && DistanceCorrect && DurationCorrect && BurnedCorrect); if (correctValues) { exerdatabase = new ExerciseTableDatabaseAzure(); await exerdatabase.InsertExercise(exer); var details = await exerdatabase.GetConnection(); foreach (var detail in details) { if (detail.Name == exer.Name && detail.ExerciseType == exer.ExerciseType && detail.Distance == exer.Distance && detail.Duration == exer.Duration && detail.Calories == exer.Calories) { exer.Id = detail.Id; } } string _exerciseid = exer.Id; string _userid = ""; entereduUser = new UserTableDatabaseAzure(); var users = await entereduUser.GetUser(); foreach (var user in users) { if (user.Name == "Kazuko") { _userid = user.Id; } } entered.UserID = _userid; entered.ExerciseID = _exerciseid; entered.Date = DateTime.Now; enteredExercise = new ExerciseEnteredTableDatabaseAzure(); bool _checked = await enteredExercise.CheckIfExists(entered); if (!_checked) { await enteredExercise.InsertExercise(entered); Close(this); } } }
private async Task ShowList() { string userid = await getuserid(); string foodid = ""; Meals.Clear(); //Meals = new ObservableCollection<FoodsTable>(); enteredFood = new FoodEnteredTableDatabaseAzure(); foodDatabase = new FoodsTableDatabaseAzure(); var mealdetails = await enteredFood.GetFood(); foreach (var detail in mealdetails) { if (detail.UserID == userid) { foodid = detail.FoodID; var datas = await foodDatabase.GetFood(); foreach (var data in datas) { if (data.Id == foodid) { Meals.Add(data); eatenValue += data.Calories; Eaten = "" + eatenValue; remainingValue = remainder(); Remaining = "" + remainingValue; } } } } string exerciseid = ""; Exercises.Clear(); //Exercises = new ObservableCollection<ExerciseTable>(); enteredExer = new ExerciseEnteredTableDatabaseAzure(); exerDatabase = new ExerciseTableDatabaseAzure(); var exerdetails = await enteredExer.GetExercise(); foreach (var detail in exerdetails) { if (detail.UserID == userid) { exerciseid = detail.ExerciseID; var datas = await exerDatabase.GetExercise(); foreach (var data in datas) { if (data.Id == exerciseid) { Exercises.Add(data); burnedValue += data.Calories; Burned = "" + burnedValue; remainingValue = remainder(); Remaining = "" + remainingValue; } } } } }