private void buttonUpdateFaculty_Click(object sender, EventArgs e)
{
string id = this.textboxFacultyID.Text;
FacultyDataHandler facultyData = new FacultyDataHandler(id);
facultyData.SetPhone(this.textboxFacultyPhone.Text);
facultyData.SetName(this.texboxFacultyName.Text);
facultyData.SetID(this.textboxFacultyID.Text);
facultyData.SetFather(this.textboxFacultyFather.Text);
facultyData.SetMother(this.textboxFacultyMother.Text);
facultyData.SetEmail(this.textboxFacultyEmail.Text);
facultyData.SetDOB(this.datetimeFacultyDOB.Value);
facultyData.SetDepartment(this.comboboxFacultyDepartment.SelectedIndex);
facultyData.SetBloodGroup(this.comboboxFacultyBloodGroup.SelectedIndex);
facultyData.SetNationality(this.comboboxFacultyNationality.SelectedIndex);
if (radiobuttonFacultyMale.Checked)
{
facultyData.SetGender(1);
}
else
{
facultyData.SetGender(2);
}
facultyData.SetPassword(GeneratePasswordHash.CalculateMD5Hash(this.textboxStudentPassword.Text));
// studentData.SetImageDirectory(studentImageURL);
facultyData.UpdateFaculty();
UpdateForm();
MessageBox.Show("Faculty Updated");
}
public void LoadGetFacultyInfo(string id)
{
FacultyDataHandler facultyData = new FacultyDataHandler(id);
this.textboxFacultyPhone.Text = facultyData.GetPhone();
this.texboxFacultyName.Text = facultyData.GetName();
this.textboxFacultyID.Text = facultyData.GetID();
this.textboxFacultyFather.Text = facultyData.GetFather();
this.textboxFacultyMother.Text = facultyData.GetMother();
this.textboxFacultyEmail.Text = facultyData.GetEmail();
this.datetimeFacultyDOB.Value = facultyData.GetDOB();
this.comboboxFacultyDepartment.SelectedIndex = facultyData.GetDepartment();
this.comboboxFacultyBloodGroup.SelectedIndex = facultyData.GetBloodGroup();
this.comboboxFacultyNationality.SelectedIndex = facultyData.GetNationality();
if (facultyData.GetGender() == 1)
{
radiobuttonFacultyMale.Checked = true;
}
else
{
radiobuttonFacultyFemale.Checked = true;
}
// Image directory code required.
// this.pictureboxStudentPicture.Load();
}
public FacultyInterface(string id)
{
this.id = id;
InitializeComponent();
FacultyDataHandler facultyData = new FacultyDataHandler(id);
hotspot = new Hotspot();
this.Text = "Welcome, " + facultyData.GetName();
this.labelPhoneAns.Text = facultyData.GetPhone();
this.labelNameAns.Text = facultyData.GetName();
this.labelMotherAns.Text = facultyData.GetMother();
this.labelIDAns.Text = facultyData.GetID();
this.labelGenderAns.Text = facultyData.GetGender().ToString();
this.labelFatherAns.Text = facultyData.GetFather();
this.labelEmailAns.Text = facultyData.GetEmail();
this.labelDOBAns.Text = facultyData.GetDOB();
this.labelDepartmentAns.Text = facultyData.GetDepartment().ToString();
this.labelBloodGroupAns.Text = facultyData.GetBloodGroup().ToString();
foreach (var course in facultyData.GetCourseList())
{
this.comboboxCourses.Items.Add(course);
}
}
private void buttonDeleteFaculty_Click(object sender, EventArgs e)
{
string id = this.textboxFacultyID.Text;
FacultyDataHandler facultyData = new FacultyDataHandler(id);
facultyData.DeleteFaculty();
UpdateForm();
MessageBox.Show("Faculty Deleted");
}
private void UpdateForm()
{
StudentDataHandler studentData = new StudentDataHandler();
FacultyDataHandler facultyData = new FacultyDataHandler();
CourseDataHandler courseData = new CourseDataHandler();
this.datagridStudentTable.DataSource = studentData.GetStudentTable();
this.datagridFacultyTable.DataSource = facultyData.GetFacultyTable();
this.datagridCourseTable.DataSource = courseData.GetCourseTable();
string FacultyName = this.comboboxCourseAssignFaculty.SelectedItem.ToString();
this.datagridFacultyCoursesAssigned.DataSource = courseData.GetFacultyCoursesAssigned(FacultyName);
}
private void textboxFacultySearch_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{
FacultyDataHandler facultyData = new FacultyDataHandler();
if (Regex.IsMatch(textboxFacultySearch.Text, @"^[\p{L}]+$"))
{
this.datagridFacultyTable.DataSource = facultyData.SearchFacultyByName(textboxFacultySearch.Text);
}
// else if (textboxSearchStudent.Text.Length == 3)
// this.datagridStudentTable.DataSource = studentData.SearchStudentByDepartment(textboxSearchStudent.Text);
else if (textboxFacultySearch.Text.Length > 0)
{
this.datagridFacultyTable.DataSource = facultyData.SearchFacultyByID(textboxFacultySearch.Text);
}
else
{
this.datagridFacultyTable.DataSource = facultyData.GetFacultyTable();
}
}
}
private void comboboxCourses_SelectedIndexChanged(object sender, EventArgs e)
{
FacultyDataHandler facultyData = new FacultyDataHandler(this.id);
List <int?> CourseIDs = facultyData.GetCourseIDs();
string CourseName = comboboxCourses.SelectedItem.ToString();
int ansCourseID = 0;
foreach (var courseid in CourseIDs)
{
CourseDataHandler courseData1 = new CourseDataHandler(courseid ?? 1);
if (courseData1.GetName() == CourseName)
{
ansCourseID = courseid ?? 1;
break;
}
}
CourseDataHandler courseData = new CourseDataHandler(ansCourseID);
this.labelCourseIDAns.Text = courseData.GetID().ToString();
this.labelCourseNameAns.Text = courseData.GetName().ToString();
this.labelCourseNameAnswer.Text = courseData.GetName().ToString();
this.labelDepartmentAns.Text = courseData.GetDepartment().ToString();
if (courseData.GetDaySlot() == 1)
{
this.labelDaysAns.Text = "Sun-Tues";
}
else
{
this.labelDaysAns.Text = "Mon-Wed";
}
this.labelStartTimeEndTime.Text = Times[courseData.GetStartTime()] + " - " + Times[courseData.GetEndTime()];
this.labelSectionAns.Text = Sections[courseData.GetSection()];
}
public AdminInterface(string id)
{
this.id = id;
InitializeComponent();
foreach (var bg in Enum.GetValues(typeof(BloodGroup)))
{
comboboxFacultyBloodGroup.Items.Add(bg);
comboboxStudentBloodGroup.Items.Add(bg);
}
foreach (var nationality in Enum.GetValues(typeof(Nationality)))
{
comboboxFacultyNationality.Items.Add(nationality);
comboboxStudentNationality.Items.Add(nationality);
}
AdminDataHandler departmentData = new AdminDataHandler();
List <string> departmentList = departmentData.GetDepartmentData();
foreach (string dept in departmentList)
{
this.comboboxCourseDepartment.Items.Add(dept);
this.comboboxFacultyDepartment.Items.Add(dept);
this.comboboxStudentDepartment.Items.Add(dept);
}
foreach (string time in Times)
{
this.comboboxCourseStartTime.Items.Add(time);
this.comboboxCourseEndTime.Items.Add(time);
}
foreach (int credit in Credits)
{
this.comboboxCourseCredits.Items.Add(credit);
}
foreach (string section in Sections)
{
this.comboboxCourseSection.Items.Add(section);
}
AdminDataHandler adminData = new AdminDataHandler(id);
StudentDataHandler studentData = new StudentDataHandler();
FacultyDataHandler facultyData = new FacultyDataHandler();
CourseDataHandler courseData = new CourseDataHandler();
List <string> facultyList = facultyData.GetAllFaculty();
foreach (string faculty in facultyList)
{
this.comboboxCourseAssignFaculty.Items.Add(faculty);
}
this.Text = "Welcome, " + adminData.GetName();
this.labelPhoneAns.Text = adminData.GetPhone();
this.labelNameAns.Text = adminData.GetName();
this.labelMotherAns.Text = adminData.GetMother();
this.labelIDAns.Text = adminData.GetID();
this.labelGenderAns.Text = adminData.GetGender().ToString();
this.labelFatherAns.Text = adminData.GetFather();
this.labelEmailAns.Text = adminData.GetEmail();
this.labelDOBAns.Text = adminData.GetDOB();
this.labelBloodGroupAns.Text = Enum.GetName(typeof(BloodGroup), adminData.GetBloodGroup());
this.datagridStudentTable.DataSource = studentData.GetStudentTable();
this.datagridFacultyTable.DataSource = facultyData.GetFacultyTable();
this.datagridCourseTable.DataSource = courseData.GetCourseTable();
this.datagridSearchAssignCourses.DataSource = courseData.GetAssignCourseTable();
try
{
string FacultyName = this.comboboxCourseAssignFaculty.SelectedItem.ToString();
}
catch
{
string FacultyName = "n/a";
this.datagridFacultyCoursesAssigned.DataSource = courseData.GetFacultyCoursesAssigned(FacultyName);
}
}
