private void metroButton5_Click(object sender, EventArgs e)
{
//check if records exists if yes load them for edit or if not create a record for each student and load for edit
AttendanceReportTableAdapter ada = new AttendanceReportTableAdapter();
DataTable dt = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
if (dt.Rows.Count > 0)
{
//we have records, so we can edit them
DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
dataGridView1.DataSource = dt_new;
}
else
{
//create record for each student
//get the class student list
StudentsTableAdapter student_adap = new StudentsTableAdapter();
DataTable dt_students = student_adap.GetDataByClassID((int)metroComboBox1.SelectedValue);
foreach (DataRow row in dt_students.Rows)
{
//insert new record for this student
ada.InsertQuery((int)row[0], (int)metroComboBox1.SelectedValue, dateTimePicker1.Text, "", row[1].ToString(), metroComboBox1.Text);
}
DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
dataGridView1.DataSource = dt_new;
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
AttendanceReportTableAdapter ada = new AttendanceReportTableAdapter();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[1].Value != null)
{
ada.UpdateQuery("", row.Cells[0].Value.ToString(), (int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
}
}
DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
dataGridView1.DataSource = dt_new;
}