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