private int tongkhno()
{
List <eKhachHang> lskh = khbul.getKhachHangs();
int i = 0;
foreach (var item in lskh)
{
List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang);
foreach (var item1 in lsp)
{
if (item1.ngayTraPhiTreHen == null)
{
i++;
break;
}
}
}
return(i);
}
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.getKhachHangs()
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 BaoCaoKhachHang_Load(object sender, EventArgs e)
{
khbul = new KhachHangBUL();
phieu = new PhieuThueTraBUL();
td = new TieuDeBUL();
tl = new TheLoaiBUL();
dvd = new DVDBUL();
List <eKhachHang> ls = khbul.getKhachHangs();
dgv_dskh.DataSource = ls;
FormatLaiDataGridviewkh(dgv_dskh);
txt_totalkhnop.Text = tongkhno().ToString();
txt_totaldiatra.Text = tongkhthue().ToString();
cb_listkh.Items.Add("Tất Cả");
cb_listkh.Items.Add("Khách hàng quá hạn trả đĩa");
cb_listkh.Items.Add("Khách hàng nợ phí trễ hạn");
cb_listkh.SelectedIndex = 0;
}
void loadDataGridView(DataGridView d)
{
dgv_dskh.DataSource = khbul.getKhachHangs();
FormatGridView(d);
}