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