public IActionResult Delete(Guid id) { MaterialDesignViewModel mDesignVm = new MaterialDesignViewModel(); using (MaterialDesignDBContext db = new MaterialDesignDBContext()) { using (var dbB = new BridgeDBContext()) { BridgeViewModel bridgeVm = new BridgeViewModel(); bridgeVm.BridgeList = dbB.Bridges.ToList(); bridgeVm.NewBridge = dbB.Bridges.Where( md => md.MaterialDesignId == id).FirstOrDefault(); if (bridgeVm.NewBridge == null) { mDesignVm.NewMaterialDesign = new MaterialDesign(); //find id in database mDesignVm.NewMaterialDesign.MaterialDesignId = Guid.Parse(RouteData.Values["id"].ToString()); //update recode state db.Entry(mDesignVm.NewMaterialDesign).State = EntityState.Deleted; db.SaveChanges(); TempData["ResultMessage"] = "Material Design deleted"; } else { TempData["ResultMessage"] = "This Material Design has dependencies, cannot delete!"; } } } return(RedirectToAction("Index")); }
public IActionResult Edit(MaterialDesignViewModel obj) { //check for valid model if (ModelState.IsValid) { using (MaterialDesignDBContext db = new MaterialDesignDBContext()) { //object for view model MaterialDesign md = obj.NewMaterialDesign; //retrieve primary key/id from route data md.MaterialDesignId = Guid.Parse(RouteData.Values["id"].ToString()); //update record status db.Entry(md).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); }