public List <WorkoutSchedule> GetAll(WorkoutScheduleSearchParams searchParams)
{
var query = _context.WorkoutSchedules
.Include(x => x.Workout)
.AsQueryable();
if (searchParams.DayOfWeek != null)
{
query = query.Where(x => x.DayOfTheWeek == searchParams.DayOfWeek);
}
if (!string.IsNullOrEmpty(searchParams.WorkoutId))
{
int id = int.Parse(searchParams.WorkoutId);
query = query.Where(x => x.WorkoutId == id);
}
if (searchParams.TimeFrom != null)
{
query = query.Where(x => x.TimeOfTheDay >= searchParams.TimeFrom);
}
if (searchParams.TimeTo != null)
{
query = query.Where(x => x.TimeOfTheDay <= searchParams.TimeTo);
}
return(query
.OrderBy(x => x.WorkoutId)
.OrderBy(x => x.TimeOfTheDay)
.Select(x => WorkoutScheduleMapper.fromDb(x))
.ToList());
}
public async Task loadGridData()
{
WorkoutScheduleSearchParams searchParams = new WorkoutScheduleSearchParams
{
DayOfWeek = (DayOfWeek)int.Parse(cbWorkoutDays.SelectedValue.ToString()),
TimeFrom = new TimeSpan(timePickerStart.Value.Hour, timePickerStart.Value.Minute, 0),
TimeTo = new TimeSpan(timePickerEnd.Value.Hour, timePickerEnd.Value.Minute, 0),
WorkoutId = cbWorkout.SelectedValue.ToString()
};
_workoutScheduleList = await _workoutScheduleApiService.GetAll <List <WorkoutSchedule> >(searchParams);
dgvSchedules.DataSource = _workoutScheduleList;
}
public async Task LoadSchedules()
{
WorkoutSchedules.Clear();
WorkoutScheduleSearchParams searchParams = new WorkoutScheduleSearchParams
{
WorkoutId = Workout.Id.ToString()
};
List <WorkoutSchedule> workoutSchedules = await workoutScheduleApiService.GetAll <List <WorkoutSchedule> >(searchParams);
foreach (var schedule in workoutSchedules)
{
WorkoutSchedules.Add(schedule);
}
}
