/// <summary> /// Update data in database /// </summary> /// <param name="trainingExerciseSet">data</param> /// <returns>updated data</returns> public TrainingExerciseSet Update(TrainingExerciseSet trainingExerciseSet) { if (trainingExerciseSet == null || string.IsNullOrWhiteSpace(trainingExerciseSet.UserId) || trainingExerciseSet.Year == 0 || trainingExerciseSet.WeekOfYear == 0 || trainingExerciseSet.DayOfWeek < 0 || trainingExerciseSet.DayOfWeek > 6 || trainingExerciseSet.TrainingDayId == 0 || trainingExerciseSet.TrainingExerciseId == 0 || trainingExerciseSet.Id == 0) { return(null); } var row = _dbContext.TrainingExerciseSet.Where(t => t.UserId == trainingExerciseSet.UserId && t.Year == trainingExerciseSet.Year && t.WeekOfYear == trainingExerciseSet.WeekOfYear && t.DayOfWeek == trainingExerciseSet.DayOfWeek && t.TrainingDayId == trainingExerciseSet.TrainingDayId && t.TrainingExerciseId == trainingExerciseSet.TrainingExerciseId && t.Id == trainingExerciseSet.Id).FirstOrDefault(); if (row == null) { // No data in database return(Create(trainingExerciseSet)); } else { //Modify Data in database TrainingExerciseSetTransformer.ToRow(trainingExerciseSet, row); _dbContext.SaveChanges(); return(TrainingExerciseSetTransformer.ToBean(row)); } }
/// <summary> /// Create data in database /// </summary> /// <param name="trainingExerciseSet">Data</param> /// <returns>insert data</returns> public TrainingExerciseSet Create(TrainingExerciseSet trainingExerciseSet) { if (trainingExerciseSet == null || string.IsNullOrWhiteSpace(trainingExerciseSet.UserId) || trainingExerciseSet.Year == 0 || trainingExerciseSet.WeekOfYear == 0 || trainingExerciseSet.DayOfWeek < 0 || trainingExerciseSet.DayOfWeek > 6 || trainingExerciseSet.TrainingDayId == 0 || trainingExerciseSet.TrainingExerciseId == 0 || trainingExerciseSet.Id == 0) { return(null); } var row = new TrainingExerciseSetRow(); TrainingExerciseSetTransformer.ToRow(trainingExerciseSet, row); _dbContext.Insert(row); return(TrainingExerciseSetTransformer.ToBean(row)); }
/// <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); }
/// <summary> /// Get data in database /// </summary> /// <param name="key">Primary Key</param> /// <returns>read data</returns> public TrainingExerciseSet Get(TrainingExerciseSetKey key) { if (key == null || string.IsNullOrWhiteSpace(key.UserId) || key.Year == 0 || key.WeekOfYear == 0 || key.DayOfWeek < 0 || key.DayOfWeek > 6 || key.TrainingExerciseId == 0 || key.Id == 0) { return(null); } var row = _dbContext.TrainingExerciseSet.Where(t => t.UserId == key.UserId && t.Year == key.Year && t.WeekOfYear == key.WeekOfYear && t.DayOfWeek == key.DayOfWeek && t.TrainingDayId == key.TrainingDayId && t.TrainingExerciseId == key.TrainingExerciseId && t.Id == key.Id).FirstOrDefault(); if (row != null) { return(TrainingExerciseSetTransformer.ToBean(row)); } return(null); }