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(StatusCodeViewModel statusCodeVM)
{
using (var db = new StatusCodeDBContext())
{
db.StatusCodes.Add(statusCodeVM.NewStatusCode);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
// GET: /<controller>/
public IActionResult Index()
{
StatusCodeViewModel statusCodeVM = new StatusCodeViewModel();
using (var db = new StatusCodeDBContext())
{
statusCodeVM.StatusCodeList = db.StatusCodes.ToList();
statusCodeVM.NewStatusCode = new StatusCode();
}
return(View(statusCodeVM));
}
//GET Filled in Form
public IActionResult Edit(Guid id)
{
//a new instance of the view model
StatusCodeViewModel sCodeVM = new StatusCodeViewModel();
using (StatusCodeDBContext db = new StatusCodeDBContext())
{
//find id location in database
sCodeVM.NewStatusCode = db.StatusCodes.Where(
e => e.StatusCodeId == id).SingleOrDefault();
//return view model
return(View(sCodeVM));
}
}
public IActionResult Edit(StatusCodeViewModel obj)
{
//check for valid model
if (ModelState.IsValid)
{
using (StatusCodeDBContext db = new StatusCodeDBContext())
{
//object for view model
StatusCode sc = obj.NewStatusCode;
//retrieve primary key/id from route data
sc.StatusCodeId = Guid.Parse(RouteData.Values["id"].ToString());
//update record status
db.Entry(sc).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
private static List <SelectListItem> GetStatusCodesDDL()
{
List <SelectListItem> sCode = new List <SelectListItem>();
StatusCodeViewModel scvm = new StatusCodeViewModel();
using (var db = new StatusCodeDBContext())
{
scvm.StatusCodeList = db.StatusCodes.ToList();
}
foreach (StatusCode s in scvm.StatusCodeList)
{
sCode.Add(new SelectListItem
{
Text = s.StatusName,
Value = s.StatusCodeId.ToString()
});
}
return(sCode);
}
