public IActionResult Delete(Guid id) { ConstructionDesignViewModel cDesignVm = new ConstructionDesignViewModel(); using (ConstructionDesignDBContext db = new ConstructionDesignDBContext()) { using (var dbB = new BridgeDBContext()) { BridgeViewModel bridgeVm = new BridgeViewModel(); bridgeVm.BridgeList = dbB.Bridges.ToList(); bridgeVm.NewBridge = dbB.Bridges.Where( cd => cd.ConstructionDesignId == id).FirstOrDefault(); if (bridgeVm.NewBridge == null) { cDesignVm.NewConstructionDesign = new ConstructionDesign(); //retrieve info from route data cDesignVm.NewConstructionDesign.ConstructionDesignId = Guid.Parse(RouteData.Values["id"].ToString()); //update record state db.Entry(cDesignVm.NewConstructionDesign).State = EntityState.Deleted; db.SaveChanges(); TempData["ResultMessage"] = "Construction Design deleted"; } else { TempData["ResultMessage"] = "This Construction Design has dependencies, cannot delete!"; } } } return(RedirectToAction("Index")); }
public IActionResult Index(ConstructionDesignViewModel constructionDesignVM) { using (var db = new ConstructionDesignDBContext()) { db.ConstructionDesigns.Add(constructionDesignVM.NewConstructionDesign); db.SaveChanges(); return(RedirectToAction("Index")); } }
// GET: /<controller>/ public IActionResult Index() { ConstructionDesignViewModel constructionDesignVM = new ConstructionDesignViewModel(); using (var db = new ConstructionDesignDBContext()) { constructionDesignVM.ConstructionDesignList = db.ConstructionDesigns.ToList(); constructionDesignVM.NewConstructionDesign = new ConstructionDesign(); } return(View(constructionDesignVM)); }
//Get Fill Form public IActionResult Edit(Guid id) { ConstructionDesignViewModel cDesignVM = new ConstructionDesignViewModel(); using (ConstructionDesignDBContext db = new ConstructionDesignDBContext()) { //find id passed location in database cDesignVM.NewConstructionDesign = db.ConstructionDesigns.Where( e => e.ConstructionDesignId == id).SingleOrDefault(); //return view model return(View(cDesignVM)); } }
public IActionResult Edit(ConstructionDesignViewModel obj) { //check for valid model if (ModelState.IsValid) { using (ConstructionDesignDBContext db = new ConstructionDesignDBContext()) { //instantiate object from view model ConstructionDesign c = obj.NewConstructionDesign; //retrieve primary key/id from route data c.ConstructionDesignId = Guid.Parse(RouteData.Values["id"].ToString()); //update record status db.Entry(c).State = EntityState.Modified; //persist changes db.SaveChanges(); } } return(RedirectToAction("Index")); }
private static List <SelectListItem> GetConstructionDesignsDDL() { List <SelectListItem> cDesign = new List <SelectListItem>(); ConstructionDesignViewModel cdvm = new ConstructionDesignViewModel(); using (var db = new ConstructionDesignDBContext()) { cdvm.ConstructionDesignList = db.ConstructionDesigns.ToList(); } foreach (ConstructionDesign c in cdvm.ConstructionDesignList) { cDesign.Add(new SelectListItem { Text = c.ConstructionDesignType, Value = c.ConstructionDesignId.ToString() }); } return(cDesign); }