public static List <KhachHang> LayDanhSachKhachHang() { using (dbKaoraokeDataContext dataContext = new dbKaoraokeDataContext()) { var list = (from khachHang in dataContext.KHACHHANGs select new KhachHang() { MaKhachHang = khachHang.MAKH, LoaiKhachHang = khachHang.LOAIKHACHHANG.TENLOAIKH, SoDienThoai = khachHang.SDT, TenKhachHang = khachHang.TENKH }).ToList(); return(list); } }
public static List <HoaDon> LayDanhSachHoaDon() { using (dbKaoraokeDataContext dataContext = new dbKaoraokeDataContext()) { var list = (from hoaDon in dataContext.HOADONs select new HoaDon() { MaKhachHang = hoaDon.MAKH, SoHoaDon = hoaDon.SOHD, GiamGia = hoaDon.GIAMGIA.HasValue ? hoaDon.GIAMGIA.Value : 0, GioVao = hoaDon.GIOVAO.HasValue ? hoaDon.GIOVAO.Value : DateTime.Now, GioRa = hoaDon.GIORA.HasValue ? hoaDon.GIORA.Value : DateTime.Now, MaPhong = hoaDon.MAPHONG, NgayLap = hoaDon.NGAYLAP.HasValue ? hoaDon.NGAYLAP.Value : DateTime.Now, ThanhTien = hoaDon.THANHTIEN.HasValue ? hoaDon.THANHTIEN.Value : 0, TienGio = hoaDon.TIENGIO.HasValue ? hoaDon.TIENGIO.Value : 0, TrangThai = hoaDon.TRANGTHAI.HasValue ? hoaDon.TRANGTHAI.Value : 0 }).ToList(); return(list); } }