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 ActionResult Edit([Bind(Include = "ma_tang,ten_tang")] tblTang tblTang)
{
if (ModelState.IsValid)
{
db.Entry(tblTang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblTang));
}
public ActionResult Create([Bind(Include = "ma_tang,ten_tang")] tblTang tblTang)
{
if (ModelState.IsValid)
{
db.tblTangs.Add(tblTang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblTang));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
tblTang tblTang = db.tblTangs.Find(id);
db.tblTangs.Remove(tblTang);
db.SaveChanges();
}
catch
{
}
return(RedirectToAction("Index"));
}
public JsonResult SaveDataLevel(LevelRoomViewModel model)
{
bool status = false;
string message = string.Empty;
tblTang tang = new tblTang();
tang.ma_tang = model.ID;
tang.ten_tang = model.Name;
if (model.ID == 0)
{
db.tblTangs.Add(tang);
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.tblTangs.Find(model.ID);
entity.ten_tang = model.Name;
//entity.CreatedDate = DateTime.Now;
try
{
db.SaveChanges();
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
return(Json(new
{
status = status,
message = message
}));
}
// GET: Tang/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblTang tblTang = db.tblTangs.Find(id);
if (tblTang == null)
{
return(HttpNotFound());
}
return(View(tblTang));
}
