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 ActionResult Edit([Bind(Include = "MADK,MAKH,SOPHONG,NGAYDEN,NGAYDI")] PHONGTHUE pHONGTHUE)
{
if (ModelState.IsValid)
{
db.Entry(pHONGTHUE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MAKH = new SelectList(db.KHACHHANGs, "MAKH", "TENKH", pHONGTHUE.MAKH);
ViewBag.SOPHONG = new SelectList(db.PHONGs, "SOPHONG", "LOAIPHONG", pHONGTHUE.SOPHONG);
return(View(pHONGTHUE));
}
// GET: Admin/PHONGTHUEs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHONGTHUE pHONGTHUE = db.PHONGTHUEs.Find(id);
if (pHONGTHUE == null)
{
return(HttpNotFound());
}
return(View(pHONGTHUE));
}
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);
}
// GET: Admin/PHONGTHUEs/Create
//public ActionResult Create()
//{
// ViewBag.MAKH = new SelectList(db.KHACHHANGs, "MAKH", "TENKH");
// ViewBag.SOPHONG = new SelectList(db.PHONGs, "SOPHONG", "LOAIPHONG");
// return View();
//}
// POST: Admin/PHONGTHUEs/Create
// To protect from overposting attacks, enable the specific properties you want to bind to, for
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.
// GET: Admin/PHONGTHUEs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHONGTHUE pHONGTHUE = db.PHONGTHUEs.Find(id);
if (pHONGTHUE == null)
{
return(HttpNotFound());
}
ViewBag.MAKH = new SelectList(db.KHACHHANGs, "MAKH", "TENKH", pHONGTHUE.MAKH);
ViewBag.SOPHONG = new SelectList(db.PHONGs, "SOPHONG", "LOAIPHONG", pHONGTHUE.SOPHONG);
return(View(pHONGTHUE));
}
public ActionResult Booking(string dtp_from, string dtp_to, string people, string quantity, string pool, string bar, string gym, string rooms, string fullname, string phonenum)
{
var db = new QuanLyKhachSanEntities();
var PhongThue = new PHONGTHUE();
string idPhongThue = new GenerateIDPhongThue().generateID();
// check phòng
var phongTrong = db.PHONGs.Where(x => x.LOAIPHONG == rooms && x.TRANGTHAI == "false").FirstOrDefault();
if (phongTrong == null)
{
return(Content("nullRooms"));
}
// tạo thông tin khách hàng
var khachHang = new KHACHHANG();
khachHang.MAKH = new GenerateIDPhongThue().generateIDKH();
khachHang.TENKH = fullname;
khachHang.SDT = Convert.ToInt32(phonenum);
db.KHACHHANGs.Add(khachHang);
// lưu database
db.SaveChanges();
// tạo thống tin cho phòng thuê
phongTrong.TRANGTHAI = "true";
PhongThue.MADK = idPhongThue;
PhongThue.NGAYDI = Convert.ToDateTime(dtp_to);
PhongThue.NGAYDEN = Convert.ToDateTime(dtp_from);
PhongThue.SOPHONG = phongTrong.SOPHONG;
PhongThue.MAKH = khachHang.MAKH;
db.PHONGTHUEs.Add(PhongThue);
db.SaveChanges();
// tạo thông tin lưu dịch vụ
if (pool == "true")
{
string idBooking = new GenerateIDPhongThue().generateIDServiceBooking();
var DVKH = new DVKH();
DVKH.ID = idBooking;
DVKH.MADV = "1";
DVKH.MADK = idPhongThue;
db.DVKHs.Add(DVKH);
db.SaveChanges();
}
if (bar == "true")
{
string idBooking = new GenerateIDPhongThue().generateIDServiceBooking();
var DVKH = new DVKH();
DVKH.ID = idBooking;
DVKH.MADV = "2";
DVKH.MADK = idPhongThue;
db.DVKHs.Add(DVKH);
db.SaveChanges();
}
if (gym == "true")
{
string idBooking = new GenerateIDPhongThue().generateIDServiceBooking();
var DVKH = new DVKH();
DVKH.ID = idBooking;
DVKH.MADV = "3";
DVKH.MADK = idPhongThue;
db.DVKHs.Add(DVKH);
db.SaveChanges();
}
return(Content("true"));
}
