public List <ChiTietLopHocDTO> tim_LopHocDAO(string HoTen)
{
List <ChiTietLopHocDTO> lst_LopHoc = new List <ChiTietLopHocDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string query = "Select DD.MaLop, DD.MaHV, HV.HoTen, L.PhongHoc, L.MaTKB, DD.SoNgayVang, KQ.Nghe, KQ.Noi, KQ.Doc, KQ.Viet From DiemDanh DD, Lop L, HocVien HV, KetQua KQ Where HV.HoTen like '%" + HoTen + "%' and DD.MaLop = L.MaLop and DD.MaHV = KQ.MaHV and KQ.MaHV = HV.MaHV and L.MaLop = KQ.MaLop";
SqlDataReader sdr = DataProvider.ThucHienTruyVan(query, conn);
while (sdr.Read())
{
ChiTietLopHocDTO item = new ChiTietLopHocDTO();
item.MaLop = sdr["MaLop"].ToString();
item.MaHV = sdr["MaHV"].ToString();
item.HoTen = sdr["HoTen"].ToString();
item.PhongHoc = sdr["PhongHoc"].ToString();
item.MaTKB = sdr["MaTKB"].ToString();
item.SoNgayVang = int.Parse(sdr["SoNgayVang"].ToString());
item.Nghe = double.Parse(sdr["Nghe"].ToString());
item.Noi = double.Parse(sdr["Noi"].ToString());
item.Doc = double.Parse(sdr["Doc"].ToString());
item.Viet = double.Parse(sdr["Viet"].ToString());
lst_LopHoc.Add(item);
}
sdr.Close();
conn.Close();
return(lst_LopHoc);
}
private void dgv_Lop_SelectionChanged(object sender, EventArgs e)
{
if (dgv_Lop.SelectedRows.Count > 0)
{
_HocVienDaChon = (ChiTietLopHocDTO)dgv_Lop.SelectedRows[0].DataBoundItem;
}
else
{
_HocVienDaChon = null;
}
BindingChiTietHocVien();
}
