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 Index(CountyViewModel countyVM)
{
using (var db = new CountyDBContext())
{
db.Counties.Add(countyVM.NewCounty);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public IActionResult Index(CountyViewModel countyAdd)
{
if (ModelState.IsValid)
{
using (var db = new CountyDBContext())
{
db.Counties.Add(countyAdd.NewCounty);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
// GET: /<controller>/
public IActionResult Index()
{
CountyViewModel countiesVM = new CountyViewModel();
using (var db = new CountyDBContext())
{
countiesVM.CountyList = db.Counties.ToList();
countiesVM.NewCounty = new County();
}
return(View(countiesVM));
}
//Get Filled in Form
public IActionResult Edit(Guid id)
{
//create an instance of the view model
CountyViewModel countiesVM = new CountyViewModel();
using (CountyDBContext db = new CountyDBContext())
{
//find id location in database
countiesVM.NewCounty = db.Counties.Where(
e => e.CountyId == id).SingleOrDefault();
//return the view model
return(View(countiesVM));
}
}
public IActionResult Edit(CountyViewModel obj)
{
//check for valid model
if (ModelState.IsValid)
{
using (CountyDBContext db = new CountyDBContext())
{
//object for view model
County e = obj.NewCounty;
//retrieve primary key/id from route data
e.CountyId = Guid.Parse(RouteData.Values["id"].ToString());
//update record status
db.Entry(e).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
private static List <SelectListItem> GetCountiesDDL()
{
List <SelectListItem> counties = new List <SelectListItem>();
CountyViewModel cvm = new CountyViewModel();
using (var db = new CountyDBContext())
{
cvm.CountyList = db.Counties.ToList();
}
foreach (County c in cvm.CountyList)
{
counties.Add(new SelectListItem
{
Text = c.CountyName,
Value = c.CountyId.ToString()
});
}
return(counties);
}
