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