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