private void buttonUpdateStudent_Click(object sender, EventArgs e) { string id = this.textboxStudentID.Text; StudentDataHandler studentData = new StudentDataHandler(id); studentData.SetPhone(this.textboxStudentPhone.Text); studentData.SetName(this.textboxStudentName.Text); studentData.SetMother(this.textboxStudentMother.Text); studentData.SetID(this.textboxStudentID.Text); if (radiobuttonStudentMale.Checked) { studentData.SetGender(1); } else { studentData.SetGender(2); } studentData.SetFather(this.textboxStudentFather.Text); studentData.SetEmail(this.textboxStudentEmail.Text); studentData.SetDOB(this.datetimeStudentDOB.Value); studentData.SetDepartment(this.comboboxStudentDepartment.SelectedIndex); studentData.SetCredit(Convert.ToInt32(this.textboxStudentCreditsCompleted.Text)); studentData.SetCGPA(Convert.ToDouble(this.textboxStudentCGPA.Text)); studentData.SetBloodGroup(this.comboboxStudentBloodGroup.SelectedIndex); studentData.SetImageDirectory(studentImageURL); studentData.SetMAC(this.textboxStudentMAC.Text); studentData.SetPassword(GeneratePasswordHash.CalculateMD5Hash(this.textboxStudentPassword.Text)); studentData.UpdateStudent(); UpdateForm(); MessageBox.Show("Student Updated"); }
/// <summary> /// CLick event handler for btnShowRecord to display record of selected student /// </summary> /// <param name="sender">Object on which event has occured</param> /// <param name="e">Args for the event</param> protected void btnShowRecord_Click(object sender, EventArgs e) { //Extract rollno from textbox string value = txtRollNo.Text; int rollNo; int.TryParse(value, out rollNo); //Call GetStudentRecord() method to fetch data StudentDataHandler studentHandler = new StudentDataHandler(); List <string> stud = studentHandler.GetStudentRecord(rollNo); //Check the returned result if (stud != null) { #region Display Record Response.Write("<h2>Data for Student </h2>"); Response.Write(string.Format("Student ID : {0}<br />", stud[0])); Response.Write(string.Format("Full Name : {0}<br />", stud[1])); Response.Write(string.Format("Father's Name : {0}<br />", stud[2])); Response.Write(string.Format("Age : {0}<br />", stud[3])); Response.Write(string.Format("Roll No. : {0}<br />", stud[4])); Response.Write(string.Format("Stream : {0}<br />", stud[5])); Response.Write(string.Format("Address : {0}<br />", stud[7])); #endregion } else { Response.Write("No record found."); } }
public void LoadGetStudentInfo(string id) { StudentDataHandler studentData = new StudentDataHandler(id); this.textboxStudentPhone.Text = studentData.GetPhone(); this.textboxStudentName.Text = studentData.GetName(); this.textboxStudentMother.Text = studentData.GetMother(); this.textboxStudentID.Text = studentData.GetID(); if (studentData.GetGender() == 1) { radiobuttonStudentMale.Checked = true; } else { radiobuttonStudentFemale.Checked = true; } this.textboxStudentFather.Text = studentData.GetFather(); this.textboxStudentEmail.Text = studentData.GetEmail(); this.datetimeStudentDOB.Value = studentData.GetDOB(); this.comboboxStudentDepartment.SelectedIndex = studentData.GetDepartment(); this.textboxStudentCreditsCompleted.Text = studentData.GetCredit().ToString(); this.textboxStudentCGPA.Text = studentData.GetCGPA().ToString(); this.comboboxStudentNationality.SelectedIndex = studentData.GetNationality(); this.comboboxStudentBloodGroup.SelectedIndex = studentData.GetBloodGroup(); this.pictureboxStudentPicture.ImageLocation = studentData.GetImageDirectory(); this.textboxStudentMAC.Text = studentData.GetMAC(); // this.pictureboxStudentPicture.Load(); }
private void buttonDeleteStudent_Click(object sender, EventArgs e) { string id = this.textboxStudentID.Text; StudentDataHandler studentData = new StudentDataHandler(id); studentData.DeleteStudent(); UpdateForm(); MessageBox.Show("Student 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); }
public StudentInterface(string id) { InitializeComponent(); StudentDataHandler studentData = new StudentDataHandler(id); this.Text = "Welcome, " + studentData.GetName(); this.labelPhoneAns.Text = studentData.GetPhone(); this.labelNameAns.Text = studentData.GetName(); this.labelMotherAns.Text = studentData.GetMother(); this.labelIDAns.Text = studentData.GetID(); this.labelGenderAns.Text = studentData.GetGender() == 1 ? "Male" : "Female"; this.labelFatherAns.Text = studentData.GetFather(); this.labelEmailAns.Text = studentData.GetEmail(); this.labelDOBAns.Text = studentData.GetDOB(); this.labelDepartmentAns.Text = studentData.GetDepartment(); this.labelCreditsAns.Text = studentData.GetCredit().ToString(); this.labelCGPAAns.Text = studentData.GetCGPA().ToString(); this.labelBloodGroupAns.Text = Enum.GetName(typeof(BloodGroup), studentData.GetBloodGroup()); }
private void textboxSearchStudent_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { StudentDataHandler studentData = new StudentDataHandler(); if (Regex.IsMatch(textboxSearchStudent.Text, @"^[\p{L}]+$")) { this.datagridStudentTable.DataSource = studentData.SearchStudentByName(textboxSearchStudent.Text); } // else if (textboxSearchStudent.Text.Length == 3) // this.datagridStudentTable.DataSource = studentData.SearchStudentByDepartment(textboxSearchStudent.Text); else if (textboxSearchStudent.Text.Length > 0) { this.datagridStudentTable.DataSource = studentData.SearchStudentByID(textboxSearchStudent.Text); } else { this.datagridStudentTable.DataSource = studentData.GetStudentTable(); } } }
private void Button_Click(object sender, RoutedEventArgs e) // Load { string comboBoxValue = Regex.Match(Entity_ComboBox.SelectedValue.ToString(), @"(?<=: )\w+").Value; switch (comboBoxValue) { case "Student": { Entity_ComboBox.IsEnabled = false; studentDataHandler = new StudentDataHandler(FilePath_Box.Text); MainDataGrid.ItemsSource = studentDataHandler.Students; break; } case "Teacher": { Entity_ComboBox.IsEnabled = false; teacherDataHandler = new TeacherDataHandler(FilePath_Box.Text); MainDataGrid.ItemsSource = teacherDataHandler.Teachers; break; } } }
private void Form1_Load(object sender, EventArgs e) { dh = new StudentDataHandler(); }
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); } }
public StudentsHandler() { dataHandler = new StudentDataHandler(); }