private void btn_MarkAttendance_Click(object sender, EventArgs e)
{
string attendance_Status = "";
int teacherId = Convert.ToInt32(data.Rows[0]["teacher_Id"].ToString());
int coureId = Convert.ToInt32(data.Rows[0]["course_Id"].ToString());
string teacherName = data.Rows[0]["teacher_Name"].ToString();
string courseName = data.Rows[0]["course_Name"].ToString();
int stuId = 0;
string stuName = "";
int iter = 0;
foreach (object item in checkedListBox_Attendance.Items)
{
if (checkedListBox_Attendance.CheckedItems.Contains(item))
{
attendance_Status = "Present";
}
else
{
attendance_Status = "Absent";
}
stuId = Convert.ToInt32(data.Rows[iter]["student_Id"].ToString());
stuName = data.Rows[iter]["student_Name"].ToString();
iter++;
mysql.AttendanceInsert(stuId, teacherId, coureId, stuName, teacherName, courseName, dateNow, attendance_Status);
}
label_Message.ForeColor = Color.Green;
label_Message.Text = "Attendance Marked.";
label_Message.Show();
}