private void cmbTeacher_TextChanged(object sender, EventArgs e) { try { if (startIntract == true) { int teacherId = Convert.ToInt32(this.cmbTeacher.SelectedValue); manageClassrooms myC = new manageClassrooms(); myC.getClassByTeacher(teacherId); if (myC.dacFound == true) { this.swapTeacher = true; MessageBox.Show(this.cmbTeacher.Text + "is already assigned to " + myC.className, "System Notification", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { this.swapTeacher = false; } } } catch (Exception ex) { MessageBox.Show("failed in cmbTeacher_Leave() " + ex.Message); } }
private void Form1_Load(object sender, EventArgs e) { try { manageClassrooms myC = new manageClassrooms(); myC.getClassByTeacher(sessions.userId); sessions.classId = myC.classRoomId; sessions.classGrade = myC.classGrade; manageControl myCntr = new manageControl(); myCntr.getCntrl(); sessions.curPeriod = myCntr.currentPeriod; sessions.currTerm = myCntr.currTerm; } catch (Exception ex) { MessageBox.Show("failed in frmTeacherMainMenu() " + ex.Message); } }
private void frmAttendance_Load(object sender, EventArgs e) { try { if (sessions.userType == "T") { manageClassrooms myC = new manageClassrooms(); manageStudent myS = new manageStudent(); myC.getClassByTeacher(sessions.userId); this.classId = myC.classRoomId; this.classTotal = 3; this.lbCounter.Text = page.ToString() + "/" + classTotal.ToString(); this.fillStudents(); } } catch (MySqlException ex) { System.Windows.Forms.MessageBox.Show("frmAttendance_Load() " + ex); } }
private void frmAttendance_Load(object sender, EventArgs e) { try { if (sessions.userType == "T") { manageClassrooms myC = new manageClassrooms(); manageStudent myS = new manageStudent(); myC.getClassByTeacher(sessions.userId); this.classId = myC.classRoomId; this.classTotal = 3; var attendDate = this.txtDate.Value.ToShortDateString(); this.lbCounter.Text = page.ToString() + "/" + classTotal.ToString(); this.lblShowList.Text = "List of students not marked in register"; string sql = "SELECT * FROM wizstudents WHERE classId = '" + this.classId + "' AND enrolmentId NOT IN (SELECT enrolmentId FROM wizattendsheet WHERE entryData = '" + attendDate + "' ) "; this.fillStudents(sql); } } catch (MySqlException ex) { System.Windows.Forms.MessageBox.Show("frmAttendance_Load() " + ex); } }