private void Form2_Load(object sender, EventArgs e) { label1.Parent = pictureBox1; label1.Location = new Point(10, label1.Location.Y); var course_array = from row in RegistrationDatabase.GetCourses() select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; var student_array = from row in RegistrationDatabase.GetUserDatabase() where row.Value is Student select new { First = row.Value.GetFirstName(), Last = row.Value.GetLastName(), Username = row.Value.GetUserName(), CurrentAdvisor = row.Value.GetStatus() }; var faculty_array = from row in RegistrationDatabase.GetUserDatabase() where row.Value is Faculty select new { First = row.Value.GetFirstName(), Last = row.Value.GetLastName(), Username = row.Value.GetUserName(), CurrentAdvisor = row.Value.GetStatus() }; dataGridView1.DataSource = course_array.ToArray(); dataGridView2.DataSource = student_array.ToArray(); dataGridView3.DataSource = faculty_array.ToArray(); ComboBox comboBox3 = new ComboBox(); foreach (User user in RegistrationDatabase.GetUserDatabase().Values) { if (user is Student) { comboBox1.Items.Add(user.GetUserName()); } if (user is Faculty) { comboBox3.Items.Add(user.GetUserName()); comboBox2.Items.Add(user.GetUserName()); } } ((DataGridViewComboBoxColumn)dataGridView2.Columns["Advisor"]).DataSource = comboBox3.Items; foreach (DataGridViewRow d_row in dataGridView2.Rows) { d_row.Cells[0].Value = RegistrationDatabase.GetUser((string)d_row.Cells[3].Value).GetStatus(); } }
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0) { var i = 0; foreach (KeyValuePair <string, Course> row in RegistrationDatabase.GetCourses()) { if (i == e.RowIndex) { current_course = row.Value; } i += 1; } StudentList form3 = new StudentList(); form3.Show(); } }
private void Form2_Load(object sender, EventArgs e) { label1.Parent = pictureBox1; label2.Parent = pictureBox1; label1.Location = new Point(10, label1.Location.Y); label2.Location = new Point(10, label2.Location.Y); var course_array = from row in RegistrationDatabase.GetCourses() select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; dataGridView1.DataSource = course_array.ToArray(); var student_course_array = from row in current_user.GetCourses() select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; dataGridView2.DataSource = student_course_array.ToArray(); var student_course_history_array = from row in current_user.GetCourseHistory() select new { Id = row.GetCourseID(), Term = row.GetCourseTerm(), Credits = row.GetCourseCredit(), Grade = row.GetGrade(), }; dataGridView3.DataSource = student_course_history_array.ToArray(); label3.Text = $"Total Credits: {current_user.GetHistoryCourseCredits():F2} GPA: {current_user.GetGradePointAverage():F2}"; }
private void Form2_Load(object sender, EventArgs e) { label1.Parent = pictureBox1; label2.Parent = pictureBox1; label1.Location = new Point(10, label1.Location.Y); label2.Location = new Point(10, label2.Location.Y); dataGridView3.Visible = false; var course_array = from row in RegistrationDatabase.GetCourses() //where row.Value.GetCourseTerm() == "F14" select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; dataGridView1.DataSource = course_array.ToArray(); var faculty_course_array = from row in RegistrationDatabase.GetCourses() //where row.Value.GetCourseTerm() == "F14" && where row.Value.GetFaculty().GetUserName() == current_user.GetUserName() select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; dataGridView2.DataSource = faculty_course_array.ToArray(); var advisees_array = from row in current_user.GetStudentAdvisees() select new { First = row.GetFirstName(), Last = row.GetLastName() }; dataGridView3.DataSource = advisees_array.ToArray(); try { var student_course_array = from row in current_user.GetStudentAdvisees()[0].GetCourses() select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; dataGridView4.DataSource = student_course_array.ToArray(); } catch { } }
private void Form2_Load(object sender, EventArgs e) { var course_array = from row in RegistrationDatabase.GetCourses() select new { Id = row.Value.GetCourseID(), Name = row.Value.GetCourseName(), Faculty = row.Value.GetFaculty().GetUserName(), Credits = row.Value.GetCourseCredit(), Seats = row.Value.GetNumSeats(), Dates = String.Join(", ", row.Value.GetDayBlocks()), Times = String.Join(", ", row.Value.GetTimeBlocks()) }; var student_array = from row in RegistrationDatabase.GetUserDatabase() where row.Value is Student select new { First = row.Value.GetFirstName(), Last = row.Value.GetLastName(), Username = row.Value.GetUserName(), CurrentAdvisor = row.Value.GetStatus() }; var faculty_array = from row in RegistrationDatabase.GetUserDatabase() where row.Value is Faculty select new { First = row.Value.GetFirstName(), Last = row.Value.GetLastName(), Username = row.Value.GetUserName(), CurrentAdvisor = row.Value.GetStatus() }; dataGridView1.DataSource = course_array.ToArray(); dataGridView2.DataSource = student_array.ToArray(); dataGridView3.DataSource = faculty_array.ToArray(); ComboBox comboBox10 = new ComboBox(); if (comboBox9.Items.Count > 0) { comboBox9.Items.Clear(); } if (comboBox8.Items.Count > 0) { comboBox8.Items.Clear(); } if (comboBox2.Items.Count > 0) { comboBox2.Items.Clear(); } if (comboBox1.Items.Count > 0) { comboBox1.Items.Clear(); } foreach (User user in RegistrationDatabase.GetUserDatabase().Values) { if (user is Student) { comboBox1.Items.Add(user.GetUserName()); } if (user is Faculty) { comboBox10.Items.Add(user.GetUserName()); comboBox9.Items.Add(user.GetUserName()); comboBox8.Items.Add(user.GetUserName()); comboBox2.Items.Add(user.GetUserName()); } } comboBox9.Items.Add("faculty"); comboBox9.Items.Add("admin"); ((DataGridViewComboBoxColumn)dataGridView2.Columns["Advisor"]).DataSource = comboBox10.Items; foreach (DataGridViewRow d_row in dataGridView2.Rows) { d_row.Cells[1].Value = RegistrationDatabase.GetUser((string)d_row.Cells[4].Value).GetStatus(); } ((DataGridViewComboBoxColumn)dataGridView1.Columns["ChangeProfessor"]).DataSource = comboBox10.Items; foreach (DataGridViewRow d_row in dataGridView1.Rows) { d_row.Cells[1].Value = (string)d_row.Cells[4].Value; } }