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