public static async Task CreateFeedbackSubmissionExercises (int feedbackSubmssionID, int profileID, int gymID, ObservableCollection<ExerciseViewModel> simpleExerciseList) { FeedbackSubmissionExercises feedbackSubmissionExercises = new FeedbackSubmissionExercises (); int sequence = 0; List<FeedbackSubmissionExercises> feedbackSubmissionExercisesToInsert = new List<FeedbackSubmissionExercises> (); foreach (ExerciseViewModel simpleExercise in simpleExerciseList) { feedbackSubmissionExercises = new FeedbackSubmissionExercises (); feedbackSubmissionExercises.ProfileID = profileID; feedbackSubmissionExercises.FeedbackSubmissionID = feedbackSubmssionID; feedbackSubmissionExercises.ExerciseID = simpleExercise.Exercise.ExerciseID; feedbackSubmissionExercises.Sets = simpleExercise.Sets; feedbackSubmissionExercises.Reps = simpleExercise.Reps; feedbackSubmissionExercises.Duration = simpleExercise.Duration; //feedbackSubmissionExercises.HeartRate = simpleExercise.TargetHRMin; feedbackSubmissionExercises.ExerciseSequence = sequence++; feedbackSubmissionExercises.Weight = simpleExercise.Weight; feedbackSubmissionExercises.GymID = gymID; feedbackSubmissionExercisesToInsert.Add (feedbackSubmissionExercises); } if (feedbackSubmissionExercisesToInsert.Count > 0) { var db = DependencyService.Get<ISQLite> ().GetAsyncConnection (); await db.CreateTableAsync<FeedbackSubmissionExercises> (); await db.InsertAllAsync (feedbackSubmissionExercisesToInsert); } }
public static async Task CreateFeedbackSubmissionExercises (int feedbackSubmissionID, int profileID, int gymID, ObservableCollection<MemberExerciseViewModel> simpleExerciseList) { FeedbackSubmissionExercises feedbackSubmissionExercises = new FeedbackSubmissionExercises (); int sequence = 0; List<FeedbackSubmissionExercises> feedbackSubmissionExercisesToInsert = new List<FeedbackSubmissionExercises> (); foreach (MemberExerciseViewModel simpleExercise in simpleExerciseList) { feedbackSubmissionExercises = new FeedbackSubmissionExercises (); feedbackSubmissionExercises.ProfileID = profileID; feedbackSubmissionExercises.FeedbackSubmissionID = feedbackSubmissionID; feedbackSubmissionExercises.ExerciseID = simpleExercise.Exercise.ExerciseID; feedbackSubmissionExercises.Sets = simpleExercise.Sets; feedbackSubmissionExercises.Reps = simpleExercise.Reps; feedbackSubmissionExercises.ExerciseSequence = sequence++; feedbackSubmissionExercises.Weight = simpleExercise.Weight; feedbackSubmissionExercises.SeatPosition1Value = simpleExercise.SeatPosition1Value; feedbackSubmissionExercises.SeatPosition2Value = simpleExercise.SeatPosition2Value; feedbackSubmissionExercises.SeatPosition3Value = simpleExercise.SeatPosition3Value; feedbackSubmissionExercises.SeatPosition4Value = simpleExercise.SeatPosition4Value; feedbackSubmissionExercises.SeatPosition1Label = simpleExercise.GetSeatPosition1Label (); feedbackSubmissionExercises.SeatPosition2Label = simpleExercise.GetSeatPosition2Label (); feedbackSubmissionExercises.SeatPosition3Label = simpleExercise.GetSeatPosition3Label (); feedbackSubmissionExercises.SeatPosition4Label = simpleExercise.GetSeatPosition4Label (); feedbackSubmissionExercises.GymID = gymID; feedbackSubmissionExercisesToInsert.Add (feedbackSubmissionExercises); } if (feedbackSubmissionExercisesToInsert.Count > 0) { var db = DependencyService.Get<ISQLite> ().GetAsyncConnection (); await db.CreateTableAsync<FeedbackSubmissionExercises> (); await db.InsertAllAsync (feedbackSubmissionExercisesToInsert); } }