private void UpdateFreeAuds() { List<int> weekList; try { weekList = Utilities.ConvertWeeksToList(lessonWeeks.Text); } catch { return; } if ((DayOfWeekListBox.SelectedIndex == -1) || (ringsListBox.SelectedItems.Count == 0) || (lessonWeeks.Text == "")) { return; } var calendarIds = ( from cal in _repo.Calendars.GetAllCalendars() where Constants.DowRemap[(int) cal.Date.DayOfWeek] - 1 == DayOfWeekListBox.SelectedIndex let week = _repo.CommonFunctions.CalculateWeekNumber(cal.Date) where weekList.Contains(week) select cal.CalendarId) .ToList(); var ringIds = ( from object ringView in ringsListBox.SelectedItems select ((RingView) ringView).RingId) .ToList(); var res = _repo.CommonFunctions.GetFreeAuditoriumsAtDowTime(calendarIds, ringIds, _selectedBuildingId, proposedIncluded.Checked); var c = new Utilities.AudComparer(); res = res .OrderBy(aud => aud, c) .ToList(); audList.DataSource = res; audList.ValueMember = "AuditoriumId"; audList.DisplayMember = "Name"; audList.SelectedIndex = -1; }
private void UpdateFreeAuds() { List<int> weekList; try { weekList = Utilities.ConvertWeeksToList(lessonWeeks.Text); } catch { return; } if ((dayOfWeekBox.SelectedIndex == -1) || (ringsBox.SelectedIndex == -1) || (lessonWeeks.Text == "")) { return; } var calendarIds = new List<int>(); foreach (var cal in _repo.GetAllCalendars()) { if (Constants.Constants.DOWRemap[(int)cal.Date.DayOfWeek]-1 == dayOfWeekBox.SelectedIndex) { var week = _repo.CalculateWeekNumber(cal.Date); if (weekList.Contains(week)) { calendarIds.Add(cal.CalendarId); } } } var res = _repo.GetFreeAuditoriumAtDOWTime(calendarIds, _repo.GetRing((int)ringsBox.SelectedValue)); var c = new Utilities.AudComparer(); res = res .OrderBy(aud => aud, c) .ToList(); audList.DataSource = res; audList.ValueMember = "AuditoriumId"; audList.DisplayMember = "Name"; audList.SelectedIndex = -1; }