public void LoadData(int s)
{
List <eKhachHang> listkh = new List <eKhachHang>();
//Chon ra nhung phieu dat truoc theo tieu de da dat
// ePhieuDatTruoc bs = tieuDeBUL.FindbyID(s);
var lispdt = from td in tieuDeBUL.getTieuDes()
join pdt in phieuDatTruocBUL.getPhieuDatTruocs()
on td.id_TieuDe equals pdt.id_TieuDe
where pdt.id_TieuDe == s
select new
{
pdt.id_KhachHang,
pdt.id_TieuDe
};
var lit = from p in lispdt
join kh in khachHangBUL.getKhachHangs1()
on p.id_KhachHang equals kh.id_KhachHang
select new
{
kh.id_KhachHang,
kh.tenKhachHang,
kh.soCMND,
kh.soDT
};
foreach (var item in lit)
{
eKhachHang ek = new eKhachHang();
ek.id_KhachHang = item.id_KhachHang;
ek.tenKhachHang = item.tenKhachHang;
ek.soCMND = item.soCMND;
ek.soDT = item.soDT;
listkh.Add(ek);
}
dgv_dskhdat.DataSource = listkh;
}
private void QuanLyKhachHang_Load(object sender, EventArgs e)
{
dgv_dskh.DataSource = kh.getKhachHangs1();
}