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