public List <khachhangtaikhoan> getKhachhang() { var truyvan = from kh in db.khachhangs join tk in db.users on(int) kh.matk equals(int) tk.id into g from khGroup in g.DefaultIfEmpty() select new { tentk = khGroup == null ? "null" : khGroup.tentk, kh.makh, kh.hoten, kh.diachi, kh.gioitinh, kh.email, kh.sodt }; List <khachhangtaikhoan> listKhtk = new List <khachhangtaikhoan>(); foreach (var dt in truyvan) { khachhangtaikhoan khtk = new khachhangtaikhoan(); khtk.makh = (int)dt.makh; khtk.tenkh = dt.hoten; khtk.gioitinh = dt.gioitinh; khtk.diachi = dt.diachi; khtk.sdt = dt.sodt; khtk.email = dt.email; khtk.tentk = dt.tentk; listKhtk.Add(khtk); } return(listKhtk); }
public List <khachhangtaikhoan> getLoaikhachhang(int lkh) { List <khachhangtaikhoan> listKhtk = new List <khachhangtaikhoan>(); if (lkh == 1) { var truyvan = from kh in db.khachhangs join tk in db.users on(int) kh.matk equals(int) tk.id select new { tk.tentk, kh.makh, kh.hoten, kh.diachi, kh.gioitinh, kh.email, kh.sodt }; foreach (var dt in truyvan) { khachhangtaikhoan khtk = new khachhangtaikhoan(); khtk.makh = (int)dt.makh; khtk.tenkh = dt.hoten; khtk.gioitinh = dt.gioitinh; khtk.diachi = dt.diachi; khtk.sdt = dt.sodt; khtk.email = dt.email; khtk.tentk = dt.tentk; listKhtk.Add(khtk); } } else { var truyvan = from kh in db.khachhangs where kh.matk == null select new { kh.makh, kh.hoten, kh.diachi, kh.gioitinh, kh.email, kh.sodt }; foreach (var dt in truyvan) { khachhangtaikhoan khtk = new khachhangtaikhoan(); khtk.makh = (int)dt.makh; khtk.tenkh = dt.hoten; khtk.gioitinh = dt.gioitinh; khtk.diachi = dt.diachi; khtk.sdt = dt.sodt; khtk.email = dt.email; khtk.tentk = "Không có"; listKhtk.Add(khtk); } } return(listKhtk); }