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