public void DeleteWorkOutDefinition(IWorkoutDefinitionViewModel workOutDefinition) { using (var connection = DependencyService.Get <ISQLite>().GetConnection()) { var assignments = connection .Query <WorkOutAssignmentRow>("SELECT * FROM WorkOutAssignment WHERE WorkOutDefinitionId = ?", workOutDefinition.WorkOutId); foreach (var assignment in assignments) { connection.Delete <WorkOutAssignmentRow>(assignment.AssignmentId); } connection.Delete <WorkOutDefinitionRow>(workOutDefinition.WorkOutId); } }
public void UpdateWorkOutDefinition(IWorkoutDefinitionViewModel workoutDefinition) { using (var connection = DependencyService.Get <ISQLite>().GetConnection()) { connection.Update(new WorkOutDefinitionRow { WorkOutDefinitionId = workoutDefinition.WorkOutId, WorkOutName = workoutDefinition.WorkOutName, NumberOfWarmUpSets = workoutDefinition.NumberOfWarmUpSets, WarmUpRepetitions = workoutDefinition.WarmUpRepetitions, WarmUpWeight = workoutDefinition.WarmUpWeight, NumberOfSets = workoutDefinition.NumberOfSets, Repetitions = workoutDefinition.Repetitions, Weight = workoutDefinition.Weight }); } }
private IWorkoutViewModel CreateWorkOutFromWorkOutRow(WorkOutRow workOutRow, IWorkoutDefinitionViewModel workOutDefinition) { var workout = App.Container.Resolve <IWorkoutViewModel>(); workout.WorkOutId = workOutRow.WorkOuId; workout.SessionId = workOutRow.SessionId; workout.WorkOutDefinitionId = workOutRow.WorkOutDefinitionId; workout.WorkOutName = workOutRow.WorkOutName; workout.WorkOutType = (WorkOutAssignment.WorkOutTypes)workOutRow.WorkOutType; workout.WorkOutComplete = workOutRow.WorkOutComplete; foreach (var set in _setRepository.GetSets(workOutRow.WorkOuId)) { workout.WorkOutSets.Add(set); } return(workout); }
private static List <ISetViewModel> CreateWarmUpSetsFromWorkOutDefinition(IWorkoutDefinitionViewModel workOutDefinition) { var warmUpWorkOutSets = new List <ISetViewModel>(); for (var count = 0; count < workOutDefinition.NumberOfWarmUpSets; count++) { var set = App.Container.Resolve <ISetViewModel>(); set.SetName = "Set " + (count + 1); set.SetType = WorkOutAssignment.WorkOutTypes.WarmUpWorkout; set.Weight = workOutDefinition.WarmUpWeight; set.CompletedRepetitions = 0; set.TotalRepetitions = workOutDefinition.WarmUpRepetitions; warmUpWorkOutSets.Add(set); } return(warmUpWorkOutSets); }
public void AddWorkOutDefinition(IWorkoutDefinitionViewModel workoutDefinition) { using (var connection = DependencyService.Get <ISQLite>().GetConnection()) { var workOutDefinitionRow = new WorkOutDefinitionRow { WorkOutName = workoutDefinition.WorkOutName, NumberOfWarmUpSets = workoutDefinition.NumberOfWarmUpSets, WarmUpRepetitions = workoutDefinition.WarmUpRepetitions, WarmUpWeight = workoutDefinition.WarmUpWeight, NumberOfSets = workoutDefinition.NumberOfSets, Repetitions = workoutDefinition.Repetitions, Weight = workoutDefinition.Weight }; connection.Insert(workOutDefinitionRow); workoutDefinition.WorkOutId = workOutDefinitionRow.WorkOutDefinitionId; } }