public List <MuscularGroup> FindMuscularGroups(MuscularGroupCriteria muscularGroupCriteria = null) { var muscularGroupList = _module.Find(muscularGroupCriteria); if (muscularGroupList != null) { foreach (var muscularGroup in muscularGroupList) { if (muscularGroup != null) { muscularGroup.Name = Translation.GetInDB(MuscularGroupTransformer.GetTranslationKey(muscularGroup.Id)); } } } return(muscularGroupList); }
/// <summary> /// /// </summary> /// <returns></returns> public List <MuscularGroup> Find(MuscularGroupCriteria muscularGroupCriteria = null) { List <MuscularGroup> resultList = null; TableQuery <MuscularGroupRow> muscularGroupRowList = _dbContext.Table <MuscularGroupRow>(); CriteriaTransformer.CompleteQuery(ref muscularGroupRowList, muscularGroupCriteria); if (muscularGroupRowList != null && muscularGroupRowList.Count() > 0) { resultList = new List <MuscularGroup>(); foreach (var muscularGroupRow in muscularGroupRowList) { resultList.Add(MuscularGroupTransformer.ToBean(muscularGroupRow)); } } return(resultList); }
/// <summary> /// /// </summary> /// <returns></returns> public List <MuscularGroup> Find(MuscularGroupCriteria muscularGroupCriteria = null) { List <MuscularGroup> resultList = null; IQueryable <MuscularGroupRow> rowList = _dbContext.MuscularGroup; CriteriaTransformer.CompleteQuery(ref rowList, muscularGroupCriteria); if (rowList != null) { foreach (var muscularGroupRow in rowList) { if (resultList == null) { resultList = new List <MuscularGroup>(); } resultList.Add(MuscularGroupTransformer.ToBean(muscularGroupRow)); } } return(resultList); }
/// <summary> /// Update data in database /// </summary> /// <param name="muscularGroup">data</param> /// <returns>updated data</returns> public MuscularGroup Update(MuscularGroup muscularGroup) { if (muscularGroup == null || muscularGroup.Id == 0) { return(null); } var muscularGroupRow = _dbContext.MuscularGroup.Where(m => m.Id == muscularGroup.Id).FirstOrDefault(); if (muscularGroupRow == null) { // No data in database return(Create(muscularGroup)); } else { //Modify Data in database MuscularGroupTransformer.ToRow(muscularGroup, muscularGroupRow); _dbContext.SaveChanges(); return(MuscularGroupTransformer.ToBean(muscularGroupRow)); } }
/// <summary> /// Update data in database /// </summary> /// <param name="muscularGroup">data</param> /// <returns>updated data</returns> public MuscularGroup Update(MuscularGroup muscularGroup) { if (muscularGroup == null || muscularGroup.Id == 0) { return(null); } var muscularGroupRow = _dbContext.Table <MuscularGroupRow>().Where(m => m.Id == muscularGroup.Id).FirstOrDefault(); if (muscularGroupRow == null) { // No data in database return(Create(muscularGroup)); } else { //Modify Data in database MuscularGroupTransformer.ToRow(muscularGroup, muscularGroupRow); _dbContext.Delete(muscularGroupRow); //Update don't work... need delete and insert _dbContext.Insert(muscularGroupRow); return(MuscularGroupTransformer.ToBean(muscularGroupRow)); } }
internal void DeleteMuscularGroup(MuscularGroupKey key) { //Update Translation Name Translation.DeleteInDB(MuscularGroupTransformer.GetTranslationKey(key.Id), DbContext); _muscularGroupModule.Delete(key); }