public ActionResult DeleteBuilding(int id) { Building building = context.Buildings.Find(id); BuildingXManager deleteFromTable = (from row in context.BuildingManagerJunctions where row.BuildId == id select row).First(); context.Buildings.Remove(building); context.BuildingManagerJunctions.Remove(deleteFromTable); context.SaveChanges(); return(RedirectToAction("Buildings")); }
public ActionResult AddBuilding(Building model) { string UserID = User.Identity.GetUserId(); try { Manager manager = (from row in context.Managers where row.UserId == UserID select row).First(); context.Buildings.Add(model); context.SaveChanges(); Building building = (from row in context.Buildings where row.ID == model.ID select row).First(); BuildingXManager junction = new BuildingXManager(); junction.ManagerId = manager.ID; junction.building = building; junction.BuildId = model.ID; context.BuildingManagerJunctions.Add(junction); context.SaveChanges(); return(RedirectToAction("Buildings")); } catch { return(RedirectToAction("Create")); } }