public void DeleteSessionDefinition(ISessionDefinitionViewModel sessionDefinition)
{
using (var connection = DependencyService.Get <ISQLite>().GetConnection())
{
connection.Delete <SessionDefinitionRow>(sessionDefinition.SessionDefinitonId);
}
}
public SessionDefinitionView(ISessionDefinitionViewModel sessionDefinition, IWorkoutDefinitionLibraryViewModel workOutDefinitionLibraryViewModel, IUserInterfaceState userInterfaceState)
{
InitializeComponent();
_sessionDefintion = sessionDefinition;
_workOutDefinitionLibraryViewModel = workOutDefinitionLibraryViewModel;
_userInterfaceState = userInterfaceState;
}
public void UpdateSessionDefinition(ISessionDefinitionViewModel sessionDefinition)
{
using (var connection = DependencyService.Get <ISQLite>().GetConnection())
{
connection.Update(new SessionDefinitionRow
{
SessionDefinitonId = sessionDefinition.SessionDefinitonId,
SessionName = sessionDefinition.SessionName,
SessionOrder = sessionDefinition.SessionOrder
});
}
}
public void AddSessionDefinition(ISessionDefinitionViewModel sessionDefinition)
{
using (var connection = DependencyService.Get <ISQLite>().GetConnection())
{
var sessionDefinitionRow = new SessionDefinitionRow
{
SessionName = sessionDefinition.SessionName,
SessionOrder = sessionDefinition.SessionOrder
};
connection.Insert(sessionDefinitionRow);
sessionDefinition.SessionDefinitonId = sessionDefinitionRow.SessionDefinitonId;
}
}
public WorkOutAssignment[] GetAssignments(ISessionDefinitionViewModel sessionDefinitionViewModel)
{
using (var connection = DependencyService.Get <ISQLite>().GetConnection())
{
var workoutDefinitions = _workoutDefinitionRepository.GetWorkOutDefinitions();
return(connection.Query <WorkOutAssignmentRow>("SELECT * FROM WorkOutAssignment WHERE SessionDefinitionId = ?", sessionDefinitionViewModel.SessionDefinitonId)
.Select(s => new WorkOutAssignment
{
SessionDefinitionId = s.SessionDefinitionId,
SessionDefinition = sessionDefinitionViewModel,
WorkOutDefinitionId = s.WorkOutDefinitionId,
WorkoutType = (WorkOutAssignment.WorkOutTypes)s.WorkOutType,
WorkOutDefinition = workoutDefinitions.First(f => f.WorkOutId == s.WorkOutDefinitionId)
})
.ToArray());
}
}
