private void GetDateBtn_Click(object sender, EventArgs e)
{
//check if the records exist if yes load them for editing if not create each record for each student
// and load for edit
AttendanceRecTableTableAdapter ada = new AttendanceRecTableTableAdapter();
DataTable dt = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
if (dt.Rows.Count > 0)
{
// we have records we can edit
DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text);
dataGridView1.DataSource = dt_new;
}
else
{
// create record for each student here
// get class students list
StudentTableTableAdapter student_adaptor = new StudentTableTableAdapter();
DataTable dt_students = student_adaptor.GetDataByClassID((int)metroComboBox1.SelectedValue);
foreach (DataRow row in dt_students.Rows)
{
// insert new rec for 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;
}
// TODO: This line of code loads data into the 'dataSet1.AttendanceRecTable' table. You can move, or remove it, as needed.
this.attendanceRecTableTableAdapter.Fill(this.dataSet1.AttendanceRecTable);
}
