void LoadCourse(string Code) { //cmbCourseCode.Items.Clear(); using (Maintenance maintain = new Maintenance()) { var value = maintain.GetCourse().Where(x => x.Active == true && x.CourseCode == Code).OrderBy(o => o.Course).FirstOrDefault().Course; txtDescription.Text = value; } txtDescription.ReadOnly = true; }
void LoadCourse() { cmbStudentCourse.Items.Clear(); using (Maintenance _maintain = new Maintenance()) { _maintain.GetCourse().OrderBy(o => o.Course).ToList().ForEach(x => { cmbStudentCourse.Items.Add(x.Course); }); } }
void LoadCourse() { cmbCourseCode.Items.Clear(); using (Maintenance maintain = new Maintenance()) { var value = maintain.GetCourse().Where(x => x.Active == true).OrderBy(o => o.CourseCode).ToList(); value.ForEach(x => { cmbCourseCode.Items.Add(x.CourseCode); }); } txtDescription.ReadOnly = true; }
void LoadCourseProgram() { dgCourseProgram.Rows.Clear(); int i = 1; using (Maintenance _maintain = new Maintenance()) { _maintain.GetCourse().OrderBy(y => y.CourseCode).ToList().ForEach(x => { dgCourseProgram.Rows.Add(x.ID, i, x.CourseCode, x.Course, x.YearLevelFromTo, x.Active); i++; }); } ObjEnable(false); txtFromTo.ReadOnly = true; }
void LoadStudent(string Search) { int i = 1; dgStudentList.Rows.Clear(); using (Students std = new Students()) { using (Maintenance maintain = new Maintenance()) { if (rbCourse.Checked) { Search = maintain.GetCourse().Where(x => x.CourseCode == Search).FirstOrDefault().Course; } std.GetStudentInfo().Where(x => rbCourse.Checked ? x.Course == Search : x.YearLevel == Search && x.Active == true && x.CompletedStatus == true && x.EnrolledStatus == true && x.GraduateStatus == false).ToList().ForEach(f => { dgStudentList.Rows.Add(f.ID, i, f.StudentID, string.Format("{0},{1} {2}", f.LastName, f.FirstName, f.MiddleName), f.Course, f.YearLevel, false); i++; }); } } }
void LoadCourseYealvl(bool Course) { cmbSearch.Items.Clear(); using (Maintenance maintain = new Maintenance()) { if (Course) { maintain.GetCourse().Where(x => x.Active == true).OrderBy(o => o.Course).ToList().ForEach(y => { cmbSearch.Items.Add(y.CourseCode); }); } else { maintain.GetYearLevel().Where(x => x.Active == true).OrderBy(o => o.YearLevel).ToList().ForEach(y => { cmbSearch.Items.Add(y.YearLevel); }); } } }
void dgCourseProgram_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgCourseProgram.Rows.Count > 0) { using (Maintenance _maintain = new Maintenance()) { var value = _maintain.GetCourse().Where(x => x.ID == Convert.ToInt64(dgCourseProgram.SelectedRows[0].Cells[0].Value)).FirstOrDefault(); if (value != null) { cmbMin.Text = value.YearMinimum.Value.ToString(); cmbMax.Text = value.YearMaximum.Value.ToString(); txtFromTo.Text = value.YearLevelFromTo; txtCode.Text = value.CourseCode; txtCourse.Text = value.Description; txtDescription.Text = value.Description; cbActive.Checked = value.Active.Value; btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString()); btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString()); } } } }