public JsonResult ThanhToan(int?sohd)
{
Phong p = db.ChiTietHDs.Find(sohd).PhongThue.Phong;
p.TinhTrang = false;
db.SaveChanges();
return(Json("ok", JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "MaLoaiKhach,TenLoaiKhach")] LoaiKhach loaiKhach)
{
if (ModelState.IsValid)
{
db.LoaiKhaches.Add(loaiKhach);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiKhach));
}
public ActionResult Create([Bind(Include = "MaLoaiPhong,Gia")] LoaiPhong loaiPhong)
{
if (ModelState.IsValid)
{
db.LoaiPhongs.Add(loaiPhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiPhong));
}
public ActionResult Create([Bind(Include = "MaPhong,MaLoaiPhong,TinhTrang,GhiChu")] Phong phong)
{
if (ModelState.IsValid)
{
db.Phongs.Add(phong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaLoaiPhong = new SelectList(db.LoaiPhongs, "MaLoaiPhong", "MaLoaiPhong", phong.MaLoaiPhong);
return(View(phong));
}
public ActionResult Create([Bind(Include = "MaKH,MaLoaiKhach,TenKhach,GioiTinh,CMND,DiaChi")] KhachHang khachHang)
{
if (ModelState.IsValid)
{
db.KhachHangs.Add(khachHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaLoaiKhach = new SelectList(db.LoaiKhaches, "MaLoaiKhach", "MaLoaiKhach", khachHang.MaLoaiKhach);
return(View(khachHang));
}
public ActionResult Create([Bind(Include = "STT,MaThue,HoTen,CMND,MaKH")] ChiTietThue chiTietThue)
{
if (ModelState.IsValid)
{
db.ChiTietThues.Add(chiTietThue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "MaLoaiKhach", chiTietThue.MaKH);
ViewBag.MaThue = new SelectList(db.PhongThues, "MaThue", "MaThue", chiTietThue.MaThue);
return(View(chiTietThue));
}
public ActionResult Create(int makh)
{
if (ModelState.IsValid)
{
HoaDon hd = new HoaDon();
hd.MaKH = makh;
hd.Ngay = DateTime.Now;
db.HoaDons.Add(hd);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public void InsertUpdate()
{
KhachSanContext context = new KhachSanContext();
context.Accounts.AddOrUpdate(this);
context.SaveChanges();
}
public ActionResult DeleteConfirmed(string id)
{
Backup backup = db.BackUps.Find(id);
db.BackUps.Remove(backup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void Delete(int id)
{
KhachSanContext context = new KhachSanContext();
Account ac = context.Accounts.Where(p => p.STT == id).FirstOrDefault();
try
{
context.Accounts.Remove(ac);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public static void Delete(int cmnd)
{
KhachSanContext context = new KhachSanContext();
User u = context.Users.Where(p => p.CMND == cmnd).FirstOrDefault();
try
{
context.Users.Remove(u);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public ActionResult Create([Bind(Include = "MaThue,SoHD,MaPhong,NgayDen,NgayDi,SoLuong")] PhongThue phongThue)
{
if (ModelState.IsValid)
{
ChiTietHD cthd = new ChiTietHD();
int soNgay = cthd.SoNgay(Convert.ToDateTime(phongThue.NgayDen), Convert.ToDateTime(phongThue.NgayDi));
Phong p = db.Phongs.Find(phongThue.MaPhong);
int tien = Convert.ToInt32(db.LoaiPhongs.Find(p.MaLoaiPhong).Gia);
int makhach = Convert.ToInt32(db.HoaDons.Find(phongThue.SoHD).MaKH);
p.TinhTrang = true;
db.PhongThues.Add(phongThue);
cthd.SoNgayO = soNgay;
cthd.MaThue = phongThue.MaThue;
cthd.SoHD = Convert.ToInt32(phongThue.SoHD);
int slKhach = Convert.ToInt32(db.PhongThues.Find(cthd.MaThue).SoLuong);
if (db.KhachHangs.Find(makhach).MaLoaiKhach == "NN")
{
if (slKhach > 2)
{
cthd.Tien = ((tien * 3 / 2) + ((tien * 3 / 2) / 4)) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
else
{
cthd.Tien = (tien * 3 / 2) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
}
else
{
if (slKhach > 2)
{
cthd.Tien = (tien + tien / 4) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
else
{
cthd.Tien = (tien) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
}
return(RedirectToAction("Index", "ChiTietHDs"));
}
ViewBag.SoHD = new SelectList(db.HoaDons, "SoHd", "SoHD", phongThue.SoHD);
ViewBag.MaPhong = new SelectList(db.Phongs, "MaPhong", "MaPhong", phongThue.MaPhong);
return(View(phongThue));
}
