private List <TrainingExercise> FindTrainingExercise(TrainingDay trainingDay) { if (trainingDay == null) { return(null); } var criteria = new TrainingExerciseCriteria() { Year = new IntegerCriteria() { Equal = trainingDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingDay.TrainingDayId }, UserId = new StringCriteria() { Equal = trainingDay.UserId } }; return(_trainingExercisesService.FindTrainingExercise(criteria)); }
private void CompleteTrainingDayWithExercise(TrainingDay trainingJournalDay) { if (trainingJournalDay != null) { var trainingExerciseCriteria = new TrainingExerciseCriteria() { UserId = new StringCriteria() { Equal = trainingJournalDay.UserId }, Year = new IntegerCriteria() { Equal = trainingJournalDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingJournalDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingJournalDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingJournalDay.TrainingDayId } }; var trainingExerciseService = new TrainingExerciseService(DbContext); trainingJournalDay.TrainingExercises = trainingExerciseService.FindTrainingExercise(trainingExerciseCriteria); } }
public List <TrainingExercise> FindTrainingExercise(TrainingExerciseCriteria trainingExerciseCriteria) { var trainingExercises = _trainingExerciseModule.Find(trainingExerciseCriteria); FindTrainingExerciseSet(trainingExercises); return(trainingExercises); }
internal TrainingDay UpdateTrainingDay(TrainingDay trainingDay, TrainingDayScenario trainingDayScenario) { TrainingDay trainingDayResult = null; trainingDayResult = _trainingDayModule.Update(trainingDay, AppUtils.GetUserUnit(_userInfosService, trainingDay.UserId)); SynchroManager.TrainingDayChange(DbContext, trainingDayResult); if (trainingDayScenario != null && trainingDayScenario.ManageExercise) { var trainingExerciseCriteria = new TrainingExerciseCriteria() { UserId = new StringCriteria() { Equal = trainingDay.UserId }, Year = new IntegerCriteria() { Equal = trainingDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingDay.TrainingDayId } }; var trainingExercisesDb = _trainingExercisesService.FindTrainingExercise(trainingExerciseCriteria); if (trainingExercisesDb != null && trainingExercisesDb.Count > 0) { foreach (var trainingExerciseDb in trainingExercisesDb) { //remove only training exercises who do not present (for keep exercise tempos: retrocompatibility) if (trainingDay.TrainingExercises == null || !trainingDay.TrainingExercises.Any(te => te.Id == trainingExerciseDb.Id)) { _trainingExercisesService.DeleteTrainingExercise(trainingExerciseDb); } } } if (trainingDay.TrainingExercises != null) { trainingDayResult.TrainingExercises = new List <TrainingExercise>(); foreach (var trainingExercise in trainingDay.TrainingExercises) { trainingDayResult.TrainingExercises.Add(_trainingExercisesService.UpdateTrainingExercise(trainingExercise, true)); } } } return(trainingDayResult); }
internal TrainingDay UpdateTrainingDay(TrainingDay trainingDay, TrainingDayScenario trainingDayScenario) { TrainingDay trainingDayResult = null; trainingDayResult = _trainingDayModule.Update(trainingDay); if (trainingDayScenario != null && trainingDayScenario.ManageExercise) { var trainingExerciseService = new TrainingExerciseService(DbContext); var trainingExerciseCriteria = new TrainingExerciseCriteria() { UserId = new StringCriteria() { Equal = trainingDay.UserId }, Year = new IntegerCriteria() { Equal = trainingDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingDay.TrainingDayId } }; var trainingExercisesDb = trainingExerciseService.FindTrainingExercise(trainingExerciseCriteria); if (trainingExercisesDb != null && trainingExercisesDb.Count > 0) { foreach (var trainingExerciseDb in trainingExercisesDb) { trainingExerciseService.DeleteTrainingExercise(trainingExerciseDb); } } if (trainingDay.TrainingExercises != null) { trainingDayResult.TrainingExercises = new List <TrainingExercise>(); foreach (var trainingExercise in trainingDay.TrainingExercises) { trainingDayResult.TrainingExercises.Add(trainingExerciseService.UpdateTrainingExercise(trainingExercise, true)); } } } return(trainingDayResult); }
public List<TrainingExercise> FindTrainingExercise(TrainingExerciseCriteria trainingExerciseCriteria) { var trainingExercises = _trainingDayExerciseModule.Find(trainingExerciseCriteria); if (trainingExercises != null) { foreach (var trainingExercise in trainingExercises) { CompleteTrainingExerciseWithSet(trainingExercise); } } return trainingExercises; }
public List <TrainingExercise> FindTrainingExercise(TrainingExerciseCriteria trainingExerciseCriteria) { var trainingExercises = _trainingExerciseModule.Find(trainingExerciseCriteria); if (trainingExercises != null) { foreach (var trainingExercise in trainingExercises) { CompleteTrainingExerciseWithSet(trainingExercise); } } return(trainingExercises); }
/// <summary> /// Find datas /// </summary> /// <returns></returns> public List<TrainingExercise> Find(TrainingExerciseCriteria trainingExerciseCriteria = null) { List<TrainingExercise> resultList = null; IQueryable<TrainingExerciseRow> rowList = _dbContext.TrainingExercise; CriteriaTransformer.CompleteQuery(ref rowList, trainingExerciseCriteria); rowList = rowList.OrderBy(t => t.Id); if (rowList != null && rowList.Count() > 0) { resultList = new List<TrainingExercise>(); foreach (var row in rowList) { resultList.Add(GetBean(row)); } } return resultList; }
/// <summary> /// Find datas /// </summary> /// <returns></returns> public List <TrainingExercise> Find(TrainingExerciseCriteria trainingExerciseCriteria = null) { List <TrainingExercise> resultList = null; TableQuery <TrainingExerciseRow> rowList = _dbContext.Table <TrainingExerciseRow>(); CriteriaTransformer.CompleteQuery(ref rowList, trainingExerciseCriteria); rowList = rowList.OrderBy(t => t.Id); if (rowList != null && rowList.Count() > 0) { resultList = new List <TrainingExercise>(); foreach (var row in rowList) { resultList.Add(GetBean(row)); } } return(resultList); }
public List <TrainingExercise> FindTrainingExercise(TrainingExerciseCriteria trainingExerciseCriteria) { List <TrainingExercise> result = null; BeginTransaction(); try { result = GetTrainingExerciseManager().FindTrainingExercise(trainingExerciseCriteria); CommitTransaction(); } catch { RollbackTransaction(); throw; } finally { EndTransaction(); } return(result); }
public List <TrainingExercise> FindTrainingExercise(TrainingExerciseCriteria trainingExerciseCriteria) { return(GetTrainingExerciseManager().FindTrainingExercise(trainingExerciseCriteria)); }
private List<TrainingExercise> FindTrainingExercise(TrainingDay trainingDay) { if (trainingDay == null) return null; var criteria = new TrainingExerciseCriteria() { Year = new IntegerCriteria() { Equal = trainingDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingDay.TrainingDayId }, UserId = new StringCriteria() { Equal = trainingDay.UserId } }; return _trainingExercisesService.FindTrainingExercise(criteria); }
private void CompleteTrainingDayWithExercise(TrainingDay trainingJournalDay) { if (trainingJournalDay != null) { var trainingExerciseCriteria = new TrainingExerciseCriteria() { UserId = new StringCriteria() { Equal = trainingJournalDay.UserId }, Year = new IntegerCriteria() { Equal = trainingJournalDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingJournalDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingJournalDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingJournalDay.TrainingDayId } }; trainingJournalDay.TrainingExercises = _trainingWeeksService.FindTrainingExercise(trainingExerciseCriteria); } }
internal TrainingDay UpdateTrainingDay(TrainingDay trainingDay, TrainingDayScenario trainingDayScenario) { TrainingDay trainingDayResult = null; trainingDayResult = _trainingDayModule.Update(trainingDay); SynchroManager.TrainingDayChange(DbContext, trainingDayResult); if (trainingDayScenario != null && trainingDayScenario.ManageExercise) { var trainingExerciseCriteria = new TrainingExerciseCriteria() { UserId = new StringCriteria() { Equal = trainingDay.UserId }, Year = new IntegerCriteria() { Equal = trainingDay.Year }, WeekOfYear = new IntegerCriteria() { Equal = trainingDay.WeekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = trainingDay.DayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingDay.TrainingDayId } }; var trainingExercisesDb = _trainingWeeksService.FindTrainingExercise(trainingExerciseCriteria); if (trainingExercisesDb != null && trainingExercisesDb.Count > 0) { foreach(var trainingExerciseDb in trainingExercisesDb) { //remove only training exercises who do not present (for keep exercise tempos: retrocompatibility) if (trainingDay.TrainingExercises == null || !trainingDay.TrainingExercises.Any(te => te.Id == trainingExerciseDb.Id)) _trainingWeeksService.DeleteTrainingExercise(trainingExerciseDb); } } if (trainingDay.TrainingExercises != null) { trainingDayResult.TrainingExercises = new List<TrainingExercise>(); foreach (var trainingExercise in trainingDay.TrainingExercises) { trainingDayResult.TrainingExercises.Add(_trainingWeeksService.UpdateTrainingExercise(trainingExercise, true)); } } } return trainingDayResult; }
public IActionResult EditTrainingExercise(string userId, int year, int weekOfYear, int dayOfWeek, int trainingDayId, int trainingExerciseId, bool upward=false, bool downward=false) { if (IncorrectHttpData(userId, year, weekOfYear, dayOfWeek, trainingDayId, trainingExerciseId)) return RedirectToAction("Index"); var actionResult = GetViewActionResult(userId, year, weekOfYear, dayOfWeek); if (upward || downward) { var findcriteria = new TrainingExerciseCriteria() { UserId = new StringCriteria() { Equal = userId }, Year = new IntegerCriteria() { Equal = year }, WeekOfYear = new IntegerCriteria() { Equal = weekOfYear }, DayOfWeek = new IntegerCriteria() { Equal = dayOfWeek }, TrainingDayId = new IntegerCriteria() { Equal = trainingDayId } }; var trainingExercises = _trainingExercisesService.FindTrainingExercise(findcriteria); if (trainingExercises == null || trainingExercises.Count == 0) return actionResult; trainingExercises = trainingExercises.OrderBy(t => t.Id).ToList(); int indexOfCurrentExercice = trainingExercises.FindIndex(t => t.Id == trainingExerciseId); if (indexOfCurrentExercice == -1) return actionResult; foreach (var trainingExerciseTmp in trainingExercises) _trainingExercisesService.DeleteTrainingExercise(trainingExerciseTmp); OrderTrainingExercices(trainingExercises, indexOfCurrentExercice, upward == true); foreach (var trainingExerciseTmp in trainingExercises) _trainingExercisesService.CreateTrainingExercise(trainingExerciseTmp); return actionResult; } ViewBag.UserUnit = GetUserUnit(userId); var key = new TrainingExerciseKey() { UserId = userId, Year = year, WeekOfYear = weekOfYear, DayOfWeek = dayOfWeek, TrainingDayId = trainingDayId, Id = trainingExerciseId }; var trainingExercise = _trainingExercisesService.GetTrainingExercise(key); if (trainingExercise == null) return actionResult; var bodyExercise = _bodyExercisesService.GetBodyExercise(new BodyExerciseKey() { Id = trainingExercise.BodyExerciseId }); var viewModel = new TrainingExerciseViewModel(); viewModel.UserId = userId; viewModel.Year = year; viewModel.WeekOfYear = weekOfYear; viewModel.DayOfWeek = dayOfWeek; viewModel.TrainingDayId = trainingDayId; viewModel.TrainingExerciseId = trainingExerciseId; viewModel.BodyExerciseId = bodyExercise.Id; viewModel.BodyExerciseName = bodyExercise.Name; viewModel.BodyExerciseImage = bodyExercise.ImageName; viewModel.RestTime = trainingExercise.RestTime; viewModel.EccentricContractionTempo = trainingExercise.EccentricContractionTempo; viewModel.StretchPositionTempo = trainingExercise.StretchPositionTempo; viewModel.ConcentricContractionTempo = trainingExercise.ConcentricContractionTempo; viewModel.ContractedPositionTempo = trainingExercise.ContractedPositionTempo; viewModel.Unit = (int)GetUserUnit(userId); if (trainingExercise.TrainingExerciseSets != null) { if(trainingExercise.TrainingExerciseSets.Count > 0) //Take unit of first user set if exist viewModel.Unit = (int)trainingExercise.TrainingExerciseSets[0].Unit; foreach (var trainingExerciseSet in trainingExercise.TrainingExerciseSets) { for(int i=0; i < trainingExerciseSet.NumberOfSets; i++) { viewModel.Reps.Add(trainingExerciseSet.NumberOfReps); viewModel.Weights.Add(trainingExerciseSet.Weight); } } } if(viewModel.Reps == null || viewModel.Reps.Count == 0) viewModel.Reps = new List<int?>() { 8 }; if (viewModel.Weights == null || viewModel.Weights.Count == 0) viewModel.Weights = new List<double?>() { 0 }; return View(viewModel); }
public List<TrainingExercise> FindTrainingExercise(TrainingExerciseCriteria trainingExerciseCriteria) { return GetTrainingExerciseManager().FindTrainingExercise(trainingExerciseCriteria); }