internal Muscle GetMuscle(MuscleKey key)
{
var result = _muscleModule.Get(key);
CompleteTranslation(result);
return(result);
}
public IActionResult Edit(MuscleViewModel viewModel)
{
if (ModelState.IsValid && viewModel.Id > 0)
{
// Verify not exist on id
var key = new MuscleKey()
{
Id = viewModel.Id
};
var muscle = _musclesService.GetMuscle(key);
if (muscle != null)
{
muscle.Name = viewModel.Name;
muscle.MuscularGroupId = viewModel.MuscularGroupId;
muscle = _musclesService.UpdateMuscle(muscle);
return(RedirectToAction("Index"));
}
}
int muscularGroupId = 0;
if (viewModel != null)
{
muscularGroupId = viewModel.MuscularGroupId;
}
ViewBag.MuscularGroups = ControllerUtils.CreateSelectMuscularGroupItemList(_muscularGroupsService.FindMuscularGroups(), muscularGroupId);
return(View(viewModel));
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="muscle">Data</param>
/// <returns>insert data</returns>
public Muscle Create(Muscle muscle)
{
if (muscle == null)
{
return(null);
}
if (muscle.Id == 0)
{
var key = new MuscleKey();
var sequencerManager = new SequencerManager();
do
{
key.Id = sequencerManager.GetNextValue(_dbContext, 4, "muscle");
}while (Get(key) != null); // Test Record exist
muscle.Id = key.Id;
}
if (muscle.Id == 0)
{
return(null);
}
var row = new MuscleRow();
MuscleTransformer.ToRow(muscle, row);
_dbContext.Muscle.Add(row);
_dbContext.SaveChanges();
return(MuscleTransformer.ToBean(row));
}
internal Muscle GetMuscle(MuscleKey key)
{
var muscle = _module.Get(key);
if (muscle != null)
{
muscle.Name = Translation.GetInDB(MuscleTransformer.GetTranslationKey(muscle.Id));
}
return(muscle);
}
public Muscle GetMuscle(MuscleKey key)
{
Muscle muscle = null;
string cacheKey = key == null ? "MuscleKey_null" : key.GetCacheKey();
if (key != null && !TryGetCacheData(cacheKey, out muscle, _cacheName))
{
muscle = GetMuscleManager().GetMuscle(key);
SetCacheData(_cacheName, cacheKey, muscle);
}
return(muscle);
}
public IActionResult Delete([FromBody] MuscleKey key)
{
try
{
_musclesService.DeleteMuscle(key);
return(new OkObjectResult(true)); // bool
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
public IActionResult Get(MuscleKey key)
{
try
{
var result = _musclesService.GetMuscle(key);
return(new OkObjectResult(result)); // Muscle
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(MuscleKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var row = _dbContext.Table <MuscleRow>().Where(m => m.Id == key.Id).FirstOrDefault();
if (row != null)
{
_dbContext.Delete(row);
}
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public Muscle Get(MuscleKey key)
{
if (key == null || key.Id == 0)
{
return(null);
}
var row = _dbContext.Muscle.Where(m => m.Id == key.Id).FirstOrDefault();
if (row != null)
{
return(MuscleTransformer.ToBean(row));
}
return(null);
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(MuscleKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var row = _dbContext.Muscle.Where(m => m.Id == key.Id).FirstOrDefault();
if (row != null)
{
_dbContext.Muscle.Remove(row);
_dbContext.SaveChanges();
}
}
public IActionResult Delete(int id)
{
if (id != 0)
{
var key = new MuscleKey()
{
Id = id
};
var muscle = _musclesService.GetMuscle(key);
if (muscle != null)
{
_musclesService.DeleteMuscle(muscle);
}
}
return(RedirectToAction("Index"));
}
public void DeleteMuscle(MuscleKey key)
{
BeginTransaction();
try
{
GetMuscleManager().DeleteMuscle(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to delete muscle", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
}
public IActionResult Edit(int id)
{
if (id != 0)
{
var key = new MuscleKey()
{
Id = id
};
var muscle = _musclesService.GetMuscle(key);
if (muscle != null)
{
var viewModel = new MuscleViewModel();
viewModel.Id = muscle.Id;
viewModel.Name = muscle.Name;
viewModel.MuscularGroupId = muscle.MuscularGroupId;
ViewBag.MuscularGroups = ControllerUtils.CreateSelectMuscularGroupItemList(_muscularGroupsService.FindMuscularGroups(), viewModel.MuscularGroupId);
return(View(viewModel));
}
}
return(RedirectToAction("Index"));
}
internal void DeleteMuscle(MuscleKey key)
{
//Update Translation Name
Translation.DeleteInDB(MuscleTransformer.GetTranslationKey(key.Id), DbContext);
_muscleModule.Delete(key);
}
