/// <summary> /// Create data in database /// </summary> /// <param name="trainingJournalDayExercise">Data</param> /// <returns>insert data</returns> public TrainingExercise Create(TrainingExercise trainingJournalDayExercise) { if (trainingJournalDayExercise == null || string.IsNullOrWhiteSpace(trainingJournalDayExercise.UserId) || trainingJournalDayExercise.Year == 0 || trainingJournalDayExercise.WeekOfYear == 0|| trainingJournalDayExercise.DayOfWeek < 0 || trainingJournalDayExercise.DayOfWeek > 6 || trainingJournalDayExercise.TrainingDayId == 0 || trainingJournalDayExercise.Id == 0) return null; var row = new TrainingExerciseRow(); TrainingExerciseTransformer.ToRow(trainingJournalDayExercise, row); _dbContext.TrainingExercise.Add(row); _dbContext.SaveChanges(); return GetBean(row); }
internal static TrainingExercise ToBean(TrainingExerciseRow row) { if (row == null) return null; var bean = new TrainingExercise(); bean.UserId = row.UserId; bean.Year = row.Year; bean.WeekOfYear = row.WeekOfYear; bean.DayOfWeek = row.DayOfWeek; bean.TrainingDayId = row.TrainingDayId; bean.Id = row.Id; bean.BodyExerciseId = row.BodyExerciseId; bean.RestTime = row.RestTime; bean.EccentricContractionTempo = row.EccentricContractionTempo.HasValue ? row.EccentricContractionTempo.Value : 0; bean.StretchPositionTempo = row.StretchPositionTempo.HasValue ? row.StretchPositionTempo.Value : 0; bean.ConcentricContractionTempo = row.ConcentricContractionTempo.HasValue ? row.ConcentricContractionTempo.Value : 0; bean.ContractedPositionTempo = row.ContractedPositionTempo.HasValue ? row.ContractedPositionTempo.Value : 0; bean.ModificationDate = DbUtils.DbDateToUtc(row.ModificationDate); return bean; }
public static void ToRow(TrainingExercise bean, TrainingExerciseRow row) { if (bean == null) return; row.UserId = bean.UserId; row.Year = bean.Year; row.WeekOfYear = bean.WeekOfYear; row.DayOfWeek = bean.DayOfWeek; row.TrainingDayId = bean.TrainingDayId; row.Id = bean.Id; row.BodyExerciseId = bean.BodyExerciseId; row.RestTime = bean.RestTime; if (bean.ObjectVersionNumber > 0) // Retrocompatibility { row.EccentricContractionTempo = bean.EccentricContractionTempo; row.StretchPositionTempo = bean.StretchPositionTempo; row.ConcentricContractionTempo = bean.ConcentricContractionTempo; row.ContractedPositionTempo = bean.ContractedPositionTempo; } row.ModificationDate = DbUtils.DateToUtc(Utils.DateTimeWithoutMs); // Set modificationDate }
private TrainingExercise GetBean(TrainingExerciseRow row) { if (row == null) return null; var trainingExercise = TrainingExerciseTransformer.ToBean(row); if (row != null && trainingExercise != null) { if (!row.EccentricContractionTempo.HasValue) trainingExercise.EccentricContractionTempo = 1; if (!row.StretchPositionTempo.HasValue) trainingExercise.StretchPositionTempo = 0; if (!row.ConcentricContractionTempo.HasValue) trainingExercise.ConcentricContractionTempo = 1; if (!row.ContractedPositionTempo.HasValue) trainingExercise.ContractedPositionTempo = 0; } return trainingExercise; }