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