// GET: /Tuyenong/Delete/5 public ActionResult Delete(int?id) { Tuyenong tuyenOng = db.Tuyenongs.Find(id); tuyenOng.IsDelete = true; db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Lấy tên cấp tuyến ống /// </summary> /// <param name="tuyenOngID"></param> /// <returns></returns> public static int getCapTuyenOng(int?tuyenOngID) { Tuyenong tuyenOngCha = db.Tuyenongs.Where(p => p.TuyenongID == tuyenOngID).FirstOrDefault(); if (tuyenOngCha != null) { return(tuyenOngCha.CaptuyenID.Value); } return(0); }
public static String getTenTuyenOng(int?tuyenOngID) { Tuyenong tuyenOngCha = db.Tuyenongs.Where(p => p.TuyenongID == tuyenOngID).FirstOrDefault(); if (tuyenOngCha != null) { return(tuyenOngCha.Tentuyen); } return(""); }
// GET: /Tuyenong/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tuyenong tuyenong = db.Tuyenongs.Find(id); if (tuyenong == null) { return(HttpNotFound()); } return(View(tuyenong)); }
public ActionResult Edit([Bind(Include = "TuyenongID,TuyenongPID,CaptuyenID,Matuyen,Tentuyen,QuanHuyenID,PhuongxaID,IsDelete")] Tuyenong tuyenong) { if (ModelState.IsValid) { db.Entry(tuyenong).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag._QuanHuyen = new SelectList(db.Quanhuyens.Where(p => p.IsDelete == false || p.IsDelete == null), "QuanhuyenID", "Ten", tuyenong.QuanHuyenID); ViewBag._Phuongxa = new SelectList(db.Phuongxas.Where(p => p.IsDelete == false || p.IsDelete == null), "PhuongxaID", "Ten", tuyenong.PhuongxaID); ViewBag.selectedPID = tuyenong.TuyenongPID; ViewBag._parentID = db.Tuyenongs.Where(p => p.IsDelete == false).ToList(); ViewBag._CaptuyenID = new SelectList(db.Captuyens, "CaptuyenID", "Ten", tuyenong.CaptuyenID); return(View(tuyenong)); }
// GET: /Tuyenong/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tuyenong tuyenong = db.Tuyenongs.Find(id); if (tuyenong == null) { return(HttpNotFound()); } ViewBag._QuanHuyen = db.Quanhuyens.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); ViewBag._selectedQuanHuyen = tuyenong.QuanHuyenID; ViewBag._Phuongxa = db.Phuongxas.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); ViewBag._selectedPhuongXa = tuyenong.PhuongxaID; ViewBag._parentID = db.Tuyenongs.Where(p => p.IsDelete == false).ToList(); ViewBag.selectedPID = tuyenong.TuyenongPID; ViewBag.CaptuyenID = new SelectList(db.Captuyens, "CaptuyenID", "Ten", tuyenong.CaptuyenID); return(View(tuyenong)); }
public ActionResult Create([Bind(Include = "TuyenongID,TuyenongPID,CaptuyenID,Matuyen,Tentuyen,QuanHuyenID,PhuongxaID,IsDelete")] Tuyenong tuyenong) { if (ModelState.IsValid) { Tuyenong firstPlumber = db.Tuyenongs.FirstOrDefault(p => p.Tentuyen == tuyenong.Tentuyen && p.Matuyen == tuyenong.Matuyen); if (firstPlumber == null) { db.Tuyenongs.Add(tuyenong); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.duplicate = true; } } ViewBag.QuanHuyen = db.Quanhuyens.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); ViewBag.Phuongxa = db.Phuongxas.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); ViewBag.parentID = db.Tuyenongs.Where(p => p.IsDelete == false).ToList(); ViewBag.CaptuyenID = new SelectList(db.Captuyens, "CaptuyenID", "Ten", tuyenong.CaptuyenID); return(View(tuyenong)); }