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