private void btnPrev_Click(object sender, EventArgs e) { try { if (page < 0) { page = 0; } this.lbCounter.Text = page.ToString() + "/" + classTotal.ToString(); manageStudent myS = new manageStudent(); string sql = "SELECT * FROM wizstudents WHERE classId = " + this.classId + " ORDER BY systemId ASC LIMIT 1 OFFSET " + this.page; myS.getStudentByQuery(sql); //SELECT * FROM fi_posts WHERE wall = ? AND agent = ? ORDER BY postId DESC LIMIT $page ,$per_pa this.txtEnId.Text = myS.enrolmentId; this.txtFname.Text = myS.firstName; this.txtLname.Text = myS.lastName; //get Attendance information manageAttendence myA = new manageAttendence(); myA.getAttendence(sessions.currTerm, myS.enrolmentId); this.txtAbsent.Text = myA.absentdays.ToString(); this.txtPresent.Text = myA.presentdays.ToString(); this.txtTotal.Text = myA.totaldays.ToString(); this.page -= 1; } catch (Exception ex) { MessageBox.Show("failed in btnPrev_Click()" + ex); } }
private void btnNext_Click(object sender, EventArgs e) { try { if (page < classTotal) { this.lbCounter.Text = page.ToString() + "/" + classTotal.ToString(); manageStudent myS = new manageStudent(); string sql = "SELECT * FROM wizstudents WHERE classId = " + this.classId + " ORDER BY systemId ASC LIMIT 1 OFFSET " + this.page; myS.getStudentByQuery(sql); this.txtEnId.Text = myS.enrolmentId; this.txtFname.Text = myS.firstName; this.txtLname.Text = myS.lastName; manageAttendence myA = new manageAttendence(); myA.getAttendence(sessions.currTerm, myS.enrolmentId); this.txtAbsent.Text = myA.absentdays.ToString(); this.txtPresent.Text = myA.presentdays.ToString(); this.txtTotal.Text = myA.totaldays.ToString(); this.page += 1; } else { MessageBox.Show("class total exceeded", "system notification", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBox.Show("failed in btnNext_Click()" + ex); } }