private void btnLuu_Click(object sender, EventArgs e)
{
int i = 0;
foreach (DataGridViewRow dr in dgvBangDiem.Rows)
{
diem[i].Diem15Phut =(float) Convert.ToInt32(dr.Cells[1].Value);
diem[i].Diem1Tiet = (float) Convert.ToInt32(dr.Cells[2].Value);
diem[i].DiemHocKi = (float) Convert.ToInt32(dr.Cells[3].Value);
i++;
}
DiemDAO adapterDiem = new DiemDAO();
if (adapterDiem.UpdateMark(diem))
{
MessageBox.Show("Lưu thành công!");
}
else
{
MessageBox.Show("Hệ thống bị lỗi!");
}
}
private void XL_Chon()
{
if (flag == true)
{
DiemDAO adapterDiem = new DiemDAO();
HocSinhDAO adapterHS = new HocSinhDAO();
if (combHK.Text != "" && combLop.Text != "" && combMonHoc.Text != "" && combHK.SelectedIndex >= 0 && combLop.SelectedIndex >= 0 && combMonHoc.SelectedIndex>=0)
{
int chi_soHK = combHK.SelectedIndex;
int chi_soLop = combLop.SelectedIndex;
int chi_soMH = combMonHoc.SelectedIndex;
HocKi KQHK;
MonHoc KQMH;
Lop KQL;
if (chi_soHK >= 0 && chi_soLop >= 0 && chi_soMH >= 0)
{
HocKi[] HK = (HocKi[])combHK.Tag;
KQHK = HK[chi_soHK];
Lop[] Lop = (Lop[])combLop.Tag;
KQL = Lop[chi_soLop];
MonHoc[] MonHoc = (MonHoc[])combMonHoc.Tag;
KQMH = MonHoc[chi_soMH];
HocSinh[] HS = adapterHS.getStudentIf(KQL.MaLop, KQMH.MaMonHoc, KQHK.MaHocKi);
diem = adapterDiem.getStudentIf(KQL.MaLop, KQMH.MaMonHoc, KQHK.MaHocKi);
DataTable dt = new DataTable();
dt.Columns.Add("hoTen");
dt.Columns.Add("diem15Phut");
dt.Columns.Add("diem1Tiet");
dt.Columns.Add("diemHocKi");
for (int i = 0; i < HS.Length; i++)
{
DataRow Dong = dt.NewRow();
dt.Rows.Add(Dong);
Dong["hoTen"] = HS[i].HoTen;
Dong["diem15Phut"] = diem[i].Diem15Phut;
Dong["diem1Tiet"] = diem[i].Diem1Tiet;
Dong["diemHocKi"] = diem[i].DiemHocKi;
}
dgvBangDiem.DataSource = dt;
}
}
}
}
