public ActionResult Edit([Bind(Include = "ma_kh,mat_khau,ho_ten,cmt,sdt,mail,diem")] tblKhachHang tblKhachHang)
{
if (ModelState.IsValid)
{
db.Entry(tblKhachHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblKhachHang));
}
public ActionResult CaNhan([Bind(Include = "ma_nv,ho_ten,ngay_sinh,dia_chi,sdt,tai_khoan,mat_khau,ma_chuc_vu")] tblNhanVien tblNhanVien)
{
if (ModelState.IsValid)
{
db.Entry(tblNhanVien).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("/"));
}
ViewBag.ma_chuc_vu = new SelectList(db.tblChucVus, "ma_chuc_vu", "chuc_vu", tblNhanVien.ma_chuc_vu);
return(View(tblNhanVien));
}
public ActionResult Edit([Bind(Include = "MADV,TENDV,GIADV")] DICHVU dICHVU)
{
if (ModelState.IsValid)
{
db.Entry(dICHVU).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dICHVU));
}
public ActionResult Edit([Bind(Include = "SOPHONG,LOAIPHONG,GIAPHONG")] PHONG pHONG)
{
if (ModelState.IsValid)
{
db.Entry(pHONG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pHONG));
}
public ActionResult Edit([Bind(Include = "MANV,HOTEN,NGAYSINH,CMND_NV,DIACHI,roleID,username")] NHANVIEN nHANVIEN)
{
if (ModelState.IsValid)
{
db.Entry(nHANVIEN).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.roleID = new SelectList(db.Ref_Role, "roleID", "roleName", nHANVIEN.roleID);
return(View(nHANVIEN));
}
public ActionResult Edit([Bind(Include = "MAHD,NGAY,TONGTIEN,MADK")] HOADON hOADON)
{
if (ModelState.IsValid)
{
db.Entry(hOADON).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MADK = new SelectList(db.PHONGTHUEs, "MADK", "MAKH", hOADON.MADK);
return(View(hOADON));
}
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));
}
private void AutoHuyPhieuDatPhong()
{
var datenow = DateTime.Now;
var tblPhieuDatPhongs = db.tblPhieuDatPhongs.Where(u => u.ma_tinh_trang == 1).Include(t => t.tblKhachHang).Include(t => t.tblPhong).Include(t => t.tblTinhTrangPhieuDatPhong).ToList();
foreach (var item in tblPhieuDatPhongs)
{
System.Diagnostics.Debug.WriteLine((item.ngay_vao - datenow).Value.Days);
if ((item.ngay_vao - datenow).Value.Days < 0)
{
item.ma_tinh_trang = 3;
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public void Update(T entity)
{
dbSet.Attach(entity);
_dbContext.Entry(entity).State = EntityState.Modified;
_dbContext.SaveChanges();
}
public ActionResult TaoHoaDon(string ma_pdp, string hoten1, string hoten2, string hoten3, string hoten4, string tuoi1, string tuoi2, string tuoi3, string tuoi4)
{
if (ma_pdp == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
List <KhachHang> likh;
tblPhieuDatPhong pt = db.tblPhieuDatPhongs.Find(Int32.Parse(ma_pdp));
if (pt.thong_tin_khach_thue == null)
{
likh = new List <KhachHang>();
likh.Add(new KhachHang("", ""));
}
else
{
likh = JsonConvert.DeserializeObject <List <KhachHang> >(pt.thong_tin_khach_thue);
}
if (!hoten1.Equals(""))
{
likh.Add(new KhachHang(hoten1, tuoi1));
}
if (!hoten2.Equals(""))
{
likh.Add(new KhachHang(hoten2, tuoi2));
}
if (!hoten3.Equals(""))
{
likh.Add(new KhachHang(hoten3, tuoi3));
}
if (!hoten4.Equals(""))
{
likh.Add(new KhachHang(hoten4, tuoi4));
}
pt.thong_tin_khach_thue = JsonConvert.SerializeObject(likh);
db.Entry(pt).State = EntityState.Modified;
db.SaveChanges();
tblHoaDon hd = new tblHoaDon();
hd.ma_pdp = Int32.Parse(ma_pdp);
hd.ma_tinh_trang = 1;
try
{
db.tblHoaDons.Add(hd);
tblPhieuDatPhong tgd = db.tblPhieuDatPhongs.Find(Int32.Parse(ma_pdp));
if (tgd == null)
{
return(HttpNotFound());
}
tblPhong p = db.tblPhongs.Find(tgd.ma_phong);
if (p == null)
{
return(HttpNotFound());
}
tgd.ma_tinh_trang = 2;
db.Entry(tgd).State = EntityState.Modified;
p.ma_tinh_trang = 2;
db.Entry(p).State = EntityState.Modified;
ViewBag.ngay_ra = tgd.ngay_ra;
db.SaveChanges();
ViewBag.Result = "success";
}
catch
{
ViewBag.Result = "error";
}
}
return(View());
}