/// <summary>
/// Create data in database
/// </summary>
/// <param name="muscularGroup">Data</param>
/// <returns>insert data</returns>
public MuscularGroup Create(MuscularGroup muscularGroup)
{
if (muscularGroup == null)
{
return(null);
}
if (muscularGroup.Id == 0)
{
var key = new MuscularGroupKey();
var sequencerManager = new SequencerManager();
do
{
key.Id = sequencerManager.GetNextValue(_dbContext, 1, "muscularGroup");
}while (Get(key) != null); // Test Record exist
muscularGroup.Id = key.Id;
}
if (muscularGroup.Id == 0)
{
return(null);
}
var muscularGroupRow = new MuscularGroupRow();
MuscularGroupTransformer.ToRow(muscularGroup, muscularGroupRow);
_dbContext.MuscularGroup.Add(muscularGroupRow);
_dbContext.SaveChanges();
return(MuscularGroupTransformer.ToBean(muscularGroupRow));
}
internal MuscularGroup GetMuscularGroup(MuscularGroupKey key)
{
MuscularGroup result = _muscularGroupModule.Get(key);
CompleteTranslation(result);
return(result);
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="muscularGroup">Data</param>
/// <returns>insert data</returns>
public MuscularGroup Create(MuscularGroup muscularGroup)
{
if (muscularGroup == null)
return null;
if (muscularGroup.Id == 0)
{
var key = new MuscularGroupKey();
var sequencerManager = new SequencerManager();
do
{
key.Id = sequencerManager.GetNextValue(_dbContext, 1, "muscularGroup");
}
while (Get(key) != null); // Test Record exist
muscularGroup.Id = key.Id;
}
if(muscularGroup.Id == 0)
return null;
var muscularGroupRow = new MuscularGroupRow();
MuscularGroupTransformer.ToRow(muscularGroup, muscularGroupRow);
_dbContext.MuscularGroup.Add(muscularGroupRow);
_dbContext.SaveChanges();
return MuscularGroupTransformer.ToBean(muscularGroupRow);
}
internal MuscularGroup GetMuscularGroup(MuscularGroupKey key)
{
var muscularGroup = _module.Get(key);
if (muscularGroup != null)
{
muscularGroup.Name = Translation.GetInDB(MuscularGroupTransformer.GetTranslationKey(muscularGroup.Id));
}
return(muscularGroup);
}
public IActionResult Get(MuscularGroupKey key)
{
try
{
var result = _muscularGroupsService.GetMuscularGroup(key);
return new OkObjectResult(result); // MuscularGroup
}
catch (Exception exception)
{
return BadRequest(new WebApiException("Error", exception));
}
}
public MuscularGroup GetMuscularGroup(MuscularGroupKey key)
{
MuscularGroup muscularGroup = null;
string cacheKey = key == null ? "MuscularGroupKey_null" : key.GetCacheKey();
if (key != null && !TryGetCacheData(cacheKey, out muscularGroup))
{
muscularGroup = GetMuscularGroupManager().GetMuscularGroup(key);
SetCacheData(_cacheName, cacheKey, muscularGroup);
}
return(muscularGroup);
}
public IActionResult Delete([FromBody] MuscularGroupKey key)
{
try
{
_muscularGroupsService.DeleteMuscularGroup(key);
return(new OkObjectResult(true)); // bool
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
public IActionResult Get(MuscularGroupKey key)
{
try
{
var result = _muscularGroupsService.GetMuscularGroup(key);
return(new OkObjectResult(result)); // MuscularGroup
}
catch (Exception exception)
{
return(BadRequest(new WebApiException("Error", exception)));
}
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(MuscularGroupKey key)
{
if (key == null || key.Id == 0)
return;
var muscularGroupRow = _dbContext.MuscularGroup.Where(m => m.Id == key.Id).FirstOrDefault();
if (muscularGroupRow != null)
{
_dbContext.MuscularGroup.Remove(muscularGroupRow);
_dbContext.SaveChanges();
}
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(MuscularGroupKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var muscularGroupRow = _dbContext.Table <MuscularGroupRow>().Where(m => m.Id == key.Id).FirstOrDefault();
if (muscularGroupRow != null)
{
_dbContext.Delete(muscularGroupRow);
}
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public MuscularGroup Get(MuscularGroupKey key)
{
if (key == null || key.Id == 0)
{
return(null);
}
var muscularGroupRow = _dbContext.Table <MuscularGroupRow>().Where(m => m.Id == key.Id).FirstOrDefault();
if (muscularGroupRow != null)
{
return(MuscularGroupTransformer.ToBean(muscularGroupRow));
}
return(null);
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(MuscularGroupKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var muscularGroupRow = _dbContext.MuscularGroup.Where(m => m.Id == key.Id).FirstOrDefault();
if (muscularGroupRow != null)
{
_dbContext.MuscularGroup.Remove(muscularGroupRow);
_dbContext.SaveChanges();
}
}
public IActionResult Delete(int id)
{
if (id != 0)
{
var key = new MuscularGroupKey()
{
Id = id
};
var muscularGroup = _muscularGroupsService.GetMuscularGroup(key);
if (muscularGroup != null)
{
_muscularGroupsService.DeleteMuscularGroup(muscularGroup);
}
}
return(RedirectToAction("Index"));
}
public IActionResult Edit(MuscularGroupViewModel viewModel)
{
if (ModelState.IsValid && viewModel.Id > 0)
{
// Verify not exist on id
var key = new MuscularGroupKey()
{
Id = viewModel.Id
};
var muscularGroup = _muscularGroupsService.GetMuscularGroup(key);
if (muscularGroup != null)
{
muscularGroup.Name = viewModel.Name;
muscularGroup = _muscularGroupsService.UpdateMuscularGroup(muscularGroup);
return(RedirectToAction("Index"));
}
}
return(View(viewModel));
}
public void DeleteMuscularGroup(MuscularGroupKey key)
{
BeginTransaction();
try
{
GetMuscularGroupManager().DeleteMuscularGroup(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch
{
RollbackTransaction();
throw;
}
finally
{
EndTransaction();
}
}
public IActionResult Edit(int id)
{
if (id != 0)
{
var key = new MuscularGroupKey()
{
Id = id
};
var muscularGroup = _muscularGroupsService.GetMuscularGroup(key);
if (muscularGroup != null)
{
var viewModel = new MuscularGroupViewModel();
viewModel.Id = muscularGroup.Id;
viewModel.Name = muscularGroup.Name;
return(View(viewModel));
}
}
return(RedirectToAction("Index"));
}
public void DeleteMuscularGroup(MuscularGroupKey key)
{
BeginTransaction();
try
{
GetMuscularGroupManager().DeleteMuscularGroup(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to delete muscular group", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
}
public void DeleteMuscularGroup(MuscularGroupKey key)
{
BeginTransaction();
try
{
GetMuscularGroupManager().DeleteMuscularGroup(key);
CommitTransaction();
//invalidate cache
InvalidateCache(_cacheName);
}
catch (Exception exception)
{
_logger.LogCritical("Unable to delete muscular group", exception);
RollbackTransaction();
throw exception;
}
finally
{
EndTransaction();
}
}
public IActionResult Edit(int id)
{
if (id != 0)
{
var key = new MuscularGroupKey() { Id = id };
var muscularGroup = _muscularGroupsService.GetMuscularGroup(key);
if (muscularGroup != null)
{
var viewModel = new MuscularGroupViewModel();
viewModel.Id = muscularGroup.Id;
viewModel.Name = muscularGroup.Name;
return View(viewModel);
}
}
return RedirectToAction("Index");
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public MuscularGroup Get(MuscularGroupKey key)
{
if (key == null || key.Id == 0)
return null;
var muscularGroupRow = _dbContext.MuscularGroup.Where(m => m.Id == key.Id).FirstOrDefault();
if (muscularGroupRow != null)
{
return MuscularGroupTransformer.ToBean(muscularGroupRow);
}
return null;
}
public MuscularGroup GetMuscularGroup(MuscularGroupKey key)
{
MuscularGroup muscularGroup = null;
string cacheKey = key == null ? "MuscularGroupKey_null" : key.GetCacheKey();
if (key != null && !TryGetCacheData(cacheKey, out muscularGroup))
{
muscularGroup = GetMuscularGroupManager().GetMuscularGroup(key);
SetCacheData(_cacheName, cacheKey, muscularGroup);
}
return muscularGroup;
}
internal void DeleteMuscularGroup(MuscularGroupKey key)
{
//Update Translation Name
Translation.DeleteInDB(MuscularGroupTransformer.GetTranslationKey(key.Id), DbContext);
_muscularGroupModule.Delete(key);
}
internal void DeleteMuscularGroup(MuscularGroupKey key)
{
//Update Translation Name
//Translation.DeleteInDB(MuscularGroupTransformer.GetTranslationKey(key.Id), _dbContext);
_module.Delete(key);
}
internal MuscularGroup GetMuscularGroup(MuscularGroupKey key)
{
MuscularGroup result = _muscularGroupModule.Get(key);
CompleteTranslation(result);
return result;
}
public IActionResult Edit(MuscularGroupViewModel viewModel)
{
if (ModelState.IsValid && viewModel.Id > 0)
{
// Verify not exist on id
var key = new MuscularGroupKey() { Id = viewModel.Id };
var muscularGroup = _muscularGroupsService.GetMuscularGroup(key);
if (muscularGroup != null)
{
muscularGroup.Name = viewModel.Name;
muscularGroup = _muscularGroupsService.UpdateMuscularGroup(muscularGroup);
return RedirectToAction("Index");
}
}
return View(viewModel);
}
public IActionResult Delete(int id)
{
if (id != 0)
{
var key = new MuscularGroupKey() { Id = id };
var muscularGroup = _muscularGroupsService.GetMuscularGroup(key);
if (muscularGroup != null)
{
_muscularGroupsService.DeleteMuscularGroup(muscularGroup);
}
}
return RedirectToAction("Index");
}
