public ActionResult Result(String MAKH, String NGAYVAO, String NGAYRA, string MAPHONG)
{
if (MAKH == null || NGAYVAO == null || NGAYRA == null || MAPHONG == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
PHIEUDATPHONG tgd = new PHIEUDATPHONG();
List <int> ds = JsonConvert.DeserializeObject <List <int> >(MAPHONG);
tgd.MAKH = int.Parse(MAKH);
tgd.TINHTRANGPHIEU = 1;
tgd.NGAYDAT = DateTime.Now;
tgd.NGAYVAO = (DateTime.ParseExact(NGAYVAO, "dd/MM/yyyy", CultureInfo.InvariantCulture)).AddHours(12);
tgd.NGAYRA = (DateTime.ParseExact(NGAYRA, "dd/MM/yyyy", CultureInfo.InvariantCulture)).AddHours(12);
try
{
for (int i = 0; i < ds.Count; i++)
{
tgd.MAPHONG = ds[i];
db.PHIEUDATPHONGs.Add(tgd);
db.SaveChanges();
ViewBag.Result = "success";
}
ViewBag.ngay_vao = tgd.NGAYVAO;
setNull();
}
catch
{
ViewBag.Result = "error";
}
}
return(View());
}
// GET: PhieuDatPhong/Delete/5
public ActionResult XoaPhieuDatPhong(int?id)
{
KHACHHANG kh = new KHACHHANG();
if (Session["KH"] != null)
{
kh = (KHACHHANG)Session["KH"];
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUDATPHONG tblPhieuDatPhong = db.PHIEUDATPHONGs.Find(id);
if (tblPhieuDatPhong == null)
{
return(HttpNotFound());
}
if (tblPhieuDatPhong.MAKH != kh.MAKH)
{
return(RedirectToAction("Index", "Home"));
}
return(View(tblPhieuDatPhong));
}
public ActionResult SuaPhieuDatPhong(int?id)
{
KHACHHANG kh = new KHACHHANG();
if (Session["KH"] != null)
{
kh = (KHACHHANG)Session["KH"];
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUDATPHONG tblPhieuDatPhong = db.PHIEUDATPHONGs.Find(id);
if (tblPhieuDatPhong == null)
{
return(HttpNotFound());
}
if (tblPhieuDatPhong.MAKH != kh.MAKH)
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.ma_kh = new SelectList(db.KHACHHANGs, "EMAIL", "MATKHAU", tblPhieuDatPhong.MAKH);
ViewBag.ma_phong = new SelectList(db.PHONGs, "MAPHONG", "SOPHONG", tblPhieuDatPhong.MAPHONG);
// ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhieuDatPhongs, "ma_tinh_trang", "tinh_trang", tblPhieuDatPhong.ma_tinh_trang);
return(View(tblPhieuDatPhong));
}
public ActionResult ResultDoiPhong(String MAPHIEUDAT, String ma_phong_cu, String ma_phong_moi)
{
if (MAPHIEUDAT == null || ma_phong_cu == null || ma_phong_moi == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
PHIEUDATPHONG pdp = db.PHIEUDATPHONGs.Find(Int32.Parse(MAPHIEUDAT));
PHONG p = db.PHONGs.Find(pdp.PHONG.MAPHONG); // lấy thông tin phòng cũ
p.TINHTRANGPHONG = 1; // set phòng cũ về đang dọn
db.Entry(p).State = EntityState.Modified;
pdp.MAPHONG = Int32.Parse(ma_phong_moi); // đổi phòng cũ sang mới
p = db.PHONGs.Find(Int32.Parse(ma_phong_moi)); // lấy thông tin phòng mới
p.TINHTRANGPHONG = 2; // set phòng mới về đang sd
db.Entry(p).State = EntityState.Modified;
db.Entry(pdp).State = EntityState.Modified;
db.SaveChanges();
@ViewBag.NGAYRA = pdp.NGAYRA;
ViewBag.result = "success";
}
catch (Exception e)
{
ViewBag.result = "error: " + e;
}
return(View());
}
public ActionResult Create(String radSelect, [Bind(Include = "ma_pdp,ma_kh,ngay_dat,ngay_vao,ngay_ra,ma_phong,ma_tinh_trang")] PHIEUDATPHONG tblPhieuDatPhong, [Bind(Include = "hoten,socmt,tuoi,sodt")] KhachHang kh)
{
System.Diagnostics.Debug.WriteLine("SS :" + radSelect);
if (radSelect.Equals("rad2"))
{
tblPhieuDatPhong.MAKH = null;
List <KhachHang> likh = new List <KhachHang>();
likh.Add(kh);
String ttkh = JsonConvert.SerializeObject(likh);
tblPhieuDatPhong.THONGTINKHACHTHUE = ttkh;
}
tblPhieuDatPhong.TINHTRANGPHIEU = 1;
tblPhieuDatPhong.NGAYVAO = DateTime.Now;
tblPhieuDatPhong.NGAYDAT = DateTime.Now;
db.PHIEUDATPHONGs.Add(tblPhieuDatPhong);
db.SaveChanges();
int ma = tblPhieuDatPhong.MAPHIEUDAT;
return(RedirectToAction("Add", "HoaDon", new { id = ma }));
// ViewBag.MAKH = new SelectList(db.KHACHHANGs, "MAKH", "MAKH", PHIEUDATPHONG.MAKH);
// ViewBag.MAPHONG = new SelectList(db.PHONGs, "MAPHONG", "SOPHONG", PHIEUDATPHONG.MAPHONG);
//ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhieuDatPhongs, "ma_tinh_trang", "tinh_trang", tblPhieuDatPhong.ma_tinh_trang);
return(View(tblPhieuDatPhong));
}
public ActionResult GiaHanPhong(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HOADON tblHoaDon = db.HOADONs.Find(id);
if (tblHoaDon == null)
{
return(HttpNotFound());
}
PHIEUDATPHONG pdp = db.PHIEUDATPHONGs.Find(tblHoaDon.MAPHIEUDAT);
String dt = null;
try
{
DateTime d = (DateTime)db.PHIEUDATPHONGs.Where(t => t.TINHTRANGPHIEU == 1 && t.MAPHONG == pdp.PHONG.MAPHONG).Select(t => t.NGAYVAO).OrderBy(t => t.Value).First();
dt = d.ToString();
}
catch
{
}
ViewBag.dateMax = dt;
return(View(pdp));
}
public ActionResult ConfirmXoaPhieuDatPhong(int id)
{
PHIEUDATPHONG tblPhieuDatPhong = db.PHIEUDATPHONGs.Find(id);
tblPhieuDatPhong.TINHTRANGPHIEU = 3;
db.Entry(tblPhieuDatPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("BookRoom", "Home"));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
PHIEUDATPHONG tblPhieuDatPhong = db.PHIEUDATPHONGs.Find(id);
db.PHIEUDATPHONGs.Remove(tblPhieuDatPhong);
db.SaveChanges();
}
catch
{
}
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ma_pdp,ma_kh,ngay_dat,ngay_vao,ngay_ra,ma_phong,ma_tinh_trang")] PHIEUDATPHONG tblPhieuDatPhong)
{
if (ModelState.IsValid)
{
db.Entry(tblPhieuDatPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ma_kh = new SelectList(db.KHACHHANGs, "MAKH", "MATKHAU", tblPhieuDatPhong.MAKH);
ViewBag.ma_phong = new SelectList(db.PHONGs, "MAPHONG", "SOPHONG", tblPhieuDatPhong.MAPHONG);
//ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhieuDatPhongs, "ma_tinh_trang", "tinh_trang", tblPhieuDatPhong.ma_tinh_trang);
return(View(tblPhieuDatPhong));
}
public ActionResult SuaPhieuDatPhong([Bind(Include = "ma_pdp,ma_kh,ngay_dat,ngay_vao,ngay_ra,ma_phong,ma_tinh_trang")] PHIEUDATPHONG tblPhieuDatPhong)
{
if (ModelState.IsValid)
{
tblPhieuDatPhong.TINHTRANGPHIEU = 1;
db.Entry(tblPhieuDatPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("BookRoom", "Home"));
}
ViewBag.ma_kh = new SelectList(db.KHACHHANGs, "ma_kh", "mat_khau", tblPhieuDatPhong.MAKH);
ViewBag.ma_phong = new SelectList(db.PHONGs, "ma_phong", "so_phong", tblPhieuDatPhong.MAPHONG);
//ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhieuDatPhongs, "ma_tinh_trang", "tinh_trang", tblPhieuDatPhong.ma_tinh_trang);
return(RedirectToAction("BookRoom", "Home"));
}
// GET: PhieuDatPhong/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUDATPHONG tblPhieuDatPhong = db.PHIEUDATPHONGs.Find(id);
if (tblPhieuDatPhong == null)
{
return(HttpNotFound());
}
return(View(tblPhieuDatPhong));
}
// GET: PhieuDatPhong/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUDATPHONG tblPhieuDatPhong = db.PHIEUDATPHONGs.Find(id);
if (tblPhieuDatPhong == null)
{
return(HttpNotFound());
}
ViewBag.ma_kh = new SelectList(db.KHACHHANGs, "MAKH", "MATKHAU", tblPhieuDatPhong.MAKH);
ViewBag.ma_phong = new SelectList(db.PHONGs, "MAPHONG", "SOPHONG", tblPhieuDatPhong.MAPHONG);
//ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhieuDatPhongs, "ma_tinh_trang", "tinh_trang", tblPhieuDatPhong.ma_tinh_trang);
return(View(tblPhieuDatPhong));
}
public ActionResult DoiPhong(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HOADON tblHoaDon = db.HOADONs.Find(id);
if (tblHoaDon == null)
{
return(HttpNotFound());
}
PHIEUDATPHONG pdp = db.PHIEUDATPHONGs.Find(tblHoaDon.MAPHIEUDAT);
var li = db.PHONGs.Where(t => t.TINHTRANGPHONG == 1 && !(db.PHIEUDATPHONGs.Where(m => (m.TINHTRANGPHIEU == 1 || m.TINHTRANGPHIEU == 2) && m.NGAYRA > DateTime.Now && m.NGAYVAO < pdp.NGAYRA)).Select(m => m.MAPHONG).ToList().Contains(t.MAPHONG));
ViewBag.ma_phong_moi = new SelectList(li, "MAPHONG", "SOPHONG");
return(View(pdp));
}
public ActionResult ResultGiaHan(String MAPHIEUDAT, String NGAYRA)
{
if (MAPHIEUDAT == null || NGAYRA == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
PHIEUDATPHONG pdp = db.PHIEUDATPHONGs.Find(Int32.Parse(MAPHIEUDAT));
DateTime ngayra = DateTime.Parse(NGAYRA);
pdp.NGAYRA = ngayra;
ViewBag.result = "success";
ViewBag.NGAYRA = NGAYRA;
}
catch (Exception e)
{
ViewBag.result = "error: " + e;
}
return(View());
}
/// <summary>
/// ///////////////////
/// <returns></returns>
///
public ActionResult XacNhanThanhToan(String MAHD, String TIENPHONG, String TIENDICHVU, String PHUTHU, String TONGTIEN)
{
if (MAHD == null || TIENPHONG == null || TIENDICHVU == null || PHUTHU == null || TONGTIEN == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
HOADON hd = db.HOADONs.Find(Int32.Parse(MAHD));
NHANVIEN nv = (NHANVIEN)Session["NV"];
if (nv != null)
{
hd.MANV = nv.MANV;
}
hd.TIENPHONG = int.Parse(TIENPHONG);
hd.TIENDICHVU = int.Parse(TIENDICHVU);
hd.PHUTHU = int.Parse(PHUTHU);
hd.TONGTIEN = int.Parse(TONGTIEN);
hd.TINHTRANGHD = 2;
hd.NGAYTRAPHONG = DateTime.Now;
db.Entry(hd).State = EntityState.Modified;
PHONG p = db.PHONGs.Find(hd.PHIEUDATPHONG.MAPHONG);
p.TINHTRANGPHONG = 1;
PHIEUDATPHONG pd = db.PHIEUDATPHONGs.Find(hd.PHIEUDATPHONG.MAPHIEUDAT);
pd.TINHTRANGPHIEU = 4;
db.Entry(p).State = EntityState.Modified;
db.Entry(pd).State = EntityState.Modified;
db.SaveChanges();
ViewBag.result = "success";
}
catch
{
ViewBag.result = "error";
}
ViewBag.MAHD = MAHD;
return(View());
}
public ActionResult Result(String MAPHIEUDAT /*, String hoten1, String hoten2, String hoten3, String hoten4, String tuoi1, String tuoi2, String tuoi3, String tuoi4*/)
{
if (MAPHIEUDAT == null)
{
return(RedirectToAction("Index", "Index"));
}
else
{
//List<KhachHang> likh;
PHIEUDATPHONG pt = db.PHIEUDATPHONGs.Find(Int32.Parse(MAPHIEUDAT));
//if (pt.THONGTINKHACHTHUE == null)
//{
// likh = new List<KhachHang>();
// likh.Add(new KhachHang("", ""));
//}
//else
//{
// likh = JsonConvert.DeserializeObject<List<KhachHang>>(pt.THONGTINKHACHTHUE);
//}
//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.THONGTINKHACHTHUE = JsonConvert.SerializeObject(likh);
//db.Entry(pt).State = EntityState.Modified;
//db.SaveChanges();
HOADON hd = new HOADON();
hd.MAPHIEUDAT = Int32.Parse(MAPHIEUDAT);
hd.TINHTRANGHD = 1;
try
{
db.HOADONs.Add(hd);
PHIEUDATPHONG tgd = db.PHIEUDATPHONGs.Find(Int32.Parse(MAPHIEUDAT));
if (tgd == null)
{
return(HttpNotFound());
}
PHONG p = db.PHONGs.Find(tgd.MAPHONG);
if (p == null)
{
return(HttpNotFound());
}
tgd.TINHTRANGPHIEU = 2;
db.Entry(tgd).State = EntityState.Modified;
p.TINHTRANGPHONG = 2;
db.Entry(p).State = EntityState.Modified;
ViewBag.NGAYRA = tgd.NGAYRA;
db.SaveChanges();
ViewBag.Result = "success";
}
catch
{
ViewBag.Result = "error";
}
}
return(View());
}
