// GET: Rooms
public ActionResult Index()
{
var db = new QuanLyKhachSanEntities();
var lsRooms = db.PHONGs.ToList();
return(View(lsRooms));
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
try
{
var roleId = Convert.ToInt32(httpContext.Session["roleID"]);
using (var context = new QuanLyKhachSanEntities())
{
var roleObj = context.Ref_Role.Find(roleId);
if (context.Ref_Role.Find(roleId) == null)
{
return(false);
}
string roleName = roleObj.roleName;
foreach (var role in allowedroles)
{
if (role == roleName)
{
return(true);
}
}
}
return(false);
}
catch
{
return(false);
}
}
public bool XoaPhongThue_info(ref string err, string TenPhong)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
THONGTIN_PHONG ttp = new THONGTIN_PHONG();
ttp.TenPhong = TenPhong;
qlksEntity.THONGTIN_PHONG.Attach(ttp);
qlksEntity.THONGTIN_PHONG.Remove(ttp);
qlksEntity.SaveChanges();
return(true);
}
public bool ThemLoaiPhong(string LoaiPhong, int GiaPhong, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
KIEUPHONG kp = new KIEUPHONG();
kp.LoaiPhong = LoaiPhong;
kp.GiaPhong = GiaPhong;
qlksEntity.KIEUPHONGs.Add(kp);
qlksEntity.SaveChanges();
return(true);
}
public bool XoaLoaiPhong(ref string err, string LoaiPhong)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
KIEUPHONG kp = new KIEUPHONG();
kp.LoaiPhong = LoaiPhong;
qlksEntity.KIEUPHONGs.Attach(kp);
qlksEntity.KIEUPHONGs.Remove(kp);
qlksEntity.SaveChanges();
return(true);
}
public bool XoaPhongThue(ref string err, string MaDK)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
PHONGTHUE pt = new PHONGTHUE();
pt.MaDK = MaDK;
qlksEntity.PHONGTHUEs.Attach(pt);
qlksEntity.PHONGTHUEs.Remove(pt);
qlksEntity.SaveChanges();
return(true);
}
public bool XoaNhanVien(ref string err, string MaNV)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
NHANVIEN nv = new NHANVIEN();
nv.MaNV = MaNV;
qlksEntity.NHANVIENs.Attach(nv);
qlksEntity.NHANVIENs.Remove(nv);
qlksEntity.SaveChanges();
return(true);
}
public bool XoaKhachHang(ref string err, string MaKH)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
KHACHHANG kh = new KHACHHANG();
kh.MaKH = MaKH;
qlksEntity.KHACHHANGs.Attach(kh);
qlksEntity.KHACHHANGs.Remove(kh);
qlksEntity.SaveChanges();
return(true);
}
public bool XoaHoaDon(ref string err, string MaHD)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
HOADON hd = new HOADON();
hd.MaHD = MaHD;
qlksEntity.HOADONs.Attach(hd);
qlksEntity.HOADONs.Remove(hd);
qlksEntity.SaveChanges();
return(true);
}
public bool XoaDichVu(ref string err, string MaDV)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
DICHVU dv = new DICHVU();
dv.MaDV = MaDV;
qlksEntity.DICHVUs.Attach(dv);
qlksEntity.DICHVUs.Remove(dv);
qlksEntity.SaveChanges();
return(true);
}
public bool ThemPhongThue_info(string TenPhong, string LoaiPhong, string TinhTrang, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
THONGTIN_PHONG ttp = new THONGTIN_PHONG();
ttp.TenPhong = TenPhong;
ttp.LoaiPhong = LoaiPhong;
ttp.TinhTrang = TinhTrang;
qlksEntity.THONGTIN_PHONG.Add(ttp);
qlksEntity.SaveChanges();
return(true);
}
public bool CapNhatLoaiPhong(string LoaiPhong, int GiaPhong, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.KIEUPHONGs where dv.LoaiPhong == LoaiPhong select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.GiaPhong = GiaPhong;
qlksEntity.SaveChanges();
}
return(true);
}
public bool CapNhatPhongThue_info(string TenPhong, string LoaiPhong, string TinhTrang, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.THONGTIN_PHONG where dv.TenPhong == TenPhong select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.LoaiPhong = LoaiPhong;
dvQuerry.TinhTrang = TinhTrang;
qlksEntity.SaveChanges();
}
return(true);
}
public bool ThemDichVu(string MaDV, string TenDV, int GiaDV, string MaNV, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
DICHVU dv = new DICHVU();
dv.MaDV = MaDV;
dv.TenDV = TenDV;
dv.GiaDV = GiaDV;
dv.MaNV = MaNV;
qlksEntity.DICHVUs.Add(dv);
qlksEntity.SaveChanges();
return(true);
}
public bool ThemUser(string User, string pass, string repass, bool phanquyen, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
USER_INFO ui = new USER_INFO();
ui.UserName = User;
ui.PassWord = pass;
ui.RePassWord = repass;
ui.UserType = phanquyen;
qlksEntity.USER_INFO.Add(ui);
qlksEntity.SaveChanges();
return(true);
}
public bool ThemTK(int SoLuongKH, int SoLuongDV, DateTime NgayThongKe, int TongDoanhThu, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
THONGKE tk = new THONGKE();
tk.SoLuongKH = SoLuongKH;
tk.SoLuongDV = SoLuongDV;
tk.NgayThongKe = NgayThongKe;
tk.TongDoanhThu = TongDoanhThu;
qlksEntity.THONGKEs.Add(tk);
qlksEntity.SaveChanges();
return(true);
}
public DataTable LayChucVu()
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var tps = from p in qlksEntity.CHUCVUs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Chức Vụ");
dt.Columns.Add("Chức Vụ");
foreach (var p in tps)
{
dt.Rows.Add(p.MaChucVu, p.ChucVu1);
}
return(dt);
}
public DataTable LayPhongThue_info1()
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var tps = from p in qlksEntity.THONGTIN_PHONG select p;
DataTable dt = new DataTable();
dt.Columns.Add("Tên Phòng");
dt.Columns.Add("Tình Trạng");
foreach (var p in tps)
{
dt.Rows.Add(p.TenPhong, p.TinhTrang);
}
return(dt);
}
public bool ThemPhongThue(string MaDK, string MaKH, string TenPhong, DateTime NgayDK, string TinhTrang, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
PHONGTHUE pt = new PHONGTHUE();
pt.MaDK = MaDK;
pt.MaKH = MaKH;
pt.TenPhong = TenPhong;
pt.NgayDK = NgayDK;
pt.TinhTrang = TinhTrang;
qlksEntity.PHONGTHUEs.Add(pt);
qlksEntity.SaveChanges();
return(true);
}
public DataTable LayLoaiPhong()
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var tps = from p in qlksEntity.KIEUPHONGs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Loại Phòng");
dt.Columns.Add("Giá Phòng");
foreach (var p in tps)
{
dt.Rows.Add(p.LoaiPhong, p.GiaPhong);
}
return(dt);
}
public bool CapNhatDichVu(string MaDV, string TenDV, int GiaDV, string MaNV, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.DICHVUs where dv.MaDV == MaDV select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.TenDV = TenDV;
dvQuerry.GiaDV = GiaDV;
dvQuerry.MaNV = MaNV;
qlksEntity.SaveChanges();
}
return(true);
}
public bool ThemHoaDon(string MaHD, string TenHD, string MaDV, string MaKH, DateTime NgayLapHD, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
HOADON hd = new HOADON();
hd.MaHD = MaHD;
hd.TenHD = TenHD;
hd.MaDV = MaDV;
hd.MaKH = MaKH;
hd.NgayLapHD = NgayLapHD;
qlksEntity.HOADONs.Add(hd);
qlksEntity.SaveChanges();
return(true);
}
public bool CapNhatHoaDon(string MaHD, string TenHD, string MaDV, string MaKH, DateTime NgayLapHD, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.HOADONs where dv.MaHD == MaHD select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.TenHD = TenHD;
dvQuerry.MaDV = MaDV;
dvQuerry.MaKH = MaKH;
dvQuerry.NgayLapHD = NgayLapHD;
qlksEntity.SaveChanges();
}
return(true);
}
public bool CapNhatPhongThue(string MaDK, string MaKH, string TenPhong, DateTime NgayDK, string TinhTrang, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.PHONGTHUEs where dv.MaDK == MaDK select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.MaKH = MaKH;
dvQuerry.TenPhong = TenPhong;
dvQuerry.NgayDK = NgayDK;
dvQuerry.TinhTrang = TinhTrang;
qlksEntity.SaveChanges();
}
return(true);
}
public bool ThemKhachHang(string MaKH, string TenKH, DateTime NgaySinh, string GioiTinh, string CMND, string SDT, string QuocTich, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
KHACHHANG kh = new KHACHHANG();
kh.MaKH = MaKH;
kh.TenKH = TenKH;
kh.NgaySinh = NgaySinh;
kh.GioiTinh = GioiTinh;
kh.CMND = CMND;
kh.SDT = SDT;
kh.QuocTich = QuocTich;
qlksEntity.KHACHHANGs.Add(kh);
qlksEntity.SaveChanges();
return(true);
}
public bool ThemNhanVien(string MaNV, string HoTen, DateTime NgaySinh, string GioiTinh, string CMND_NV, string DiaChi, string MaChucVu, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
NHANVIEN nv = new NHANVIEN();
nv.MaNV = MaNV;
nv.HoTen = HoTen;
nv.NgaySinh = NgaySinh;
nv.GioiTinh = GioiTinh;
nv.CMND_NV = CMND_NV;
nv.DiaChi = DiaChi;;
nv.MaChucVu = MaChucVu;
qlksEntity.NHANVIENs.Add(nv);
qlksEntity.SaveChanges();
return(true);
}
public DataTable LayDichVu()
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var tps = from p in qlksEntity.DICHVUs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã DV");
dt.Columns.Add("Tên DV");
dt.Columns.Add("Giá DV");
dt.Columns.Add("Mã NV");
foreach (var p in tps)
{
dt.Rows.Add(p.MaDV, p.TenDV, p.GiaDV, p.MaNV);
}
return(dt);
}
public bool CapNhatKhachHang(string MaKH, string TenKH, DateTime NgaySinh, string GioiTinh, string CMND, string SDT, string QuocTich, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.KHACHHANGs where dv.MaKH == MaKH select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.TenKH = TenKH;
dvQuerry.NgaySinh = NgaySinh;
dvQuerry.GioiTinh = GioiTinh;
dvQuerry.CMND = CMND;
dvQuerry.SDT = SDT;
dvQuerry.QuocTich = QuocTich;
qlksEntity.SaveChanges();
}
return(true);
}
public bool CapNhatNhanVien(string MaNV, string HoTen, DateTime NgaySinh, string GioiTinh, string CMND_NV, string DiaChi, string MaChucVu, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var dvQuerry = (from dv in qlksEntity.NHANVIENs where dv.MaNV == MaNV select dv).SingleOrDefault();
if (dvQuerry != null)
{
dvQuerry.HoTen = HoTen;
dvQuerry.NgaySinh = NgaySinh;
dvQuerry.GioiTinh = GioiTinh;
dvQuerry.CMND_NV = CMND_NV;
dvQuerry.DiaChi = DiaChi;
dvQuerry.MaChucVu = MaChucVu;
qlksEntity.SaveChanges();
}
return(true);
}
public DataTable LayTK()
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
var tps = from p in qlksEntity.THONGKEs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Thống Kê");
dt.Columns.Add("Số Lượng KH");
dt.Columns.Add("Số Lượng DV");
dt.Columns.Add("Ngày Thống Kê");
dt.Columns.Add("Tổng Doanh Thu");
foreach (var p in tps)
{
dt.Rows.Add(p.MaThongKe, p.SoLuongKH, p.SoLuongDV, p.NgayThongKe, p.TongDoanhThu);
}
return(dt);
}
