//Lấy giá dịch vụ và hiển thị lên combobox
public static List <DichVu_DTO> HienThiGiaDichVuLenComboBox(string maDichVu)
{
List <DichVu_DTO> lstGiaDichVu = new List <DichVu_DTO>();
try
{
string strTruyVan = string.Format("select * from DichVu where MaDichVu = '" + maDichVu + "'");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
DichVu_DTO dvDTO = new DichVu_DTO();
dvDTO.MaDichVu = _dt.Rows[i]["MaDichVu"].ToString();
dvDTO.DonGia = Convert.ToInt32(_dt.Rows[i]["DonGia"]);
lstGiaDichVu.Add(dvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstGiaDichVu);
}
//HIển thị danh sách thông tin phòng đã ở
public static List <Phong_DTO> HienThiDSKhachHangDaCoPhong()
{
List <Phong_DTO> lstKhachHangDaCoPhong = null;
try
{
string strTruyVan = string.Format("select PDK.MaPhieuDK,KH.TenKH,PHG.TenPhong from PhieuDangKy as PDK,ChiTietLoaiPhong as CTLP, KhachHang as KH,Phong as PHG where PDK.MaPhieuDK = CTLP.MaPhieuDK and PDK.MaKH = KH.MaKH and CTLP.MaPhong = PHG.MaPhong and DaVaoPhong = 1");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
lstKhachHangDaCoPhong = new List <Phong_DTO>();
for (int i = 0; i < _dt.Rows.Count; i++)
{
Phong_DTO phgDTO = new Phong_DTO();
phgDTO.MaPhieuDK = _dt.Rows[i]["MaPhieuDK"].ToString();
phgDTO.TenKH = _dt.Rows[i]["TenKH"].ToString();
phgDTO.TenPhong = _dt.Rows[i]["TenPhong"].ToString();;
lstKhachHangDaCoPhong.Add(phgDTO);
}
}
return(lstKhachHangDaCoPhong);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
//Hiển thị tên loại phòng lên comboBox trong form Chi Tiết Loại Phòng
public static List <LoaiPhong_DTO> HienThiTenLoaiPhong()
{
List <LoaiPhong_DTO> lstTenLoaiPhong = null;
try
{
string strTruyVan = string.Format("SELECT MaLoaiPhong, TenLoaiPhong FROM LoaiPhong");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
lstTenLoaiPhong = new List <LoaiPhong_DTO>();
for (int i = 0; i < _dt.Rows.Count; i++)
{
LoaiPhong_DTO lphgDTO = new LoaiPhong_DTO();
lphgDTO.MaLoaiPhong = _dt.Rows[i]["MaLoaiPhong"].ToString();
lphgDTO.TenLoaiPhong = _dt.Rows[i]["TenLoaiPhong"].ToString();
lstTenLoaiPhong.Add(lphgDTO);
}
}
return(lstTenLoaiPhong);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
public static List <LoaiPhong_DTO> HienThiGiaLoaiPhongLenComboBox()
{
List <LoaiPhong_DTO> lstGiaLoaiPhong = new List <LoaiPhong_DTO>();
try
{
string strTruyVan = string.Format("SELECT distinct GiaLoaiPhong from LoaiPhong");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
LoaiPhong_DTO lphgDTO = new LoaiPhong_DTO();
lphgDTO.GiaLoaiPhong = Convert.ToInt32(_dt.Rows[i]["GiaLoaiPhong"]);
lstGiaLoaiPhong.Add(lphgDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstGiaLoaiPhong);
}
public static List <LoaiPhong_DTO> HienThiThongTinLoaiPhong(int index)
{
List <LoaiPhong_DTO> lstLoaiPhong = null;
try
{
string strTruyVan = string.Format("SELECT * FROM LoaiPhong");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
lstLoaiPhong = new List <LoaiPhong_DTO>();
for (index = 0; index < _dt.Rows.Count; index++)
{
LoaiPhong_DTO lphgDTO = new LoaiPhong_DTO();
lphgDTO.MaLoaiPhong = _dt.Rows[index]["MaLoaiPhong"].ToString();
lphgDTO.TenLoaiPhong = _dt.Rows[index]["TenLoaiPhong"].ToString();
lphgDTO.TrangThietBi = _dt.Rows[index]["TrangThietBi"].ToString();
lphgDTO.GiaLoaiPhong = Convert.ToInt32(_dt.Rows[index]["GiaLoaiPhong"]);
lphgDTO.MoTa = _dt.Rows[index]["MoTa"].ToString();
lstLoaiPhong.Add(lphgDTO);
}
}
return(lstLoaiPhong);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
public static string DoiMatKhau(string maNV, string tendangnhap, string matkhau)
{
string id = "";
try
{
string strTruyVan = string.Format("update NhanVien set TenDangNhap = '" + tendangnhap + "', MatKhau = '" + matkhau + "' where MaNV = '" + maNV + "'");
DataTable dt = new DataTable();
dt = DataProvider.fillDataTable(strTruyVan);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
id = dt.Rows[i]["MaNV"].ToString();
id = dt.Rows[i]["TenDangNhap"].ToString();
id = dt.Rows[i]["MatKhau"].ToString();
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Lỗi xảy ra khi truy vấn dữ liệu hoặc kết nối với server thất bại :" + ex.Message);
}
return(id);
}
public static List <ChucVu_DTO> HienThiDanhSachChucVu(int index)
{
List <ChucVu_DTO> lstChucVu = new List <ChucVu_DTO>();
try
{
string strTruyVan = string.Format("SELECT * FROM ChucVu");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (index = 0; index < _dt.Rows.Count; index++)
{
ChucVu_DTO cvDTO = new ChucVu_DTO();
cvDTO.MaChucVu = _dt.Rows[index]["MaChucVu"].ToString();
cvDTO.TenChucVu = _dt.Rows[index]["TenChucVu"].ToString();
lstChucVu.Add(cvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstChucVu);
}
public static List <DichVu_DTO> HienThiTenDichVuTheoMaDichVu(string maLoaiDichVu)
{
List <DichVu_DTO> lstDichVu = new List <DichVu_DTO>();
try
{
string strTruyVan = string.Format("SELECT * FROM DichVu where MaLoaiDichVu = '" + maLoaiDichVu + "'");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
DichVu_DTO dvDTO = new DichVu_DTO();
dvDTO.MaDichVu = _dt.Rows[i]["MaDichVu"].ToString();
dvDTO.TenDichVu = _dt.Rows[i]["TenDichVu"].ToString();
lstDichVu.Add(dvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstDichVu);
}
//Lấy thông tin nhân viên lễ tân load lên comboBox
public static List <NhanVien_DTO> HienThiDanhSachNhanVienLeTan()
{
List <NhanVien_DTO> lstNhanVienLeTan = new List <NhanVien_DTO>();
try
{
string strTruyVan = string.Format("select NV.MaNV,NV.TenNhanVien from NhanVien as NV, ChucVu as CV where NV.MaChucVu = CV.MaChucVu and TenChucVu like N'Nhân Viên Lễ Tân'");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
NhanVien_DTO nvDTO = new NhanVien_DTO();
nvDTO.MaNV = _dt.Rows[i]["MaNV"].ToString();
nvDTO.TenNhanVien = _dt.Rows[i]["TenNhanVien"].ToString();
lstNhanVienLeTan.Add(nvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstNhanVienLeTan);
}
public static List <DichVu_DTO> HienThiDanhSachCacDichVu(int index)
{
List <DichVu_DTO> lstDichVu = new List <DichVu_DTO>();
try
{
string strTruyVan = string.Format("select DV.MaDichVu,DV.TenDichVu,DV.MaLoaiDichVu,DV.DonGia,DoVi.MaDonVi,DoVi.TenDonVi from DichVu as DV, DonVi as DoVi where DV.MaDonVi = DoVI.MaDonVi");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (index = 0; index < _dt.Rows.Count; index++)
{
DichVu_DTO dvDTO = new DichVu_DTO();
dvDTO.MaDichVu = _dt.Rows[index]["MaDichVu"].ToString();
dvDTO.TenDichVu = _dt.Rows[index]["TenDichVu"].ToString();
dvDTO.DonGia = Convert.ToInt32(_dt.Rows[index]["DonGia"]);
dvDTO.MaLoaiDichVu = _dt.Rows[index]["MaLoaiDichVu"].ToString();
dvDTO.MaDonVi = _dt.Rows[index]["MaDonVi"].ToString();
dvDTO.TenDonVi = _dt.Rows[index]["TenDonVi"].ToString();
lstDichVu.Add(dvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstDichVu);
}
public static List <PhieuDangKy_DTO> HienThiDuLieuPDKDangCho()
{
List <PhieuDangKy_DTO> listPDKDTO = new List <PhieuDangKy_DTO>();
try
{
string strTruyVan = string.Format(@"SELECT DISTINCT KH.MaKH, KH.TenKH, PDK.MaPhieuDK, PDK.TienDatCoc, PDK.MaNV, PDK.MaKH, KH.NgaySinh, KH.GioiTinh, KH.CMND, KH.QuocTich, KH.DiaChi, KH.SDT FROM PhieuDangKy as PDK, KhachHang as KH WHERE PDK.MaKH = KH.MaKH AND KH.DaXacNhan = 1 AND ISNULL(PDK.DaVaoPhong,'false') not in (1)");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (int index = 0; index < _dt.Rows.Count; index++)
{
PhieuDangKy_DTO pdkDTO = new PhieuDangKy_DTO();
pdkDTO.TenKH = _dt.Rows[index]["TenKH"].ToString();
pdkDTO.MaPhieuDK = _dt.Rows[index]["MaPhieuDK"].ToString();
pdkDTO.TienDatCoc = double.Parse(_dt.Rows[index]["TienDatCoc"].ToString());
pdkDTO.MaNV = _dt.Rows[index]["MaNV"].ToString();
pdkDTO.MaKH = _dt.Rows[index]["MaKH"].ToString();
listPDKDTO.Add(pdkDTO);
}
}
return(listPDKDTO);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
//Hiển thị mã phiếu đăng ký mà chưa có xác nhận đặt phòng ở
public static List <PhieuDangKy_DTO> HienThiMaPhieuDangKyChuaDuocDatPhong()
{
List <PhieuDangKy_DTO> lstMaPhieuDKChuaDuocDP = new List <PhieuDangKy_DTO>();
try
{
string strTruyVan = string.Format("select * from PhieuDangKy where DaXacNhan = 0");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
if (lstMaPhieuDKChuaDuocDP == null)
{
lstMaPhieuDKChuaDuocDP = new List <PhieuDangKy_DTO>();
}
PhieuDangKy_DTO pdkDTO = null;
for (int i = 0; i < _dt.Rows.Count; i++)
{
pdkDTO = new PhieuDangKy_DTO();
pdkDTO.MaPhieuDK = _dt.Rows[i]["MaPhieuDK"].ToString();
lstMaPhieuDKChuaDuocDP.Add(pdkDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
return(lstMaPhieuDKChuaDuocDP);
}
public static List <LoaiDichVu_DTO> HienThiTenLoaiDichVuLenComboBox()
{
List <LoaiDichVu_DTO> lstTenLoaiDichVu = new List <LoaiDichVu_DTO>();
try
{
string strTruyVan = string.Format("SELECT * FROM LoaiDichVu");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
LoaiDichVu_DTO ldvDTO = new LoaiDichVu_DTO();
ldvDTO.MaLoaiDichVu = _dt.Rows[i]["MaLoaiDichVu"].ToString();
ldvDTO.TenLoaiDichVu = _dt.Rows[i]["TenLoaiDichVu"].ToString();
lstTenLoaiDichVu.Add(ldvDTO);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(lstTenLoaiDichVu);
}
public static List <Phong_DTO> HienThiDanhSachCacPhong()
{
List <Phong_DTO> lstTenPhong = null;
try
{
string strTruyVan = string.Format("select MaPhong,TenPhong, (CASE WHEN TinhTrangPhong='1' THEN N'Phòng có khách' ELSE N'Phòng trống' END) AS TinhTrangPhong,MaLoaiPhong from Phong");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
lstTenPhong = new List <Phong_DTO>();
for (int i = 0; i < _dt.Rows.Count; i++)
{
Phong_DTO phgDTO = new Phong_DTO();
phgDTO.TenPhong = _dt.Rows[i]["TenPhong"].ToString();
phgDTO.MaPhong = _dt.Rows[i]["MaPhong"].ToString();
phgDTO.TinhTrangPhong = _dt.Rows[i]["TinhTrangPhong"].ToString();
phgDTO.MaLoaiPhong = _dt.Rows[i]["MaLoaiPhong"].ToString();
lstTenPhong.Add(phgDTO);
}
}
return(lstTenPhong);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
//Hiển thị tên phòng đã có khách đặt
public static List <Phong_DTO> HienThiTenPhongTheoMaLoaiPhong_CoNguoi(string maLoaiPhong)
{
List <Phong_DTO> lstTenPhong = null;
try
{
string strTruyVan = string.Format("select MaPhong,TenPhong from Phong where MaLoaiPhong = '" + maLoaiPhong + "' and ISNULL(TinhTrangPhong,'false') not in(0) ");
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
lstTenPhong = new List <Phong_DTO>();
for (int i = 0; i < _dt.Rows.Count; i++)
{
Phong_DTO phgDTO = new Phong_DTO();
phgDTO.TenPhong = _dt.Rows[i]["TenPhong"].ToString();
phgDTO.MaPhong = _dt.Rows[i]["MaPhong"].ToString();
// phgDTO.MaLoaiPhong = _dt.Rows[i]["MaLoaiPhong"].ToString();
lstTenPhong.Add(phgDTO);
}
}
return(lstTenPhong);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
public static string LayMaQuyenHan(string maCanLay)
{
string id = "";
try
{
string strTruyVan = string.Format("select * from NhanVien where MaNV = '" + maCanLay + "'");
DataTable dt = new DataTable();
dt = DataProvider.fillDataTable(strTruyVan);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//Nếu tài khoản còn được sử dụng thì mới có mã quyền hạn
if (dt.Rows[i]["DinhChi"].ToString() == "False")
{
id = dt.Rows[i]["MaQuyenHan"].ToString();
}
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Lỗi xảy ra khi truy vấn dữ liệu hoặc kết nối với server thất bại :" + ex.Message);
}
return(id);
}
public static List <PhieuDangKy_DTO> HienThiDanhSachKhachHangTrongPDK(int index)
{
List <PhieuDangKy_DTO> lstPhieuDangKy = null;
try
{
string strTruyVan = @"SELECT DISTINCT KH.MaKH ,KH.TenKH,PDK.MaPhieuDK,PDK.NgayDen,PDK.GioDen,PDK.NgayDi,PDK.GioDi,PDK.SoLuongNguoiLon,PDK.SoLuongTreEm,PDK.TienDatCoc,PDK.MaNV,PDK.MaKH,KH.NgaySinh,KH.GioiTinh,KH.CMND,KH.QuocTich,KH.DiaChi,KH.SDT
FROM PhieuDangKy as PDK, KhachHang as KH
WHERE PDK.MaKH = KH.MaKH AND KH.DaXacNhan = 1";
DataTable _dt = new DataTable();
_dt = DataProvider.fillDataTable(strTruyVan);
if (_dt != null)
{
if (lstPhieuDangKy == null)
{
lstPhieuDangKy = new List <PhieuDangKy_DTO>();
}
PhieuDangKy_DTO pdkDTO = null;
for (index = 0; index < _dt.Rows.Count; index++)
{
pdkDTO = new PhieuDangKy_DTO();
pdkDTO.TenKH = _dt.Rows[index]["TenKH"].ToString();
pdkDTO.MaPhieuDK = _dt.Rows[index]["MaPhieuDK"].ToString();
pdkDTO.NgayDen = Convert.ToDateTime(_dt.Rows[index]["NgayDen"].ToString());
DateTime dtGioDen = Convert.ToDateTime(_dt.Rows[index]["GioDen"].ToString());
string strGioDen = String.Format("{0:00}:{1:00}:{2:00}", dtGioDen.Hour, dtGioDen.Minute, dtGioDen.Second);
DateTime dtGioDi = Convert.ToDateTime(_dt.Rows[index]["GioDi"].ToString());
string strGioDi = String.Format("{0:00}:{1:00}:{2:00}", dtGioDi.Hour, dtGioDi.Minute, dtGioDi.Second);
pdkDTO.GioDen = strGioDen;
pdkDTO.GioDi = strGioDi;
pdkDTO.NgayDi = Convert.ToDateTime(_dt.Rows[index]["NgayDi"].ToString());
pdkDTO.SoLuongNguoiLon = int.Parse(_dt.Rows[index]["SoLuongNguoiLon"].ToString());
pdkDTO.SoLuongTreEm = int.Parse(_dt.Rows[index]["SoLuongTreEm"].ToString());
pdkDTO.TienDatCoc = double.Parse(_dt.Rows[index]["TienDatCoc"].ToString());
pdkDTO.MaNV = _dt.Rows[index]["MaNV"].ToString();
pdkDTO.MaKH = _dt.Rows[index]["MaKH"].ToString();
lstPhieuDangKy.Add(pdkDTO);
}
}
return(lstPhieuDangKy);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
return(null);
}
}
public static DataTable LayThuocTinhPhong()
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("select MaPhong,TenPhong from Phong where TinhTrangPhong = 1");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable TimTenPhong(string tenPhong)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("select PDK.MaPhieuDK,KH.MaKH,KH.TenKH,KH.GioiTinh,KH.NgaySinh,KH.DiaChi,KH.CMND,SDT,KH.QuocTich,PHG.MaPhong,PHG.TenPhong from PhieuDangKy as PDK,ChiTietLoaiPhong as CTLP, KhachHang as KH,Phong as PHG where PDK.MaPhieuDK = CTLP.MaPhieuDK and PDK.MaKH = KH.MaKH and CTLP.MaPhong = PHG.MaPhong and DaVaoPhong = 1 and PHG.TinhTrangPhong = 1 and PHG.TenPhong like '%" + tenPhong + "%'");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable LayMaPhieuDK()
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT MaPhieuDK from PhieuDangKy");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable TimMaPhieuDK(string maPhieuDK)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT * FROM PhieuDangKy WHERE MaPhieuDK = '" + maPhieuDK + "'");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(dt);
}
public static DataTable LayMaChiTietHoaDon()
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT * FROM ChiTietHoaDon");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable HienThiMaPhong(string maPhong)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("select * from Phong where TinhTrangPhong = 1 and MaPhong = '" + maPhong + "'");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable TimMaHoaDon(string maHoaDon)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT * FROM HoaDon WHERE MaHoaDon = '" + maHoaDon + "'");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable HienThiDanhSachHoaDon()
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("select HD.MaHoaDon,HD.NgayThanhToan,CTHD.TienDichVu,CTHD.TienPhong,CTHD.PhuThu,HD.SoTienDaDatTruoc,HD.TongTienHoaDon from HoaDon as HD inner join ChiTietHoaDon as CTHD on HD.MaChiTietHoaDon = CTHD.MaChiTietHoaDon where CTHD.DaThanhToan = 1");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable HienThiDanhSachChiTietHoaDon()
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT * FROM ChiTietHoaDon where DaThanhToan = 0");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable HienThiDanhSachCacDichVuCanCapNhat(string maDichVu, string maPhong)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("select distinct d.MaSuDungDichVu, p.MaPhong, p.TenPhong, k.TenKH,ldv.MaLoaiDichVu,ldv.TenLoaiDichVu,TenDichVu,count(TenDichVu) as [SoLuong],sum(ThanhTien)as [Tong Tien] from DanhSachSDDichVu d join Phong p on p.MaPhong = d.MaPhong join ChiTietLoaiPhong c on p.MaPhong = c.MaPhong join PhieuDangKy ph on ph.MaPhieuDK = c.MaPhieuDK join KhachHang k on k.MaKH = ph.MaKH join DichVu dv on dv.MaDichVu = d.MaDichVu join LoaiDichVu ldv on dv.MaLoaiDichVu = ldv.MaLoaiDichVu where p.MaPhong = '" + maPhong + "' and d.MaDichVu = '" + maDichVu + "' group by TenDichVu, k.TenKH, p.TenPhong, p.MaPhong, d.MaSuDungDichVu,ldv.MaLoaiDichVu,ldv.TenLoaiDichVu");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
XtraMessageBox.Show("Error : " + ex.Message);
}
return(dt);
}
public static DataTable LayMaKhachHang()
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT MaKH,TenKH from KhachHang");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable TimTenKhachHang(string tenKH)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("SELECT * FROM KhachHang WHERE TenKH = N'" + tenKH + "'");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable HienThiDanhSachMaSuDungDichVu(string maPhong)
{
DataTable dt = new DataTable();
try
{
string strTruyVan = string.Format("select * from DanhSachSDDichVu as DS inner join Phong as PHG on DS.MaPhong = PHG.MaPhong where PHG.MaPhong = '" + maPhong + "' and TinhTrangPhong = 1");
dt = DataProvider.fillDataTable(strTruyVan);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}