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