public ActionResult EditFacilities([Bind(Include = "Id,Name,IP,Domain,SerialNumber,ProgramVersion, locations_Id, locations_countries_Id,locations_countries_continents_Id,User_Id")] facilities facilities) { if (ModelState.IsValid) { //writes the user input data to database db.Entry(facilities).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("FacilityOverview")); } //writes data from dropdown lists to facility table(collects data from locations, countries, continents and user tables) ViewBag.locations_Id = new SelectList(db.locations, "Id", "StreetAddress", facilities.locations_Id); ViewBag.locations_countries_Id = new SelectList(db.countries, "Id", "Name", facilities.locations_countries_Id); ViewBag.locations_countries_continents_Id = new SelectList(db.continents, "Id", "Name", facilities.locations_countries_continents_Id); ViewBag.User_Id = new SelectList(db.User, "Id", "UserName", facilities.User_Id); return(View(facilities)); }
public ActionResult EditFacilities(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } facilities facilities = db.facilities.Find(id);//gets id from opened facility if (facilities == null) { return(HttpNotFound()); } //creates dropdown lists for location, country, continents and user. Displays name, returns ID ViewBag.locations_Id = new SelectList(db.locations, "Id", "StreetAddress"); ViewBag.locations_countries_Id = new SelectList(db.countries, "Id", "Name"); ViewBag.locations_countries_continents_Id = new SelectList(db.continents, "Id", "Name"); ViewBag.User_Id = new SelectList(db.User, "Id", "UserName"); return(View(facilities)); }
public ActionResult AddFacility2([Bind(Include = "Id,Name,IP,Domain,SerialNumber, ProgramVersion,locations_Id,locations_countries_Id,locations_countries_continents_Id")] facilities facilities) { if (ModelState.IsValid) { //Saves data from view to database db.facilities.Add(facilities); try { db.SaveChanges(); } catch (InvalidOperationException e) { throw new InvalidOperationException("Data could not be saved", e); } //Returns Facility overview when data has been saved return(RedirectToAction("FacilityOverview")); } //writes data from dropdown lists to facilities table(collects data from locations, countries and continents tables) ViewBag.locations_Id = new SelectList(db.locations, "Id", "StreetAddress", facilities.locations_Id); ViewBag.locations_countries_Id = new SelectList(db.countries, "Id", "Name", facilities.locations_countries_Id); ViewBag.locations_countries_continents_Id = new SelectList(db.continents, "Id", "Name", facilities.locations_countries_continents_Id); return(View(facilities));//opens facility overview }