/// <summary>
        /// Find datas
        /// </summary>
        /// <returns></returns>
        public List<TrainingExerciseSet> Find(TrainingExerciseSetCriteria trainingExerciseSetCriteria = null)
        {
            List<TrainingExerciseSet> resultList = null;
            IQueryable<TrainingExerciseSetRow> rowList = _dbContext.TrainingExerciseSet;
            CriteriaTransformer.CompleteQuery(ref rowList, trainingExerciseSetCriteria);
            rowList = rowList.OrderBy(t => t.TrainingExerciseId);

            if (rowList != null && rowList.Count() > 0)
            {
                resultList = new List<TrainingExerciseSet>();
                foreach (var row in rowList)
                {
                    resultList.Add(TrainingExerciseSetTransformer.ToBean(row));
                }
            }
            return resultList;
        }
 private void CompleteTrainingExerciseWithSet(TrainingExercise trainingExercise)
 {
     if (trainingExercise != null)
     {
         var criteria = new TrainingExerciseSetCriteria()
         {
             UserId = new StringCriteria() { Equal = trainingExercise.UserId },
             Year = new IntegerCriteria() { Equal = trainingExercise.Year },
             WeekOfYear = new IntegerCriteria() { Equal = trainingExercise.WeekOfYear },
             DayOfWeek = new IntegerCriteria() { Equal = trainingExercise.DayOfWeek },
             TrainingDayId = new IntegerCriteria() { Equal = trainingExercise.TrainingDayId },
             TrainingExerciseId = new IntegerCriteria() { Equal = trainingExercise.Id }
         };
         trainingExercise.TrainingExerciseSets = _trainingExerciseSetModule.Find(criteria);
     }
 }