/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(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;
}
var row = _dbContext.Table <TrainingExerciseSetRow>().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)
{
_dbContext.Delete(row);
}
}
/// <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);
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(TrainingExerciseSetKey key)
{
if (key == null || string.IsNullOrWhiteSpace(key.UserId) || key.Year == 0 || key.WeekOfYear == 0 ||
key.DayOfWeek < 0 || key.DayOfWeek > 6 || key.TrainingExerciseId == 0)
{
return;
}
var rowList = _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);
if (key.Id != 0) //key.Id == 0 -> massive delete
{
rowList = rowList.Where(t => t.Id == key.Id);
}
_dbContext.TrainingExerciseSet.RemoveRange(rowList);
_dbContext.SaveChanges();
}
public void DeleteTrainingExerciseSet(TrainingExerciseSetKey key)
{
_trainingExerciseSetModule.Delete(key);
}
public TrainingExerciseSet GetTrainingExerciseSet(TrainingExerciseSetKey key)
{
return(_trainingExerciseSetModule.Get(key));
}
