internal BodyExercise Update(BodyExercise bodyExercise)
{
//Update Translation Name
//Translation.UpdateInDB(BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id), bodyExercise.Name, _dbContext);
return _module.Update(bodyExercise);
}
public BodyExercise CreateBodyExercise(BodyExercise bodyExercise)
{
//invalidate cache
InvalidateCache(_cacheName);
BodyExercise result = null;
BeginTransaction();
try
{
result = GetBodyExerciseManager().CreateBodyExercise(bodyExercise);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
return(result);
}
public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
BodyExercise result = _bodyExerciseModule.Get(key);
CompleteTranslation(result);
return(result);
}
/// <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);
}
/// <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));
}
public IActionResult Create(BodyExerciseViewModel bodyExerciseViewModel, IFormFile imageFile)
{
if (ModelState.IsValid)
{
var bodyExercise = new BodyExercise()
{
Name = bodyExerciseViewModel.Name,
MuscleId = bodyExerciseViewModel.MuscleId,
ExerciseCategoryType = Utils.IntToEnum <TExerciseCategoryType>(bodyExerciseViewModel.ExerciseCategoryType),
ExerciseUnitType = Utils.IntToEnum <TExerciseUnitType>(bodyExerciseViewModel.ExerciseUnitType)
};
bodyExercise = _bodyExercisesService.CreateBodyExercise(bodyExercise);
if (bodyExercise == null || bodyExercise.Id == 0)
{
_logger.LogError("Create new Body Exercise fail");
}
else if (ImageUtils.CheckUploadedImageIsCorrect(imageFile, "png"))
{
ImageUtils.SaveImage(imageFile, Path.Combine(_env.WebRootPath, "images", "bodyexercises"), bodyExercise.ImageName);
}
return(RedirectToAction("Index"));
}
ViewBag.Muscles = ControllerUtils.CreateSelectMuscleItemList(_musclesService.FindMuscles(), 0);
ViewBag.ExerciseCategories = ControllerUtils.CreateSelectExerciseCategoryTypeItemList(0);
ViewBag.ExerciseUnitTypes = ControllerUtils.CreateSelectExerciseUnitTypeItemList(0);
return(View(bodyExerciseViewModel));
}
public static void ToRow(BodyExercise bean, BodyExerciseRow row)
{
if (bean == null)
return;
row.Id = bean.Id;
row.MuscleId = bean.MuscleId;
}
private void SaveTranslation(BodyExercise bodyExercise)
{
if (bodyExercise != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
Translation.UpdateInDB(trKey, bodyExercise.Name, DbContext);
}
}
private void CompleteTranslation(BodyExercise bodyExercise)
{
if (bodyExercise != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
bodyExercise.Name = Translation.GetInDB(trKey, DbContext);
}
}
private void CompleteTranslation(BodyExercise bodyExercise)
{
if (bodyExercise != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
bodyExercise.Name = Translation.GetInDB(trKey, DbContext);
}
}
internal BodyExercise UpdateBodyExercise(BodyExercise bodyExercise)
{
SaveTranslation(bodyExercise);
BodyExercise result = _bodyExerciseModule.Update(bodyExercise);
CompleteTranslation(result);
return result;
}
internal BodyExercise UpdateBodyExercise(BodyExercise bodyExercise)
{
SaveTranslation(bodyExercise);
BodyExercise result = _bodyExerciseModule.Update(bodyExercise);
CompleteTranslation(result);
return(result);
}
public static void ToRow(BodyExercise bean, BodyExerciseRow row)
{
if (bean == null)
{
return;
}
row.Id = bean.Id;
row.MuscleId = bean.MuscleId;
}
public static void ToRow(BodyExercise bean, BodyExerciseRow row)
{
if (bean == null)
{
return;
}
row.Id = bean.Id;
row.MuscleId = bean.MuscleId;
row.ExerciseCategoryType = (int)bean.ExerciseCategoryType;
row.ExerciseUnitType = (int)bean.ExerciseUnitType;
}
public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
BodyExercise bodyExercise = null;
string cacheKey = key == null ? "BodyExerciseKey_null" : key.GetCacheKey();
if (key != null && !TryGetCacheData(cacheKey, out bodyExercise, _cacheName))
{
bodyExercise = GetBodyExerciseManager().GetBodyExercise(key);
SetCacheData(_cacheName, cacheKey, bodyExercise);
}
return(bodyExercise);
}
public BodyExercise CreateBodyExercise(BodyExercise bodyExercise)
{
string name = bodyExercise != null ? bodyExercise.Name : null;
var result = _bodyExerciseModule.Create(bodyExercise);
if (result != null && result.Id != 0)
{
result.Name = name;
SaveTranslation(result);
CompleteTranslation(result);
}
return result;
}
public IActionResult Update([FromBody] BodyExercise bodyExercise)
{
try
{
BodyExercise result = _bodyExercisesService.UpdateBodyExercise(bodyExercise);
return(new OkObjectResult(result)); // BodyExercise
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
public BodyExercise CreateBodyExercise(BodyExercise bodyExercise)
{
string name = bodyExercise != null ? bodyExercise.Name : null;
var result = _bodyExerciseModule.Create(bodyExercise);
if (result != null && result.Id != 0)
{
result.Name = name;
SaveTranslation(result);
CompleteTranslation(result);
}
return(result);
}
internal static BodyExercise ToBean(BodyExerciseRow row)
{
if (row == null)
return null;
var bean = new BodyExercise();
bean.Id = row.Id;
//Image name is "{id}.png"
bean.ImageName = string.Format("{0}.png", row.Id);
bean.MuscleId = row.MuscleId;
return bean;
}
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 static void ToRow(BodyExercise bean, BodyExerciseRow row)
{
if (bean == null)
{
return;
}
row.Id = bean.Id;
row.MuscleId = bean.MuscleId;
if (bean.ObjectVersionNumber > 0) // Retrocompatibility
{
row.ExerciseCategoryType = (int)bean.ExerciseCategoryType;
row.ExerciseUnitType = (int)bean.ExerciseUnitType;
}
}
internal static BodyExercise ToBean(BodyExerciseRow row)
{
if (row == null)
{
return(null);
}
var bean = new BodyExercise();
bean.Id = row.Id;
//bean.Name = Resources.Translation.GetInDB(GetTranslationKey(row.Id));
//Image name is "{id}.png"
bean.ImageName = string.Format("{0}.png", row.Id);
bean.MuscleId = row.MuscleId;
return(bean);
}
/// <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));
}
internal static BodyExercise ToBean(BodyExerciseRow row)
{
if (row == null)
{
return(null);
}
var bean = new BodyExercise();
bean.Id = row.Id;
//Image name is "{id}.png"
bean.ImageName = string.Format("{0}.png", row.Id);
bean.MuscleId = row.MuscleId;
bean.ExerciseCategoryType = Utils.IntToEnum <TExerciseCategoryType>(row.ExerciseCategoryType ?? (int)TExerciseCategoryType.Bodybuilding);
bean.ExerciseUnitType = Utils.IntToEnum <TExerciseUnitType>(row.ExerciseUnitType ?? (int)TExerciseUnitType.RepetitionNumber);
return(bean);
}
/// <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));
}
}
public IActionResult Create(BodyExerciseViewModel bodyExerciseViewModel, IFormFile imageFile)
{
if (ModelState.IsValid)
{
var bodyExercise = new BodyExercise() { Name = bodyExerciseViewModel.Name, MuscleId = bodyExerciseViewModel.MuscleId };
bodyExercise = _bodyExercisesService.CreateBodyExercise(bodyExercise);
if (bodyExercise == null || bodyExercise.Id == 0)
{
_logger.LogError("Create new Body Exercise fail");
}
else if (ImageUtils.CheckUploadedImageIsCorrect(imageFile, "png"))
{
ImageUtils.SaveImage(imageFile, Path.Combine(_env.WebRootPath, "images", "bodyexercises"), bodyExercise.ImageName);
}
return RedirectToAction("Index");
}
ViewBag.Muscles = ControllerUtils.CreateSelectMuscleItemList(_musclesService.FindMuscles(), 0);
return View(bodyExerciseViewModel);
}
public BodyExercise CreateBodyExercise(BodyExercise bodyExercise)
{
BodyExercise result = null;
BeginTransaction();
try
{
result = GetBodyExerciseManager().CreateBodyExercise(bodyExercise);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to create bodyexercise", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
return result;
}
public BodyExercise UpdateBodyExercise(BodyExercise bodyExercise)
{
BodyExercise result = null;
BeginTransaction();
try
{
result = GetBodyExerciseManager().UpdateBodyExercise(bodyExercise);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to update bodyexercise", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
return(result);
}
public BodyExercise UpdateBodyExercise(BodyExercise bodyExercise)
{
BodyExercise result = null;
BeginTransaction();
try
{
result = GetBodyExerciseManager().Update(bodyExercise);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch
{
RollbackTransaction();
throw;
}
finally
{
EndTransaction();
}
return(result);
}
public static async Task <BodyExercise> UpdateAsync(WebApiWrapper webApiWrapper, string userId, Cookie cookie, BodyExercise bodyExercice)
{
return(await webApiWrapper.HttpClientPoolManager.PostAsync <BodyExercise, BodyExercise>(userId, cookie, _baseUrl + "Update", bodyExercice));
}
private void SaveTranslation(BodyExercise bodyExercise)
{
if (bodyExercise != null)
{
string trKey = BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id);
Translation.UpdateInDB(trKey, bodyExercise.Name, DbContext);
}
}
/// <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);
}
}
