private void btn_MarkAttendance_Click(object sender, EventArgs e)
{
string attendance_Status = "";
int attendance_Id = 0;
int iter = 0;
foreach (object item in checkedListBox_Attendance.Items)
{
if (checkedListBox_Attendance.CheckedItems.Contains(item))
{
attendance_Status = "Present";
}
else
{
attendance_Status = "Absent";
}
attendance_Id = Convert.ToInt32(data.Rows[iter]["attendance_Id"].ToString());
iter++;
mysql.AttendanceUpdate(attendance_Id, attendance_Status);
}
label_Message.ForeColor = Color.Green;
label_Message.Text = "Attendance Edited.";
label_Message.Show();
}