public async Task <IActionResult> Edit(int id, [Bind("CampusID,CareerID")] CampusCareer campusCareer) { if (id != campusCareer.CampusID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(campusCareer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CampusCareerExists(campusCareer.CampusID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CampusID"] = new SelectList(_context.Campuses, "CampusID", "Name", campusCareer.CampusID); ViewData["CareerID"] = new SelectList(_context.Careers, "CareerID", "Name", campusCareer.CareerID); return(View(campusCareer)); }
public async Task <IActionResult> PutCampusCareer(int id, CampusCareer campusCareer) { if (id != campusCareer.CampusID) { return(BadRequest()); } _context.Entry(campusCareer).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CampusCareerExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Create([Bind("CampusID,CareerID")] CampusCareer campusCareer) { if (ModelState.IsValid) { _context.Add(campusCareer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CampusID"] = new SelectList(_context.Campuses, "CampusID", "Name", campusCareer.CampusID); ViewData["CareerID"] = new SelectList(_context.Careers, "CareerID", "Name", campusCareer.CareerID); return(View(campusCareer)); }
public async Task <ActionResult <CampusCareer> > PostCampusCareer(CampusCareer campusCareer) { _context.campusCareers.Add(campusCareer); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (CampusCareerExists(campusCareer.CampusID)) { return(Conflict()); } else { throw; } } return(CreatedAtAction("GetCampusCareer", new { id = campusCareer.CampusID }, campusCareer)); }
public static void Initialize(SchoolContext context) { // Crea automáticamente la base de datos. context.Database.EnsureCreated(); // Verifica si existe algún estudiante if (context.Students.Any()) { return; } var campuses = new Campus[] { new Campus { CampusID = 1, Name = "San Miguel" }, new Campus { CampusID = 2, Name = "San Isidro" }, }; foreach (Campus s in campuses) { context.Campuses.Add(s); } var careers = new Career[] { new Career { CareerID = 11, Name = "Ingenieria de Software" }, new Career { CareerID = 12, Name = "Ingenieria de Sist. Infor." }, }; foreach (Career s in careers) { context.Careers.Add(s); } context.SaveChanges(); var campusCareers = new CampusCareer[] { new CampusCareer { CampusID = 1, CareerID = 11 }, new CampusCareer { CampusID = 1, CareerID = 12 }, new CampusCareer { CampusID = 2, CareerID = 11 }, new CampusCareer { CampusID = 2, CareerID = 12 } }; foreach (CampusCareer s in campusCareers) { context.campusCareers.Add(s); } context.SaveChanges(); var courses = new Course[] { new Course { CourseID = 21, Title = "Aplicaciones Web", Credits = 4, CareerID = 11 }, new Course { CourseID = 22, Title = "Aplicaciones Open Source", Credits = 5, CareerID = 11 }, new Course { CourseID = 23, Title = "Fundamentos de Sist de Inf", Credits = 5, CareerID = 12 }, }; foreach (Course s in courses) { context.Courses.Add(s); } context.SaveChanges(); /*var students = new Student[] * { * new Student{FirstMidName="Carson",LastName="Alexander", * EnrollmentDate=DateTime.Parse("2005-09-01")}, * new Student{FirstMidName="Meredith",LastName="Alonso", * EnrollmentDate=DateTime.Parse("2002-09-01")}, * new Student{FirstMidName="Arturo",LastName="Anand", * EnrollmentDate=DateTime.Parse("2003-09-01")}, * new Student{FirstMidName="Gytis",LastName="Barzdukas", * EnrollmentDate=DateTime.Parse("2002-09-01")}, * new Student{FirstMidName="Yan",LastName="Li", * EnrollmentDate=DateTime.Parse("2002-09-01")}, * new Student{FirstMidName="Peggy",LastName="Justice", * EnrollmentDate=DateTime.Parse("2001-09-01")}, * new Student{FirstMidName="Laura",LastName="Norman", * EnrollmentDate=DateTime.Parse("2003-09-01")}, * new Student{FirstMidName="Nino",LastName="Olivetto", * EnrollmentDate=DateTime.Parse("2005-09-01")} * }; * foreach (Student s in students) * { * context.Students.Add(s); * } * context.SaveChanges(); * * var courses = new Course[] * { * new Course{CourseID=1050,Title="Chemistry",Credits=3}, * new Course{CourseID=4022,Title="Microeconomics",Credits=3}, * new Course{CourseID=4041,Title="Macroeconomics",Credits=3}, * new Course{CourseID=1045,Title="Calculus",Credits=4}, * new Course{CourseID=3141,Title="Trigonometry",Credits=4}, * new Course{CourseID=2021,Title="Composition",Credits=3}, * new Course{CourseID=2042,Title="Literature",Credits=4} * }; * foreach (Course c in courses) * { * context.Courses.Add(c); * } * context.SaveChanges(); * * var enrollments = new Enrollment[] * { * new Enrollment{StudentID=1,CourseID=1050,Grade=Grade.A}, * new Enrollment{StudentID=1,CourseID=4022,Grade=Grade.C}, * new Enrollment{StudentID=1,CourseID=4041,Grade=Grade.B}, * new Enrollment{StudentID=2,CourseID=1045,Grade=Grade.B}, * new Enrollment{StudentID=2,CourseID=3141,Grade=Grade.F}, * new Enrollment{StudentID=2,CourseID=2021,Grade=Grade.F}, * new Enrollment{StudentID=3,CourseID=1050}, * new Enrollment{StudentID=4,CourseID=1050}, * new Enrollment{StudentID=4,CourseID=4022,Grade=Grade.F}, * new Enrollment{StudentID=5,CourseID=4041,Grade=Grade.C}, * new Enrollment{StudentID=6,CourseID=1045}, * new Enrollment{StudentID=7,CourseID=3141,Grade=Grade.A}, * }; * foreach (Enrollment e in enrollments) * { * context.Enrollments.Add(e); * } * context.SaveChanges();*/ }