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 Index(MaterialDesignViewModel materialDesignVM)
{
using (var db = new MaterialDesignDBContext())
{
db.MaterialDesigns.Add(materialDesignVM.NewMaterialDesign);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
// GET: /<controller>/
public IActionResult Index()
{
MaterialDesignViewModel materialDesignVM = new MaterialDesignViewModel();
using (var db = new MaterialDesignDBContext())
{
materialDesignVM.MaterialDesignList = db.MaterialDesigns.ToList();
materialDesignVM.NewMaterialDesign = new MaterialDesign();
}
return(View(materialDesignVM));
}
//GET Filled in Form
public IActionResult Edit(Guid id)
{
//a new instance of the view model
MaterialDesignViewModel mDesign = new MaterialDesignViewModel();
using (MaterialDesignDBContext db = new MaterialDesignDBContext())
{
//find id location in database
mDesign.NewMaterialDesign = db.MaterialDesigns.Where(
e => e.MaterialDesignId == id).SingleOrDefault();
//return view model
return(View(mDesign));
}
}
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"));
}
private static List <SelectListItem> GetMaterialDesignsDDL()
{
List <SelectListItem> material = new List <SelectListItem>();
MaterialDesignViewModel mdvm = new MaterialDesignViewModel();
using (var db = new MaterialDesignDBContext())
{
mdvm.MaterialDesignList = db.MaterialDesigns.ToList();
}
foreach (MaterialDesign m in mdvm.MaterialDesignList)
{
material.Add(new SelectListItem
{
Text = m.MaterialDesignType,
Value = m.MaterialDesignId.ToString()
});
}
return(material);
}
