public JsonResult GetDetailRoom(int id)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
var room = db.tblPhongs.Find(id);
tblLoaiPhong modelLoaiPhong = db.tblLoaiPhongs.Where(x => x.loai_phong == room.loai_phong).SingleOrDefault();
tblTang modelTang = db.tblTangs.Where(x => x.ma_tang == room.ma_tang).SingleOrDefault();
LevelRoomViewModel roomViewModel = new LevelRoomViewModel();
roomViewModel.ID = room.ma_phong;
roomViewModel.Name = room.so_phong;
roomViewModel.Level = modelTang.ten_tang;
roomViewModel.Type = modelLoaiPhong.mo_ta;
return(Json(new
{
data = roomViewModel,
status = true
}, JsonRequestBehavior.AllowGet));
}
catch (Exception error)
{
return(Json(new { status = false, message = error.ToString() }, JsonRequestBehavior.AllowGet));
}
}
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 JsonResult SaveDataTypeRoom(TypeRoomViewModel roomType)
{
bool status = false;
string message = string.Empty;
tblLoaiPhong loaiPhong = new tblLoaiPhong();
loaiPhong.loai_phong = roomType.ID;
loaiPhong.gia = roomType.Price;
loaiPhong.ti_le_phu_thu = roomType.Percent;
loaiPhong.mo_ta = roomType.TypeRoom;
loaiPhong.anh = roomType.Image;
if (roomType.ID == 0)
{
//Thêm mới
db.tblLoaiPhongs.Add(loaiPhong);
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.tblLoaiPhongs.Find(roomType.ID);
entity.mo_ta = roomType.TypeRoom;
entity.gia = roomType.Price;
entity.ti_le_phu_thu = roomType.Percent;
//entity.trang_thai = service.Status;
entity.anh = roomType.Image;
//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();
tblLoaiPhong lp = db.tblLoaiPhongs.Find(id);
return(View(lp));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
tblLoaiPhong tblLoaiPhong = db.tblLoaiPhongs.Find(id);
db.tblLoaiPhongs.Remove(tblLoaiPhong);
db.SaveChanges();
}
catch
{
}
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "loai_phong,mo_ta,gia,anh")] tblLoaiPhong tblLoaiPhong)
{
if (ModelState.IsValid)
{
if (tblLoaiPhong.anh == null)
{
tblLoaiPhong.anh = "[\"/Content/Images/Phong/default.png\"]";
}
db.Entry(tblLoaiPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblLoaiPhong));
}
// GET: LoaiPhong/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblLoaiPhong tblLoaiPhong = db.tblLoaiPhongs.Find(id);
if (tblLoaiPhong == null)
{
return(HttpNotFound());
}
return(View(tblLoaiPhong));
}
public ActionResult Create([Bind(Include = "mo_ta,gia,anh")] tblLoaiPhong tblLoaiPhong)
{
if (ModelState.IsValid)
{
if (tblLoaiPhong.anh == null)
{
tblLoaiPhong.anh = "[\"/Content/Images/Phong/default.png\"]";
}
db.tblLoaiPhongs.Add(tblLoaiPhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblLoaiPhong));
}
