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();*/
}
