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