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