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