public IActionResult Delete(Guid id) { BridgeViewModel bridgeVm = new BridgeViewModel(); using (BridgeDBContext db = new BridgeDBContext()) { using (var dbI = new InspectionDBContext()) { InspectionViewModel inspectVm = new InspectionViewModel(); inspectVm.InspectionList = dbI.Inspections.ToList(); inspectVm.NewInspection = dbI.Inspections.Where( i => i.BridgeId == id).FirstOrDefault(); //create an instance of the view model if (inspectVm.NewInspection == null) { bridgeVm.NewBridge = new Bridge(); //retrieve info from route data bridgeVm.NewBridge.Bridgeid = Guid.Parse(RouteData.Values["id"].ToString()); //update recode state db.Entry(bridgeVm.NewBridge).State = EntityState.Deleted; db.SaveChanges(); TempData["ResultMessage"] = "Bridge Record Deleted"; } else { TempData["ResultMessage"] = "This Bridge Record has Dependencies. This Record cannot be Deleted!"; } } } return(RedirectToAction("Index")); }
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")); }
//GET Fill Form public IActionResult Edit(Guid id) { //create an instance of the view model BridgeViewModel bridgeVM = new BridgeViewModel(); using (BridgeDBContext db = new BridgeDBContext()) { //find id passed in location in the database bridgeVM.NewBridge = db.Bridges.Where( e => e.Bridgeid == id).SingleOrDefault(); //fill Material Designs drop down bridgeVM.MaterialDesigns = GetMaterialDesignsDDL(); //fill Construction Designs drop down bridgeVM.ConstructionDesigns = GetConstructionDesignsDDL(); //fill Functional Classes drop down bridgeVM.FunctionalClasses = GetFunctionalClassesDDL(); //fill Status Codes drop down bridgeVM.StatusCodes = GetStatusCodesDDL(); //fill Counties drop down bridgeVM.Counties = GetCountiesDDL(); //return the view model return(View(bridgeVM)); } }
public IActionResult Delete(Guid id) { FunctionalClassViewModel fClassVm = new FunctionalClassViewModel(); using (FunctionalClassDBContext db = new FunctionalClassDBContext()) { using (var dbB = new BridgeDBContext()) { BridgeViewModel bridgeVm = new BridgeViewModel(); bridgeVm.BridgeList = dbB.Bridges.ToList(); bridgeVm.NewBridge = dbB.Bridges.Where( fc => fc.FunctionalClassId == id).FirstOrDefault(); if (bridgeVm.NewBridge == null) { fClassVm.NewFunctionalClass = new FunctionalClass(); //retrieve info from route data fClassVm.NewFunctionalClass.FunctionalClassId = Guid.Parse(RouteData.Values["id"].ToString()); //update record status db.Entry(fClassVm.NewFunctionalClass).State = EntityState.Deleted; db.SaveChanges(); TempData["ResultMessage"] = "Functional Class deleted"; } else { TempData["ResultMessage"] = "This Functional Class has dependencies, cannot delete!"; } } } return(RedirectToAction("Index")); }
public IActionResult Delete(Guid id) { CountyViewModel countvVM = new CountyViewModel(); using (CountyDBContext db = new CountyDBContext()) { using (var dbC = new BridgeDBContext()) { BridgeViewModel bridgeVm = new BridgeViewModel(); bridgeVm.BridgeList = dbC.Bridges.ToList(); bridgeVm.NewBridge = dbC.Bridges.Where( c => c.CountyId == id).FirstOrDefault(); if (bridgeVm.NewBridge == null) { countvVM.NewCounty = new County(); //retrieve info from route data countvVM.NewCounty.CountyId = Guid.Parse(RouteData.Values["id"].ToString()); //update record state db.Entry(countvVM.NewCounty).State = EntityState.Deleted; db.SaveChanges(); TempData["ResultMessage"] = "County Deleted"; } else { TempData["ResultMessage"] = "This County has dependencies, cannot delete!"; } } } return(RedirectToAction("Index")); }
public IActionResult Delete(Guid id) { StatusCodeViewModel sCodeVm = new StatusCodeViewModel(); using (StatusCodeDBContext db = new StatusCodeDBContext()) { using (var dbB = new BridgeDBContext()) { BridgeViewModel bridgeVm = new BridgeViewModel(); bridgeVm.BridgeList = dbB.Bridges.ToList(); bridgeVm.NewBridge = dbB.Bridges.Where( sc => sc.StatusId == id).FirstOrDefault(); if (bridgeVm.NewBridge == null) { sCodeVm.NewStatusCode = new StatusCode(); //find id sCodeVm.NewStatusCode.StatusCodeId = Guid.Parse(RouteData.Values["id"].ToString()); db.Entry(sCodeVm.NewStatusCode).State = EntityState.Deleted; db.SaveChanges(); TempData["ResultMessage"] = "Status Code deleted"; } else { TempData["ResultMessage"] = "This Status Code has dependencies, cannot delete!"; } } } return(RedirectToAction("Index")); }
public IActionResult Index(BridgeViewModel bridgeVM) { using (var db = new BridgeDBContext()) { db.Bridges.Add(bridgeVM.NewBridge); db.SaveChanges(); return(RedirectToAction("Index")); } }
// GET: /<controller>/ public IActionResult Index() { BridgeViewModel bridgeVM = new BridgeViewModel(); using (var db = new BridgeDBContext()) { bridgeVM.BridgeList = db.Bridges.ToList(); bridgeVM.NewBridge = new Bridge(); } return(View(bridgeVM)); }
public IActionResult Index(BridgeViewModel bridgeAdd) { if (ModelState.IsValid) { using (var db = new BridgeDBContext()) { db.Bridges.Add(bridgeAdd.NewBridge); db.SaveChanges(); } } return(RedirectToAction("Index")); }
// GET: /<controller>/ public IActionResult Index() { BridgeViewModel bridgeVM = new BridgeViewModel(); using (var db = new BridgeDBContext()) { bridgeVM.BridgeList = db.Bridges.ToList(); bridgeVM.NewBridge = new Bridge(); bridgeVM.MaterialDesigns = GetMaterialDesignsDDL(); bridgeVM.ConstructionDesigns = GetConstructionDesignsDDL(); bridgeVM.FunctionalClasses = GetFunctionalClassesDDL(); bridgeVM.StatusCodes = GetStatusCodesDDL(); bridgeVM.Counties = GetCountiesDDL(); } return(View(bridgeVM)); }
private static List <SelectListItem> GetBridgesDDL() { List <SelectListItem> bridge = new List <SelectListItem>(); BridgeViewModel bvm = new BridgeViewModel(); using (var db = new BridgeDBContext()) { bvm.BridgeList = db.Bridges.ToList(); } foreach (Bridge b in bvm.BridgeList) { bridge.Add(new SelectListItem { Text = b.Bridgeid.ToString() }); } return(bridge); }
public IActionResult Edit(BridgeViewModel obj) { //check for valid model state if (ModelState.IsValid) { using (BridgeDBContext db = new BridgeDBContext()) { //instance of object Bridge b = obj.NewBridge; //retrieve info from route data b.Bridgeid = Guid.Parse(RouteData.Values["id"].ToString()); //update record state db.Entry(b).State = EntityState.Modified; //save changes db.SaveChanges(); } } return(RedirectToAction("Index")); }