public List <ClassKhachHang> GetKhachHang()
{
using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext())
{
List <ClassKhachHang> lstKH = new List <ClassKhachHang>();
db.DeferredLoadingEnabled = false;
var ttKH = from k in db.KhachHangs
join l in db.LoaiKhachHangs on k.LoaiKhachHang equals l.MaLoaiKhachHang
select new
{
KhachHang = k,
LoaiKhachHang = l
};
foreach (var i in ttKH)
{
// MessageBox.Show(""+i);
ClassKhachHang KHNew = new ClassKhachHang();
KHNew.MaKhachHang = i.KhachHang.MaKhachHang;
KHNew.TenKhachHang = i.KhachHang.TenKhachHang;
KHNew.Ngaysinh = i.KhachHang.Ngaysinh;
KHNew.GioiTinh = i.KhachHang.GioiTinh;
KHNew.Email = i.KhachHang.Email;
KHNew.DiaChi = i.KhachHang.DiaChi;
KHNew.SDT = i.KhachHang.SDT;
KHNew.LoaiKhachHang = i.LoaiKhachHang.TenLoaiKhachHang;
KHNew.GhiChu = i.KhachHang.GhiChu;
if (i.KhachHang.Image != null)
{
KHNew.Image = ByteArrayToImage(i.KhachHang.Image.ToArray());
}
lstKH.Add(KHNew);
}
classKH = lstKH;
return(lstKH);
}
}