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)); }