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 Index(FunctionalClassViewModel functionalClassVM)
{
using (var db = new FunctionalClassDBContext())
{
db.FunctionalClasses.Add(functionalClassVM.NewFunctionalClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
// GET: /<controller>/
public IActionResult Index()
{
FunctionalClassViewModel functionalClassVM = new FunctionalClassViewModel();
using (var db = new FunctionalClassDBContext())
{
functionalClassVM.FunctionalClassList = db.FunctionalClasses.ToList();
functionalClassVM.NewFunctionalClass = new FunctionalClass();
}
return(View(functionalClassVM));
}
//Get Fill Form
public IActionResult Edit(Guid id)
{
//created a new instance of the view model
FunctionalClassViewModel fClassVM = new FunctionalClassViewModel();
using (FunctionalClassDBContext db = new FunctionalClassDBContext())
{
//find id location in database
fClassVM.NewFunctionalClass = db.FunctionalClasses.Where(
e => e.FunctionalClassId == id).SingleOrDefault();
//return view model
return(View(fClassVM));
}
}
public IActionResult Edit(FunctionalClassViewModel obj)
{
//check for valid model
if (ModelState.IsValid)
{
using (FunctionalClassDBContext db = new FunctionalClassDBContext())
{
//object for view model
FunctionalClass fc = obj.NewFunctionalClass;
//retrieve primary key/id from route data
fc.FunctionalClassId = Guid.Parse(RouteData.Values["id"].ToString());
//update record status
db.Entry(fc).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
private static List <SelectListItem> GetFunctionalClassesDDL()
{
List <SelectListItem> fClass = new List <SelectListItem>();
FunctionalClassViewModel fcvm = new FunctionalClassViewModel();
using (var db = new FunctionalClassDBContext())
{
fcvm.FunctionalClassList = db.FunctionalClasses.ToList();
}
foreach (FunctionalClass f in fcvm.FunctionalClassList)
{
fClass.Add(new SelectListItem
{
Text = f.FunctionalClassType,
Value = f.FunctionalClassId.ToString()
});
}
return(fClass);
}
