Пример #1
0
        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);
            }
        }
Пример #2
0
        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);
            }
        }