public IList <ChucDanhNghienCuu> LayTatCaChucDanhNCKH(string maGV)
{
IList <ChucDanhNghienCuu> listChucDanhNCKH = new List <ChucDanhNghienCuu>();
string str = "LayChucDanhNCKHChuaNhan '" + maGV + "'";
DataTable data = new DataTable();
data = Server.LayDuLieuBang(str);
foreach (DataRow item in data.Rows)
{
ChucDanhNCKH = new ChucDanhNghienCuu
{
MaChucDanh = item["MaChucDanh"].ToString(),
TenChucDanh = item["TenChucDanh"].ToString()
};
listChucDanhNCKH.Add(ChucDanhNCKH);
}
return(listChucDanhNCKH);
}
public IList <ChucDanhNghienCuu> listChucDanh(string maGV)
{
IList <ChucDanhNghienCuu> list = new List <ChucDanhNghienCuu>();
string str = "ChucDanhNghienCuuCuaGiaoVien '" + maGV + "'";
DataTable data = new DataTable();
data = Server.LayDuLieuBang(str);
foreach (DataRow item in data.Rows)
{
ChucDanhNCKH = new ChucDanhNghienCuu
{
TenChucDanh = item["TenChucDanh"].ToString(),
Nam = item["Nam"].ToString(),
NoiBoNhiem = item["NoiBoNhiem"].ToString()
};
list.Add(ChucDanhNCKH);
}
return(list);
}
private void btnThemCDNCKH_Click(object sender, EventArgs e)
{
if (dtpNgayNhanCDNCKH.Checked && cbbCDNCKH.Text != "" && txtNoiBNCDNCKH.Text != "")
{
string maCD = ((ChucDanhNghienCuu)cbbCDNCKH.SelectedItem).MaChucDanh;
if (new GiaoVienDAL().ThemCDNCKH(maGV, maCD, dtpNgayNhanCDNCKH.Text, txtNoiBNCDNCKH.Text))
{
ChucDanhNghienCuu cd = new ChucDanhNghienCuu
{
MaChucDanh = maCD,
TenChucDanh = cbbCDNCKH.Text,
NgayNhan = dtpNgayNhanCDNCKH.Text
};
ttCDNCKH.Add(cd);
taiTTCDNCKH();
LyLichKhoaHoc();
MessageBox.Show("Cập nhật thành công");
}
else
{
MessageBox.Show("Lỗi! Cập nhật thất bại");
}
}
}
