public static bool FacultyOverlap(string facUser, string courseToCheck) { bool result = false; linqtoregdbDataContext db = new linqtoregdbDataContext(); var queryFacTimes = from usr in db.users join crs in db.courses on usr.userID equals crs.instructor join crstb in db.course_timeblocks on crs.courseID equals crstb.courseID where usr.username == facUser select crstb.timeblock; var queryNewCourseTimes = from crs in db.courses join crstb in db.course_timeblocks on crs.courseID equals crstb.courseID where crs.courseName == courseToCheck select crstb.timeblock; //MessageBox.Show(TimeCheck.convertTime(queryNewCourseTimes.ToList())); foreach (var c in queryFacTimes) { if (TimeCheck.overlaps(TimeCheck.convertTime(queryNewCourseTimes.ToList()), TimeCheck.convertTime(queryFacTimes.ToList()))) { result = true; } } return(result); }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { listBox2.Items.Clear(); listBox3.Items.Clear(); listBox4.Items.Clear(); listBox5.Items.Clear(); maskedTextBox1.Text = ""; selectedIndex = listBox1.SelectedIndex; linqtoregdbDataContext db = new linqtoregdbDataContext(); if (listBox1.SelectedIndex != -1) { listBox2.Items.AddRange((from prq in db.prereqs where prq.courseName == listBox1.SelectedItem.ToString() select prq.prereqName).ToArray()); listBox3.Items.AddRange((from crs in db.courses select crs.courseName).ToArray()); var queryGetCourse = (from crs in db.courses where crs.courseName == listBox1.SelectedItem.ToString() select crs).FirstOrDefault(); textBox1.Text = queryGetCourse.courseTitle; textBox3.Text = queryGetCourse.numSeats.ToString(); textBox4.Text = queryGetCourse.courseCredit.ToString(); maskedTextBox1.Text = queryGetCourse.semester; currSemester = queryGetCourse.semester; var queryGetInstructor = (from usr in db.users where usr.userID == queryGetCourse.instructor select usr.username).FirstOrDefault(); textBox2.Text = queryGetInstructor; richTextBox1.Text = ""; foreach (var c in TimeCheck.GetTimes(listBox1.SelectedItem.ToString())) { foreach (var d in TimeCheck.convertTime(c)) { richTextBox1.Text += d.ToString() + "\n"; } } listBox4.Items.AddRange((from usrcrs in db.user_courses where usrcrs.courseName == listBox1.SelectedItem.ToString() select usrcrs.username).ToArray()); var queryGetUsersNotInClass = from usr in db.users where usr.usertype == "student" select usr.username; foreach (var c in queryGetUsersNotInClass) { if (!listBox4.Items.Contains(c)) { listBox5.Items.Add(c); } } } else { textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; richTextBox1.Text = ""; listBox4.Items.Clear(); listBox5.Items.Clear(); } }