public void capNhatTinhTrangGiaoDich(int idDoan, int tinhTrang)
{
using (var db = new ManageHotelEntities())
{
db.sp_CapNhatTinhTrangGiaoDich(idDoan, tinhTrang);
}
}
public List <sp_SearchAvailableRoom_Result> SearchAvailableRoom(int floor, int state, int level, int numberSlot, String dateFrom, String dateTo)
{
using (var db = new ManageHotelEntities())
{
return(db.sp_SearchAvailableRoom(floor, state, level, numberSlot, dateFrom, dateTo).ToList());
}
}
public void capNhatSoPhong(int idDoan, int soPhong)
{
using (var db = new ManageHotelEntities())
{
db.sp_CapNhatSoPhongGiaoDich(idDoan, soPhong);
}
}
public void xoaChiTietGiaoDichTheoMaDoan(int idDoan)
{
using (var db = new ManageHotelEntities())
{
db.sp_XoaChiTietGiaoDichTheoDoan(idDoan);
}
}
public List <sp_LayChiTietGiaoDichTheoDoan_Result> layChiTietGiaoDichTheoMaDoan(int idDoan)
{
using (var db = new ManageHotelEntities())
{
return(db.sp_LayChiTietGiaoDichTheoDoan(idDoan).ToList());
}
}
public void xoaChiTietGiaoDich(int id)
{
using (var db = new ManageHotelEntities())
{
db.sp_XoaChiTietGiaoDich(id);
}
}
public List <sp_ChiTietGiaoDich_Result> getChiTietGiaoDich(int idDoan)
{
using (var db = new ManageHotelEntities())
{
List <sp_ChiTietGiaoDich_Result> result = db.sp_ChiTietGiaoDich(idDoan).ToList();
return(result);
}
}
public Phong getPhong(int id)
{
using (var db = new ManageHotelEntities())
{
Phong result = db.Phongs.Where(x => x.ID == id).FirstOrDefault();
return(result);
}
}
public void themChiTietGiaoDich(ChiTietGiaoDich ct)
{
using (var db = new ManageHotelEntities())
{
db.sp_ThemChiTietGiaoDich(ct.ID_GiaoDich, ct.ID_MaPhong,
ct.ID_KhachHang, ct.NgayBatDau, ct.NgayKetThuc);
}
}
public List <HinhThuc> getAllHinhThuc()
{
using (var db = new ManageHotelEntities())
{
List <HinhThuc> hinhthuc = db.HinhThucs.ToList();
return(hinhthuc);
}
}
public List <String> getAllTang()
{
using (var db = new ManageHotelEntities())
{
List <String> hangphong = db.Phongs.Select(x => x.ViTriTang).Distinct().ToList();
return(hangphong);
}
}
public List <Hang> getAllHang()
{
using (var db = new ManageHotelEntities())
{
List <Hang> hangphong = db.Hangs.ToList();
return(hangphong);
}
}
public GiaoDich getAccount(String username)
{
using (var db = new ManageHotelEntities())
{
GiaoDich khachhang = db.GiaoDiches.Where(gt => gt.TenDangNhap == username).FirstOrDefault();
return(khachhang);
}
}
public sp_LayThongTinDoan_Result layThongTinDoan(int idDoan)
{
using (var db = new ManageHotelEntities())
{
var thongTinDoan = db.sp_LayThongTinDoan(idDoan).ToList();
if (thongTinDoan.Count > 0)
{
return(thongTinDoan[0]);
}
return(null);
}
}
public List <KhachHang> getDanhSachDoan(int idDoan)
{
List <KhachHang> listKH = new List <KhachHang>();
using (var db = new ManageHotelEntities())
{
var list = db.sp_LayDanhSachDoan(idDoan).ToList();
foreach (var kh in list)
{
listKH.Add(createKhachHang(kh));
}
return(listKH);
}
}
