/// <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 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"); }