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);
}
}
