public ActionResult BookRoom()
{
if (Session["KH"] == null)
{
return(RedirectToAction("Login", "KhachHang"));
}
tblKhachHang kh = (tblKhachHang)Session["KH"];
ViewBag.ma_kh = kh.ma_kh;
ViewBag.ten_kh = kh.ho_ten;
ViewBag.ngay_dat = DateTime.Now;
ViewBag.ngay_vao = (String)Session["ngay_vao"];
ViewBag.ngay_ra = (String)Session["ngay_ra"];
if (Session["ma_phong"] != null)
{
ViewBag.ma_phong = (String)Session["ma_phong"];
int map = Int32.Parse((String)Session["ma_phong"]);
tblPhong p = (tblPhong)db.tblPhongs.Find(map);
ViewBag.so_phong = p.so_phong;
}
var liP = db.tblPhieuDatPhongs.Where(u => u.ma_kh == kh.ma_kh && u.ma_tinh_trang == 1).ToList();
return(View(liP));
}
public ActionResult ResultDoiPhong(String ma_pdp, String ma_phong_cu, String ma_phong_moi)
{
if (ma_pdp == null || ma_phong_cu == null || ma_phong_moi == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
tblPhieuDatPhong pdp = db.tblPhieuDatPhongs.Find(Int32.Parse(ma_pdp));
tblPhong p = db.tblPhongs.Find(pdp.tblPhong.ma_phong); // lấy thông tin phòng cũ
p.ma_tinh_trang = 3; // set phòng cũ về đang dọn
db.Entry(p).State = EntityState.Modified;
pdp.ma_phong = Int32.Parse(ma_phong_moi); // đổi phòng cũ sang mới
p = db.tblPhongs.Find(Int32.Parse(ma_phong_moi)); // lấy thông tin phòng mới
p.ma_tinh_trang = 2; // set phòng mới về đang sd
db.Entry(p).State = EntityState.Modified;
db.Entry(pdp).State = EntityState.Modified;
db.SaveChanges();
ViewBag.result = "success";
}
catch (Exception e)
{
ViewBag.result = "error: " + e;
}
return(View());
}
public JsonResult SaveDataRoom(LevelRoomViewModel model)
{
bool status = false;
string message = string.Empty;
tblLoaiPhong modelLoaiPhong = db.tblLoaiPhongs.Where(x => x.mo_ta == model.Type).SingleOrDefault();
tblTang modelTang = db.tblTangs.Where(x => x.ten_tang == model.Level).SingleOrDefault();
tblPhong phong = new tblPhong();
phong.ma_phong = model.ID;
phong.so_phong = model.Name;
phong.loai_phong = modelLoaiPhong.loai_phong;
phong.ma_tang = modelTang.ma_tang;
phong.ma_tinh_trang = 1;
if (model.ID == 0)
{
db.tblPhongs.Add(phong);
try
{
db.SaveChanges();
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
else
{
//Đang cập nhật dữ liệu
var entity = db.tblPhongs.Find(model.ID);
entity.so_phong = model.Name;
entity.ma_tang = modelTang.ma_tang;
entity.loai_phong = modelLoaiPhong.loai_phong;
//entity.CreatedDate = DateTime.Now;
try
{
db.SaveChanges();
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
return(Json(new
{
status = status,
message = message
}));
}
public ActionResult Slider(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPhong p = db.tblPhongs.Include(a => a.tblLoaiPhong).Where(a => a.ma_phong == id).First();
return(View(p));
}
public ActionResult DonPhongXong(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPhong p = db.tblPhongs.Where(u => u.ma_phong == id).First();
p.ma_tinh_trang = 1;
db.Entry(p).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Index"));
}
public ActionResult Edit([Bind(Include = "ma_phong,so_phong,loai_phong,ma_tang,ma_tinh_trang")] tblPhong tblPhong)
{
if (ModelState.IsValid)
{
db.Entry(tblPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.loai_phong = new SelectList(db.tblLoaiPhongs, "loai_phong", "mo_ta", tblPhong.loai_phong);
ViewBag.ma_tang = new SelectList(db.tblTangs, "ma_tang", "ten_tang", tblPhong.ma_tang);
ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhongs, "ma_tinh_trang", "mo_ta", tblPhong.ma_tinh_trang);
return(View(tblPhong));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
tblPhong tblPhong = db.tblPhongs.Find(id);
db.tblPhongs.Remove(tblPhong);
db.SaveChanges();
}
catch
{
}
return(RedirectToAction("Index"));
}
// GET: Phong/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPhong tblPhong = db.tblPhongs.Find(id);
if (tblPhong == null)
{
return(HttpNotFound());
}
return(View(tblPhong));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
tblPhong tblPhong = db.tblPhongs.Find(id);
tblPhong.ma_tinh_trang = 5;
db.Entry(tblPhong).State = EntityState.Modified;
db.SaveChanges();
}
catch
{
}
return(RedirectToAction("Index"));
}
// GET: Phong/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPhong tblPhong = db.tblPhongs.Find(id);
if (tblPhong == null)
{
return(HttpNotFound());
}
ViewBag.loai_phong = new SelectList(db.tblLoaiPhongs, "loai_phong", "mo_ta", tblPhong.loai_phong);
ViewBag.ma_tang = new SelectList(db.tblTangs, "ma_tang", "ten_tang", tblPhong.ma_tang);
ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangPhongs, "ma_tinh_trang", "mo_ta", tblPhong.ma_tinh_trang);
return(View(tblPhong));
}
public ActionResult XacNhanThanhToan(string ma_hd, string tien_phong, string tien_dich_vu, string phu_thu, string tong_tien)
{
if (ma_hd == null || tien_phong == null || tien_dich_vu == null || phu_thu == null || tong_tien == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
tblHoaDon hd = db.tblHoaDons.Find(Int32.Parse(ma_hd));
tblNhanVien nv = (tblNhanVien)Session["NhanVien"];
if (nv != null)
{
hd.ma_nv = nv.ma_nv;
}
hd.tien_phong = Double.Parse(tien_phong);
hd.tien_dich_vu = Double.Parse(tien_dich_vu);
hd.phu_thu = Double.Parse(phu_thu);
hd.tong_tien = Double.Parse(tong_tien);
hd.ma_tinh_trang = 2;
hd.ngay_tra_phong = DateTime.Now;
db.Entry(hd).State = EntityState.Modified;
tblPhong p = db.tblPhongs.Find(hd.tblPhieuDatPhong.ma_phong);
p.ma_tinh_trang = 3;
tblPhieuDatPhong pd = db.tblPhieuDatPhongs.Find(hd.tblPhieuDatPhong.ma_pdp);
pd.ma_tinh_trang = 4;
db.Entry(p).State = EntityState.Modified;
db.Entry(pd).State = EntityState.Modified;
db.SaveChanges();
ViewBag.result = "success";
}
catch
{
ViewBag.result = "error";
}
ViewBag.ma_hd = ma_hd;
return(View());
}
public ActionResult BookRoom()
{
if (Session["KH"] == null)
{
return(RedirectToAction("Login", "Account"));
}
AutoHuyPhieuDatPhong();
tblKhachHang kh = (tblKhachHang)Session["KH"];
ViewBag.ma_kh = kh.ma_kh;
ViewBag.ten_dang_nhap = kh.ten_dang_nhap;
ViewBag.ten_kh = kh.ho_ten;
ViewBag.ngay_dat = DateTime.Now;
ViewBag.ngay_vao = (String)Session["ngay_vao"];
ViewBag.ngay_ra = (String)Session["ngay_ra"];
//if (Session["ma_phong"] != null)
//{
// ViewBag.ma_phong = (String)Session["ma_phong"];
// int map = Int32.Parse((String)Session["ma_phong"]);
// tblPhong p = (tblPhong)db.tblPhongs.Find(map);
// ViewBag.so_phong = p.so_phong;
//}
String sp = "";
List <int> ds;
ds = (List <int>)Session["ds_ma_phong"];
if (ds == null)
{
ds = new List <int>();
}
ViewBag.ma_phong = JsonConvert.SerializeObject(ds);
foreach (var item in ds)
{
tblPhong p = (tblPhong)db.tblPhongs.Find(Int32.Parse(item.ToString()));
sp += p.so_phong.ToString() + ", ";
}
ViewBag.so_phong = sp;
var liP = db.tblPhieuDatPhongs.Where(u => u.ma_kh == kh.ma_kh && u.ma_tinh_trang == 1).ToList();
return(View(liP));
}
public ActionResult GoiDichVu(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPhong phong = new tblPhong();
phong = db.tblPhongs.Find(id);
tblPhieuDatPhong phieudatphong = new tblPhieuDatPhong();
phieudatphong = db.tblPhieuDatPhongs.Where(x => x.ma_phong == phong.ma_phong && x.ma_tinh_trang == 2 && phong.ma_tinh_trang == 2).FirstOrDefault();
tblHoaDon hoadon = new tblHoaDon();
hoadon = db.tblHoaDons.Where(x => x.ma_pdp == phieudatphong.ma_pdp && phieudatphong.ma_tinh_trang == 2 && x.ma_tinh_trang == 1).SingleOrDefault();
//int ma_hd = db.tblHoaDons.Where(x => x.ma_phong == id && u.ma_tinh_trang == 2).First().ma_hd;
return(RedirectToAction("GoiDichVu", "HoaDon", new { id = hoadon.ma_hd }));
}
public ActionResult Result(String ma_tgd)
{
if (ma_tgd == null)
{
return(RedirectToAction("Index", "Admin"));
}
else
{
tblHoaDon hd = new tblHoaDon();
hd.ma_tgd = Int32.Parse(ma_tgd);
hd.ma_tinh_trang = 1;
try
{
db.tblHoaDons.Add(hd);
tblPhieuDatPhong tgd = db.tblPhieuDatPhongs.Find(Int32.Parse(ma_tgd));
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());
}
public ActionResult Result(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", "Index"));
}
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());
}
