public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
BodyExercise result = _bodyExerciseModule.Get(key);
CompleteTranslation(result);
return(result);
}
public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
var bodyExercise = _module.Get(key);
if (bodyExercise != null)
bodyExercise.Name = Translation.GetInDB(BodyExerciseTransformer.GetTranslationKey(bodyExercise.Id));
return bodyExercise;
}
internal void DeleteBodyExercise(BodyExerciseKey key)
{
_bodyExerciseModule.Delete(key);
//Update Translation Name
Translation.DeleteInDB(BodyExerciseTransformer.GetTranslationKey(key.Id), DbContext);
}
/// <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));
}
internal void DeleteBodyExercise(BodyExerciseKey key)
{
_bodyExerciseModule.Delete(key);
//Update Translation Name
Translation.DeleteInDB(BodyExerciseTransformer.GetTranslationKey(key.Id), DbContext);
}
public IActionResult Edit(BodyExerciseViewModel bodyExerciseViewModel, IFormFile imageFile)
{
if (ModelState.IsValid)
{
// Verify not exist on bodyExercise name
var key = new BodyExerciseKey()
{
Id = bodyExerciseViewModel.Id
};
var bodyExercise = _bodyExercisesService.GetBodyExercise(key);
if (bodyExercise != null)
{
string oldImageName = bodyExercise.ImageName;
bodyExercise.Name = bodyExerciseViewModel.Name;
bodyExercise.MuscleId = bodyExerciseViewModel.MuscleId;
bodyExercise.ExerciseCategoryType = Utils.IntToEnum <TExerciseCategoryType>(bodyExerciseViewModel.ExerciseCategoryType);
bodyExercise.ExerciseUnitType = Utils.IntToEnum <TExerciseUnitType>(bodyExerciseViewModel.ExerciseUnitType);
bodyExercise = _bodyExercisesService.UpdateBodyExercise(bodyExercise);
//Save a new Image if it's correct
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(), bodyExerciseViewModel?.MuscleId ?? 0);
ViewBag.ExerciseCategories = ControllerUtils.CreateSelectExerciseCategoryTypeItemList(bodyExerciseViewModel?.ExerciseCategoryType ?? 0);
ViewBag.ExerciseUnitTypes = ControllerUtils.CreateSelectExerciseUnitTypeItemList(bodyExerciseViewModel?.ExerciseUnitType ?? 0);
return(View(bodyExerciseViewModel));
}
/// <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);
}
internal void Delete(BodyExerciseKey key)
{
//Update Translation Name
//Translation.DeleteInDB(MuscularGroupTransformer.GetTranslationKey(key.Id), _dbContext);
_module.Delete(key);
}
public IActionResult Edit(int id)
{
if (id > 0)
{
var key = new BodyExerciseKey()
{
Id = id
};
var bodyExercise = _bodyExercisesService.GetBodyExercise(key);
if (bodyExercise != null)
{
var bodyExerciseViewModel = new BodyExerciseViewModel();
bodyExerciseViewModel.Id = bodyExercise.Id;
bodyExerciseViewModel.Name = bodyExercise.Name;
bodyExerciseViewModel.MuscleId = bodyExercise.MuscleId;
bodyExerciseViewModel.MuscleName = Translation.GetInDB(MuscleTransformer.GetTranslationKey(bodyExercise.MuscleId));
bodyExerciseViewModel.ExerciseCategoryType = (int)bodyExercise.ExerciseCategoryType;
bodyExerciseViewModel.ExerciseUnitType = (int)bodyExercise.ExerciseUnitType;
bodyExerciseViewModel.ImageUrl = ImageUtils.GetImageUrl(_env.WebRootPath, "bodyexercises", bodyExercise.ImageName);
ViewBag.Muscles = ControllerUtils.CreateSelectMuscleItemList(_musclesService.FindMuscles(), bodyExercise.MuscleId);
ViewBag.ExerciseCategories = ControllerUtils.CreateSelectExerciseCategoryTypeItemList((int)bodyExercise.ExerciseCategoryType);
ViewBag.ExerciseUnitTypes = ControllerUtils.CreateSelectExerciseUnitTypeItemList((int)bodyExercise.ExerciseUnitType);
return(View(bodyExerciseViewModel));
}
}
return(RedirectToAction("Index"));
}
public IActionResult Delete([FromBody] BodyExerciseKey key)
{
try
{
_bodyExercisesService.DeleteBodyExercise(key);
return(new OkObjectResult(true)); // bool
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(BodyExerciseKey key)
{
if (key == null || key.Id == 0)
return;
var bodyExerciseRow = _dbContext.BodyExercise.Where(m => m.Id == key.Id).FirstOrDefault();
if (bodyExerciseRow != null)
{
_dbContext.BodyExercise.Remove(bodyExerciseRow);
_dbContext.SaveChanges();
}
}
public IActionResult Get(BodyExerciseKey key)
{
try
{
var result = _bodyExercisesService.GetBodyExercise(key);
return(new OkObjectResult(result)); // BodyExercise
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
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);
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(BodyExerciseKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var bodyExerciseRow = _dbContext.Table <BodyExerciseRow>().Where(m => m.Id == key.Id).FirstOrDefault();
if (bodyExerciseRow != null)
{
_dbContext.Delete(bodyExerciseRow);
}
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(BodyExerciseKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var bodyExerciseRow = _dbContext.BodyExercise.Where(m => m.Id == key.Id).FirstOrDefault();
if (bodyExerciseRow != null)
{
_dbContext.BodyExercise.Remove(bodyExerciseRow);
_dbContext.SaveChanges();
}
}
/// <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);
}
public IActionResult Delete(int id)
{
if (id > 0)
{
var key = new BodyExerciseKey()
{
Id = id
};
var bodyExercise = _bodyExercisesService.GetBodyExercise(key);
if (bodyExercise != null)
{
_bodyExercisesService.DeleteBodyExercise(key);
DeleteImage(bodyExercise.ImageName);
}
}
return(RedirectToAction("Index"));
}
public void DeleteBodyExercise(BodyExerciseKey key)
{
BeginTransaction();
try
{
GetBodyExerciseManager().Delete(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch
{
RollbackTransaction();
throw;
}
finally
{
EndTransaction();
}
}
public void DeleteBodyExercise(BodyExerciseKey key)
{
BeginTransaction();
try
{
GetBodyExerciseManager().DeleteBodyExercise(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to delete bodyexercise", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
}
public void DeleteBodyExercise(BodyExerciseKey key)
{
BeginTransaction();
try
{
GetBodyExerciseManager().DeleteBodyExercise(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to delete bodyexercise", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
}
public IActionResult Edit(BodyExerciseViewModel bodyExerciseViewModel, IFormFile imageFile)
{
if (ModelState.IsValid)
{
// Verify not exist on bodyExercise name
var key = new BodyExerciseKey() { Id = bodyExerciseViewModel.Id };
var bodyExercise = _bodyExercisesService.GetBodyExercise(key);
if (bodyExercise != null)
{
string oldImageName = bodyExercise.ImageName;
bodyExercise.Name = bodyExerciseViewModel.Name;
bodyExercise.MuscleId = bodyExerciseViewModel.MuscleId;
bodyExercise = _bodyExercisesService.UpdateBodyExercise(bodyExercise);
//Save a new Image if it's correct
if (ImageUtils.CheckUploadedImageIsCorrect(imageFile, "png"))
{
ImageUtils.SaveImage(imageFile, Path.Combine(_env.WebRootPath, "images", "bodyexercises"), bodyExercise.ImageName);
}
return RedirectToAction("Index");
}
}
int muscleId = 0;
if (bodyExerciseViewModel != null)
muscleId = bodyExerciseViewModel.MuscleId;
ViewBag.Muscles = ControllerUtils.CreateSelectMuscleItemList(_musclesService.FindMuscles(), muscleId);
return View(bodyExerciseViewModel);
}
public IActionResult Edit(int id)
{
if (id > 0)
{
var key = new BodyExerciseKey() { Id = id };
var bodyExercise = _bodyExercisesService.GetBodyExercise(key);
if (bodyExercise != null)
{
var bodyExerciseViewModel = new BodyExerciseViewModel();
bodyExerciseViewModel.Id = bodyExercise.Id;
bodyExerciseViewModel.Name = bodyExercise.Name;
bodyExerciseViewModel.MuscleId = bodyExercise.MuscleId;
bodyExerciseViewModel.MuscleName = Translation.GetInDB(MuscleTransformer.GetTranslationKey(bodyExercise.MuscleId));
bodyExerciseViewModel.ImageUrl = ImageUtils.GetImageUrl(_env.WebRootPath, "bodyexercises", bodyExercise.ImageName);
ViewBag.Muscles = ControllerUtils.CreateSelectMuscleItemList(_musclesService.FindMuscles(), bodyExercise.MuscleId);
return View(bodyExerciseViewModel);
}
}
return RedirectToAction("Index");
}
public IActionResult Delete(int id)
{
if (id > 0)
{
var key = new BodyExerciseKey() { Id = id };
var bodyExercise = _bodyExercisesService.GetBodyExercise(key);
if (bodyExercise != null)
{
_bodyExercisesService.DeleteBodyExercise(key);
DeleteImage(bodyExercise.ImageName);
}
}
return RedirectToAction("Index");
}
public IActionResult Get(BodyExerciseKey key)
{
try
{
var result = _bodyExercisesService.GetBodyExercise(key);
return new OkObjectResult(result); // BodyExercise
}
catch (Exception exception)
{
return BadRequest(new WebApiException("Error", exception));
}
}
public static async Task <BodyExercise> GetAsync(WebApiWrapper webApiWrapper, string userId, Cookie cookie, BodyExerciseKey key)
{
Dictionary <string, string> datas = new Dictionary <string, string>();
datas.Add("Id", key.Id.ToString());
return(await webApiWrapper.HttpClientPoolManager.GetAsync <BodyExercise>(userId, cookie, _baseUrl + "Get", datas));
}
public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
BodyExercise result = _bodyExerciseModule.Get(key);
CompleteTranslation(result);
return result;
}
public BodyExercise GetBodyExercise(BodyExerciseKey key)
{
BodyExercise bodyExercise = null;
string cacheKey = key == null ? "BodyExerciseKey_null" : key.GetCacheKey();
if (key != null && !TryGetCacheData(cacheKey, out bodyExercise))
{
bodyExercise = GetBodyExerciseManager().GetBodyExercise(key);
SetCacheData(_cacheName, cacheKey, bodyExercise);
}
return bodyExercise;
}
public static async Task <bool> DeleteAsync(WebApiWrapper webApiWrapper, string userId, Cookie cookie, BodyExerciseKey key)
{
return(await webApiWrapper.HttpClientPoolManager.PostAsync <BodyExerciseKey, bool>(userId, cookie, _baseUrl + "Delete", key));
}
/// <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;
}
