private void btnRemove_student_Click(object sender, EventArgs e) { string taiKhoan = txtUser_name_student.Text; BUS_Admin.DeleteUser(taiKhoan); MessageBox.Show("Delete Student Success"); }
private void btnRemove_teacher_Click(object sender, EventArgs e) { string taiKhoan = txtUserName_teacher.Text; BUS_Admin.DeleteUser(taiKhoan); MessageBox.Show("Delete Teacher Success"); }
private void btnResult_Click(object sender, EventArgs e) { dt_Result.DataSource = null; dt_Result.Columns.Clear(); ControlAdmin.TabPages.Clear(); ControlAdmin.TabPages.Add(TabResult); dt_Result.DataSource = BUS_Admin.GetExaminationResult(); }
private void btnList_Student_Click(object sender, EventArgs e) { dt_student.DataSource = null; dt_student.Columns.Clear(); ControlAdmin.TabPages.Clear(); ControlAdmin.TabPages.Add(TabList_student); BUS_Admin.GetListOfStudent(dt_student, conStrSettings, lbPage_student); }
private void btnList_Teacher_Click(object sender, EventArgs e) { dt_teacher.DataSource = null; dt_teacher.Columns.Clear(); ControlAdmin.TabPages.Clear(); ControlAdmin.TabPages.Add(TabList_teacher); BUS_Admin.GetListOfTeacher(dt_teacher, conStrSettings, lbPage_teacher); }
private void btnRestore_Click(object sender, EventArgs e) { OpenFileDialog folder = new OpenFileDialog(); string Path = null; if (folder.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Path = folder.FileName; } BUS_Admin.RestoreDataBase(Path, conStrSettings); MessageBox.Show("Restore Success"); }
private void btnBack_up_Click(object sender, EventArgs e) { FolderBrowserDialog folder = new FolderBrowserDialog(); string Path = null; if (folder.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Path = folder.SelectedPath; } BUS_Admin.BackupDataBase(Path, conStrSettings); MessageBox.Show("Back up Success"); }
private void btnStudent_Seach_Click(object sender, EventArgs e) { if (Radiobtn_FullName_student.Checked == false && Radiobtn_ClassName.Checked == false) { return; } if (Radiobtn_FullName_student.Checked == true) { dt_student.DataSource = BUS_Admin.SearchingForStudentWithName(txtSearch_student.Text, conStrSettings, lbPage_student); } if (Radiobtn_ClassName.Checked == true) { dt_student.DataSource = BUS_Admin.SearchingForStudentWithClass(txtSearch_student.Text, conStrSettings, lbPage_student); } }
private void btnExport_Click(object sender, EventArgs e) { if (ControlAdmin.SelectedIndex == -1) { return; } if (ControlAdmin.TabPages[ControlAdmin.SelectedIndex] == TabList_student || ControlAdmin.TabPages[ControlAdmin.SelectedIndex] == TabList_teacher) { BUS_Admin.btnExport_Click(_inputParameter, bgWorker_Export, dt_student, dt_teacher, ControlAdmin, TabList_student, TabList_teacher, pgBar); } else { return; } }
private void btnTeacher_Search_Click(object sender, EventArgs e) { if (Radiobtn_FullName_teacher.Checked == false && Radiobtn_GradeName.Checked == false) { return; } if (Radiobtn_FullName_teacher.Checked == true) { dt_student.DataSource = BUS_Admin.SearchingForTeacherWithName(txtSearch_student.Text, conStrSettings, lbPage_student); } if (Radiobtn_GradeName.Checked == true) { dt_student.DataSource = BUS_Admin.SearchingForTeacherWithGrade(txtSearch_student.Text, conStrSettings, lbPage_teacher); } }
private void dt_teacher_SelectionChanged(object sender, EventArgs e) { if (dt_teacher.SelectedRows.Count > 0) { btnAdd_teacher.Visible = false; DataGridViewRow row = dt_teacher.SelectedRows[0]; Teacher_User_Account = row.Cells[0].Value.ToString(); txtUserName_teacher.Text = row.Cells[0].Value.ToString(); txtCMND_TCC_teacher.Text = row.Cells[5].Value.ToString(); txtFull_name_teacher.Text = row.Cells[4].Value.ToString(); txtMail_teacher.Text = row.Cells[8].Value.ToString(); txtSDT_teacher.Text = row.Cells[7].Value.ToString(); dtTeacher_Picker.Value = DateTime.Parse(row.Cells[6].Value.ToString()); Grade_CBB.Text = BUS_Admin.findGradeByID(row.Cells[2].Value.ToString()); } }
private void dt_student_SelectionChanged(object sender, EventArgs e) { if (dt_student.SelectedRows.Count > 0) { btnAdd_student.Visible = false; DataGridViewRow row = dt_student.SelectedRows[0]; Student_User_Account = row.Cells[0].Value.ToString(); txtUser_name_student.Text = row.Cells[0].Value.ToString(); txtCMND_TCC_student.Text = row.Cells[5].Value.ToString(); txtFull_name_student.Text = row.Cells[4].Value.ToString(); txtMail_student.Text = row.Cells[8].Value.ToString(); txtSDT_student.Text = row.Cells[7].Value.ToString(); dtStudent_Picker.Value = DateTime.Parse(row.Cells[6].Value.ToString()); Class_CBB.Text = BUS_Admin.findClassByID(row.Cells[3].Value.ToString()); } }
private void btnUpdate_teacher_Click(object sender, EventArgs e) { Giao_Vienn Teacher = new Giao_Vienn() { Ho_Ten = txtFull_name_teacher.Text, Tai_Khoan = txtUserName_teacher.Text, Mat_Khau = txtUserName_teacher.Text, CMND_TCC = txtCMND_TCC_teacher.Text, Lop = null, Khoi = listGrades[Grade_CBB.SelectedIndex].GradeID, Email = txtMail_teacher.Text, SDT = txtSDT_teacher.Text, Ngay_Sinh = DateTime.Parse(dtTeacher_Picker.Value.ToString()) }; BUS_Admin.UpdateTeacher(Teacher, Teacher_User_Account); }
private void btnUpdate_student_Click(object sender, EventArgs e) { Hoc_Sinhh Student = new Hoc_Sinhh() { Ho_Ten = txtFull_name_student.Text, Tai_Khoan = txtUser_name_student.Text, Mat_Khau = txtUser_name_student.Text, CMND_TCC = txtCMND_TCC_student.Text, Lop = listClasses[Class_CBB.SelectedIndex].ClassID, Khoi = null, Email = txtMail_student.Text, SDT = txtSDT_student.Text, Ngay_Sinh = DateTime.Parse(dtStudent_Picker.Value.ToString()) }; BUS_Admin.UpdateStudent(Student, Student_User_Account); }
private void btnImport_Click(object sender, EventArgs e) { OpenFileDialog file = new OpenFileDialog(); string Path = null; if (file.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Path = file.FileName; if (ControlAdmin.TabPages[ControlAdmin.SelectedIndex] == TabList_student) { BUS_Admin.ImportStudent(Path, dt_student); } else if (ControlAdmin.TabPages[ControlAdmin.SelectedIndex] == TabList_teacher) { BUS_Admin.ImportTeacher(Path, dt_teacher); } else { return; } } }
private void btnAdd_student_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { Hoc_Sinhh Student = new Hoc_Sinhh() { Ho_Ten = txtFull_name_student.Text, Tai_Khoan = txtUser_name_student.Text, Mat_Khau = txtUser_name_student.Text, CMND_TCC = txtCMND_TCC_student.Text, Lop = listClasses[Class_CBB.SelectedIndex].ClassID, Khoi = null, Email = txtMail_student.Text, SDT = txtSDT_student.Text, Ngay_Sinh = DateTime.Parse(dtStudent_Picker.Value.ToString()) }; BUS_Admin.InsertStudent(Student); MessageBox.Show("Add Student Success!"); } MessageBox.Show("Add Student Failed!"); return; }
private void btnAdd_teacher_Click(object sender, EventArgs e) { if (ValidateChildren(ValidationConstraints.Enabled)) { Giao_Vienn Teacher = new Giao_Vienn() { Ho_Ten = txtFull_name_teacher.Text, Tai_Khoan = txtUserName_teacher.Text, Mat_Khau = txtUserName_teacher.Text, CMND_TCC = txtCMND_TCC_teacher.Text, Khoi = listGrades[Grade_CBB.SelectedIndex].GradeID, Lop = null, Email = txtMail_teacher.Text, SDT = txtSDT_teacher.Text, Ngay_Sinh = DateTime.Parse(dtTeacher_Picker.Value.ToString()) }; BUS_Admin.InsertTeacher(Teacher); MessageBox.Show("Add Teacher Success!"); } MessageBox.Show("Add Teacher Failed!"); return; }
private void frmAdmin_Load(object sender, EventArgs e) { listClasses = BUS_Admin.LoadClasses(); Class_CBB.DataSource = listClasses; listGrades = BUS_Admin.LoadGrades(); Grade_CBB.DataSource = listGrades; RegexValidator SearchInfomation_Student = new RegexValidator(); SearchInfomation_Student.ControlToValidate = txtSearch_student; SearchInfomation_Student.ErrorMessage = "Infomation Incorrect, Correct Form: Lop 10A or Nguyen Van A"; SearchInfomation_Student.Pattern = @"^[0-9A-Za-z][A-Za-z0-9\s]{1,60}$"; RegexValidator SearchInfomation_Teacher = new RegexValidator(); SearchInfomation_Teacher.ControlToValidate = txtSearch_teacher; SearchInfomation_Teacher.ErrorMessage = "Infomation Incorrect, Correct Form: Khoi 10 or Nguyen Van A"; SearchInfomation_Teacher.Pattern = @"^[0-9A-Za-z][A-Za-z0-9\s]{1,60}$"; RegexValidator TeacherUserName = new RegexValidator(); TeacherUserName.ControlToValidate = txtUserName_teacher; TeacherUserName.ErrorMessage = "Teacher Account Incorrect, Correct Form: TK000001"; TeacherUserName.Pattern = @"^[A-Z][A-Z0-9]{8,9}$"; RegexValidator StudentUserName = new RegexValidator(); StudentUserName.ControlToValidate = txtUser_name_student; StudentUserName.ErrorMessage = "Student Account Incorrect, Correct Form: TK000001"; StudentUserName.Pattern = @"^[A-Z][A-Z0-9]{8,9}$"; RegexValidator TeacherName = new RegexValidator(); TeacherName.ControlToValidate = txtFull_name_teacher; TeacherName.ErrorMessage = "Teacher Name Incorrect, Correct Form: Nguyen Van A"; TeacherName.Pattern = @"^[A-Z][A-Za-z\s]{1,60}$"; RegexValidator StudentName = new RegexValidator(); StudentName.ControlToValidate = txtFull_name_student; StudentName.ErrorMessage = "Student Name Incorrect, Correct Form: Nguyen Van A"; StudentName.Pattern = @"^[A-Z][A-Za-z\s]{1,60}$"; DateValidator StudentDOB = new DateValidator(); StudentDOB.ControlToValidate = dtStudent_Picker; StudentDOB.ErrorMessage = "Date Incorrect, Correct Form: 01/01/1753"; DateValidator TeacherDOB = new DateValidator(); TeacherDOB.ControlToValidate = dtTeacher_Picker; TeacherDOB.ErrorMessage = "Date Incorrect, Correct Form: 01/01/1753"; RegexValidator StudentEmail = new RegexValidator(); StudentEmail.ControlToValidate = txtMail_student; StudentEmail.ErrorMessage = "Email Incorrect, Correct Form: [email protected]"; StudentEmail.Pattern = @"^[A-Za-z][a-zA-Z0-9_\.@]{13,40}$"; RegexValidator TeacherEmail = new RegexValidator(); TeacherEmail.ControlToValidate = txtMail_teacher; TeacherEmail.ErrorMessage = "Email Incorrect, Correct Form: [email protected]"; TeacherEmail.Pattern = @"^[a-z][a-zA-Z0-9_\.@]{13,40}$"; RegexValidator StudentPhoneNumber = new RegexValidator(); StudentPhoneNumber.ControlToValidate = txtSDT_student; StudentPhoneNumber.ErrorMessage = "PhoneNumber Incorrect, Correct Form: 0944686099"; StudentPhoneNumber.Pattern = @"^[0-9]{10,15}$"; RegexValidator TeacherPhoneNumber = new RegexValidator(); TeacherPhoneNumber.ControlToValidate = txtSDT_teacher; TeacherPhoneNumber.ErrorMessage = "PhoneNumber Incorrect, Correct Form: 0944686099"; TeacherPhoneNumber.Pattern = @"^[0-9]{10,15}$"; RegexValidator StudentCMND_TCC = new RegexValidator(); StudentCMND_TCC.ControlToValidate = txtCMND_TCC_student; StudentCMND_TCC.ErrorMessage = "PhoneNumber Incorrect, Correct Form: 123456789"; StudentCMND_TCC.Pattern = @"^[0-9]{9,15}$"; RegexValidator TeacherCMND_TCC = new RegexValidator(); TeacherCMND_TCC.ControlToValidate = txtCMND_TCC_teacher; TeacherCMND_TCC.ErrorMessage = "PhoneNumber Incorrect, Correct Form: 123456789"; TeacherCMND_TCC.Pattern = @"^[0-9]{9,15}$"; }
private void btnPrev_student_Click(object sender, EventArgs e) { BUS_Admin.PrevPage_student(dt_student, conStrSettings, lbPage_student, txtSearch_student.Text, Radiobtn_FullName_student, Radiobtn_ClassName); }
private void btnNext_teacher_Click(object sender, EventArgs e) { BUS_Admin.PrevPage_teacher(dt_teacher, conStrSettings, lbPage_teacher, txtSearch_teacher.Text, Radiobtn_FullName_teacher, Radiobtn_GradeName); }
private void bgWorker_Export_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { BUS_Admin.bgWorker_Export_RunWorkerCompleted(sender, e, lbStatus); }
private void bgWorker_Export_ProgressChanged(object sender, ProgressChangedEventArgs e) { BUS_Admin.bgWorker_Export_ProgressChanged(sender, e, pgBar, lbStatus); }
private void bgWorker_Export_DoWork(object sender, DoWorkEventArgs e) { BUS_Admin.bgWorker_Export_DoWork(sender, e, bgWorker_Export); }