/// <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));
}
public static void ToRow(TrainingExerciseSet bean, TrainingExerciseSetRow 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.TrainingExerciseId = bean.TrainingExerciseId;
row.Id = bean.Id;
row.NumberOfSets = bean.NumberOfSets;
row.NumberOfReps = bean.NumberOfReps;
row.Weight = bean.Weight;
row.Unit = (int)bean.Unit;
row.ModificationDate = bean.ModificationDate;
}
public static void ToRow(TrainingExerciseSet bean, TrainingExerciseSetRow 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.TrainingExerciseId = bean.TrainingExerciseId;
row.Id = bean.Id;
row.NumberOfSets = bean.NumberOfSets;
row.NumberOfReps = bean.NumberOfReps;
row.Weight = bean.Weight;
row.ModificationDate = DbUtils.DbDateToUtc(bean.ModificationDate);
row.ExecutionTime = bean.ExecutionTime;
}
internal static TrainingExerciseSet ToBean(TrainingExerciseSetRow row)
{
if (row == null)
{
return(null);
}
var bean = new TrainingExerciseSet();
bean.UserId = row.UserId;
bean.Year = row.Year;
bean.WeekOfYear = row.WeekOfYear;
bean.DayOfWeek = row.DayOfWeek;
bean.TrainingDayId = row.TrainingDayId;
bean.TrainingExerciseId = row.TrainingExerciseId;
bean.Id = row.Id;
bean.NumberOfSets = row.NumberOfSets;
bean.NumberOfReps = row.NumberOfReps;
bean.Weight = row.Weight;
bean.Unit = Utils.IntToEnum <TUnitType>(row.Unit);
bean.ModificationDate = row.ModificationDate;
return(bean);
}
public static void ToRow(TrainingExerciseSet bean, TrainingExerciseSetRow 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.TrainingExerciseId = bean.TrainingExerciseId;
row.Id = bean.Id;
row.NumberOfSets = bean.NumberOfSets;
row.NumberOfReps = bean.NumberOfReps;
row.Weight = bean.Weight;
row.ModificationDate = DbUtils.DateToUtc(Utils.DateTimeWithoutMs); // Set modificationDate
if (bean.ObjectVersionNumber > 0) // Retrocompatibility
{
row.ExecutionTime = bean.ExecutionTime;
}
}
internal static TrainingExerciseSet ToBean(TrainingExerciseSetRow row)
{
if (row == null)
{
return(null);
}
var bean = new TrainingExerciseSet();
bean.UserId = row.UserId;
bean.Year = row.Year;
bean.WeekOfYear = row.WeekOfYear;
bean.DayOfWeek = row.DayOfWeek;
bean.TrainingDayId = row.TrainingDayId;
bean.TrainingExerciseId = row.TrainingExerciseId;
bean.Id = row.Id;
bean.NumberOfSets = row.NumberOfSets;
bean.NumberOfReps = row.NumberOfReps;
bean.Weight = row.Weight;
bean.ModificationDate = DbUtils.DbDateToUtc(row.ModificationDate);
bean.ExecutionTime = row.ExecutionTime.HasValue ? row.ExecutionTime.Value : 0;
return(bean);
}
