internal void DeleteBodyExercise(BodyExerciseKey key)
{
_bodyExerciseModule.Delete(key);
//Update Translation Name
Translation.DeleteInDB(BodyExerciseTransformer.GetTranslationKey(key.Id), DbContext);
}
public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
var bodyExercise = _module.Get(key);
if (bodyExercise != null)
bodyExercise.Name = Translation.GetInDB(BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id));
return bodyExercise;
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="bodyExercise">Data</param>
/// <returns>insert data</returns>
public BodyExercise Create(BodyExercise bodyExercise)
{
if (bodyExercise == null)
{
return(null);
}
if (bodyExercise.Id == 0)
{
var key = new BodyExerciseKey();
var sequencerManager = new SequencerManager();
do
{
key.Id = sequencerManager.GetNextValue(_dbContext, 2, "bodyExercise");
}while (Get(key) != null); // Test Record exist
bodyExercise.Id = key.Id;
}
if (bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = new BodyExerciseRow();
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.BodyExercise.Add(bodyExerciseRow);
_dbContext.SaveChanges();
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
private void CompleteTranslation(BodyExercise bodyExercise)
{
if (bodyExercise != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
bodyExercise.Name = Translation.GetInDB(trKey, DbContext);
}
}
private void SaveTranslation(BodyExercise bodyExercise)
{
if (bodyExercise != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
Translation.UpdateInDB(trKey, bodyExercise.Name, DbContext);
}
}
private void SaveTranslation(Muscle muscle)
{
if (muscle != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(muscle.Id);
Translation.UpdateInDB(trKey, muscle.Name, DbContext);
}
}
public BodyExercise CreateBodyExercise(BodyExercise bodyExercise)
{
string name = bodyExercise.Name;
bodyExercise = _module.Create(bodyExercise);
if (bodyExercise != null && bodyExercise.Id > 0)
{
//Update Translation Name
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
/*Translation.UpdateInDB(trKey, name, _dbContext);*/
bodyExercise.Name = Translation.GetInDB(trKey);
}
return bodyExercise;
}
public List<BodyExercise> FindBodyExercises(BodyExerciseCriteria bodyExerciseCriteria = null)
{
var bodyExerciseList = _module.Find(bodyExerciseCriteria);
if (bodyExerciseList != null)
{
foreach (var bodyExercise in bodyExerciseList)
{
if (bodyExercise != null)
bodyExercise.Name = Translation.GetInDB(BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id));
}
}
return bodyExerciseList;
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public BodyExercise Get(BodyExerciseKey key)
{
if (key == null || key.Id == 0)
{
return(null);
}
var bodyExerciseRow = _dbContext.BodyExercise.Where(m => m.Id == key.Id).FirstOrDefault();
if (bodyExerciseRow != null)
{
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
return(null);
}
/// <summary>
/// Find body exercises
/// </summary>
/// <returns></returns>
public List <BodyExercise> Find(BodyExerciseCriteria bodyExerciseCriteria = null)
{
List <BodyExercise> resultList = null;
TableQuery <BodyExerciseRow> muscularGroupRowList = _dbContext.Table <BodyExerciseRow>();
CriteriaTransformer.CompleteQuery(ref muscularGroupRowList, bodyExerciseCriteria);
if (muscularGroupRowList != null && muscularGroupRowList.Count() > 0)
{
resultList = new List <BodyExercise>();
foreach (var muscularGroupRow in muscularGroupRowList)
{
resultList.Add(BodyExerciseTransformer.ToBean(muscularGroupRow));
}
}
return(resultList);
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="bodyExercise">Data</param>
/// <returns>insert data</returns>
public BodyExercise Create(BodyExercise bodyExercise)
{
if (bodyExercise == null)
{
return(null);
}
if (bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = new BodyExerciseRow();
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.Insert(bodyExerciseRow);
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="bodyExercise">data</param>
/// <returns>updated data</returns>
public BodyExercise Update(BodyExercise bodyExercise)
{
if (bodyExercise == null || bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = _dbContext.BodyExercise.Where(m => m.Id == bodyExercise.Id).FirstOrDefault();
if (bodyExerciseRow == null)
{ // No data in database
return(Create(bodyExercise));
}
else
{ //Modify Data in database
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.SaveChanges();
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="bodyExercise">data</param>
/// <returns>updated data</returns>
public BodyExercise Update(BodyExercise bodyExercise)
{
if (bodyExercise == null || bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = _dbContext.Table <BodyExerciseRow>().Where(m => m.Id == bodyExercise.Id).FirstOrDefault();
if (bodyExerciseRow == null)
{ // No data in database
return(Create(bodyExercise));
}
else
{ //Modify Data in database
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.Delete(bodyExerciseRow); //Update don't work... need delete and insert
_dbContext.Insert(bodyExerciseRow);
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
}
private async Task SynchronizeDataAsync()
{
var unit = await GetExerciseUnit();
string weightUnit = "kg";
if (unit == TUnitType.Imperial)
{
weightUnit = Translation.Get(TRS.POUND);
}
ExerciseTitle = Translation.GetInDB(BodyExerciseTransformer.GetTranslationKey(_trainingExercise.BodyExerciseId));
RestTime = _trainingExercise.RestTime;
EccentricContractionTempo = _trainingExercise.EccentricContractionTempo;
StretchPositionTempo = _trainingExercise.StretchPositionTempo;
ConcentricContractionTempo = _trainingExercise.ConcentricContractionTempo;
ContractedPositionTempo = _trainingExercise.ContractedPositionTempo;
string urlImages = HttpConnector.Instance.BaseUrl + "images/bodyexercises/{0}";
var imageName = string.Format("{0}.png", _trainingExercise.BodyExerciseId);
var urlImage = string.Format(urlImages, imageName);
var localImagePath = Path.Combine(AppTools.BodyExercisesImagesDirectory, imageName);
await AppTools.Instance.CachingImageAsync(_trainingExercise, urlImage, localImagePath, null);
ExerciseImageSource = localImagePath;
if (BindingTrainingExerciseSetReps == null)
{
BindingTrainingExerciseSetReps = new ObservableCollection <BindingTrainingExerciseSetRep>();
}
else
{
BindingTrainingExerciseSetReps.Clear();
}
if (_trainingExercise != null)
{
BindingTrainingExerciseSetRep bindingSetRep;
if (_trainingExercise.TrainingExerciseSets == null || _trainingExercise.TrainingExerciseSets.Count == 0)
{
bindingSetRep = new BindingTrainingExerciseSetRep();
bindingSetRep.RepsLabel = Translation.Get(TRS.REPS);
bindingSetRep.WeightsLabel = Translation.Get(TRS.WEIGHT) + "(" + weightUnit + ")";
bindingSetRep.Reps = 8;
bindingSetRep.Weights = 0;
BindingTrainingExerciseSetReps.Add(bindingSetRep);
}
else
{
int count = 0;
foreach (var trainingExerciseSet in _trainingExercise.TrainingExerciseSets)
{
for (int i = 0; i < trainingExerciseSet.NumberOfSets; i++)
{
bindingSetRep = new BindingTrainingExerciseSetRep();
if (count == 0)
{
bindingSetRep.RepsLabel = Translation.Get(TRS.REPS);
bindingSetRep.WeightsLabel = Translation.Get(TRS.WEIGHT) + "(" + weightUnit + ")";
}
else
{
bindingSetRep.RepsLabel = bindingSetRep.WeightsLabel = string.Empty; // necessary for trigger Text.Length
}
bindingSetRep.Reps = trainingExerciseSet.NumberOfReps;
bindingSetRep.Weights = trainingExerciseSet.Weight;
BindingTrainingExerciseSetReps.Add(bindingSetRep);
count++;
}
}
}
if (BindingTrainingExerciseSetReps.Count > 0)
{
BindingTrainingExerciseSetReps[BindingTrainingExerciseSetReps.Count - 1].BtnPlusVisible = true;
}
}
}
