public async Task <IActionResult> Edit(int id, [Bind("DegreePlanId,DegreeID,StudentID,DegreePlanAbbrev,DegreePlanName")] DegreePlan degreePlan) { if (id != degreePlan.DegreePlanId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(degreePlan); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DegreePlanExists(degreePlan.DegreePlanId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["DegreeID"] = new SelectList(_context.Degrees, "DegreeId", "DegreeAbrrev", degreePlan.DegreeID); ViewData["StudentID"] = new SelectList(_context.Students, "StudentId", "First", degreePlan.StudentID); return(View(degreePlan)); }
public async Task <IActionResult> Edit(int id, [Bind("DegreePlanID,DegreeID,StudentID,DegreePlanAbbrev,DegreePlanName")] DegreePlan degreePlan) { if (id != degreePlan.DegreePlanID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(degreePlan); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DegreePlanExists(degreePlan.DegreePlanID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(degreePlan)); }
public override string ToString() { return(base.ToString() + ": " + "StudentTermID = " + StudentTermID + "DegreePlanId = " + DegreePlanId + ", Term = " + Term + ", TermAbbrev = " + TermAbbrev + ", DegreePlan = {" + DegreePlan.ToString() + "}"); }
public async Task <IActionResult> Create([Bind("DegreePlanID,DegreeID,StudentID,DegreePlanAbbrev,DegreePlanName")] DegreePlan degreePlan) { if (ModelState.IsValid) { _context.Add(degreePlan); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(degreePlan)); }
public async Task <IActionResult> Create([Bind("DegreePlanId,StudentId,DegreePlanAbbr,DegreePlanName,DegreePlanSelected")] DegreePlan degreePlan) { if (ModelState.IsValid) { _context.Add(degreePlan); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["StudentId"] = new SelectList(_context.Students, "StudentId", "StudentId", degreePlan.StudentId); return(View(degreePlan)); }
//------------------------------------------------------------------------------ // HELPER FUNCTION FOR InitDegreePlan // Adds the courses from the query to the list of courses that need to be scheduled //------------------------------------------------------------------------------ protected void planBuilder(DataTable dt) { bool CORE_CLASS = true; List <Job> courseNums = new List <Job>(); foreach (DataRow row in dt.Rows) { // Need to store more information that we get from the DT Job job = new Job((int)row.ItemArray[0], (int)row.ItemArray[1], CORE_CLASS, (int)row.ItemArray[2]); courseNums.Add(job); } RequiredCourses = new DegreePlan(courseNums); }
public static void Initialize(ApplicationDbContext context) { if (context.Degrees.Any()) { Console.WriteLine("Degrees already exists!"); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbbrev = "ACS+2", DegreePlanName = "MS ACS +2" } }; Console.WriteLine($"Inserted {degrees.Length} new degrees"); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } if (context.Requirements.Any()) { Console.WriteLine("Requirements already exists!"); } else { var requirements = new Requirement[] { new Requirement { RequirementId = 460, RequirementAbbrev = "DB", RequirementName = "44-460 Database" }, new Requirement { RequirementId = 356, RequirementAbbrev = "NF", RequirementName = "44-356 Network Fundamemtals" }, new Requirement { RequirementId = 542, RequirementAbbrev = "OOP", RequirementName = "44-542 OOP with Java" }, new Requirement { RequirementId = 563, RequirementAbbrev = "Web apps", RequirementName = "44-563 Web apps" }, new Requirement { RequirementId = 560, RequirementAbbrev = "ADB", RequirementName = "44-560 ADB" }, new Requirement { RequirementId = 555, RequirementAbbrev = "NS", RequirementName = "44-555 Network Security" }, new Requirement { RequirementId = 618, RequirementAbbrev = "PM", RequirementName = "44-618 PM" }, new Requirement { RequirementId = 1, RequirementAbbrev = "Mobile", RequirementName = "44-643 or 44-644" }, new Requirement { RequirementId = 664, RequirementAbbrev = "UX", RequirementName = "44-664 UX" }, new Requirement { RequirementId = 10, RequirementAbbrev = "E1", RequirementName = "Elective 1" }, new Requirement { RequirementId = 20, RequirementAbbrev = "E2", RequirementName = "Elective 2" }, new Requirement { RequirementId = 691, RequirementAbbrev = "GDP1", RequirementName = "GDP1" }, new Requirement { RequirementId = 692, RequirementAbbrev = "GDP2", RequirementName = "GDP2" } }; Console.WriteLine($"Inserted {requirements.Length} new requirements"); foreach (Requirement r in requirements) { context.Requirements.Add(r); } context.SaveChanges(); } //Student if (context.Students.Any()) { Console.WriteLine("Student records already exists!"); } else { var students = new Student[] { new Student { StudentId = 531367, LastName = "Devineni", FirstName = "Sai Sirisha", Snumber = "s531367", _919number = 562438 }, new Student { StudentId = 533985, LastName = "Marasini", FirstName = "Dristi", Snumber = "s533985", _919number = 569178 }, new Student { StudentId = 521315, LastName = "Joshi", FirstName = "Aawaj", Snumber = "s521315", _919number = 480684 }, new Student { StudentId = 533900, LastName = "Bourishetty", FirstName = "Karun ", Snumber = "s533900", _919number = 568896 } }; Console.WriteLine($"Inserted {students.Length} new student record"); foreach (Student d in students) { context.Students.Add(d); } context.SaveChanges(); } //Degreeplan if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exists!"); } else { var degreePlans = new DegreePlan[] { new DegreePlan { DegreePlanId = 10, DegreeId = 1, StudentId = 531367, DegreePlanAbrev = "No summer off", DegreePlanName = "No summer off" }, new DegreePlan { DegreePlanId = 11, DegreeId = 1, StudentId = 531367, DegreePlanAbrev = "Summer Off", DegreePlanName = "summer off" }, new DegreePlan { DegreePlanId = 30, DegreeId = 1, StudentId = 533900, DegreePlanAbrev = "No summer off", DegreePlanName = "No summer off" }, new DegreePlan { DegreePlanId = 31, DegreeId = 1, StudentId = 533900, DegreePlanAbrev = "Summer Off", DegreePlanName = "summer off" }, new DegreePlan { DegreePlanId = 12, DegreeId = 1, StudentId = 533985, DegreePlanAbrev = "No summer off", DegreePlanName = "No summer off" }, new DegreePlan { DegreePlanId = 13, DegreeId = 1, StudentId = 533985, DegreePlanAbrev = "Summer Off", DegreePlanName = "summer off" }, new DegreePlan { DegreePlanId = 14, DegreeId = 1, StudentId = 521315, DegreePlanAbrev = "No summer off", DegreePlanName = "No summer off" }, new DegreePlan { DegreePlanId = 15, DegreeId = 1, StudentId = 521315, DegreePlanAbrev = "Summer Off", DegreePlanName = "summer off" } }; Console.WriteLine($"Inserted {degreePlans.Length} new degree plan term requirements"); foreach (DegreePlan d in degreePlans) { context.DegreePlans.Add(d); } context.SaveChanges(); } //DegreeRequirement if (context.DegreeRequirements.Any()) { Console.WriteLine("Degree Requirements already exists!"); } else { var degreeRequirements = new DegreeRequirement[] { new DegreeRequirement { DegreeRequirementId = 1, DegreeId = 1, RequirementId = 460 }, new DegreeRequirement { DegreeRequirementId = 2, DegreeId = 1, RequirementId = 356 }, new DegreeRequirement { DegreeRequirementId = 3, DegreeId = 1, RequirementId = 542 }, new DegreeRequirement { DegreeRequirementId = 4, DegreeId = 1, RequirementId = 563 }, new DegreeRequirement { DegreeRequirementId = 5, DegreeId = 1, RequirementId = 560 }, new DegreeRequirement { DegreeRequirementId = 6, DegreeId = 1, RequirementId = 555 }, new DegreeRequirement { DegreeRequirementId = 7, DegreeId = 1, RequirementId = 618 }, new DegreeRequirement { DegreeRequirementId = 8, DegreeId = 1, RequirementId = 1 }, new DegreeRequirement { DegreeRequirementId = 9, DegreeId = 1, RequirementId = 664 }, new DegreeRequirement { DegreeRequirementId = 10, DegreeId = 1, RequirementId = 10 }, new DegreeRequirement { DegreeRequirementId = 11, DegreeId = 1, RequirementId = 20 }, new DegreeRequirement { DegreeRequirementId = 12, DegreeId = 1, RequirementId = 691 }, new DegreeRequirement { DegreeRequirementId = 13, DegreeId = 1, RequirementId = 692 }, }; Console.WriteLine($"Inserted {degreeRequirements.Length} new degree requirements"); foreach (DegreeRequirement dr in degreeRequirements) { context.DegreeRequirements.Add(dr); } context.SaveChanges(); } //StudentTerm if (context.StudentTerms.Any()) { Console.WriteLine("StudentTerm Requirements already exists!"); } else { var studentTerms = new StudentTerm[] { new StudentTerm { StudentTermId = 13, StudentId = 521315, Term = 12, TermLabel = "Spring 2018" }, new StudentTerm { StudentTermId = 14, StudentId = 521315, Term = 13, TermLabel = "Fall 2018" }, new StudentTerm { StudentTermId = 15, StudentId = 521315, Term = 14, TermLabel = "Spring 2019" }, new StudentTerm { StudentTermId = 16, StudentId = 521315, Term = 15, TermLabel = "Summer 2018" }, new StudentTerm { StudentTermId = 17, StudentId = 521315, Term = 16, TermLabel = "Fall 2018" }, }; Console.WriteLine($"Inserted {studentTerms.Length} new student terms"); foreach (StudentTerm st in studentTerms) { context.StudentTerms.Add(st); } context.SaveChanges(); } if (context.DegreePlanTermRequirements.Any()) { Console.WriteLine("Degree Plan Term Requirements already exists!"); } else { var degreePlanTermRequirements = new DegreePlanTermRequirement[] { new DegreePlanTermRequirement { DegreePlanTermRequirementId = 1, DegreePlanId = 10, TermId = 1, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 2, DegreePlanId = 10, TermId = 1, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 3, DegreePlanId = 10, TermId = 1, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 4, DegreePlanId = 10, TermId = 1, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 5, DegreePlanId = 10, TermId = 2, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 6, DegreePlanId = 10, TermId = 2, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 7, DegreePlanId = 10, TermId = 2, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 8, DegreePlanId = 10, TermId = 3, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 9, DegreePlanId = 10, TermId = 3, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 10, DegreePlanId = 10, TermId = 3, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 11, DegreePlanId = 10, TermId = 4, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 12, DegreePlanId = 10, TermId = 4, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 13, DegreePlanId = 10, TermId = 4, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 14, DegreePlanId = 11, TermId = 1, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 15, DegreePlanId = 11, TermId = 1, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 16, DegreePlanId = 11, TermId = 1, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 17, DegreePlanId = 11, TermId = 1, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 18, DegreePlanId = 11, TermId = 2, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 19, DegreePlanId = 11, TermId = 2, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 20, DegreePlanId = 11, TermId = 2, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 21, DegreePlanId = 11, TermId = 4, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 22, DegreePlanId = 11, TermId = 4, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 23, DegreePlanId = 11, TermId = 4, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 24, DegreePlanId = 11, TermId = 5, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 25, DegreePlanId = 11, TermId = 5, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 26, DegreePlanId = 11, TermId = 5, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 27, DegreePlanId = 30, TermId = 18, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 28, DegreePlanId = 30, TermId = 18, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 29, DegreePlanId = 30, TermId = 18, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 30, DegreePlanId = 30, TermId = 18, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 31, DegreePlanId = 30, TermId = 19, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 32, DegreePlanId = 30, TermId = 19, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 33, DegreePlanId = 30, TermId = 19, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 34, DegreePlanId = 30, TermId = 21, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 35, DegreePlanId = 30, TermId = 21, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 36, DegreePlanId = 30, TermId = 21, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 37, DegreePlanId = 30, TermId = 21, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 38, DegreePlanId = 30, TermId = 22, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 39, DegreePlanId = 30, TermId = 22, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 40, DegreePlanId = 31, TermId = 18, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 41, DegreePlanId = 31, TermId = 18, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 42, DegreePlanId = 31, TermId = 18, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 43, DegreePlanId = 31, TermId = 18, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 44, DegreePlanId = 31, TermId = 19, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 45, DegreePlanId = 31, TermId = 19, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 46, DegreePlanId = 31, TermId = 19, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 47, DegreePlanId = 31, TermId = 20, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 48, DegreePlanId = 31, TermId = 21, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 49, DegreePlanId = 31, TermId = 21, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 50, DegreePlanId = 31, TermId = 21, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 51, DegreePlanId = 31, TermId = 22, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 52, DegreePlanId = 31, TermId = 22, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 53, DegreePlanId = 12, TermId = 1, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 54, DegreePlanId = 12, TermId = 1, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 55, DegreePlanId = 12, TermId = 1, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 56, DegreePlanId = 12, TermId = 3, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 57, DegreePlanId = 12, TermId = 3, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 58, DegreePlanId = 12, TermId = 3, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 59, DegreePlanId = 12, TermId = 2, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 60, DegreePlanId = 12, TermId = 2, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 61, DegreePlanId = 12, TermId = 4, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 62, DegreePlanId = 12, TermId = 4, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 63, DegreePlanId = 12, TermId = 6, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 64, DegreePlanId = 12, TermId = 6, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 65, DegreePlanId = 12, TermId = 6, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 66, DegreePlanId = 13, TermId = 1, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 67, DegreePlanId = 13, TermId = 1, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 68, DegreePlanId = 13, TermId = 1, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 69, DegreePlanId = 13, TermId = 1, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 70, DegreePlanId = 13, TermId = 3, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 71, DegreePlanId = 13, TermId = 3, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 72, DegreePlanId = 13, TermId = 3, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 73, DegreePlanId = 13, TermId = 3, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 74, DegreePlanId = 13, TermId = 4, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 75, DegreePlanId = 13, TermId = 4, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 76, DegreePlanId = 13, TermId = 4, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 77, DegreePlanId = 13, TermId = 6, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 78, DegreePlanId = 13, TermId = 6, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 79, DegreePlanId = 14, TermId = 1, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 80, DegreePlanId = 14, TermId = 1, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 81, DegreePlanId = 14, TermId = 1, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 82, DegreePlanId = 14, TermId = 1, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 83, DegreePlanId = 14, TermId = 2, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 84, DegreePlanId = 14, TermId = 2, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 85, DegreePlanId = 14, TermId = 2, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 86, DegreePlanId = 14, TermId = 4, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 87, DegreePlanId = 14, TermId = 4, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 88, DegreePlanId = 14, TermId = 4, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 89, DegreePlanId = 14, TermId = 5, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 90, DegreePlanId = 14, TermId = 5, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 91, DegreePlanId = 14, TermId = 5, RequirementId = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 92, DegreePlanId = 15, TermId = 1, RequirementId = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 93, DegreePlanId = 15, TermId = 1, RequirementId = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 94, DegreePlanId = 15, TermId = 1, RequirementId = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 95, DegreePlanId = 15, TermId = 1, RequirementId = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 96, DegreePlanId = 15, TermId = 2, RequirementId = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 97, DegreePlanId = 15, TermId = 2, RequirementId = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 98, DegreePlanId = 15, TermId = 2, RequirementId = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 99, DegreePlanId = 15, TermId = 3, RequirementId = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 100, DegreePlanId = 15, TermId = 3, RequirementId = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 101, DegreePlanId = 15, TermId = 3, RequirementId = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 102, DegreePlanId = 15, TermId = 4, RequirementId = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 103, DegreePlanId = 15, TermId = 4, RequirementId = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 104, DegreePlanId = 15, TermId = 4, RequirementId = 692 } }; Console.WriteLine($"Inserted {degreePlanTermRequirements.Length} new degree plan term requirements"); foreach (DegreePlanTermRequirement d in degreePlanTermRequirements) { context.DegreePlanTermRequirements.Add(d); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { if (context.Degrees.Any()) { Console.WriteLine("Degree exists."); } else { var team_6 = new Degree[] { new Degree { DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "MS ACS + DB" }, }; Console.WriteLine($"New degree {team_6.Length} new degree in inserted"); foreach (Degree d in team_6) { context.Degrees.Add(d); } context.SaveChanges(); } //END HERE //This section is for Student if (context.Students.Any()) { Console.WriteLine("Student exists."); } else { var team_6 = new Student[] { new Student { StudentID = 533990, FirstName = "Hari Priya", LastName = "Jupally", bearcatNum = "919569151" }, new Student { StudentID = 531366, FirstName = "Bharadwaj", LastName = "Dasari", bearcatNum = "919559663" }, new Student { StudentID = 533710, FirstName = "Durga Susmitha", LastName = "Kotyada", bearcatNum = "919570698" }, new Student { StudentID = 533626, FirstName = "Hyndavi", LastName = "Musipatla", bearcatNum = "919570835" }, new Student { StudentID = 531383, FirstName = "Vyshnavi", LastName = "Yalamareddy", bearcatNum = "919562271" }, }; Console.WriteLine($"New student {team_6.Length} new student in inserted"); foreach (Student d in team_6) { context.Students.Add(d); } context.SaveChanges(); } //END HERE //This section is for DegreePlan if (context.DegreePlans.Any()) { Console.WriteLine("DegreePlan exists."); } else { var team_6 = new DegreePlan[] { new DegreePlan { DegreePlanID = 1, DegreeID = 2, StudentID = 533990, DegreePlanAbbrev = "No Summer Off", DegreePlanName = "No Summer Off" }, new DegreePlan { DegreePlanID = 2, DegreeID = 2, StudentID = 533990, DegreePlanAbbrev = "Summer Off", DegreePlanName = "Summer Off" }, new DegreePlan { DegreePlanID = 3, DegreeID = 2, StudentID = 531366, DegreePlanAbbrev = "No Summer Off", DegreePlanName = "No Summer Off" }, new DegreePlan { DegreePlanID = 4, DegreeID = 2, StudentID = 531366, DegreePlanAbbrev = "Summer Off", DegreePlanName = "Summer Off" }, new DegreePlan { DegreePlanID = 5, DegreeID = 2, StudentID = 533710, DegreePlanAbbrev = "No Summer Off", DegreePlanName = "No Summer Off" }, new DegreePlan { DegreePlanID = 6, DegreeID = 2, StudentID = 533710, DegreePlanAbbrev = "Summer Off", DegreePlanName = "Summer Off" }, new DegreePlan { DegreePlanID = 7, DegreeID = 2, StudentID = 533626, DegreePlanAbbrev = "No Summer Off", DegreePlanName = "No Summer Off" }, new DegreePlan { DegreePlanID = 8, DegreeID = 2, StudentID = 533626, DegreePlanAbbrev = "Summer Off", DegreePlanName = "Summer Off" }, new DegreePlan { DegreePlanID = 9, DegreeID = 2, StudentID = 531383, DegreePlanAbbrev = "No Summer Off", DegreePlanName = "No Summer Off" }, new DegreePlan { DegreePlanID = 10, DegreeID = 2, StudentID = 531383, DegreePlanAbbrev = "Summer Off", DegreePlanName = "Summer Off" }, }; Console.WriteLine($"New student {team_6.Length} new student in inserted"); foreach (DegreePlan d in team_6) { context.DegreePlans.Add(d); } context.SaveChanges(); } //END HERE //This section is for Student Term if (context.StudentTerms.Any()) { Console.WriteLine("StudentTerm exists."); } else { var team_6 = new StudentTerm[] { new StudentTerm { StudentTermId = 1, StudentID = 533990, TermID = 1, TermName = "Fall 2017", DegreePlanID = 1 }, new StudentTerm { StudentTermId = 2, StudentID = 533990, TermID = 2, TermName = "Spring 2018", DegreePlanID = 1 }, new StudentTerm { StudentTermId = 3, StudentID = 533990, TermID = 3, TermName = "Summer 2018", DegreePlanID = 1 }, new StudentTerm { StudentTermId = 4, StudentID = 533990, TermID = 4, TermName = "Fall 2018", DegreePlanID = 1 }, new StudentTerm { StudentTermId = 5, StudentID = 533990, TermID = 5, TermName = "Spring 2019", DegreePlanID = 1 }, new StudentTerm { StudentTermId = 6, StudentID = 531366, TermID = 1, TermName = "Fall 2017", DegreePlanID = 3 }, new StudentTerm { StudentTermId = 7, StudentID = 531366, TermID = 2, TermName = "Spring 2018", DegreePlanID = 3 }, new StudentTerm { StudentTermId = 8, StudentID = 531366, TermID = 3, TermName = "Summer 2018", DegreePlanID = 3 }, new StudentTerm { StudentTermId = 9, StudentID = 531366, TermID = 4, TermName = "Fall 2018", DegreePlanID = 3 }, new StudentTerm { StudentTermId = 10, StudentID = 531366, TermID = 5, TermName = "Spring 2019", DegreePlanID = 3 }, new StudentTerm { StudentTermId = 11, StudentID = 533710, TermID = 1, TermName = "Fall 2017", DegreePlanID = 5 }, new StudentTerm { StudentTermId = 12, StudentID = 533710, TermID = 2, TermName = "Spring 2018", DegreePlanID = 5 }, new StudentTerm { StudentTermId = 13, StudentID = 533710, TermID = 3, TermName = "Summer 2018", DegreePlanID = 5 }, new StudentTerm { StudentTermId = 14, StudentID = 533710, TermID = 4, TermName = "Fall 2018", DegreePlanID = 5 }, new StudentTerm { StudentTermId = 15, StudentID = 533710, TermID = 5, TermName = "Spring 2019", DegreePlanID = 5 }, new StudentTerm { StudentTermId = 16, StudentID = 533626, TermID = 1, TermName = "Fall 2017", DegreePlanID = 7 }, new StudentTerm { StudentTermId = 17, StudentID = 533626, TermID = 2, TermName = "Spring 2018", DegreePlanID = 7 }, new StudentTerm { StudentTermId = 18, StudentID = 533626, TermID = 3, TermName = "Summer 2018", DegreePlanID = 7 }, new StudentTerm { StudentTermId = 19, StudentID = 533626, TermID = 4, TermName = "Fall 2018", DegreePlanID = 7 }, new StudentTerm { StudentTermId = 20, StudentID = 533626, TermID = 5, TermName = "Spring 2019", DegreePlanID = 7 }, new StudentTerm { StudentTermId = 21, StudentID = 531383, TermID = 1, TermName = "Fall 2017", DegreePlanID = 9 }, new StudentTerm { StudentTermId = 22, StudentID = 531383, TermID = 2, TermName = "Spring 2018", DegreePlanID = 9 }, new StudentTerm { StudentTermId = 23, StudentID = 531383, TermID = 3, TermName = "Summer 2018", DegreePlanID = 9 }, new StudentTerm { StudentTermId = 24, StudentID = 531383, TermID = 4, TermName = "Fall 2018", DegreePlanID = 9 }, new StudentTerm { StudentTermId = 25, StudentID = 531383, TermID = 5, TermName = "Spring 2019", DegreePlanID = 9 }, }; Console.WriteLine($"New studentTerm {team_6.Length} new studentTerm in inserted"); foreach (StudentTerm d in team_6) { context.StudentTerms.Add(d); } context.SaveChanges(); } //END HEREs //This section is for Requirements if (context.Requirements.Any()) { Console.WriteLine("Requirement exists."); } else { var team_6 = new Requirement[] { new Requirement { RequirementID = 460, RequirementAbbrev = "DB", RequirementName = "44-460 Database", DegreeID = 2, StudentTermId = 1 }, new Requirement { RequirementID = 542, RequirementAbbrev = "OOP", RequirementName = "44-542 OOP", DegreeID = 2, StudentTermId = 1 }, new Requirement { RequirementID = 563, RequirementAbbrev = "Web apps", RequirementName = "44-563 Web apps", DegreeID = 2, StudentTermId = 1 }, new Requirement { RequirementID = 560, RequirementAbbrev = "ADB", RequirementName = "44-560 ADB", DegreeID = 2, StudentTermId = 1 }, new Requirement { RequirementID = 555, RequirementAbbrev = "NS", RequirementName = "44-555 Network Security", DegreeID = 2, StudentTermId = 2 }, new Requirement { RequirementID = 618, RequirementAbbrev = "PM", RequirementName = "44-618 PM", DegreeID = 2, StudentTermId = 2 }, new Requirement { RequirementID = 1, RequirementAbbrev = "Mobile", RequirementName = "44-643 or 44-644", DegreeID = 2, StudentTermId = 2 }, new Requirement { RequirementID = 664, RequirementAbbrev = "UXD", RequirementName = "44-664 UXD", DegreeID = 2, StudentTermId = 3 }, new Requirement { RequirementID = 10, RequirementAbbrev = "E1", RequirementName = "Elective 1", DegreeID = 2, StudentTermId = 3 }, new Requirement { RequirementID = 20, RequirementAbbrev = "E2", RequirementName = "Elective 2", DegreeID = 2, StudentTermId = 3 }, new Requirement { RequirementID = 691, RequirementAbbrev = "GDP1", RequirementName = "GDP1", DegreeID = 2, StudentTermId = 4 }, new Requirement { RequirementID = 692, RequirementAbbrev = "GDP2", RequirementName = "GDP2", DegreeID = 2, StudentTermId = 4 } }; Console.WriteLine($"New requirement {team_6.Length} new requirement in inserted"); foreach (Requirement d in team_6) { context.Requirements.Add(d); } context.SaveChanges(); } //END HERE //This section is for DegreeRequirement if (context.DegreeRequirements.Any()) { Console.WriteLine("DegreeRequirement exists."); } else { var team_6 = new DegreeRequirement[] { new DegreeRequirement { DegreeRequirementID = 1, StudentTermID = 1, RequirementID = 460 }, new DegreeRequirement { DegreeRequirementID = 2, StudentTermID = 1, RequirementID = 542 }, new DegreeRequirement { DegreeRequirementID = 3, StudentTermID = 1, RequirementID = 563 }, new DegreeRequirement { DegreeRequirementID = 4, StudentTermID = 1, RequirementID = 560 }, new DegreeRequirement { DegreeRequirementID = 5, StudentTermID = 1, RequirementID = 555 }, new DegreeRequirement { DegreeRequirementID = 6, StudentTermID = 1, RequirementID = 618 }, new DegreeRequirement { DegreeRequirementID = 7, StudentTermID = 1, RequirementID = 1 }, new DegreeRequirement { DegreeRequirementID = 8, StudentTermID = 1, RequirementID = 664 }, new DegreeRequirement { DegreeRequirementID = 9, StudentTermID = 1, RequirementID = 10 }, new DegreeRequirement { DegreeRequirementID = 10, StudentTermID = 1, RequirementID = 20 }, new DegreeRequirement { DegreeRequirementID = 11, StudentTermID = 1, RequirementID = 691 }, new DegreeRequirement { DegreeRequirementID = 12, StudentTermID = 1, RequirementID = 692 }, }; Console.WriteLine($"New degreeRequirement {team_6.Length} new degreeRequirement in inserted"); foreach (DegreeRequirement d in team_6) { context.DegreeRequirements.Add(d); } context.SaveChanges(); } //END HERE //This section is for DegreePlanTermRequirement if (context.DegreePlanTermRequirements.Any()) { Console.WriteLine("DegreePlanTermRequirement exists."); } else { var team_6 = new DegreePlanTermRequirement[] { new DegreePlanTermRequirement { DegreePlanTermRequirementID = 1, TermID = 1, DegreePlanID = 1, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 2, TermID = 1, DegreePlanID = 1, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 3, TermID = 1, DegreePlanID = 1, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 4, TermID = 2, DegreePlanID = 1, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 5, TermID = 2, DegreePlanID = 1, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 6, TermID = 2, DegreePlanID = 1, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 7, TermID = 3, DegreePlanID = 1, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 8, TermID = 3, DegreePlanID = 1, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 9, TermID = 3, DegreePlanID = 1, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 10, TermID = 4, DegreePlanID = 1, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 11, TermID = 4, DegreePlanID = 1, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 12, TermID = 4, DegreePlanID = 1, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 13, TermID = 1, DegreePlanID = 2, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 14, TermID = 1, DegreePlanID = 2, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 15, TermID = 1, DegreePlanID = 2, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 16, TermID = 2, DegreePlanID = 2, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 17, TermID = 2, DegreePlanID = 2, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 18, TermID = 2, DegreePlanID = 2, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 19, TermID = 4, DegreePlanID = 2, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 20, TermID = 4, DegreePlanID = 2, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 21, TermID = 4, DegreePlanID = 2, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 22, TermID = 5, DegreePlanID = 2, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 23, TermID = 5, DegreePlanID = 2, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 24, TermID = 5, DegreePlanID = 2, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 25, TermID = 1, DegreePlanID = 3, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 26, TermID = 1, DegreePlanID = 3, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 27, TermID = 1, DegreePlanID = 3, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 28, TermID = 2, DegreePlanID = 3, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 29, TermID = 2, DegreePlanID = 3, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 30, TermID = 2, DegreePlanID = 3, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 31, TermID = 3, DegreePlanID = 3, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 32, TermID = 3, DegreePlanID = 3, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 33, TermID = 3, DegreePlanID = 3, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 34, TermID = 4, DegreePlanID = 3, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 35, TermID = 4, DegreePlanID = 3, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 36, TermID = 4, DegreePlanID = 3, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 37, TermID = 1, DegreePlanID = 4, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 38, TermID = 1, DegreePlanID = 4, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 39, TermID = 1, DegreePlanID = 4, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 40, TermID = 2, DegreePlanID = 4, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 41, TermID = 2, DegreePlanID = 4, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 42, TermID = 2, DegreePlanID = 4, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 43, TermID = 4, DegreePlanID = 4, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 44, TermID = 4, DegreePlanID = 4, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 45, TermID = 4, DegreePlanID = 4, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 46, TermID = 5, DegreePlanID = 4, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 47, TermID = 5, DegreePlanID = 4, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 48, TermID = 5, DegreePlanID = 4, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 49, TermID = 1, DegreePlanID = 5, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 50, TermID = 1, DegreePlanID = 5, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 51, TermID = 1, DegreePlanID = 5, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 52, TermID = 2, DegreePlanID = 5, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 53, TermID = 2, DegreePlanID = 5, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 54, TermID = 2, DegreePlanID = 5, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 55, TermID = 3, DegreePlanID = 5, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 56, TermID = 3, DegreePlanID = 5, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 57, TermID = 3, DegreePlanID = 5, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 58, TermID = 4, DegreePlanID = 5, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 59, TermID = 4, DegreePlanID = 5, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 60, TermID = 4, DegreePlanID = 5, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 61, TermID = 1, DegreePlanID = 6, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 62, TermID = 1, DegreePlanID = 6, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 63, TermID = 1, DegreePlanID = 6, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 64, TermID = 2, DegreePlanID = 6, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 65, TermID = 2, DegreePlanID = 6, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 66, TermID = 2, DegreePlanID = 6, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 67, TermID = 4, DegreePlanID = 6, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 68, TermID = 4, DegreePlanID = 6, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 69, TermID = 4, DegreePlanID = 6, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 70, TermID = 5, DegreePlanID = 6, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 71, TermID = 5, DegreePlanID = 6, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 72, TermID = 5, DegreePlanID = 6, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 73, TermID = 1, DegreePlanID = 7, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 74, TermID = 1, DegreePlanID = 7, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 75, TermID = 1, DegreePlanID = 7, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 76, TermID = 2, DegreePlanID = 7, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 77, TermID = 2, DegreePlanID = 7, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 78, TermID = 2, DegreePlanID = 7, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 79, TermID = 3, DegreePlanID = 7, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 80, TermID = 3, DegreePlanID = 7, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 81, TermID = 3, DegreePlanID = 7, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 82, TermID = 4, DegreePlanID = 7, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 83, TermID = 4, DegreePlanID = 7, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 84, TermID = 4, DegreePlanID = 7, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 85, TermID = 1, DegreePlanID = 8, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 86, TermID = 1, DegreePlanID = 8, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 87, TermID = 1, DegreePlanID = 8, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 88, TermID = 2, DegreePlanID = 8, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 89, TermID = 2, DegreePlanID = 8, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 90, TermID = 2, DegreePlanID = 8, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 91, TermID = 4, DegreePlanID = 8, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 92, TermID = 4, DegreePlanID = 8, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 93, TermID = 4, DegreePlanID = 8, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 94, TermID = 5, DegreePlanID = 8, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 95, TermID = 5, DegreePlanID = 8, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 96, TermID = 5, DegreePlanID = 8, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 97, TermID = 1, DegreePlanID = 9, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 98, TermID = 1, DegreePlanID = 9, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 99, TermID = 1, DegreePlanID = 9, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 100, TermID = 2, DegreePlanID = 9, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 101, TermID = 2, DegreePlanID = 9, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 102, TermID = 2, DegreePlanID = 9, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 103, TermID = 3, DegreePlanID = 9, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 104, TermID = 3, DegreePlanID = 9, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 105, TermID = 3, DegreePlanID = 9, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 106, TermID = 4, DegreePlanID = 9, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 107, TermID = 4, DegreePlanID = 9, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 108, TermID = 4, DegreePlanID = 9, RequirementID = 692 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 109, TermID = 1, DegreePlanID = 10, RequirementID = 460 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 110, TermID = 1, DegreePlanID = 10, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 111, TermID = 1, DegreePlanID = 10, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 112, TermID = 2, DegreePlanID = 10, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 113, TermID = 2, DegreePlanID = 10, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 114, TermID = 2, DegreePlanID = 10, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 115, TermID = 4, DegreePlanID = 10, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 116, TermID = 4, DegreePlanID = 10, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 117, TermID = 4, DegreePlanID = 10, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 118, TermID = 5, DegreePlanID = 10, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 119, TermID = 5, DegreePlanID = 10, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementID = 120, TermID = 5, DegreePlanID = 10, RequirementID = 692 }, }; Console.WriteLine($"New DegreePlanTermRequirement {team_6.Length} new DegreePlanTermRequirement in inserted"); foreach (DegreePlanTermRequirement d in team_6) { context.DegreePlanTermRequirements.Add(d); } context.SaveChanges(); } //END HERE }
public static void Initialize(ApplicationDbContext context) { if (context.Degrees.Any()) { Console.WriteLine("Degree already exists"); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbrrev = "ACS+2", DegreeName = "MS ACS+2" }, new Degree { DegreeId = 2, DegreeAbrrev = "ACS+DB", DegreeName = "MS ACS+DB" }, new Degree { DegreeId = 3, DegreeAbrrev = "ACS+NF", DegreeName = "MS ACS+NF" }, new Degree { DegreeId = 4, DegreeAbrrev = "ACS", DegreeName = "MS ACS" }, }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } //Credit table if (context.Credits.Any()) { Console.WriteLine("Credit already exists"); } else { var credits = new Credit[] { new Credit { CreditId = 460, CreditAbrrev = "DB", CreditName = "Databases", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 356, CreditAbrrev = "NF", CreditName = "Network Fundamentals", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 542, CreditAbrrev = "542-OOP", CreditName = "OOP with Java", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 563, CreditAbrrev = "563-Web", CreditName = "Web Apps", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 560, CreditAbrrev = "560-ADB", CreditName = "Advanced Databases", isSummer = 1, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 664, CreditAbrrev = "664-UX", CreditName = "User Experience", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 618, CreditAbrrev = "618-PM", CreditName = "Project Management", isSummer = 1, isSpring = 0, isFall = 0, DegreeId = 1 }, new Credit { CreditId = 555, CreditAbrrev = "555-NS", CreditName = "Network Security", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 691, CreditAbrrev = "691-GDP1", CreditName = "GDP1", isSummer = 1, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 692, CreditAbrrev = "692-GDP2", CreditName = "GDP2", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 643, CreditAbrrev = "643-Android", CreditName = "Android", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 10, CreditAbrrev = "E1", CreditName = "Elective1", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 20, CreditAbrrev = "E2", CreditName = "Elective2", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 }, new Credit { CreditId = 644, CreditAbrrev = "IOS", CreditName = "IOS", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1 } }; Console.WriteLine($"Inserted {credits.Length} new credits."); foreach (Credit c in credits) { context.Credits.Add(c); } context.SaveChanges(); } //Student table if (context.Students.Any()) { Console.WriteLine("Student already exists"); } else { var students = new Student[] { new Student { StudentId = 533569, FamilyName = "Chetty Ragava", GivenName = "Harshitha", Snumber = 533569, Num919 = 919568034 }, new Student { StudentId = 533982, FamilyName = "Ali", GivenName = "Zaiba", Snumber = 533982, Num919 = 919569110 }, new Student { StudentId = 533573, FamilyName = "Nuka", GivenName = "Vamshi krishna", Snumber = 533573, Num919 = 919570332 } }; Console.WriteLine($"Inserted {students.Length} new students."); foreach (Student st in students) { context.Students.Add(st); } context.SaveChanges(); } //DegreeCredit table if (context.DegreeCredits.Any()) { Console.WriteLine("DegreeCredit already exists"); } else { var degreeCredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditId = 1, DegreeId = 3, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 2, DegreeId = 3, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 3, DegreeId = 3, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 4, DegreeId = 3, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 5, DegreeId = 3, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 6, DegreeId = 3, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 7, DegreeId = 3, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 8, DegreeId = 3, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 9, DegreeId = 3, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 10, DegreeId = 3, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 11, DegreeId = 3, CreditId = 643 }, new DegreeCredit { DegreeCreditId = 12, DegreeId = 3, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 13, DegreeId = 3, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 14, DegreeId = 3, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 15, DegreeId = 3, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 16, DegreeId = 3, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 17, DegreeId = 3, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 18, DegreeId = 3, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 19, DegreeId = 3, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 20, DegreeId = 3, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 21, DegreeId = 3, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 22, DegreeId = 3, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 23, DegreeId = 3, CreditId = 643 }, new DegreeCredit { DegreeCreditId = 24, DegreeId = 3, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 25, DegreeId = 3, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 26, DegreeId = 3, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 27, DegreeId = 3, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 28, DegreeId = 3, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 29, DegreeId = 3, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 30, DegreeId = 3, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 31, DegreeId = 3, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 32, DegreeId = 3, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 33, DegreeId = 3, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 34, DegreeId = 3, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 35, DegreeId = 3, CreditId = 643 }, new DegreeCredit { DegreeCreditId = 36, DegreeId = 3, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 37, DegreeId = 3, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 38, DegreeId = 3, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 39, DegreeId = 3, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 40, DegreeId = 3, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 41, DegreeId = 3, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 42, DegreeId = 3, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 43, DegreeId = 3, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 44, DegreeId = 3, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 45, DegreeId = 3, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 46, DegreeId = 3, CreditId = 644 }, new DegreeCredit { DegreeCreditId = 47, DegreeId = 3, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 48, DegreeId = 3, CreditId = 20 } }; Console.WriteLine($"Inserted {degreeCredits.Length} new degreecredit."); foreach (DegreeCredit d in degreeCredits) { context.DegreeCredits.Add(d); } context.SaveChanges(); } //Degreeplan table if (context.DegreePlans.Any()) { Console.WriteLine("DegreePlan already exists"); } else { var degreeplans = new DegreePlan[] { new DegreePlan { DegreePlanId = 7251, StudentId = 533569, DegreePlanAbbrev = "Super", DegreePlanName = "As", DegreeId = 3 }, new DegreePlan { DegreePlanId = 7252, StudentId = 533569, DegreePlanAbbrev = "Slow", DegreePlanName = "Take", DegreeId = 3 }, new DegreePlan { DegreePlanId = 7253, StudentId = 533982, DegreePlanAbbrev = "Easy", DegreePlanName = "Study", DegreeId = 3 }, new DegreePlan { DegreePlanId = 7254, StudentId = 533982, DegreePlanAbbrev = "one", DegreePlanName = "Complete", DegreeId = 3 }, new DegreePlan { DegreePlanId = 7255, StudentId = 533573, DegreePlanAbbrev = "slow", DegreePlanName = "Maximum", DegreeId = 3 }, new DegreePlan { DegreePlanId = 7256, StudentId = 533573, DegreePlanAbbrev = "Default", DegreePlanName = "Default", DegreeId = 3 } }; Console.WriteLine($"Inserted {degreeplans.Length} new degreeplans."); foreach (DegreePlan dp in degreeplans) { context.DegreePlans.Add(dp); } context.SaveChanges(); } //Slot table if (context.Slots.Any()) { Console.WriteLine("Slot already exists"); } else { var slots = new Slot[] { new Slot { SlotId = 1, DegreePlanId = 7251, StudentTermId = 1, CreditId = 542, Status = "C" } }; Console.WriteLine($"Inserted {slots.Length} new slots."); foreach (Slot sl in slots) { context.Slots.Add(sl); } context.SaveChanges(); } //StudentTerm Table if (context.StudentTerms.Any()) { Console.WriteLine("Student Term already exists"); } else { var studentTerms = new StudentTerm[] { new StudentTerm { StudentTermId = 1, StudentId = 533569, StudentTermNo = 1, DegreePlanId = 7251, TermAbbrev = "F18", TermName = "Fall 2018" } }; Console.WriteLine($"Inserted {studentTerms.Length} new studentTerms."); foreach (StudentTerm stt in studentTerms) { context.StudentTerms.Add(stt); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { //context.Database.EnsureCreated(); // Look for any Degrees. if (context.Degrees.Any()) { Console.WriteLine("Degrees already exist."); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbrrev = "ACS+2", DegreeName = "MS ACS +2" }, new Degree { DegreeId = 2, DegreeAbrrev = "ACS+DB", DegreeName = "MS ACS + DB" }, new Degree { DegreeId = 3, DegreeAbrrev = "ACS+NF", DegreeName = "MS ACS+ NF" }, new Degree { DegreeId = 4, DegreeAbrrev = "ACS", DegreeName = "MS ACS" } }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } if (context.Requirements.Any()) { Console.WriteLine("Requirements already exist."); } else { var requirements = new Requirement[] { new Requirement { RequirementID = 460, DegreeId = 3, RequirementAbbrev = "DB", CourseName = "44-460 Database" }, new Requirement { RequirementID = 356, DegreeId = 3, RequirementAbbrev = "NF", CourseName = "44-356 Network Fundamentals" }, new Requirement { RequirementID = 542, DegreeId = 3, RequirementAbbrev = "OOP", CourseName = "44-542 Object Oriented Programming" }, new Requirement { RequirementID = 563, DegreeId = 3, RequirementAbbrev = "Web apps", CourseName = "44-563 Web apps" }, new Requirement { RequirementID = 560, DegreeId = 3, RequirementAbbrev = "ADB", CourseName = "44-560 Advance Database topics" }, new Requirement { RequirementID = 555, DegreeId = 3, RequirementAbbrev = "NS", CourseName = "44-555 Network Security" }, new Requirement { RequirementID = 618, DegreeId = 3, RequirementAbbrev = "PM", CourseName = "44-618 Project Management" }, new Requirement { RequirementID = 1, DegreeId = 3, RequirementAbbrev = "Mobile Computing", CourseName = "Mobile Computing" }, new Requirement { RequirementID = 664, DegreeId = 3, RequirementAbbrev = "HCI", CourseName = "44-664 User Experience Design" }, new Requirement { RequirementID = 10, DegreeId = 3, RequirementAbbrev = "E1", CourseName = "Elective 1" }, new Requirement { RequirementID = 20, DegreeId = 3, RequirementAbbrev = "E2", CourseName = "Elective 2" }, new Requirement { RequirementID = 691, DegreeId = 3, RequirementAbbrev = "GDP1", CourseName = "GDP1" }, new Requirement { RequirementID = 692, DegreeId = 3, RequirementAbbrev = "GDP2", CourseName = "GDP2" } }; Console.WriteLine($"Inserted {requirements.Length} new reuirements."); foreach (Requirement d in requirements) { context.Requirements.Add(d); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Students already exist."); } else { var student = new Student[] { new Student { StudentId = 531369, First = "Girish", Last = "Guntuku", Snumber = "S531369", _919 = 919534222 }, new Student { StudentId = 531495, First = "Chaithanya", Last = "Cherukuru", Snumber = "S531495", _919 = 919531369 }, new Student { StudentId = 531333, First = "Midhun", Last = "Kumar", Snumber = "S531333", _919 = 919531495 }, new Student { StudentId = 534222, First = "Pappu", Last = "Sah", Snumber = "S534222", _919 = 919531333 }, }; Console.WriteLine($"Inserted {student.Length} new student."); foreach (Student d in student) { context.Students.Add(d); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exist."); } else { var degreeplan = new DegreePlan[] { new DegreePlan { DegreePlanId = 10, DegreeID = 3, StudentID = 531369, DegreePlanAbbrev = "NS", DegreePlanName = "No Summer" }, new DegreePlan { DegreePlanId = 11, DegreeID = 3, StudentID = 531369, DegreePlanAbbrev = "S", DegreePlanName = "Summer" }, new DegreePlan { DegreePlanId = 12, DegreeID = 3, StudentID = 531495, DegreePlanAbbrev = "NS", DegreePlanName = "No Summer" }, new DegreePlan { DegreePlanId = 13, DegreeID = 3, StudentID = 531495, DegreePlanAbbrev = "S", DegreePlanName = "Summer" }, new DegreePlan { DegreePlanId = 14, DegreeID = 3, StudentID = 531333, DegreePlanAbbrev = "NS", DegreePlanName = "No Summer" }, new DegreePlan { DegreePlanId = 15, DegreeID = 3, StudentID = 531333, DegreePlanAbbrev = "S", DegreePlanName = "Summer" }, new DegreePlan { DegreePlanId = 16, DegreeID = 3, StudentID = 534222, DegreePlanAbbrev = "NS", DegreePlanName = "No Summer" }, new DegreePlan { DegreePlanId = 17, DegreeID = 3, StudentID = 534222, DegreePlanAbbrev = "S", DegreePlanName = "Summer" }, }; Console.WriteLine($"Inserted {degreeplan.Length} new degree plans."); foreach (DegreePlan d in degreeplan) { context.DegreePlans.Add(d); } context.SaveChanges(); } if (context.DegreePlanTermRequirements.Any()) { Console.WriteLine("DegreePlan Term Requirements already exist."); } else { var degreeplantermrequirement = new DegreePlanTermRequirement[] { new DegreePlanTermRequirement { DegreePlanTermRequirementId = 1, DegreePlanID = 10, TermID = 1, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 2, DegreePlanID = 10, TermID = 1, RequirementID = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 3, DegreePlanID = 10, TermID = 1, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 4, DegreePlanID = 10, TermID = 1, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 5, DegreePlanID = 10, TermID = 2, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 6, DegreePlanID = 10, TermID = 2, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 7, DegreePlanID = 10, TermID = 2, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 8, DegreePlanID = 10, TermID = 3, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 9, DegreePlanID = 10, TermID = 3, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 10, DegreePlanID = 10, TermID = 4, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 11, DegreePlanID = 10, TermID = 4, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 12, DegreePlanID = 10, TermID = 4, RequirementID = 692 } }; Console.WriteLine($"Inserted {degreeplantermrequirement.Length} new student terms."); foreach (DegreePlanTermRequirement d in degreeplantermrequirement) { context.DegreePlanTermRequirements.Add(d); } context.SaveChanges(); } if (context.DegreeRequirements.Any()) { Console.WriteLine("Degree Requirements already exist."); } else { var degreerequirement = new DegreeRequirement[] { new DegreeRequirement { DegreeRequirementId = 1, DegreeId = 3, RequirementId = 356 }, new DegreeRequirement { DegreeRequirementId = 2, DegreeId = 3, RequirementId = 542 }, new DegreeRequirement { DegreeRequirementId = 3, DegreeId = 3, RequirementId = 563 }, new DegreeRequirement { DegreeRequirementId = 4, DegreeId = 3, RequirementId = 560 }, new DegreeRequirement { DegreeRequirementId = 5, DegreeId = 3, RequirementId = 555 }, new DegreeRequirement { DegreeRequirementId = 6, DegreeId = 3, RequirementId = 618 }, new DegreeRequirement { DegreeRequirementId = 7, DegreeId = 3, RequirementId = 1 }, new DegreeRequirement { DegreeRequirementId = 8, DegreeId = 3, RequirementId = 664 }, new DegreeRequirement { DegreeRequirementId = 9, DegreeId = 3, RequirementId = 10 }, new DegreeRequirement { DegreeRequirementId = 10, DegreeId = 3, RequirementId = 20 }, new DegreeRequirement { DegreeRequirementId = 11, DegreeId = 3, RequirementId = 691 }, new DegreeRequirement { DegreeRequirementId = 12, DegreeId = 3, RequirementId = 692 } }; Console.WriteLine($"Inserted { degreerequirement.Length} new student terms."); foreach (DegreeRequirement d in degreerequirement) { context.DegreeRequirements.Add(d); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Student Terms already exist."); } else { var studentterm = new StudentTerm[] { new StudentTerm { StudentTermId = 1, Term = 1, TermLabel = "Fall 2017", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 2, Term = 2, TermLabel = "Spring 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 3, Term = 3, TermLabel = "Summer 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 4, Term = 4, TermLabel = "Fall 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 5, Term = 1, TermLabel = "Spring 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 6, Term = 2, TermLabel = "Summer 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 7, Term = 3, TermLabel = "Fall 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 8, Term = 4, TermLabel = "Spring 2019", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 9, Term = 1, TermLabel = "Spring 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 10, Term = 2, TermLabel = "Summer 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 11, Term = 3, TermLabel = "Fall 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 12, Term = 4, TermLabel = "Spring 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 13, Term = 5, TermLabel = "Summer 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 14, Term = 6, TermLabel = "Fall 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 15, Term = 1, TermLabel = "Fall 2018", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 16, Term = 2, TermLabel = "Spring 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 17, Term = 3, TermLabel = "Summer 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 18, Term = 4, TermLabel = "Fall 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 19, Term = 1, TermLabel = "Fall2018", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 20, Term = 2, TermLabel = "Spring2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 21, Term = 3, TermLabel = "Summer 2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 22, Term = 4, TermLabel = "Fall2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 23, Term = 5, TermLabel = "Spring 2020", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 24, Term = 6, TermLabel = "Summer 2020", DegreePlanId = 18 } }; Console.WriteLine($"Inserted {studentterm.Length} new student terms."); foreach (StudentTerm d in studentterm) { context.StudentTerms.Add(d); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { context.Database.EnsureCreated(); if (context.Degrees.Any()) { Console.WriteLine("Degrees already exist."); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbbr = "ACS+2", DegreeName = "MS ACS+2", NumberOfTerms = 4 }, new Degree { DegreeId = 2, DegreeAbbr = "ACS+DB", DegreeName = "MS ACS+DB", NumberOfTerms = 4 }, new Degree { DegreeId = 3, DegreeAbbr = "ACS+NF", DegreeName = "MS ACS+NF", NumberOfTerms = 4 }, new Degree { DegreeId = 4, DegreeAbbr = "ACS", DegreeName = "MS ACS", NumberOfTerms = 4 }, }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } if (context.Credits.Any()) { Console.WriteLine("Credits already exist."); } else { var credits = new Credit[] { new Credit { CreditId = 460, DegreeId = 1, CreditAbbr = "DB", CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 356, DegreeId = 1, CreditAbbr = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 542, DegreeId = 1, CreditAbbr = "542", CreditName = "OOPS with Java", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 563, DegreeId = 1, CreditAbbr = "563", CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 560, DegreeId = 1, CreditAbbr = "560", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 664, DegreeId = 1, CreditAbbr = "664-UX", CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 618, DegreeId = 1, CreditAbbr = "618-PM", CreditName = "Project Management", IsSummer = 1, IsSpring = 0, IsFall = 0 }, new Credit { CreditId = 555, DegreeId = 1, CreditAbbr = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 691, DegreeId = 1, CreditAbbr = "691-GDP1", CreditName = "GDP1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 692, DegreeId = 1, CreditAbbr = "692-GDP2", CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 6, DegreeId = 1, CreditAbbr = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 10, DegreeId = 1, CreditAbbr = "E1", CreditName = "Elective 1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 20, DegreeId = 1, CreditAbbr = "E2", CreditName = "Elective 2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, }; Console.WriteLine($"Inserted {credits.Length} new credits."); foreach (Credit d in credits) { context.Credits.Add(d); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Students already exist."); } else { var students = new Student[] { new Student { StudentId = 533725, Family = "Mamidi", Given = "Prakash", N919 = 919569651 }, new Student { StudentId = 534049, Family = "Haritha", Given = "Atmakuri", N919 = 919569607 }, new Student { StudentId = 533767, Family = "Badisa", Given = "SaiRam", N919 = 919565612 }, }; Console.WriteLine($"Inserted {students.Length} new students."); foreach (Student d in students) { context.Students.Add(d); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exist."); } else { var degreePlans = new DegreePlan[] { new DegreePlan { DegreePlanId = 5431, DegreeId = 1, StudentId = 533725, DegreePlanAbbr = "Slow and easy", DegreePlanName = "Take a break in summer" }, new DegreePlan { DegreePlanId = 5432, DegreeId = 1, StudentId = 533725, DegreePlanAbbr = "Super Fast", DegreePlanName = "No break" }, new DegreePlan { DegreePlanId = 5433, DegreeId = 1, StudentId = 534049, DegreePlanAbbr = "Slow and easy", DegreePlanName = "As fast as I Can" }, new DegreePlan { DegreePlanId = 5434, DegreeId = 1, StudentId = 534049, DegreePlanAbbr = "Slow and easy", DegreePlanName = "Take less courses per semester" }, new DegreePlan { DegreePlanId = 5435, DegreeId = 1, StudentId = 533767, DegreePlanAbbr = "Super Fast", DegreePlanName = "More subjects in semesters" }, new DegreePlan { DegreePlanId = 5436, DegreeId = 1, StudentId = 533767, DegreePlanAbbr = "Slow and Consistent", DegreePlanName = "Take a break in summer" }, }; Console.WriteLine($"Inserted {degreePlans.Length} new Degree Plans."); foreach (DegreePlan d in degreePlans) { context.DegreePlans.Add(d); } context.SaveChanges(); } if (context.Slots.Any()) { Console.WriteLine("Slots already exist."); } else { var slots = new Slot[] { new Slot { SlotId = 1, DegreePlanId = 5431, Term = 1, CreditId = 460, Status = "C" }, new Slot { SlotId = 2, DegreePlanId = 5431, Term = 1, CreditId = 356, Status = "C" }, new Slot { SlotId = 3, DegreePlanId = 5431, Term = 1, CreditId = 563, Status = "C" }, new Slot { SlotId = 4, DegreePlanId = 5431, Term = 1, CreditId = 542, Status = "C" }, new Slot { SlotId = 5, DegreePlanId = 5431, Term = 2, CreditId = 555, Status = "A" }, new Slot { SlotId = 6, DegreePlanId = 5431, Term = 2, CreditId = 560, Status = "A" }, new Slot { SlotId = 7, DegreePlanId = 5431, Term = 2, CreditId = 6, Status = "A" }, new Slot { SlotId = 8, DegreePlanId = 5431, Term = 3, CreditId = 10, Status = "-" }, new Slot { SlotId = 9, DegreePlanId = 5431, Term = 4, CreditId = 691, Status = "P" }, new Slot { SlotId = 10, DegreePlanId = 5431, Term = 4, CreditId = 10, Status = "P" }, new Slot { SlotId = 11, DegreePlanId = 5431, Term = 5, CreditId = 20, Status = "P" }, new Slot { SlotId = 12, DegreePlanId = 5431, Term = 5, CreditId = 692, Status = "P" }, new Slot { SlotId = 13, DegreePlanId = 5431, Term = 5, CreditId = 664, Status = "P" }, }; Console.WriteLine($"Inserted {slots.Length} new slots."); foreach (Slot d in slots) { context.Slots.Add(d); } context.SaveChanges(); } if (context.DegreeCredits.Any()) { Console.WriteLine("DegreeCredits already exist."); } else { var degreeCredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditId = 1, DegreeId = 1, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 2, DegreeId = 1, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 3, DegreeId = 1, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 4, DegreeId = 1, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 5, DegreeId = 1, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 6, DegreeId = 1, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 7, DegreeId = 1, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 8, DegreeId = 1, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 9, DegreeId = 1, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 10, DegreeId = 1, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 11, DegreeId = 1, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 12, DegreeId = 1, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 13, DegreeId = 1, CreditId = 20 }, }; Console.WriteLine($"Inserted {degreeCredits.Length} new degree credits."); foreach (DegreeCredit d in degreeCredits) { context.DegreeCredits.Add(d); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Student Terms already exist."); } else { var studentTerms = new StudentTerm[] { new StudentTerm { StudentTermId = 1, DegreePlanId = 5431, Term = 1, TermAbbr = "F18", TermName = "Fall2018" }, new StudentTerm { StudentTermId = 2, DegreePlanId = 5431, Term = 2, TermAbbr = "s19", TermName = "Spring2019" }, new StudentTerm { StudentTermId = 3, DegreePlanId = 5431, Term = 3, TermAbbr = "Su19", TermName = "Summer2019" }, new StudentTerm { StudentTermId = 4, DegreePlanId = 5431, Term = 4, TermAbbr = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermId = 5, DegreePlanId = 5431, Term = 5, TermAbbr = "s20", TermName = "Spring2020" }, new StudentTerm { StudentTermId = 6, DegreePlanId = 5431, Term = 1, TermAbbr = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermId = 7, DegreePlanId = 5431, Term = 2, TermAbbr = "s20", TermName = "Spring2020" }, new StudentTerm { StudentTermId = 8, DegreePlanId = 5431, Term = 3, TermAbbr = "Su20", TermName = "Summer2020" }, new StudentTerm { StudentTermId = 9, DegreePlanId = 5431, Term = 4, TermAbbr = "F20", TermName = "Fall2020" }, new StudentTerm { StudentTermId = 10, DegreePlanId = 5431, Term = 5, TermAbbr = "S21", TermName = "Spring2021" }, new StudentTerm { StudentTermId = 11, DegreePlanId = 5431, Term = 1, TermAbbr = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermId = 12, DegreePlanId = 5431, Term = 2, TermAbbr = "Su19", TermName = "Summer2019" }, new StudentTerm { StudentTermId = 13, DegreePlanId = 5431, Term = 3, TermAbbr = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermId = 14, DegreePlanId = 5431, Term = 4, TermAbbr = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermId = 15, DegreePlanId = 5431, Term = 5, TermAbbr = "Su20", TermName = "Summer2020" }, }; Console.WriteLine($"Inserted {studentTerms.Length} new student terms."); foreach (StudentTerm d in studentTerms) { context.StudentTerms.Add(d); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { context.Database.EnsureCreated(); //for Degree Requirement - MEHAR CHOUDHARY if (context.Degrees.Any()) { Console.WriteLine("Degrees already exists."); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbbr = "ACS+2", NumberOfTerms = 5 }, new Degree { DegreeId = 2, DegreeAbbr = "ACS+DB", NumberOfTerms = 5 }, new Degree { DegreeId = 3, DegreeAbbr = "ACS+NF", NumberOfTerms = 5 }, new Degree { DegreeId = 4, DegreeAbbr = "ACS", NumberOfTerms = 5 }, }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } //for Credits - Aakash if (context.Credits.Any()) { Console.WriteLine("Credits already exist."); } else { var credit = new Credit[] { new Credit { CreditId = 460, CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 356, CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 542, CreditName = "OOPS with Java", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 563, CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 560, CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 664, CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 618, CreditName = "Project Management", IsSummer = 1, IsSpring = 0, IsFall = 0 }, new Credit { CreditId = 555, CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 691, CreditName = "GDP1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 692, CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 6, CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 10, CreditName = "Elective 1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 20, CreditName = "Elective 2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, }; Console.WriteLine($"Inserted {credit.Length} new credits."); foreach (Credit d in credit) { context.Credits.Add(d); } context.SaveChanges(); } //for DegreeCredit - Mehar Choudhary if (context.DegreeCredits.Any()) { Console.WriteLine("DegreeCredits already exist."); } else { var degreeCredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditId = 1, DegreeId = 1, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 2, DegreeId = 1, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 3, DegreeId = 1, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 4, DegreeId = 1, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 5, DegreeId = 1, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 6, DegreeId = 1, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 7, DegreeId = 1, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 8, DegreeId = 1, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 9, DegreeId = 1, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 10, DegreeId = 1, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 11, DegreeId = 1, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 12, DegreeId = 1, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 13, DegreeId = 1, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 14, DegreeId = 2, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 15, DegreeId = 2, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 16, DegreeId = 2, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 17, DegreeId = 2, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 18, DegreeId = 2, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 19, DegreeId = 2, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 20, DegreeId = 2, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 21, DegreeId = 2, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 22, DegreeId = 2, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 23, DegreeId = 2, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 24, DegreeId = 2, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 25, DegreeId = 2, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 26, DegreeId = 3, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 27, DegreeId = 3, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 28, DegreeId = 3, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 29, DegreeId = 3, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 30, DegreeId = 3, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 31, DegreeId = 3, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 32, DegreeId = 3, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 33, DegreeId = 3, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 34, DegreeId = 3, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 35, DegreeId = 3, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 36, DegreeId = 3, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 37, DegreeId = 3, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 38, DegreeId = 4, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 39, DegreeId = 4, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 40, DegreeId = 4, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 41, DegreeId = 4, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 42, DegreeId = 4, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 43, DegreeId = 4, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 44, DegreeId = 4, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 45, DegreeId = 4, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 46, DegreeId = 4, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 47, DegreeId = 4, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 48, DegreeId = 4, CreditId = 20 }, }; Console.WriteLine($"Inserted {degreeCredits.Length} new degree credits."); foreach (DegreeCredit d in degreeCredits) { context.DegreeCredits.Add(d); } context.SaveChanges(); } //for Student Id- Dasari if (context.Students.Any()) { Console.WriteLine("Students already exist."); } else { var students = new Student[] { new Student { StudentId = 533904, Family = "Peddi", Given = "Tarak", Snumber = "S533904", N919 = 91957050 }, new Student { StudentId = 533976, Family = "Meenavilli", Given = "Mehar Choudhary", Snumber = "S533976", N919 = 919571539 }, new Student { StudentId = 533489, Family = "Dasari", Given = "Venkat", Snumber = "S533489", N919 = 919568241 }, new Student { StudentId = 533714, Family = "Valluru", Given = "Aakash", Snumber = "S533714", N919 = 919568635 }, }; Console.WriteLine($"Inserted {students.Length} new students."); foreach (Student d in students) { context.Students.Add(d); } context.SaveChanges(); } //for DegreePlan - Aakash if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exist."); } else { var degreePlans = new DegreePlan[] { new DegreePlan { DegreePlanId = 1234, StudentId = 533904, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1 }, new DegreePlan { DegreePlanId = 1235, StudentId = 533904, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2 }, new DegreePlan { DegreePlanId = 1236, StudentId = 533489, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2 }, new DegreePlan { DegreePlanId = 1237, StudentId = 533489, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1 }, new DegreePlan { DegreePlanId = 1238, StudentId = 533976, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1 }, new DegreePlan { DegreePlanId = 1239, StudentId = 533976, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2 }, new DegreePlan { DegreePlanId = 1240, StudentId = 533714, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2 }, new DegreePlan { DegreePlanId = 1241, StudentId = 533714, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1 }, }; Console.WriteLine($"Inserted {degreePlans.Length} new Degree Plans."); foreach (DegreePlan d in degreePlans) { context.DegreePlans.Add(d); } context.SaveChanges(); } //for Slot - Raviteja if (context.Slots.Any()) { Console.WriteLine("Slots already exist."); } else { var slots = new Slot[] { new Slot { SlotId = 1, DegreePlanId = 1235, Term = 1, CreditId = 542, Status = "C" }, new Slot { SlotId = 2, DegreePlanId = 1235, Term = 1, CreditId = 563, Status = "C" }, new Slot { SlotId = 3, DegreePlanId = 1235, Term = 1, CreditId = 560, Status = "C" }, new Slot { SlotId = 4, DegreePlanId = 1235, Term = 2, CreditId = 664, Status = "A" }, new Slot { SlotId = 5, DegreePlanId = 1235, Term = 2, CreditId = 6, Status = "A" }, new Slot { SlotId = 6, DegreePlanId = 1235, Term = 2, CreditId = 10, Status = "A" }, new Slot { SlotId = 7, DegreePlanId = 1235, Term = 3, CreditId = 618, Status = "P" }, new Slot { SlotId = 8, DegreePlanId = 1235, Term = 3, CreditId = 691, Status = "P" }, new Slot { SlotId = 9, DegreePlanId = 1235, Term = 4, CreditId = 692, Status = "P" }, new Slot { SlotId = 10, DegreePlanId = 1235, Term = 4, CreditId = 20, Status = "P" }, new Slot { SlotId = 11, DegreePlanId = 1235, Term = 4, CreditId = 555, Status = "P" }, new Slot { SlotId = 12, DegreePlanId = 1236, Term = 1, CreditId = 542, Status = "A" }, new Slot { SlotId = 13, DegreePlanId = 1236, Term = 1, CreditId = 563, Status = "A" }, new Slot { SlotId = 14, DegreePlanId = 1236, Term = 1, CreditId = 560, Status = "A" }, new Slot { SlotId = 15, DegreePlanId = 1236, Term = 2, CreditId = 664, Status = "P" }, new Slot { SlotId = 16, DegreePlanId = 1236, Term = 2, CreditId = 6, Status = "P" }, new Slot { SlotId = 17, DegreePlanId = 1236, Term = 2, CreditId = 10, Status = "P" }, new Slot { SlotId = 18, DegreePlanId = 1236, Term = 3, CreditId = 20, Status = "P" }, new Slot { SlotId = 19, DegreePlanId = 1236, Term = 3, CreditId = 555, Status = "P" }, new Slot { SlotId = 20, DegreePlanId = 1236, Term = 3, CreditId = 691, Status = "P" }, new Slot { SlotId = 21, DegreePlanId = 1236, Term = 4, CreditId = 618, Status = "P" }, new Slot { SlotId = 22, DegreePlanId = 1236, Term = 4, CreditId = 692, Status = "P" }, new Slot { SlotId = 23, DegreePlanId = 1239, Term = 1, CreditId = 542, Status = "C" }, new Slot { SlotId = 24, DegreePlanId = 1239, Term = 1, CreditId = 563, Status = "C" }, new Slot { SlotId = 25, DegreePlanId = 1239, Term = 1, CreditId = 560, Status = "C" }, new Slot { SlotId = 26, DegreePlanId = 1239, Term = 2, CreditId = 664, Status = "A" }, new Slot { SlotId = 27, DegreePlanId = 1239, Term = 2, CreditId = 6, Status = "A" }, new Slot { SlotId = 28, DegreePlanId = 1239, Term = 2, CreditId = 10, Status = "A" }, new Slot { SlotId = 29, DegreePlanId = 1239, Term = 3, CreditId = 618, Status = "P" }, new Slot { SlotId = 30, DegreePlanId = 1239, Term = 4, CreditId = 691, Status = "P" }, new Slot { SlotId = 31, DegreePlanId = 1239, Term = 4, CreditId = 20, Status = "P" }, new Slot { SlotId = 32, DegreePlanId = 1239, Term = 5, CreditId = 692, Status = "P" }, new Slot { SlotId = 33, DegreePlanId = 1239, Term = 5, CreditId = 555, Status = "P" }, new Slot { SlotId = 34, DegreePlanId = 1240, Term = 1, CreditId = 542, Status = "A" }, new Slot { SlotId = 35, DegreePlanId = 1240, Term = 1, CreditId = 563, Status = "A" }, new Slot { SlotId = 36, DegreePlanId = 1240, Term = 1, CreditId = 560, Status = "A" }, new Slot { SlotId = 37, DegreePlanId = 1240, Term = 2, CreditId = 664, Status = "P" }, new Slot { SlotId = 38, DegreePlanId = 1240, Term = 2, CreditId = 6, Status = "P" }, new Slot { SlotId = 39, DegreePlanId = 1240, Term = 2, CreditId = 10, Status = "P" }, new Slot { SlotId = 40, DegreePlanId = 1240, Term = 3, CreditId = 20, Status = "P" }, new Slot { SlotId = 41, DegreePlanId = 1240, Term = 3, CreditId = 555, Status = "P" }, new Slot { SlotId = 42, DegreePlanId = 1240, Term = 3, CreditId = 691, Status = "P" }, new Slot { SlotId = 43, DegreePlanId = 1240, Term = 4, CreditId = 618, Status = "P" }, new Slot { SlotId = 44, DegreePlanId = 1240, Term = 4, CreditId = 692, Status = "P" }, }; Console.WriteLine($"Inserted {slots.Length} new slots."); foreach (Slot d in slots) { context.Slots.Add(d); } context.SaveChanges(); } //for StudentTerm - Raviteja if (context.Terms.Any()) { Console.WriteLine("Student Terms already exist."); } else { var studentTerms = new StudentTerm[] { new StudentTerm { StudentTermId = 1, StudentId = 533904, Term = 1, TermAbbr = "F18", TermName = "Fall 2018" }, new StudentTerm { StudentTermId = 2, StudentId = 533904, Term = 2, TermAbbr = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermId = 3, StudentId = 533904, Term = 3, TermAbbr = "Su19", TermName = "Summer 2019" }, new StudentTerm { StudentTermId = 4, StudentId = 533904, Term = 4, TermAbbr = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermId = 5, StudentId = 533489, Term = 3, TermAbbr = "S18", TermName = "Spring 2018" }, new StudentTerm { StudentTermId = 6, StudentId = 533489, Term = 4, TermAbbr = "Su18", TermName = "Summer 2018" }, new StudentTerm { StudentTermId = 7, StudentId = 533489, Term = 5, TermAbbr = "F18", TermName = "Fall 2018" }, new StudentTerm { StudentTermId = 8, StudentId = 533489, Term = 6, TermAbbr = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermId = 9, StudentId = 533976, Term = 1, TermAbbr = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermId = 10, StudentId = 533976, Term = 2, TermAbbr = "S20", TermName = "Spring 2020" }, new StudentTerm { StudentTermId = 11, StudentId = 533976, Term = 3, TermAbbr = "Su20", TermName = "Summer 2020" }, new StudentTerm { StudentTermId = 12, StudentId = 533976, Term = 4, TermAbbr = "F20", TermName = "Fall 2020" }, new StudentTerm { StudentTermId = 13, StudentId = 533714, Term = 3, TermAbbr = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermId = 14, StudentId = 533714, Term = 4, TermAbbr = "Su19", TermName = "Summer 2019" }, new StudentTerm { StudentTermId = 15, StudentId = 533714, Term = 5, TermAbbr = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermId = 16, StudentId = 533714, Term = 6, TermAbbr = "S20", TermName = "Spring 2020" }, }; Console.WriteLine($"Inserted {studentTerms.Length} new student terms."); foreach (StudentTerm d in studentTerms) { context.Terms.Add(d); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { if (context.Slots.Any()) { Console.WriteLine("Slots already exist"); } else { var slots = new Slot[] { //new Slot{SlotID =1,DegreePlan =7255,Term=1,CreditID=356,Status='B'}, //new Slot{SlotID =2,DegreePlan =7255,Term=1,CreditID=542,Status='B'}, new Slot { SlotID = 1, DegreePlanID = 7255, Term = 1, CreditID = 356, Status = B }, new Slot { SlotID = 2, DegreePlanID = 7255, Term = 1, CreditID = 542, Status = B }, new Slot { SlotID = 3, DegreePlanID = 7255, Term = 1, CreditID = 563, Status = C }, new Slot { SlotID = 4, DegreePlanID = 7255, Term = 2, CreditID = 560, Status = C }, new Slot { SlotID = 5, DegreePlanID = 7255, Term = 2, CreditID = 664, Status = B }, new Slot { SlotID = 6, DegreePlanID = 7255, Term = 2, CreditID = 6, Status = B }, new Slot { SlotID = 7, DegreePlanID = 7255, Term = 3, CreditID = 618, Status = B }, new Slot { SlotID = 8, DegreePlanID = 7255, Term = 3, CreditID = 691, Status = B }, new Slot { SlotID = 9, DegreePlanID = 7255, Term = 3, CreditID = 10, Status = B }, new Slot { SlotID = 10, DegreePlanID = 7255, Term = 4, CreditID = 20, Status = B }, new Slot { SlotID = 11, DegreePlanID = 7255, Term = 4, CreditID = 692, Status = B }, new Slot { SlotID = 12, DegreePlanID = 7255, Term = 4, CreditID = 555, Status = B }, new Slot { SlotID = 13, DegreePlanID = 7256, Term = 1, CreditID = 356, Status = B }, new Slot { SlotID = 14, DegreePlanID = 7256, Term = 1, CreditID = 542, Status = B }, new Slot { SlotID = 15, DegreePlanID = 7256, Term = 1, CreditID = 563, Status = B }, new Slot { SlotID = 16, DegreePlanID = 7256, Term = 2, CreditID = 560, Status = B }, new Slot { SlotID = 17, DegreePlanID = 7256, Term = 2, CreditID = 664, Status = B }, new Slot { SlotID = 18, DegreePlanID = 7256, Term = 2, CreditID = 6, Status = B }, new Slot { SlotID = 19, DegreePlanID = 7256, Term = 3, CreditID = 618, Status = B }, new Slot { SlotID = 20, DegreePlanID = 7256, Term = 3, CreditID = 691, Status = B }, new Slot { SlotID = 21, DegreePlanID = 7256, Term = 3, CreditID = 10, Status = B }, new Slot { SlotID = 22, DegreePlanID = 7256, Term = 4, CreditID = 20, Status = B }, new Slot { SlotID = 23, DegreePlanID = 7256, Term = 4, CreditID = 692, Status = B }, new Slot { SlotID = 24, DegreePlanID = 7256, Term = 4, CreditID = 555, Status = B }, new Slot { SlotID = 25, DegreePlanID = 7259, Term = 1, CreditID = 356, Status = B }, new Slot { SlotID = 26, DegreePlanID = 7259, Term = 1, CreditID = 542, Status = B }, new Slot { SlotID = 27, DegreePlanID = 7259, Term = 1, CreditID = 563, Status = C }, new Slot { SlotID = 28, DegreePlanID = 7259, Term = 2, CreditID = 560, Status = C }, new Slot { SlotID = 29, DegreePlanID = 7259, Term = 2, CreditID = 10, Status = A }, new Slot { SlotID = 30, DegreePlanID = 7259, Term = 2, CreditID = 6, Status = A }, new Slot { SlotID = 31, DegreePlanID = 7259, Term = 3, CreditID = 618, Status = A }, new Slot { SlotID = 32, DegreePlanID = 7259, Term = 4, CreditID = 691, Status = A }, new Slot { SlotID = 33, DegreePlanID = 7259, Term = 4, CreditID = 20, Status = A }, new Slot { SlotID = 34, DegreePlanID = 7259, Term = 5, CreditID = 692, Status = A }, new Slot { SlotID = 35, DegreePlanID = 7259, Term = 5, CreditID = 555, Status = A }, new Slot { SlotID = 36, DegreePlanID = 7259, Term = 5, CreditID = 664, Status = A }, new Slot { SlotID = 37, DegreePlanID = 7260, Term = 1, CreditID = 356, Status = A }, new Slot { SlotID = 38, DegreePlanID = 7260, Term = 1, CreditID = 542, Status = A }, new Slot { SlotID = 39, DegreePlanID = 7260, Term = 1, CreditID = 563, Status = A }, new Slot { SlotID = 40, DegreePlanID = 7260, Term = 2, CreditID = 560, Status = A }, new Slot { SlotID = 41, DegreePlanID = 7260, Term = 2, CreditID = 10, Status = A }, new Slot { SlotID = 42, DegreePlanID = 7260, Term = 2, CreditID = 6, Status = A }, new Slot { SlotID = 43, DegreePlanID = 7260, Term = 4, CreditID = 691, Status = A }, new Slot { SlotID = 44, DegreePlanID = 7260, Term = 4, CreditID = 20, Status = A }, new Slot { SlotID = 45, DegreePlanID = 7260, Term = 5, CreditID = 692, Status = A }, new Slot { SlotID = 46, DegreePlanID = 7260, Term = 5, CreditID = 555, Status = A }, new Slot { SlotID = 47, DegreePlanID = 7260, Term = 5, CreditID = 664, Status = A }, new Slot { SlotID = 48, DegreePlanID = 7260, Term = 3, CreditID = 618, Status = A }, new Slot { SlotID = 50, DegreePlanID = 7261, Term = 1, CreditID = 542, Status = B }, new Slot { SlotID = 51, DegreePlanID = 7261, Term = 1, CreditID = 563, Status = B }, new Slot { SlotID = 52, DegreePlanID = 7261, Term = 1, CreditID = 356, Status = C }, new Slot { SlotID = 53, DegreePlanID = 7261, Term = 1, CreditID = 560, Status = C }, new Slot { SlotID = 54, DegreePlanID = 7261, Term = 2, CreditID = 664, Status = B }, new Slot { SlotID = 55, DegreePlanID = 7261, Term = 2, CreditID = 6, Status = B }, new Slot { SlotID = 56, DegreePlanID = 7261, Term = 2, CreditID = 10, Status = B }, new Slot { SlotID = 57, DegreePlanID = 7261, Term = 3, CreditID = 20, Status = B }, new Slot { SlotID = 58, DegreePlanID = 7261, Term = 3, CreditID = 691, Status = B }, new Slot { SlotID = 59, DegreePlanID = 7261, Term = 3, CreditID = 618, Status = B }, new Slot { SlotID = 60, DegreePlanID = 7261, Term = 4, CreditID = 555, Status = B }, new Slot { SlotID = 61, DegreePlanID = 7261, Term = 4, CreditID = 692, Status = B }, new Slot { SlotID = 62, DegreePlanID = 7262, Term = 1, CreditID = 542, Status = B }, new Slot { SlotID = 63, DegreePlanID = 7262, Term = 1, CreditID = 563, Status = B }, new Slot { SlotID = 64, DegreePlanID = 7262, Term = 1, CreditID = 356, Status = C }, new Slot { SlotID = 65, DegreePlanID = 7262, Term = 1, CreditID = 560, Status = C }, new Slot { SlotID = 66, DegreePlanID = 7262, Term = 2, CreditID = 664, Status = B }, new Slot { SlotID = 67, DegreePlanID = 7262, Term = 2, CreditID = 6, Status = B }, new Slot { SlotID = 68, DegreePlanID = 7262, Term = 2, CreditID = 10, Status = B }, new Slot { SlotID = 69, DegreePlanID = 7262, Term = 3, CreditID = 20, Status = B }, new Slot { SlotID = 70, DegreePlanID = 7262, Term = 3, CreditID = 691, Status = B }, new Slot { SlotID = 71, DegreePlanID = 7262, Term = 3, CreditID = 618, Status = B }, new Slot { SlotID = 72, DegreePlanID = 7262, Term = 4, CreditID = 555, Status = B }, new Slot { SlotID = 73, DegreePlanID = 7262, Term = 4, CreditID = 692, Status = B }, new Slot { SlotID = 74, DegreePlanID = 7253, Term = 1, CreditID = 542, Status = C }, new Slot { SlotID = 75, DegreePlanID = 7253, Term = 1, CreditID = 356, Status = C }, new Slot { SlotID = 76, DegreePlanID = 7253, Term = 1, CreditID = 563, Status = C }, new Slot { SlotID = 77, DegreePlanID = 7253, Term = 2, CreditID = 560, Status = A }, new Slot { SlotID = 78, DegreePlanID = 7253, Term = 2, CreditID = 6, Status = A }, new Slot { SlotID = 79, DegreePlanID = 7253, Term = 2, CreditID = 555, Status = A }, new Slot { SlotID = 80, DegreePlanID = 7253, Term = 3, CreditID = 664, Status = P }, new Slot { SlotID = 81, DegreePlanID = 7253, Term = 3, CreditID = 691, Status = P }, new Slot { SlotID = 82, DegreePlanID = 7253, Term = 3, CreditID = 618, Status = P }, new Slot { SlotID = 83, DegreePlanID = 7253, Term = 4, CreditID = 692, Status = P }, new Slot { SlotID = 84, DegreePlanID = 7253, Term = 4, CreditID = 10, Status = P }, new Slot { SlotID = 85, DegreePlanID = 7253, Term = 4, CreditID = 20, Status = P }, new Slot { SlotID = 86, DegreePlanID = 7254, Term = 1, CreditID = 356, Status = C }, new Slot { SlotID = 87, DegreePlanID = 7254, Term = 1, CreditID = 542, Status = C }, new Slot { SlotID = 88, DegreePlanID = 7254, Term = 1, CreditID = 563, Status = C }, new Slot { SlotID = 89, DegreePlanID = 7254, Term = 2, CreditID = 560, Status = A }, new Slot { SlotID = 90, DegreePlanID = 7254, Term = 2, CreditID = 664, Status = A }, new Slot { SlotID = 91, DegreePlanID = 7254, Term = 2, CreditID = 6, Status = A }, new Slot { SlotID = 92, DegreePlanID = 7254, Term = 3, CreditID = 691, Status = P }, new Slot { SlotID = 93, DegreePlanID = 7254, Term = 3, CreditID = 10, Status = P }, new Slot { SlotID = 94, DegreePlanID = 7254, Term = 3, CreditID = 20, Status = P }, new Slot { SlotID = 95, DegreePlanID = 7254, Term = 4, CreditID = 618, Status = P }, new Slot { SlotID = 96, DegreePlanID = 7254, Term = 5, CreditID = 692, Status = P }, new Slot { SlotID = 97, DegreePlanID = 7254, Term = 5, CreditID = 555, Status = P }, new Slot { SlotID = 98, DegreePlanID = 7257, Term = 1, CreditID = 356, Status = A }, new Slot { SlotID = 99, DegreePlanID = 7257, Term = 1, CreditID = 563, Status = A }, new Slot { SlotID = 100, DegreePlanID = 7257, Term = 1, CreditID = 542, Status = A }, new Slot { SlotID = 101, DegreePlanID = 7257, Term = 1, CreditID = 560, Status = A }, new Slot { SlotID = 102, DegreePlanID = 7257, Term = 2, CreditID = 6, Status = A }, new Slot { SlotID = 103, DegreePlanID = 7257, Term = 2, CreditID = 664, Status = A }, new Slot { SlotID = 104, DegreePlanID = 7257, Term = 2, CreditID = 10, Status = A }, new Slot { SlotID = 105, DegreePlanID = 7257, Term = 3, CreditID = 618, Status = A }, new Slot { SlotID = 106, DegreePlanID = 7257, Term = 3, CreditID = 691, Status = A }, new Slot { SlotID = 107, DegreePlanID = 7257, Term = 4, CreditID = 692, Status = A }, new Slot { SlotID = 108, DegreePlanID = 7257, Term = 4, CreditID = 555, Status = A }, new Slot { SlotID = 109, DegreePlanID = 7257, Term = 4, CreditID = 20, Status = A }, new Slot { SlotID = 110, DegreePlanID = 7258, Term = 1, CreditID = 356, Status = A }, new Slot { SlotID = 111, DegreePlanID = 7258, Term = 1, CreditID = 563, Status = A }, new Slot { SlotID = 112, DegreePlanID = 7258, Term = 1, CreditID = 542, Status = A }, new Slot { SlotID = 113, DegreePlanID = 7258, Term = 1, CreditID = 560, Status = A }, new Slot { SlotID = 114, DegreePlanID = 7258, Term = 2, CreditID = 6, Status = A }, new Slot { SlotID = 115, DegreePlanID = 7258, Term = 2, CreditID = 664, Status = A }, new Slot { SlotID = 116, DegreePlanID = 7258, Term = 2, CreditID = 10, Status = A }, new Slot { SlotID = 117, DegreePlanID = 7258, Term = 3, CreditID = 691, Status = A }, new Slot { SlotID = 118, DegreePlanID = 7258, Term = 3, CreditID = 20, Status = A }, new Slot { SlotID = 119, DegreePlanID = 7258, Term = 4, CreditID = 692, Status = A }, new Slot { SlotID = 120, DegreePlanID = 7258, Term = 4, CreditID = 555, Status = A }, new Slot { SlotID = 121, DegreePlanID = 7258, Term = 5, CreditID = 618, Status = A }, }; Console.WriteLine($"Inserted{slots.Length} new slots."); foreach (Slot s in slots) { context.Slots.Add(s); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Students already exist"); } else { var students = new Student[] { new Student { StudentID = 533491, LastName = "Pasham", FirstName = "Goutami", _919 = 919564044 }, new Student { StudentID = 533705, LastName = "Adusumalli", FirstName = "Gangadhar", _919 = 919570593 }, new Student { StudentID = 533988, LastName = "Singam", FirstName = "Poojitha", _919 = 919571721 }, new Student { StudentID = 533622, LastName = "Gattu", FirstName = "Srujana", _919 = 919569251 }, new Student { StudentID = 533727, LastName = "Poshala", FirstName = "Himabindu", _919 = 919571930 } }; Console.WriteLine($"Inserted{students.Length} new students."); foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); } if (context.Credits.Any()) { Console.WriteLine("Credits already exist"); } else { var credits = new Credit[] { new Credit { CreditID = 356, CreditAbbrev = "NF", CreditName = "Network Fundamentals", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 542, CreditAbbrev = "542", CreditName = "OOPS with JAVA", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 563, CreditAbbrev = "563", CreditName = "Web Apps", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 560, CreditAbbrev = "560-ADB", CreditName = "Advanced Databases", IsSummer = 1, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 664, CreditAbbrev = "664-UX", CreditName = "User Experience Design", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 618, CreditAbbrev = "618-PM", CreditName = "Project Management", IsSummer = 1, ISSpring = 0, IsFall = 0 }, new Credit { CreditID = 555, CreditAbbrev = "555-NS", CreditName = "Network Security", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 691, CreditAbbrev = "691-GDP1", CreditName = "GDP1", IsSummer = 1, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 692, CreditAbbrev = "692-GDP2", CreditName = "GDP2", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 6, CreditAbbrev = "MOBILE", CreditName = "643 or 644 Mobile", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 10, CreditAbbrev = "E1", CreditName = "Elective1", IsSummer = 0, ISSpring = 1, IsFall = 1 }, new Credit { CreditID = 20, CreditAbbrev = "E2", CreditName = "Elective2", IsSummer = 0, ISSpring = 1, IsFall = 1 } }; Console.WriteLine($"Inserted{credits.Length} new credit."); foreach (Credit s in credits) { context.Credits.Add(s); } context.SaveChanges(); } if (context.Degrees.Any()) { Console.WriteLine("Degreess already exist"); } else { var degrees = new Degree[] { new Degree { DegreeID = 1, DegreeAbbrev = "ACS+2", DegreeName = "Ms ACS+2", NumberOFTerms = 5 }, new Degree { DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "Ms ACS+DB", NumberOFTerms = 5 }, new Degree { DegreeID = 3, DegreeAbbrev = "ACS+NF", DegreeName = "Ms ACS+NF", NumberOFTerms = 5 }, new Degree { DegreeID = 4, DegreeAbbrev = "ACS", DegreeName = "Ms ACS", NumberOFTerms = 5 } }; Console.WriteLine($"Inserted{degrees.Length} new degree."); foreach (Degree s in degrees) { context.Degrees.Add(s); } context.SaveChanges(); } if (context.DegreeCredits.Any()) { Console.WriteLine("Degrees credit already exist"); } else { var degreecredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditID = 1, DegreeID = 1, CreditID = 460 }, new DegreeCredit { DegreeCreditID = 2, DegreeID = 1, CreditID = 356 }, new DegreeCredit { DegreeCreditID = 3, DegreeID = 1, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 4, DegreeID = 1, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 5, DegreeID = 1, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 6, DegreeID = 1, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 7, DegreeID = 1, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 8, DegreeID = 1, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 9, DegreeID = 1, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 10, DegreeID = 1, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 11, DegreeID = 1, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 12, DegreeID = 1, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 13, DegreeID = 1, CreditID = 20 }, new DegreeCredit { DegreeCreditID = 14, DegreeID = 2, CreditID = 460 }, new DegreeCredit { DegreeCreditID = 15, DegreeID = 2, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 16, DegreeID = 2, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 17, DegreeID = 2, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 18, DegreeID = 2, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 19, DegreeID = 2, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 20, DegreeID = 2, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 21, DegreeID = 2, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 22, DegreeID = 2, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 23, DegreeID = 2, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 24, DegreeID = 2, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 25, DegreeID = 2, CreditID = 20 }, new DegreeCredit { DegreeCreditID = 26, DegreeID = 3, CreditID = 356 }, new DegreeCredit { DegreeCreditID = 27, DegreeID = 3, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 28, DegreeID = 3, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 29, DegreeID = 3, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 30, DegreeID = 3, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 31, DegreeID = 3, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 32, DegreeID = 3, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 33, DegreeID = 3, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 34, DegreeID = 3, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 35, DegreeID = 3, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 36, DegreeID = 3, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 37, DegreeID = 3, CreditID = 20 }, new DegreeCredit { DegreeCreditID = 38, DegreeID = 4, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 39, DegreeID = 4, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 40, DegreeID = 4, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 41, DegreeID = 4, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 42, DegreeID = 4, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 43, DegreeID = 4, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 44, DegreeID = 4, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 45, DegreeID = 4, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 46, DegreeID = 4, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 47, DegreeID = 4, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 48, DegreeID = 4, CreditID = 20 } }; Console.WriteLine($"Inserted{degreecredits.Length} new degree."); foreach (DegreeCredit s in degreecredits) { context.DegreeCredits.Add(s); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Degreess already exist"); } else { var studentterms = new StudentTerm[] { new StudentTerm { StudentTermID = 1, DegreePlanId = 7255, Term = 1, TermAbbrev = "F18", TermName = "Fall2018" }, new StudentTerm { StudentTermID = 2, DegreePlanId = 7255, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 3, DegreePlanId = 7255, Term = 3, TermAbbrev = "Sum", TermName = "Summer2019" }, new StudentTerm { StudentTermID = 4, DegreePlanId = 7255, Term = 4, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 5, DegreePlanId = 7256, Term = 1, TermAbbrev = "F18", TermName = "Fall2018" }, new StudentTerm { StudentTermID = 6, DegreePlanId = 7256, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 7, DegreePlanId = 7256, Term = 3, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 8, DegreePlanId = 7256, Term = 4, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 9, DegreePlanId = 7261, Term = 1, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 10, DegreePlanId = 7261, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020" }, new StudentTerm { StudentTermID = 11, DegreePlanId = 7261, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020" }, new StudentTerm { StudentTermID = 12, DegreePlanId = 7261, Term = 4, TermAbbrev = "F20", TermName = "Fall2020" }, new StudentTerm { StudentTermID = 13, DegreePlanId = 7262, Term = 1, TermAbbrev = "F19", TermName = "FALL2019" }, new StudentTerm { StudentTermID = 14, DegreePlanId = 7262, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020" }, new StudentTerm { StudentTermID = 15, DegreePlanId = 7262, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020" }, new StudentTerm { StudentTermID = 16, DegreePlanId = 7262, Term = 4, TermAbbrev = "F20", TermName = "FALL2020" }, new StudentTerm { StudentTermID = 17, DegreePlanId = 7262, Term = 5, TermAbbrev = "S21", TermName = "SPRING2021" }, new StudentTerm { StudentTermID = 18, DegreePlanId = 7259, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 19, DegreePlanId = 7259, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 20, DegreePlanId = 7259, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019" }, new StudentTerm { StudentTermID = 21, DegreePlanId = 7259, Term = 4, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 22, DegreePlanId = 7259, Term = 5, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 23, DegreePlanId = 7260, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 24, DegreePlanId = 7260, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 25, DegreePlanId = 7260, Term = 3, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 26, DegreePlanId = 7260, Term = 4, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 27, DegreePlanId = 7260, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020" }, new StudentTerm { StudentTermID = 28, DegreePlanId = 7257, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 29, DegreePlanId = 7257, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 30, DegreePlanId = 7257, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019" }, new StudentTerm { StudentTermID = 31, DegreePlanId = 7257, Term = 4, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 32, DegreePlanId = 7258, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 33, DegreePlanId = 7258, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 34, DegreePlanId = 7258, Term = 3, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 35, DegreePlanId = 7258, Term = 4, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 36, DegreePlanId = 7258, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020" }, new StudentTerm { StudentTermID = 37, DegreePlanId = 7253, Term = 1, TermAbbrev = "F 2018", TermName = "Fall 2018" }, new StudentTerm { StudentTermID = 38, DegreePlanId = 7253, Term = 2, TermAbbrev = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermID = 39, DegreePlanId = 7253, Term = 3, TermAbbrev = "Sum19", TermName = "Summer 2019" }, new StudentTerm { StudentTermID = 40, DegreePlanId = 7253, Term = 4, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 41, DegreePlanId = 7254, Term = 1, TermAbbrev = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermID = 42, DegreePlanId = 7254, Term = 2, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 43, DegreePlanId = 7254, Term = 3, TermAbbrev = "S20", TermName = "Spring 2020" }, new StudentTerm { StudentTermID = 44, DegreePlanId = 7254, Term = 4, TermAbbrev = "Sum20", TermName = "Summer 2020" }, new StudentTerm { StudentTermID = 45, DegreePlanId = 7254, Term = 5, TermAbbrev = "F20", TermName = "Fall 2020" }, }; Console.WriteLine($"Inserted{studentterms.Length} new student terms."); foreach (StudentTerm s in studentterms) { context.Degrees.Add(s); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("DegreePlans already exist"); } else { var degreeplans = new DegreePlan[] { new DegreePlan { DegreePlanID = 7253, StudentID = 533705, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7254, StudentID = 533705, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7255, StudentID = 533491, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7256, StudentID = 533491, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7257, StudentID = 533727, DegreePlanAbbrev = "SuperFast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7258, StudentID = 533727, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7259, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7260, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7261, StudentID = 533988, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7262, StudentID = 533988, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 } }; Console.WriteLine($"Inserted{degreeplans.Length} new degree plan."); foreach (DegreePlan s in degreeplans) { context.DegreePlans.Add(s); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { //context.Database.EnsureCreated(); // Look for any Degrees. if (context.Degrees.Any()) { Console.WriteLine("Degrees already exist."); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbrrev = "ACS+2", DegreeName = "MS ACS +2" }, new Degree { DegreeId = 2, DegreeAbrrev = "ACS+DB", DegreeName = "MS ACS + DB" }, new Degree { DegreeId = 3, DegreeAbrrev = "ACS+NF", DegreeName = "MS ACS+ NF" }, new Degree { DegreeId = 4, DegreeAbrrev = "ACS", DegreeName = "MS ACS" } }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } if (context.Requirements.Any()) { Console.WriteLine("Requirements already exist."); } else { var requirements = new Requirement[] { new Requirement { RequirementID = 460, RequirementAbbrev = "DB", CourseName = "44-460 Database" }, new Requirement { RequirementID = 356, RequirementAbbrev = "NF", CourseName = "44-356 Network Fundamentals" }, new Requirement { RequirementID = 542, RequirementAbbrev = "OOP", CourseName = "44-542 Object Oriented Programming" }, new Requirement { RequirementID = 563, RequirementAbbrev = "Web apps", CourseName = "44-563 Web apps" }, new Requirement { RequirementID = 560, RequirementAbbrev = "ADB", CourseName = "44-560 Advance Database topics" }, new Requirement { RequirementID = 555, RequirementAbbrev = "NS", CourseName = "44-555 Network Security" }, new Requirement { RequirementID = 618, RequirementAbbrev = "PM", CourseName = "44-618 Project Management" }, new Requirement { RequirementID = 1, RequirementAbbrev = "MC", CourseName = "Mobile Computing ios" }, new Requirement { RequirementID = 664, RequirementAbbrev = "UXD", CourseName = "44-664 User Experience Design" }, new Requirement { RequirementID = 10, RequirementAbbrev = "E1", CourseName = "Elective 1" }, new Requirement { RequirementID = 20, RequirementAbbrev = "E2", CourseName = "Elective 2" }, new Requirement { RequirementID = 691, RequirementAbbrev = "GDP1", CourseName = "GDP1" }, new Requirement { RequirementID = 692, RequirementAbbrev = "GDP2", CourseName = "GDP2" } }; Console.WriteLine($"Inserted {requirements.Length} new reuirements."); foreach (Requirement d in requirements) { context.Requirements.Add(d); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Students already exist."); } else { var student = new Student[] { new Student { StudentId = 531382, First = "Sreelekha", Last = "Vijaya", Snumber = "S531382", catpawsnum = 919562176 }, new Student { StudentId = 531496, First = "Shivani Reddy", Last = "Dodla", Snumber = "S531496", catpawsnum = 919565950 }, new Student { StudentId = 531378, First = "Lokeswari", Last = "Pittu", Snumber = "S531378", catpawsnum = 919563259 }, new Student { StudentId = 534051, First = "Abhinay", Last = "Kaitha", Snumber = "S534051", catpawsnum = 919570258 }, new Student { StudentId = 533487, First = "Rakesh", Last = "Avirineni", Snumber = "S533487", catpawsnum = 919568647 } }; Console.WriteLine($"Inserted {student.Length} new student."); foreach (Student d in student) { context.Students.Add(d); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exist."); } else { var degreeplan = new DegreePlan[] { new DegreePlan { DegreePlanId = 10, DegreeID = 3, StudentID = 531382, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As Fast as I can" }, new DegreePlan { DegreePlanId = 11, DegreeID = 3, StudentID = 531382, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "As Slow as I can" }, new DegreePlan { DegreePlanId = 12, DegreeID = 3, StudentID = 531496, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As Fast as I can" }, new DegreePlan { DegreePlanId = 13, DegreeID = 3, StudentID = 531496, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "As Slow as I can" }, new DegreePlan { DegreePlanId = 14, DegreeID = 3, StudentID = 531378, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "As Slow as I can" }, new DegreePlan { DegreePlanId = 15, DegreeID = 3, StudentID = 531378, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As Fast as I can" }, new DegreePlan { DegreePlanId = 16, DegreeID = 3, StudentID = 534051, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As Fast as I can" }, new DegreePlan { DegreePlanId = 17, DegreeID = 3, StudentID = 534051, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "As Slow as I can" }, new DegreePlan { DegreePlanId = 18, DegreeID = 3, StudentID = 533487, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "As Slow as I can" }, new DegreePlan { DegreePlanId = 19, DegreeID = 3, StudentID = 533487, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As Fast as I can" } }; Console.WriteLine($"Inserted {degreeplan.Length} new degree plans."); foreach (DegreePlan d in degreeplan) { context.DegreePlans.Add(d); } context.SaveChanges(); } if (context.DegreePlanTermRequirements.Any()) { Console.WriteLine("DegreePlan Term Requirements already exist."); } else { var degreeplantermrequirement = new DegreePlanTermRequirement[] { new DegreePlanTermRequirement { DegreePlanTermRequirementId = 1, DegreePlanID = 10, TermID = 1, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 2, DegreePlanID = 10, TermID = 1, RequirementID = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 3, DegreePlanID = 10, TermID = 1, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 4, DegreePlanID = 10, TermID = 1, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 5, DegreePlanID = 10, TermID = 2, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 6, DegreePlanID = 10, TermID = 2, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 7, DegreePlanID = 10, TermID = 2, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 8, DegreePlanID = 10, TermID = 3, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 9, DegreePlanID = 10, TermID = 3, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 10, DegreePlanID = 10, TermID = 4, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 11, DegreePlanID = 10, TermID = 4, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 12, DegreePlanID = 10, TermID = 4, RequirementID = 692 } }; Console.WriteLine($"Inserted {degreeplantermrequirement.Length} new student terms."); foreach (DegreePlanTermRequirement d in degreeplantermrequirement) { context.DegreePlanTermRequirements.Add(d); } context.SaveChanges(); } if (context.DegreeRequirements.Any()) { Console.WriteLine("Degree Requirements already exist."); } else { var degreerequirement = new DegreeRequirement[] { new DegreeRequirement { DegreeRequirementId = 1, DegreeId = 3, RequirementId = 356 }, new DegreeRequirement { DegreeRequirementId = 2, DegreeId = 3, RequirementId = 542 }, new DegreeRequirement { DegreeRequirementId = 3, DegreeId = 3, RequirementId = 563 }, new DegreeRequirement { DegreeRequirementId = 4, DegreeId = 3, RequirementId = 560 }, new DegreeRequirement { DegreeRequirementId = 5, DegreeId = 3, RequirementId = 555 }, new DegreeRequirement { DegreeRequirementId = 6, DegreeId = 3, RequirementId = 618 }, new DegreeRequirement { DegreeRequirementId = 7, DegreeId = 3, RequirementId = 1 }, new DegreeRequirement { DegreeRequirementId = 8, DegreeId = 3, RequirementId = 664 }, new DegreeRequirement { DegreeRequirementId = 9, DegreeId = 3, RequirementId = 10 }, new DegreeRequirement { DegreeRequirementId = 10, DegreeId = 3, RequirementId = 20 }, new DegreeRequirement { DegreeRequirementId = 11, DegreeId = 3, RequirementId = 691 }, new DegreeRequirement { DegreeRequirementId = 12, DegreeId = 3, RequirementId = 692 } }; Console.WriteLine($"Inserted { degreerequirement.Length} new student terms."); foreach (DegreeRequirement d in degreerequirement) { context.DegreeRequirements.Add(d); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Student Terms already exist."); } else { var studentterm = new StudentTerm[] { new StudentTerm { StudentTermId = 1, Term = 1, TermLabel = "Fall 2017", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 2, Term = 2, TermLabel = "Spring 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 3, Term = 3, TermLabel = "Summer 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 4, Term = 4, TermLabel = "Fall 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 5, Term = 1, TermLabel = "Spring 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 6, Term = 2, TermLabel = "Summer 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 7, Term = 3, TermLabel = "Fall 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 8, Term = 4, TermLabel = "Spring 2019", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 9, Term = 1, TermLabel = "Spring 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 10, Term = 2, TermLabel = "Summer 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 11, Term = 3, TermLabel = "Fall 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 12, Term = 4, TermLabel = "Spring 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 13, Term = 5, TermLabel = "Summer 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 14, Term = 6, TermLabel = "Fall 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 15, Term = 1, TermLabel = "Fall 2018", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 16, Term = 2, TermLabel = "Spring 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 17, Term = 3, TermLabel = "Summer 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 18, Term = 4, TermLabel = "Fall 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 19, Term = 1, TermLabel = "Fall2018", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 20, Term = 2, TermLabel = "Spring2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 21, Term = 3, TermLabel = "Summer 2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 22, Term = 4, TermLabel = "Fall2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 23, Term = 5, TermLabel = "Spring 2020", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 24, Term = 6, TermLabel = "Summer 2020", DegreePlanId = 18 } }; Console.WriteLine($"Inserted {studentterm.Length} new student terms."); foreach (StudentTerm d in studentterm) { context.StudentTerms.Add(d); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { // This section is for Harika: To work on Degree if (context.Degrees.Any()) { Console.WriteLine("Degree Already exists:"); } else { var degrees = new Degree[] { new Degree { DegreeID = 1, DegreeAbbrev = "ACS+2", DegreeName = "MS ACS+2", NumberOfTerms = 5 }, new Degree { DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "MS ACS + DB", NumberOfTerms = 5 }, new Degree { DegreeID = 3, DegreeAbbrev = "ACS+NF", DegreeName = "MS ACS + NF", NumberOfTerms = 5 }, new Degree { DegreeID = 4, DegreeAbbrev = "ACS", DegreeName = "MS ACS", NumberOfTerms = 5 }, }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } //This section ends //This section is for Teja: To work on Credit if (context.Credits.Any()) { Console.WriteLine("Credit Already exists:"); } else { var credits = new Credit[] { new Credit { CreditID = 460, CreditAbbrev = "DB", CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 356, CreditAbbrev = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 542, CreditAbbrev = "542", CreditName = "OOP with Java", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 563, CreditAbbrev = "563", CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 560, CreditAbbrev = "560", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 664, CreditAbbrev = "664-UX", CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 618, CreditAbbrev = "618-PM", CreditName = "Project Management", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 555, CreditAbbrev = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 691, CreditAbbrev = "691-GDP1", CreditName = "GDP-1", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 692, CreditAbbrev = "692-GDP2", CreditName = "GDP-2", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 6, CreditAbbrev = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 1, CreditAbbrev = "E1", CreditName = "Elective1", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 2, CreditAbbrev = "E2", CreditName = "Elective2", IsSummer = 1, IsSpring = 1, IsFall = 1 }, }; Console.WriteLine($"Inserted {credits.Length} new credits."); foreach (Credit d in credits) { context.Credits.Add(d); } context.SaveChanges(); } //This is for Students if (context.Students.Any()) { Console.WriteLine("Student Already exists:"); } else { var students = new Student[] { new Student { StudentID = 533726, Family = "Narne", Given = "Sai Tejaswini", Snumber = 533726, number_919 = 919571565 }, new Student { StudentID = 533490, Family = "Gadekari", Given = "Sonam", Snumber = 533490, number_919 = 919568899 }, new Student { StudentID = 533711, Family = "Naidu", Given = "Harika", Snumber = 533711, number_919 = 919570594 }, }; Console.WriteLine($"Inserted {students.Length} new students."); foreach (Student d in students) { context.Students.Add(d); } context.SaveChanges(); } //This section ends //This section ends: Credit //This section is for Harika: Degree Credit if (context.DegreeCredits.Any()) { Console.WriteLine("Degree Credit Already exists:"); } else { var degreesCredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditID = 1, DegreeID = 1, CreditID = 460 }, new DegreeCredit { DegreeCreditID = 2, DegreeID = 1, CreditID = 356 }, new DegreeCredit { DegreeCreditID = 3, DegreeID = 1, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 4, DegreeID = 1, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 5, DegreeID = 1, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 6, DegreeID = 1, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 7, DegreeID = 1, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 8, DegreeID = 1, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 9, DegreeID = 1, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 10, DegreeID = 1, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 11, DegreeID = 1, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 12, DegreeID = 1, CreditID = 1 }, new DegreeCredit { DegreeCreditID = 13, DegreeID = 1, CreditID = 2 }, new DegreeCredit { DegreeCreditID = 14, DegreeID = 2, CreditID = 460 }, new DegreeCredit { DegreeCreditID = 15, DegreeID = 2, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 16, DegreeID = 2, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 17, DegreeID = 2, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 18, DegreeID = 2, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 19, DegreeID = 2, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 20, DegreeID = 2, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 21, DegreeID = 2, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 22, DegreeID = 2, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 23, DegreeID = 2, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 24, DegreeID = 2, CreditID = 1 }, new DegreeCredit { DegreeCreditID = 25, DegreeID = 2, CreditID = 2 }, new DegreeCredit { DegreeCreditID = 26, DegreeID = 3, CreditID = 356 }, new DegreeCredit { DegreeCreditID = 27, DegreeID = 3, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 28, DegreeID = 3, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 29, DegreeID = 3, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 30, DegreeID = 3, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 31, DegreeID = 3, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 32, DegreeID = 3, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 33, DegreeID = 3, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 34, DegreeID = 3, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 35, DegreeID = 3, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 36, DegreeID = 3, CreditID = 1 }, new DegreeCredit { DegreeCreditID = 37, DegreeID = 3, CreditID = 2 }, new DegreeCredit { DegreeCreditID = 38, DegreeID = 4, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 39, DegreeID = 4, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 40, DegreeID = 4, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 41, DegreeID = 4, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 42, DegreeID = 4, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 43, DegreeID = 4, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 44, DegreeID = 4, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 45, DegreeID = 4, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 46, DegreeID = 4, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 47, DegreeID = 4, CreditID = 1 }, new DegreeCredit { DegreeCreditID = 48, DegreeID = 4, CreditID = 2 }, }; Console.WriteLine($"Inserted {degreesCredits.Length} new degreesCredits."); foreach (DegreeCredit d in degreesCredits) { context.DegreeCredits.Add(d); } context.SaveChanges(); } //This section ends //This section is for Teja: To work on Degree Plan if (context.DegreePlans.Any()) { Console.WriteLine("DegreePlans Already exists:"); } else { var degreeplans = new DegreePlan[] { new DegreePlan { DegreePlanID = 7250, StudentID = 533726, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a Summer off" }, new DegreePlan { DegreePlanID = 7251, StudentID = 533726, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As fast as I can" }, new DegreePlan { DegreePlanID = 7252, StudentID = 533490, DegreePlanAbbrev = "Spring Super Slow", DegreePlanName = "As slow as it could be with a Summer off" }, new DegreePlan { DegreePlanID = 7253, StudentID = 533490, DegreePlanAbbrev = "Spring Super fast", DegreePlanName = "As fast as it could be" }, new DegreePlan { DegreePlanID = 7254, StudentID = 533711, DegreePlanAbbrev = "Early completion", DegreePlanName = "Fall 2018 fast track" }, new DegreePlan { DegreePlanID = 7255, StudentID = 533711, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a Summer off" }, }; Console.WriteLine($"Inserted {degreeplans.Length} new degreePlans."); foreach (DegreePlan dp in degreeplans) { context.DegreePlans.Add(dp); } context.SaveChanges(); } //This section ends //This section is for Sonam: StudentTerms.cs if (context.StudentTerms.Any()) { Console.WriteLine("StudentTerms Already exists:"); } else { var studentterms = new StudentTerm[] { new StudentTerm { StudentTermID = 1, StudentID = 533726, Term = 1, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 2, StudentID = 533726, Term = 2, TermAbbrev = "S20", TermName = "Spring 2020" }, new StudentTerm { StudentTermID = 3, StudentID = 533726, Term = 3, TermAbbrev = "Su20", TermName = "Summer 2020" }, new StudentTerm { StudentTermID = 4, StudentID = 533726, Term = 4, TermAbbrev = "F20", TermName = "Fall 2020" }, new StudentTerm { StudentTermID = 5, StudentID = 533726, Term = 5, TermAbbrev = "S21", TermName = "Spring 2021" }, new StudentTerm { StudentTermID = 6, StudentID = 533490, Term = 1, TermAbbrev = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermID = 7, StudentID = 533490, Term = 2, TermAbbrev = "Su19", TermName = "Summer 2019" }, new StudentTerm { StudentTermID = 8, StudentID = 533490, Term = 3, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 9, StudentID = 533490, Term = 4, TermAbbrev = "S20", TermName = "Spring 2020" }, new StudentTerm { StudentTermID = 10, StudentID = 533490, Term = 5, TermAbbrev = "Su20", TermName = "Summer 2020" }, new StudentTerm { StudentTermID = 11, StudentID = 533490, Term = 6, TermAbbrev = "F20", TermName = "Fall 2020" }, new StudentTerm { StudentTermID = 12, StudentID = 533711, Term = 1, TermAbbrev = "F18", TermName = "Fall 2018" }, new StudentTerm { StudentTermID = 13, StudentID = 533711, Term = 2, TermAbbrev = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermID = 14, StudentID = 533711, Term = 3, TermAbbrev = "Su19", TermName = "Summer 2019" }, new StudentTerm { StudentTermID = 15, StudentID = 533711, Term = 4, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 16, StudentID = 533711, Term = 5, TermAbbrev = "S20", TermName = "Spring 2020" }, new StudentTerm { StudentTermID = 17, StudentID = 533711, Term = 6, TermAbbrev = "Su19", TermName = "Summer 2020" }, }; Console.WriteLine($"Inserted {studentterms.Length} new studentTerms."); foreach (StudentTerm d in studentterms) { context.StudentTerms.Add(d); } context.SaveChanges(); } //This section ends //This section is for Sonam: Student.cs //This section is for Sonam: Slot.cs if (context.Slots.Any()) { Console.WriteLine("Slots Already exists:"); } else { var slots = new Slot[] { new Slot { SlotID = 1, DegreePlanID = 7251, Term = 1, CreditID = 460, Status = "C" }, new Slot { SlotID = 2, DegreePlanID = 7251, Term = 1, CreditID = 542, Status = "C" }, new Slot { SlotID = 3, DegreePlanID = 7251, Term = 1, CreditID = 563, Status = "C" }, new Slot { SlotID = 4, DegreePlanID = 7251, Term = 2, CreditID = 560, Status = "A" }, new Slot { SlotID = 5, DegreePlanID = 7251, Term = 2, CreditID = 664, Status = "A" }, new Slot { SlotID = 6, DegreePlanID = 7251, Term = 2, CreditID = 6, Status = "A" }, new Slot { SlotID = 7, DegreePlanID = 7251, Term = 3, CreditID = 618, Status = "P" }, new Slot { SlotID = 8, DegreePlanID = 7251, Term = 3, CreditID = 691, Status = "P" }, new Slot { SlotID = 9, DegreePlanID = 7251, Term = 4, CreditID = 692, Status = "P" }, new Slot { SlotID = 10, DegreePlanID = 7251, Term = 4, CreditID = 1, Status = "P" }, new Slot { SlotID = 11, DegreePlanID = 7251, Term = 4, CreditID = 2, Status = "P" }, new Slot { SlotID = 12, DegreePlanID = 7251, Term = 5, CreditID = 555, Status = "P" }, new Slot { SlotID = 13, DegreePlanID = 7252, Term = 1, CreditID = 460, Status = "C" }, new Slot { SlotID = 14, DegreePlanID = 7252, Term = 1, CreditID = 542, Status = "C" }, new Slot { SlotID = 15, DegreePlanID = 7252, Term = 1, CreditID = 563, Status = "C" }, new Slot { SlotID = 16, DegreePlanID = 7252, Term = 3, CreditID = 560, Status = "C" }, new Slot { SlotID = 17, DegreePlanID = 7252, Term = 3, CreditID = 664, Status = "A" }, new Slot { SlotID = 18, DegreePlanID = 7252, Term = 3, CreditID = 6, Status = "A" }, new Slot { SlotID = 19, DegreePlanID = 7252, Term = 4, CreditID = 691, Status = "A" }, new Slot { SlotID = 20, DegreePlanID = 7252, Term = 4, CreditID = 618, Status = "P" }, new Slot { SlotID = 21, DegreePlanID = 7252, Term = 5, CreditID = 692, Status = "P" }, new Slot { SlotID = 22, DegreePlanID = 7252, Term = 5, CreditID = 1, Status = "P" }, new Slot { SlotID = 23, DegreePlanID = 7252, Term = 6, CreditID = 555, Status = "P" }, new Slot { SlotID = 24, DegreePlanID = 7252, Term = 6, CreditID = 2, Status = "P" }, new Slot { SlotID = 25, DegreePlanID = 7255, Term = 1, CreditID = 460, Status = "C" }, new Slot { SlotID = 26, DegreePlanID = 7255, Term = 1, CreditID = 542, Status = "C" }, new Slot { SlotID = 27, DegreePlanID = 7255, Term = 1, CreditID = 563, Status = "C" }, new Slot { SlotID = 28, DegreePlanID = 7255, Term = 2, CreditID = 6, Status = "A" }, new Slot { SlotID = 29, DegreePlanID = 7255, Term = 2, CreditID = 618, Status = "A" }, new Slot { SlotID = 30, DegreePlanID = 7255, Term = 2, CreditID = 560, Status = "A" }, new Slot { SlotID = 31, DegreePlanID = 7255, Term = 4, CreditID = 691, Status = "P" }, new Slot { SlotID = 32, DegreePlanID = 7255, Term = 4, CreditID = 1, Status = "P" }, new Slot { SlotID = 33, DegreePlanID = 7255, Term = 4, CreditID = 2, Status = "P" }, new Slot { SlotID = 34, DegreePlanID = 7255, Term = 5, CreditID = 555, Status = "P" }, new Slot { SlotID = 35, DegreePlanID = 7255, Term = 5, CreditID = 664, Status = "P" }, new Slot { SlotID = 36, DegreePlanID = 7255, Term = 6, CreditID = 692, Status = "P" }, }; Console.WriteLine($"Inserted {slots.Length} new slots."); foreach (Slot d in slots) { context.Slots.Add(d); } context.SaveChanges(); } //This section ends }
public static void Initialize(ApplicationDbContext context) { //context.Database.EnsureCreated(); // Look for any Degrees. if (context.Degrees.Any()) { Console.WriteLine("Degrees already exist."); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbrrev = "ACS+2", DegreeName = "MS ACS +2" }, new Degree { DegreeId = 2, DegreeAbrrev = "ACS+DB", DegreeName = "MS ACS + DB" }, new Degree { DegreeId = 3, DegreeAbrrev = "ACS+NF", DegreeName = "MS ACS+ NF" }, new Degree { DegreeId = 4, DegreeAbrrev = "ACS", DegreeName = "MS ACS" } }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } if (context.Requirements.Any()) { Console.WriteLine("Requirements already exist."); } else { var requirements = new Requirement[] { new Requirement { RequirementID = 460, DegreeId = 2, RequirementAbbrev = "DB", CourseName = "44-460 Database" }, new Requirement { RequirementID = 356, DegreeId = 2, RequirementAbbrev = "NF", CourseName = "44-356 Network Fundamentals" }, new Requirement { RequirementID = 542, DegreeId = 2, RequirementAbbrev = "OOP", CourseName = "44-542 Object Oriented Programming" }, new Requirement { RequirementID = 563, DegreeId = 2, RequirementAbbrev = "Web apps", CourseName = "44-563 Web apps" }, new Requirement { RequirementID = 560, DegreeId = 2, RequirementAbbrev = "ADB", CourseName = "44-560 Advance Database topics" }, new Requirement { RequirementID = 555, DegreeId = 2, RequirementAbbrev = "NS", CourseName = "44-555 Network Security" }, new Requirement { RequirementID = 618, DegreeId = 2, RequirementAbbrev = "PM", CourseName = "44-618 Project Management" }, new Requirement { RequirementID = 1, DegreeId = 2, RequirementAbbrev = "MC", CourseName = "Mobile Computing ios" }, new Requirement { RequirementID = 664, DegreeId = 2, RequirementAbbrev = "UXD", CourseName = "44-664 User Experience Design" }, new Requirement { RequirementID = 10, DegreeId = 2, RequirementAbbrev = "E1", CourseName = "Elective 1" }, new Requirement { RequirementID = 20, DegreeId = 2, RequirementAbbrev = "E2", CourseName = "Elective 2" }, new Requirement { RequirementID = 691, DegreeId = 2, RequirementAbbrev = "GDP1", CourseName = "GDP1" }, new Requirement { RequirementID = 692, DegreeId = 2, RequirementAbbrev = "GDP2", CourseName = "GDP2" } }; Console.WriteLine($"Inserted {requirements.Length} new reuirements."); foreach (Requirement d in requirements) { context.Requirements.Add(d); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Students already exist."); } else { var student = new Student[] { new Student { StudentId = 528116, First = "Nilantha", Last = "Dambadeniya", Snumber = "S528116", catpawsnum = 919550040 }, new Student { StudentId = 530473, First = "Ujjawal", Last = "Kumar", Snumber = "S530473", catpawsnum = 919568987 }, new Student { StudentId = 533909, First = "Meghana", Last = "Pittu", Snumber = "S533909", catpawsnum = 919570037 }, new Student { StudentId = 533570, First = "Keerthi sree", Last = "Kukunoor", Snumber = "S533570", catpawsnum = 919569706 }, new Student { StudentId = 531372, First = "Anurag", Last = "Kumar", Snumber = "S531372", catpawsnum = 919533437 } }; Console.WriteLine($"Inserted {student.Length} new student."); foreach (Student d in student) { context.Students.Add(d); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exist."); } else { var degreeplan = new DegreePlan[] { new DegreePlan { DegreePlanId = 10, DegreeID = 2, StudentID = 528116, DegreePlanAbbrev = "Express", DegreePlanName = "Finish Degree ASAP" }, new DegreePlan { DegreePlanId = 11, DegreeID = 2, StudentID = 528116, DegreePlanAbbrev = "Economy", DegreePlanName = "Finish Degree economically" }, new DegreePlan { DegreePlanId = 12, DegreeID = 2, StudentID = 530473, DegreePlanAbbrev = "Express", DegreePlanName = "Finish Degree ASAP" }, new DegreePlan { DegreePlanId = 13, DegreeID = 2, StudentID = 530473, DegreePlanAbbrev = "Economy", DegreePlanName = "Finish Degree economically" }, new DegreePlan { DegreePlanId = 14, DegreeID = 2, StudentID = 533909, DegreePlanAbbrev = "Economy", DegreePlanName = "Finish Degree economically" }, new DegreePlan { DegreePlanId = 15, DegreeID = 2, StudentID = 533909, DegreePlanAbbrev = "Express", DegreePlanName = "Finish Degree ASAP" }, new DegreePlan { DegreePlanId = 16, DegreeID = 2, StudentID = 533570, DegreePlanAbbrev = "Express", DegreePlanName = "Finish Degree ASAP" }, new DegreePlan { DegreePlanId = 17, DegreeID = 2, StudentID = 533570, DegreePlanAbbrev = "Economy", DegreePlanName = "Finish Degree economically" }, new DegreePlan { DegreePlanId = 18, DegreeID = 2, StudentID = 531372, DegreePlanAbbrev = "Economy", DegreePlanName = "Finish Degree economically" }, new DegreePlan { DegreePlanId = 19, DegreeID = 2, StudentID = 531372, DegreePlanAbbrev = "Express", DegreePlanName = "Finish Degree ASAP" } }; Console.WriteLine($"Inserted {degreeplan.Length} new degree plans."); foreach (DegreePlan d in degreeplan) { context.DegreePlans.Add(d); } context.SaveChanges(); } if (context.DegreePlanTermRequirements.Any()) { Console.WriteLine("DegreePlan Term Requirements already exist."); } else { var degreeplantermrequirement = new DegreePlanTermRequirement[] { new DegreePlanTermRequirement { DegreePlanTermRequirementId = 1, DegreePlanID = 10, TermID = 1, RequirementID = 560 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 2, DegreePlanID = 10, TermID = 1, RequirementID = 356 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 3, DegreePlanID = 10, TermID = 1, RequirementID = 542 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 4, DegreePlanID = 10, TermID = 1, RequirementID = 563 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 5, DegreePlanID = 10, TermID = 2, RequirementID = 664 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 6, DegreePlanID = 10, TermID = 2, RequirementID = 1 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 7, DegreePlanID = 10, TermID = 2, RequirementID = 10 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 8, DegreePlanID = 10, TermID = 3, RequirementID = 618 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 9, DegreePlanID = 10, TermID = 3, RequirementID = 691 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 10, DegreePlanID = 10, TermID = 4, RequirementID = 555 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 11, DegreePlanID = 10, TermID = 4, RequirementID = 20 }, new DegreePlanTermRequirement { DegreePlanTermRequirementId = 12, DegreePlanID = 10, TermID = 4, RequirementID = 692 } }; Console.WriteLine($"Inserted {degreeplantermrequirement.Length} new student terms."); foreach (DegreePlanTermRequirement d in degreeplantermrequirement) { context.DegreePlanTermRequirements.Add(d); } context.SaveChanges(); } if (context.DegreeRequirements.Any()) { Console.WriteLine("Degree Requirements already exist."); } else { var degreerequirement = new DegreeRequirement[] { new DegreeRequirement { DegreeRequirementId = 1, DegreeId = 2, RequirementId = 356 }, new DegreeRequirement { DegreeRequirementId = 2, DegreeId = 2, RequirementId = 542 }, new DegreeRequirement { DegreeRequirementId = 3, DegreeId = 2, RequirementId = 563 }, new DegreeRequirement { DegreeRequirementId = 4, DegreeId = 2, RequirementId = 560 }, new DegreeRequirement { DegreeRequirementId = 5, DegreeId = 2, RequirementId = 555 }, new DegreeRequirement { DegreeRequirementId = 6, DegreeId = 2, RequirementId = 618 }, new DegreeRequirement { DegreeRequirementId = 7, DegreeId = 2, RequirementId = 1 }, new DegreeRequirement { DegreeRequirementId = 8, DegreeId = 2, RequirementId = 664 }, new DegreeRequirement { DegreeRequirementId = 9, DegreeId = 2, RequirementId = 10 }, new DegreeRequirement { DegreeRequirementId = 10, DegreeId = 2, RequirementId = 20 }, new DegreeRequirement { DegreeRequirementId = 11, DegreeId = 2, RequirementId = 691 }, new DegreeRequirement { DegreeRequirementId = 12, DegreeId = 2, RequirementId = 692 } }; Console.WriteLine($"Inserted { degreerequirement.Length} new student terms."); foreach (DegreeRequirement d in degreerequirement) { context.DegreeRequirements.Add(d); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Student Terms already exist."); } else { var studentterm = new StudentTerm[] { new StudentTerm { StudentTermId = 1, Term = 1, TermLabel = "Fall 2017", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 2, Term = 2, TermLabel = "Spring 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 3, Term = 3, TermLabel = "Summer 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 4, Term = 4, TermLabel = "Fall 2018", DegreePlanId = 10 }, new StudentTerm { StudentTermId = 5, Term = 1, TermLabel = "Spring 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 6, Term = 2, TermLabel = "Summer 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 7, Term = 3, TermLabel = "Fall 2018", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 8, Term = 4, TermLabel = "Spring 2019", DegreePlanId = 12 }, new StudentTerm { StudentTermId = 9, Term = 1, TermLabel = "Spring 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 10, Term = 2, TermLabel = "Summer 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 11, Term = 3, TermLabel = "Fall 2018", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 12, Term = 4, TermLabel = "Spring 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 13, Term = 5, TermLabel = "Summer 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 14, Term = 6, TermLabel = "Fall 2019", DegreePlanId = 14 }, new StudentTerm { StudentTermId = 15, Term = 1, TermLabel = "Fall 2018", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 16, Term = 2, TermLabel = "Spring 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 17, Term = 3, TermLabel = "Summer 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 18, Term = 4, TermLabel = "Fall 2019", DegreePlanId = 16 }, new StudentTerm { StudentTermId = 19, Term = 1, TermLabel = "Fall2018", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 20, Term = 2, TermLabel = "Spring2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 21, Term = 3, TermLabel = "Summer 2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 22, Term = 4, TermLabel = "Fall2019", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 23, Term = 5, TermLabel = "Spring 2020", DegreePlanId = 18 }, new StudentTerm { StudentTermId = 24, Term = 6, TermLabel = "Summer 2020", DegreePlanId = 18 } }; Console.WriteLine($"Inserted {studentterm.Length} new student terms."); foreach (StudentTerm d in studentterm) { context.StudentTerms.Add(d); } context.SaveChanges(); } }
public IActionResult ViewDegreePlan(DegreePlanFormSubmissionVm data) { if (!Authenticate()) { return(RedirectToAction("Index", "Home")); } User user = GetCurrentlyLoggedInUser(); // only doing front end validation for now. //TODO fix later. using (var context = new DegreePlannerContext()) { //Figure out what courses i need to take to graduate IList <Course> coursesTaken = context.Users .Include(u => u.CourseUserLinks) .ThenInclude(cul => cul.Course) .ThenInclude(c => c.PrerequisiteLinks) .ThenInclude(pl => pl.Prerequisite) .FirstOrDefault(u => u.UserID == user.UserID) ?.Courses .ToList(); IList <Course> coursesToTake = new List <Course>(); foreach (var courseData in data.Courses) { if (coursesTaken.All(c => c.CourseID != courseData.CourseID) && coursesToTake.All(c => c.CourseID != courseData.CourseID)) { var course = CreateOrFetchCourse(context, courseData.Department, courseData.CatalogNumber, out _, true); if (course.Hours == -1) { course.Hours = courseData.Hours; } coursesToTake.Add(course); } } var degreeRequiredCourses = context.Degrees .Include(d => d.Requirements) .ThenInclude(de => de.Members) .ThenInclude(cg => cg.CourseCourseGroupLinks) .ThenInclude(ccgl => ccgl.Course) .ThenInclude(c => c.PrerequisiteLinks) .ThenInclude(pl => pl.Prerequisite) .FirstOrDefault(d => d.DegreeID == data.DegreeID) ?.Requirements .Where(de => de.Hours == de.Members.Courses.Sum(c => c.Hours)) .SelectMany(de => de.Members.Courses); foreach (var course in degreeRequiredCourses) { if (coursesTaken.All(c => c.CourseID != course.CourseID) && coursesToTake.All(c => c.CourseID != course.CourseID)) { coursesToTake.Add(course); } } for (var i = 0; i < coursesToTake.Count; i++) { foreach (var prereq in coursesToTake[i].Prerequisites) { if (coursesTaken.All(c => c.CourseID != prereq.CourseID) && coursesToTake.All(c => c.CourseID != prereq.CourseID)) { Course fullPrereqData = context.Courses .Include(c => c.PrerequisiteLinks) .ThenInclude(pl => pl.Prerequisite) .FirstOrDefault(p => p.CourseID == prereq.CourseID); coursesToTake.Add(fullPrereqData); } } } //Build an adjacency matrix int n = coursesToTake.Count; bool[,] matrix = new bool[n, n]; for (var i = 0; i < n; i++) { for (var j = 0; j < n; j++) { if (coursesToTake[i].Prerequisites.Any(c => c.CourseID == coursesToTake[j].CourseID)) { matrix[i, j] = true; } else { matrix[i, j] = false; // matrix[i, j] = true IF course j is a prerequisite of course i } } } int[] hours = new int[n]; int[] years = new int[n]; for (int i = 0; i < n; i++) { hours[i] = coursesToTake[i].Hours; years[i] = int.Parse(coursesToTake[i].CatalogNumber[0] + ""); } // Use topological sort to show the minimum semester for a course var planData = GeneratePlan(matrix, hours, years, data.MaxHoursPerSemester, data.MinHoursPerSemester, data.MinSemesters, n); // convert the graph data to actual courses DegreePlan plan = new DegreePlan() { Semesters = new List <Semester>(), MinHours = data.MinHoursPerSemester, MinSemesters = data.MinSemesters, MaxHours = data.MaxHoursPerSemester }; int index = 0; Course free = context.Courses.FirstOrDefault(c => c.Department == "UARK" && c.CatalogNumber == "000E"); foreach (var semesterData in planData) { var courses = new List <SemesterCourseLink>(); var semester = new Semester() { Index = index }; foreach (int courseData in semesterData) { if (courseData != -1) { courses.Add(new SemesterCourseLink() { Course = coursesToTake[courseData], Semester = semester }); } else { courses.Add(new SemesterCourseLink() { Course = free, Semester = semester }); } } index++; semester.SemesterCourseLinks = courses; plan.Semesters.Add(semester); } var oldPlan = context.DegreePlans.Where(dp => dp.UserID == user.UserID); if (oldPlan.Count() != 0) { context.DegreePlans.RemoveRange(oldPlan); } context.SaveChanges(); plan.UserID = user.UserID; context.DegreePlans.Add(plan); context.SaveChanges(); return(RedirectToAction("ViewDegreePlan", "Planner")); } }
//private static object studentterms; public static void Initialize(ApplicationDbContext context) { if (context.Degrees.Any()) { Console.WriteLine("Degreess already exist"); } else { var degrees = new Degree[] { new Degree { DegreeID = 1, DegreeAbbrev = "ACS+2", DegreeName = "MsACS+2", NumberOFTerms = 5 }, new Degree { DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "MsACS+DB", NumberOFTerms = 5 }, new Degree { DegreeID = 3, DegreeAbbrev = "ACS+NF", DegreeName = "MsACS+NF", NumberOFTerms = 5 }, new Degree { DegreeID = 4, DegreeAbbrev = "ACS", DegreeName = "MsACS", NumberOFTerms = 5 } }; Console.WriteLine($"Inserted{degrees.Length} new students."); foreach (Degree s in degrees) { context.Degrees.Add(s); } context.SaveChanges(); } if (context.Credits.Any()) { Console.WriteLine("Credits already exist"); } else { var credits = new Credit[] { new Credit { CreditID = 1, CreditAbbrev = "NF", CreditName = "NetworkFundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditID = 2, CreditAbbrev = "542", CreditName = "OOPSwithJAVA", IsSummer = 0, IsSpring = 1, IsFall = 1 } }; Console.WriteLine($"Inserted{credits.Length} new students."); foreach (Credit s in credits) { context.Credits.Add(s); } context.SaveChanges(); } if (context.DegreeCredit.Any()) { Console.WriteLine("Degreess already exist"); } else { var DegreeCredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditID = 1, DegreeID = 1, CreditID = 460 }, new DegreeCredit { DegreeCreditID = 2, DegreeID = 1, CreditID = 356 }, new DegreeCredit { DegreeCreditID = 3, DegreeID = 1, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 4, DegreeID = 1, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 5, DegreeID = 1, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 6, DegreeID = 1, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 7, DegreeID = 1, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 8, DegreeID = 1, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 9, DegreeID = 1, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 10, DegreeID = 1, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 11, DegreeID = 1, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 12, DegreeID = 1, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 13, DegreeID = 1, CreditID = 20 }, new DegreeCredit { DegreeCreditID = 14, DegreeID = 2, CreditID = 460 }, new DegreeCredit { DegreeCreditID = 15, DegreeID = 2, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 16, DegreeID = 2, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 17, DegreeID = 2, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 18, DegreeID = 2, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 19, DegreeID = 2, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 20, DegreeID = 2, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 21, DegreeID = 2, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 22, DegreeID = 2, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 23, DegreeID = 2, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 24, DegreeID = 2, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 25, DegreeID = 2, CreditID = 20 }, new DegreeCredit { DegreeCreditID = 26, DegreeID = 3, CreditID = 356 }, new DegreeCredit { DegreeCreditID = 27, DegreeID = 3, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 28, DegreeID = 3, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 29, DegreeID = 3, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 30, DegreeID = 3, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 31, DegreeID = 3, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 32, DegreeID = 3, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 33, DegreeID = 3, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 34, DegreeID = 3, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 35, DegreeID = 3, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 36, DegreeID = 3, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 37, DegreeID = 3, CreditID = 20 }, new DegreeCredit { DegreeCreditID = 38, DegreeID = 4, CreditID = 542 }, new DegreeCredit { DegreeCreditID = 39, DegreeID = 4, CreditID = 563 }, new DegreeCredit { DegreeCreditID = 40, DegreeID = 4, CreditID = 560 }, new DegreeCredit { DegreeCreditID = 41, DegreeID = 4, CreditID = 664 }, new DegreeCredit { DegreeCreditID = 42, DegreeID = 4, CreditID = 618 }, new DegreeCredit { DegreeCreditID = 43, DegreeID = 4, CreditID = 555 }, new DegreeCredit { DegreeCreditID = 44, DegreeID = 4, CreditID = 691 }, new DegreeCredit { DegreeCreditID = 45, DegreeID = 4, CreditID = 692 }, new DegreeCredit { DegreeCreditID = 46, DegreeID = 4, CreditID = 6 }, new DegreeCredit { DegreeCreditID = 47, DegreeID = 4, CreditID = 10 }, new DegreeCredit { DegreeCreditID = 48, DegreeID = 4, CreditID = 20 }, }; Console.WriteLine($"Inserted{DegreeCredits.Length} new students."); foreach (DegreeCredit De in DegreeCredits) { context.DegreeCredit.Add(De); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Students already exist"); } else { var students = new Student[] { new Student { StudentID = 1, LastName = "Singam", FirstName = "Poojitha", I919 = 919571721 }, new Student { StudentID = 2, LastName = "Konidela", FirstName = "RamCharan", I919 = 919571722 }, }; Console.WriteLine($"Inserted{students.Length} new students."); foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("DegreePlans already exist"); } else { var degreeplans = new DegreePlan[] { new DegreePlan { DegreePlanID = 7253, StudentID = 533705, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7254, StudentID = 533705, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7255, StudentID = 533491, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7256, StudentID = 533491, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7257, StudentID = 533727, DegreePlanAbbrev = "SuperFast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7258, StudentID = 533727, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7259, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7260, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7261, StudentID = 533988, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3 }, new DegreePlan { DegreePlanID = 7262, StudentID = 533988, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3 }, }; Console.WriteLine($"Inserted{degreeplans.Length} new students."); foreach (DegreePlan s in degreeplans) { context.DegreePlans.Add(s); } context.SaveChanges(); } if (context.Slots.Any()) { Console.WriteLine("Slots already exist"); } else { var slots = new Slot[] { new Slot { SlotID = 1, DegreePlanID = 7255, Term = 1, CreditID = 356, Status = 'B' }, new Slot { SlotID = 2, DegreePlanID = 7255, Term = 1, CreditID = 542, Status = 'B' } }; Console.WriteLine($"Inserted{slots.Length} new slots."); foreach (Slot s in slots) { context.Slots.Add(s); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Degreess already exist"); } else { var studentterms = new StudentTerm[] { new StudentTerm { StudentTermID = 1, DegreePlanId = 7255, Term = 1, TermAbbrev = "F18", TermName = "Fall2018" }, new StudentTerm { StudentTermID = 2, DegreePlanId = 7255, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 3, DegreePlanId = 7255, Term = 3, TermAbbrev = "Sum", TermName = "Summer2019" }, new StudentTerm { StudentTermID = 4, DegreePlanId = 7255, Term = 4, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 5, DegreePlanId = 7256, Term = 1, TermAbbrev = "F18", TermName = "Fall2018" }, new StudentTerm { StudentTermID = 6, DegreePlanId = 7256, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 7, DegreePlanId = 7256, Term = 3, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 8, DegreePlanId = 7256, Term = 4, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 9, DegreePlanId = 7261, Term = 1, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 10, DegreePlanId = 7261, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020" }, new StudentTerm { StudentTermID = 11, DegreePlanId = 7261, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020" }, new StudentTerm { StudentTermID = 12, DegreePlanId = 7261, Term = 4, TermAbbrev = "F20", TermName = "Fall2020" }, new StudentTerm { StudentTermID = 13, DegreePlanId = 7262, Term = 1, TermAbbrev = "F19", TermName = "FALL2019" }, new StudentTerm { StudentTermID = 14, DegreePlanId = 7262, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020" }, new StudentTerm { StudentTermID = 15, DegreePlanId = 7262, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020" }, new StudentTerm { StudentTermID = 16, DegreePlanId = 7262, Term = 4, TermAbbrev = "F20", TermName = "FALL2020" }, new StudentTerm { StudentTermID = 17, DegreePlanId = 7262, Term = 5, TermAbbrev = "S21", TermName = "SPRING2021" }, new StudentTerm { StudentTermID = 18, DegreePlanId = 7259, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 19, DegreePlanId = 7259, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 20, DegreePlanId = 7259, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019" }, new StudentTerm { StudentTermID = 21, DegreePlanId = 7259, Term = 4, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 22, DegreePlanId = 7259, Term = 5, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 23, DegreePlanId = 7260, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 24, DegreePlanId = 7260, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 25, DegreePlanId = 7260, Term = 3, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 26, DegreePlanId = 7260, Term = 4, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 27, DegreePlanId = 7260, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020" }, new StudentTerm { StudentTermID = 28, DegreePlanId = 7257, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 29, DegreePlanId = 7257, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 30, DegreePlanId = 7257, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019" }, new StudentTerm { StudentTermID = 31, DegreePlanId = 7257, Term = 4, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 32, DegreePlanId = 7258, Term = 1, TermAbbrev = "F18", TermName = "FALL2018" }, new StudentTerm { StudentTermID = 33, DegreePlanId = 7258, Term = 2, TermAbbrev = "S19", TermName = "Spring2019" }, new StudentTerm { StudentTermID = 34, DegreePlanId = 7258, Term = 3, TermAbbrev = "F19", TermName = "Fall2019" }, new StudentTerm { StudentTermID = 35, DegreePlanId = 7258, Term = 4, TermAbbrev = "S20", TermName = "Spring2020" }, new StudentTerm { StudentTermID = 36, DegreePlanId = 7258, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020" }, new StudentTerm { StudentTermID = 37, DegreePlanId = 7253, Term = 1, TermAbbrev = "F 2018", TermName = "Fall 2018" }, new StudentTerm { StudentTermID = 38, DegreePlanId = 7253, Term = 2, TermAbbrev = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermID = 39, DegreePlanId = 7253, Term = 3, TermAbbrev = "Sum19", TermName = "Summer 2019" }, new StudentTerm { StudentTermID = 40, DegreePlanId = 7253, Term = 4, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 41, DegreePlanId = 7254, Term = 1, TermAbbrev = "S19", TermName = "Spring 2019" }, new StudentTerm { StudentTermID = 42, DegreePlanId = 7254, Term = 2, TermAbbrev = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermID = 43, DegreePlanId = 7254, Term = 3, TermAbbrev = "S20", TermName = "Spring 2020" }, new StudentTerm { StudentTermID = 44, DegreePlanId = 7254, Term = 4, TermAbbrev = "Sum20", TermName = "Summer 2020" }, new StudentTerm { StudentTermID = 45, DegreePlanId = 7254, Term = 5, TermAbbrev = "F20", TermName = "Fall 2020" }, }; Console.WriteLine($"Inserted{studentterms.Length} new students."); foreach (StudentTerm s in studentterms) { context.StudentTerms.Add(s); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { context.Database.EnsureCreated(); //for Degree - TEJA if (context.Degrees.Any()) { Console.WriteLine("Degrees already exist."); } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbbr = "ACS+2", DegreeName = "MS ACS+2", NumberOfTerms = 4 }, new Degree { DegreeId = 2, DegreeAbbr = "ACS+DB", DegreeName = "MS ACS+DB", NumberOfTerms = 4 }, new Degree { DegreeId = 3, DegreeAbbr = "ACS+NF", DegreeName = "MS ACS+NF", NumberOfTerms = 4 }, new Degree { DegreeId = 4, DegreeAbbr = "ACS", DegreeName = "MS ACS", NumberOfTerms = 4 }, }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree d in degrees) { context.Degrees.Add(d); } context.SaveChanges(); } //for Credit - Malli if (context.Credits.Any()) { Console.WriteLine("Credits already exist."); return; } else { var credits = new Credit[] { new Credit { CreditId = 460, CreditAbbr = "DB", CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 356, CreditAbbr = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 542, CreditAbbr = "542", CreditName = "OOPS with Java", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 563, CreditAbbr = "563", CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 560, CreditAbbr = "560", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 664, CreditAbbr = "664-UX", CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 618, CreditAbbr = "618-PM", CreditName = "Project Management", IsSummer = 1, IsSpring = 0, IsFall = 0 }, new Credit { CreditId = 555, CreditAbbr = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 691, CreditAbbr = "691-GDP1", CreditName = "GDP1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 692, CreditAbbr = "692-GDP2", CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 6, CreditAbbr = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 10, CreditAbbr = "E1", CreditName = "Elective 1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 20, CreditAbbr = "E2", CreditName = "Elective 2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, }; Console.WriteLine($"Inserted {credits.Length} new credits."); foreach (Credit d in credits) { context.Credits.Add(d); } context.SaveChanges(); } //DegreeRequirments if (context.DegreeRequirements.Any()) { Console.WriteLine("Credits already exist."); return; } else { var degreeRequirements = new DegreeRequirement[] { new DegreeRequirement { DegreeRequirementId = 1, RequirementNumber = 542, RequirementAbbr = "542", DegreeId = 4, RequirementName = "OOPS with Java" }, new DegreeRequirement { DegreeRequirementId = 2, RequirementNumber = 563, RequirementAbbr = "563", DegreeId = 4, RequirementName = "Web Apps" }, new DegreeRequirement { DegreeRequirementId = 3, RequirementNumber = 560, RequirementAbbr = "560", DegreeId = 4, RequirementName = "Advanced Databases" }, new DegreeRequirement { DegreeRequirementId = 4, RequirementNumber = 664, RequirementAbbr = "664-UX", DegreeId = 4, RequirementName = "User Experience" }, new DegreeRequirement { DegreeRequirementId = 5, RequirementNumber = 618, RequirementAbbr = "618-PM", DegreeId = 4, RequirementName = "Project Management" }, new DegreeRequirement { DegreeRequirementId = 6, RequirementNumber = 555, RequirementAbbr = "555-NS", DegreeId = 4, RequirementName = "Network Security" }, new DegreeRequirement { DegreeRequirementId = 7, RequirementNumber = 691, RequirementAbbr = "691-GDP1", DegreeId = 4, RequirementName = "GDP1" }, new DegreeRequirement { DegreeRequirementId = 8, RequirementNumber = 692, RequirementAbbr = "692-GDP2", DegreeId = 4, RequirementName = "GDP2" }, new DegreeRequirement { DegreeRequirementId = 9, RequirementNumber = 6, RequirementAbbr = "Mobile", DegreeId = 4, RequirementName = "643 or 644 Mobile" }, new DegreeRequirement { DegreeRequirementId = 10, RequirementNumber = 10, RequirementAbbr = "E1", DegreeId = 4, RequirementName = "Elective 1" }, new DegreeRequirement { DegreeRequirementId = 11, RequirementNumber = 20, RequirementAbbr = "E2", DegreeId = 4, RequirementName = "Elective 2" }, }; Console.WriteLine($"Inserted {degreeRequirements.Length} new degree requirements."); foreach (DegreeRequirement d in degreeRequirements) { context.DegreeRequirements.Add(d); } context.SaveChanges(); } //for Student - Mouni if (context.Students.Any()) { Console.WriteLine("Students already exist."); return; } else { var students = new Student[] { new Student { StudentId = 533568, Family = "Bodepudi", Given = "Mallikarjuna", N919 = 919569870 }, new Student { StudentId = 533708, Family = "Kancharla", Given = "Sai Krishna Teja", N919 = 919571315 }, new Student { StudentId = 533897, Family = "Atluri", Given = "Mouni Krishna", N919 = 919571233 }, }; Console.WriteLine($"Inserted {students.Length} new students."); foreach (Student d in students) { context.Students.Add(d); } context.SaveChanges(); } //for DegreeCredit - Malli if (context.DegreeCredits.Any()) { Console.WriteLine("DegreeCredits already exist."); return; } else { var degreeCredits = new DegreeCredit[] { new DegreeCredit { DegreeCreditId = 1, DegreeId = 1, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 2, DegreeId = 1, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 3, DegreeId = 1, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 4, DegreeId = 1, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 5, DegreeId = 1, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 6, DegreeId = 1, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 7, DegreeId = 1, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 8, DegreeId = 1, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 9, DegreeId = 1, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 10, DegreeId = 1, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 11, DegreeId = 1, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 12, DegreeId = 1, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 13, DegreeId = 1, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 14, DegreeId = 2, CreditId = 460 }, new DegreeCredit { DegreeCreditId = 15, DegreeId = 2, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 16, DegreeId = 2, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 17, DegreeId = 2, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 18, DegreeId = 2, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 19, DegreeId = 2, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 20, DegreeId = 2, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 21, DegreeId = 2, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 22, DegreeId = 2, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 23, DegreeId = 2, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 24, DegreeId = 2, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 25, DegreeId = 2, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 26, DegreeId = 3, CreditId = 356 }, new DegreeCredit { DegreeCreditId = 27, DegreeId = 3, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 28, DegreeId = 3, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 29, DegreeId = 3, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 30, DegreeId = 3, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 31, DegreeId = 3, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 32, DegreeId = 3, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 33, DegreeId = 3, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 34, DegreeId = 3, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 35, DegreeId = 3, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 36, DegreeId = 3, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 37, DegreeId = 3, CreditId = 20 }, new DegreeCredit { DegreeCreditId = 38, DegreeId = 4, CreditId = 542 }, new DegreeCredit { DegreeCreditId = 39, DegreeId = 4, CreditId = 563 }, new DegreeCredit { DegreeCreditId = 40, DegreeId = 4, CreditId = 560 }, new DegreeCredit { DegreeCreditId = 41, DegreeId = 4, CreditId = 664 }, new DegreeCredit { DegreeCreditId = 42, DegreeId = 4, CreditId = 618 }, new DegreeCredit { DegreeCreditId = 43, DegreeId = 4, CreditId = 555 }, new DegreeCredit { DegreeCreditId = 44, DegreeId = 4, CreditId = 691 }, new DegreeCredit { DegreeCreditId = 45, DegreeId = 4, CreditId = 692 }, new DegreeCredit { DegreeCreditId = 46, DegreeId = 4, CreditId = 6 }, new DegreeCredit { DegreeCreditId = 47, DegreeId = 4, CreditId = 10 }, new DegreeCredit { DegreeCreditId = 48, DegreeId = 4, CreditId = 20 }, }; Console.WriteLine($"Inserted {degreeCredits.Length} new degree credits."); foreach (DegreeCredit d in degreeCredits) { context.DegreeCredits.Add(d); } context.SaveChanges(); } //for DegreePlan - Mouni if (context.DegreePlans.Any()) { Console.WriteLine("Degree Plans already exist."); return; } else { var degreePlans = new DegreePlan[] { new DegreePlan { DegreePlanId = 1, DegreeId = 4, StudentId = 533568, DegreePlanAbbr = "Super Fast", DegreePlanName = "Cheetah", DegreePlanSelected = 5681 }, new DegreePlan { DegreePlanId = 2, DegreeId = 4, StudentId = 533568, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Tortoise", DegreePlanSelected = 5682 }, new DegreePlan { DegreePlanId = 3, DegreeId = 4, StudentId = 533708, DegreePlanAbbr = "Super Fast", DegreePlanName = "Cheetah", DegreePlanSelected = 7081 }, new DegreePlan { DegreePlanId = 4, DegreeId = 4, StudentId = 533708, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Tortoise", DegreePlanSelected = 7082 }, new DegreePlan { DegreePlanId = 5, DegreeId = 4, StudentId = 533897, DegreePlanAbbr = "Super Fast", DegreePlanName = "Cheetah", DegreePlanSelected = 8971 }, new DegreePlan { DegreePlanId = 6, DegreeId = 4, StudentId = 533897, DegreePlanAbbr = "Summer Off", DegreePlanName = "Rabbit", DegreePlanSelected = 8973 }, }; Console.WriteLine($"Inserted {degreePlans.Length} new Degree Plans."); foreach (DegreePlan d in degreePlans) { context.DegreePlans.Add(d); } context.SaveChanges(); } //for Slot - TEJA if (context.Slots.Any()) { Console.WriteLine("Slots already exist."); return; } else { var slots = new Slot[] { new Slot { SlotId = 1, DegreePlanSelected = 5681, Term = 1, DegreeRequirementId = 1, CreditId = 542, Status = "C" }, new Slot { SlotId = 2, DegreePlanSelected = 5681, Term = 1, DegreeRequirementId = 2, CreditId = 563, Status = "C" }, new Slot { SlotId = 3, DegreePlanSelected = 5681, Term = 1, DegreeRequirementId = 3, CreditId = 560, Status = "C" }, new Slot { SlotId = 4, DegreePlanSelected = 5681, Term = 2, DegreeRequirementId = 4, CreditId = 664, Status = "A" }, new Slot { SlotId = 5, DegreePlanSelected = 5681, Term = 2, DegreeRequirementId = 5, CreditId = 6, Status = "A" }, new Slot { SlotId = 6, DegreePlanSelected = 5681, Term = 2, DegreeRequirementId = 6, CreditId = 10, Status = "A" }, new Slot { SlotId = 7, DegreePlanSelected = 5681, Term = 3, DegreeRequirementId = 7, CreditId = 618, Status = "P" }, new Slot { SlotId = 8, DegreePlanSelected = 5681, Term = 3, DegreeRequirementId = 8, CreditId = 691, Status = "P" }, new Slot { SlotId = 9, DegreePlanSelected = 5681, Term = 4, DegreeRequirementId = 9, CreditId = 692, Status = "P" }, new Slot { SlotId = 10, DegreePlanSelected = 5681, Term = 4, DegreeRequirementId = 10, CreditId = 20, Status = "P" }, new Slot { SlotId = 11, DegreePlanSelected = 5681, Term = 4, DegreeRequirementId = 11, CreditId = 555, Status = "P" }, new Slot { SlotId = 12, DegreePlanSelected = 7082, Term = 1, DegreeRequirementId = 1, CreditId = 542, Status = "C" }, new Slot { SlotId = 13, DegreePlanSelected = 7082, Term = 1, DegreeRequirementId = 2, CreditId = 563, Status = "C" }, new Slot { SlotId = 14, DegreePlanSelected = 7082, Term = 1, DegreeRequirementId = 3, CreditId = 560, Status = "C" }, new Slot { SlotId = 15, DegreePlanSelected = 7082, Term = 2, DegreeRequirementId = 4, CreditId = 664, Status = "A" }, new Slot { SlotId = 16, DegreePlanSelected = 7082, Term = 2, DegreeRequirementId = 5, CreditId = 6, Status = "A" }, new Slot { SlotId = 17, DegreePlanSelected = 7082, Term = 2, DegreeRequirementId = 6, CreditId = 10, Status = "A" }, new Slot { SlotId = 18, DegreePlanSelected = 7082, Term = 3, DegreeRequirementId = 7, CreditId = 618, Status = "P" }, new Slot { SlotId = 19, DegreePlanSelected = 7082, Term = 4, DegreeRequirementId = 8, CreditId = 691, Status = "P" }, new Slot { SlotId = 20, DegreePlanSelected = 7082, Term = 4, DegreeRequirementId = 9, CreditId = 20, Status = "P" }, new Slot { SlotId = 21, DegreePlanSelected = 7082, Term = 5, DegreeRequirementId = 10, CreditId = 692, Status = "P" }, new Slot { SlotId = 22, DegreePlanSelected = 7082, Term = 5, DegreeRequirementId = 11, CreditId = 555, Status = "P" }, new Slot { SlotId = 23, DegreePlanSelected = 8973, Term = 1, DegreeRequirementId = 1, CreditId = 542, Status = "A" }, new Slot { SlotId = 24, DegreePlanSelected = 8973, Term = 1, DegreeRequirementId = 2, CreditId = 563, Status = "A" }, new Slot { SlotId = 25, DegreePlanSelected = 8973, Term = 1, DegreeRequirementId = 3, CreditId = 560, Status = "A" }, new Slot { SlotId = 26, DegreePlanSelected = 8973, Term = 2, DegreeRequirementId = 4, CreditId = 664, Status = "P" }, new Slot { SlotId = 27, DegreePlanSelected = 8973, Term = 2, DegreeRequirementId = 5, CreditId = 6, Status = "P" }, new Slot { SlotId = 28, DegreePlanSelected = 8973, Term = 2, DegreeRequirementId = 6, CreditId = 10, Status = "P" }, new Slot { SlotId = 29, DegreePlanSelected = 8973, Term = 3, DegreeRequirementId = 7, CreditId = 20, Status = "P" }, new Slot { SlotId = 30, DegreePlanSelected = 8973, Term = 3, DegreeRequirementId = 8, CreditId = 555, Status = "P" }, new Slot { SlotId = 31, DegreePlanSelected = 8973, Term = 3, DegreeRequirementId = 9, CreditId = 691, Status = "P" }, new Slot { SlotId = 32, DegreePlanSelected = 8973, Term = 4, DegreeRequirementId = 10, CreditId = 618, Status = "P" }, new Slot { SlotId = 33, DegreePlanSelected = 8973, Term = 4, DegreeRequirementId = 11, CreditId = 692, Status = "P" }, }; Console.WriteLine($"Inserted {slots.Length} new slots."); foreach (Slot d in slots) { context.Slots.Add(d); } context.SaveChanges(); } //for StudentTerm - TEJA if (context.StudentTerms.Any()) { Console.WriteLine("Student Terms already exist."); return; } else { var studentTerms = new StudentTerm[] { new StudentTerm { StudentTermId = 1, StudentId = 533568, Term = 1, TermAbbr = "F18", TermName = "Fall 2018" }, new StudentTerm { StudentTermId = 2, StudentId = 533568, Term = 2, TermAbbr = "SP19", TermName = "Spring 2019" }, new StudentTerm { StudentTermId = 3, StudentId = 533568, Term = 3, TermAbbr = "SU19", TermName = "Summer 2019" }, new StudentTerm { StudentTermId = 4, StudentId = 533568, Term = 4, TermAbbr = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermId = 5, StudentId = 533708, Term = 1, TermAbbr = "F18", TermName = "Fall 2018" }, new StudentTerm { StudentTermId = 6, StudentId = 533708, Term = 2, TermAbbr = "SP19", TermName = "Spring 2019" }, new StudentTerm { StudentTermId = 7, StudentId = 533708, Term = 3, TermAbbr = "SU19", TermName = "Summer 2019" }, new StudentTerm { StudentTermId = 8, StudentId = 533708, Term = 4, TermAbbr = "F19", TermName = "Fall 2019" }, new StudentTerm { StudentTermId = 9, StudentId = 533708, Term = 5, TermAbbr = "SP20", TermName = "Spring 2020" }, new StudentTerm { StudentTermId = 10, StudentId = 533897, Term = 1, TermAbbr = "SP20", TermName = "Spring 2020" }, new StudentTerm { StudentTermId = 11, StudentId = 533897, Term = 2, TermAbbr = "FA20", TermName = "Fall 2020" }, new StudentTerm { StudentTermId = 12, StudentId = 533897, Term = 3, TermAbbr = "SP21", TermName = "Spring 2021" }, new StudentTerm { StudentTermId = 13, StudentId = 533897, Term = 4, TermAbbr = "SU21", TermName = "Summer 2021" }, }; Console.WriteLine($"Inserted {studentTerms.Length} new student terms."); foreach (StudentTerm d in studentTerms) { context.StudentTerms.Add(d); } context.SaveChanges(); } }
public static void Initialize(ApplicationDbContext context) { //context.Database.EnsureCreated(); // Look for any students. if (context.Degrees.Any()) { Console.WriteLine("Degree already exist"); // DB has been seeded } else { var degrees = new Degree[] { new Degree { DegreeId = 1, DegreeAbbr = "ACS+2", DegreeName = "MS ACS+2" }, new Degree { DegreeId = 2, DegreeAbbr = "ACS+DB", DegreeName = "MS ACS+DB" }, new Degree { DegreeId = 3, DegreeAbbr = "ACS+NF", DegreeName = "MS ACS+NF" }, new Degree { DegreeId = 4, DegreeAbbr = "ACS", DegreeName = "ACS" } }; Console.WriteLine($"Inserted {degrees.Length} new degrees."); foreach (Degree s in degrees) { context.Degrees.Add(s); } context.SaveChanges(); } if (context.Credits.Any()) { Console.WriteLine("Degree already exist"); // DB has been seeded } else { var credits = new Credit[] { new Credit { CreditId = 460, CreditAbv = "DB", CreditName = "Database", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 356, CreditAbv = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 542, CreditAbv = "542", CreditName = "OOP", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 563, CreditAbv = "563", CreditName = "Web Apps ", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 560, CreditAbv = "560 ", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 664, CreditAbv = "664-UX", CreditName = "User Experince Design", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 618, CreditAbv = "618-PM ", CreditName = "ProjectManagement", IsSummer = 1, IsSpring = 0, IsFall = 0 }, new Credit { CreditId = 555, CreditAbv = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 691, CreditAbv = "691-GDP1", CreditName = "GDP1", IsSummer = 1, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 692, CreditAbv = "692-GDP2 ", CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 64, CreditAbv = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 10, CreditAbv = "E1", CreditName = "Elective1", IsSummer = 0, IsSpring = 1, IsFall = 1 }, new Credit { CreditId = 20, CreditAbv = "E2", CreditName = "Elective2", IsSummer = 0, IsSpring = 1, IsFall = 1 }, }; foreach (Credit i in credits) { context.Credits.Add(i); } context.SaveChanges(); } if (context.Students.Any()) { Console.WriteLine("Degree already exist"); // DB has been seeded } else { var students = new Student[] { new Student { StudentId = 533620, Family = "Devineni", Given = "Sandeep", Snumber = "S533620", Number919 = 919572432 }, new Student { StudentId = 533901, Family = "Dayam", Given = "Rahul", Snumber = "S533901", Number919 = 919571516 }, new Student { StudentId = 533978, Family = "Vagicherla", Given = "Sampath", Snumber = "S533978", Number919 = 919575632 }, new Student { StudentId = 533979, Family = "Veeramachaneni", Given = "Subhash", Snumber = "S533979", Number919 = 919570258 }, }; foreach (Student d in students) { context.Students.Add(d); } context.SaveChanges(); } if (context.DegreeRequirements.Any()) { Console.WriteLine("Degree already exist"); // DB has been seeded } else { var degreerequirements = new DegreeRequirement[] { new DegreeRequirement { Id = 1, DegreeId = 2, CreditId = 460 }, new DegreeRequirement { Id = 2, DegreeId = 2, CreditId = 542 }, new DegreeRequirement { Id = 3, DegreeId = 2, CreditId = 563 }, new DegreeRequirement { Id = 4, DegreeId = 2, CreditId = 560 }, new DegreeRequirement { Id = 5, DegreeId = 2, CreditId = 664 }, new DegreeRequirement { Id = 6, DegreeId = 2, CreditId = 618 }, new DegreeRequirement { Id = 7, DegreeId = 2, CreditId = 555 }, new DegreeRequirement { Id = 8, DegreeId = 2, CreditId = 691 }, new DegreeRequirement { Id = 9, DegreeId = 2, CreditId = 692 }, new DegreeRequirement { Id = 10, DegreeId = 2, CreditId = 64 }, new DegreeRequirement { Id = 11, DegreeId = 2, CreditId = 10 }, new DegreeRequirement { Id = 12, DegreeId = 2, CreditId = 20 }, }; foreach (DegreeRequirement c in degreerequirements) { context.DegreeRequirements.Add(c); } context.SaveChanges(); } if (context.DegreePlans.Any()) { Console.WriteLine("Degree already exist"); // DB has been seeded } else { var degreeplans = new DegreePlan[] { new DegreePlan { DegreePlanId = 7251, StudentId = 533901, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As fast as I can ", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7252, StudentId = 533901, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a summer off", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7253, StudentId = 533620, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As fast as I can", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7254, StudentId = 533620, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a summer off", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7255, StudentId = 533979, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As fast as I can", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7256, StudentId = 533979, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a summer off", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7257, StudentId = 533978, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As fast as I can ", DegreeId = 2 }, new DegreePlan { DegreePlanId = 7258, StudentId = 533978, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a summer off", DegreeId = 2 }, }; foreach (DegreePlan ci in degreeplans) { context.DegreePlans.Add(ci); } context.SaveChanges(); } if (context.Slots.Any()) { Console.WriteLine("Slots already exist"); // DB has been seeded } else { var slots = new Slot[] { new Slot { SlotId = 1, DegreePlanId = 7251, DegreeTerm = 1, CreditId = 460, Status = "C" }, new Slot { SlotId = 2, DegreePlanId = 7251, DegreeTerm = 1, CreditId = 542, Status = "C" }, new Slot { SlotId = 3, DegreePlanId = 7251, DegreeTerm = 1, CreditId = 563, Status = "C" }, new Slot { SlotId = 4, DegreePlanId = 7251, DegreeTerm = 2, CreditId = 560, Status = "A" }, new Slot { SlotId = 5, DegreePlanId = 7251, DegreeTerm = 2, CreditId = 64, Status = "A" }, new Slot { SlotId = 6, DegreePlanId = 7251, DegreeTerm = 2, CreditId = 555, Status = "A" }, new Slot { SlotId = 7, DegreePlanId = 7251, DegreeTerm = 3, CreditId = 691, Status = "P" }, new Slot { SlotId = 8, DegreePlanId = 7251, DegreeTerm = 3, CreditId = 10, Status = "P" }, new Slot { SlotId = 9, DegreePlanId = 7251, DegreeTerm = 3, CreditId = 618, Status = "P" }, new Slot { SlotId = 10, DegreePlanId = 7251, DegreeTerm = 4, CreditId = 20, Status = "P" }, new Slot { SlotId = 11, DegreePlanId = 7251, DegreeTerm = 4, CreditId = 692, Status = "P" }, new Slot { SlotId = 12, DegreePlanId = 7251, DegreeTerm = 4, CreditId = 664, Status = "P" }, }; foreach (Slot ci in slots) { context.Slots.Add(ci); } context.SaveChanges(); } if (context.StudentTerms.Any()) { Console.WriteLine("Degree already exist"); // DB has been seeded } else { var studentterms = new StudentTerm[] { new StudentTerm { StudentTermId = 1, DegreePlanId = 7251, Term = 1, TermAbbr = "F18", TermName = " Fall2018", NoOfCoursesTaken = 4 }, new StudentTerm { StudentTermId = 2, DegreePlanId = 7251, Term = 2, TermAbbr = "s19 ", TermName = "Spring2019", NoOfCoursesTaken = 3 }, new StudentTerm { StudentTermId = 3, DegreePlanId = 7251, Term = 3, TermAbbr = "Su19", TermName = "Summer2019", NoOfCoursesTaken = 0 }, new StudentTerm { StudentTermId = 4, DegreePlanId = 7251, Term = 4, TermAbbr = "F19", TermName = "Fall2019", NoOfCoursesTaken = 3 }, new StudentTerm { StudentTermId = 5, DegreePlanId = 7251, Term = 5, TermAbbr = "s20", TermName = " Spring2020", NoOfCoursesTaken = 2 }, new StudentTerm { StudentTermId = 6, DegreePlanId = 7253, Term = 1, TermAbbr = "F19 ", TermName = "Fall2019", NoOfCoursesTaken = 4 }, new StudentTerm { StudentTermId = 7, DegreePlanId = 7253, Term = 2, TermAbbr = "s20 ", TermName = "Spring2020", NoOfCoursesTaken = 3 }, new StudentTerm { StudentTermId = 8, DegreePlanId = 7253, Term = 3, TermAbbr = "Su20", TermName = "Summer2020", NoOfCoursesTaken = 2 }, new StudentTerm { StudentTermId = 9, DegreePlanId = 7253, Term = 4, TermAbbr = "F20 ", TermName = " Fall2020", NoOfCoursesTaken = 2 }, new StudentTerm { StudentTermId = 10, DegreePlanId = 7253, Term = 5, TermAbbr = "S21", TermName = "Spring2021", NoOfCoursesTaken = 2 }, new StudentTerm { StudentTermId = 11, DegreePlanId = 7254, Term = 1, TermAbbr = "S19", TermName = "Spring2019", NoOfCoursesTaken = 4 }, new StudentTerm { StudentTermId = 12, DegreePlanId = 7254, Term = 2, TermAbbr = "Su19", TermName = "Summer2019", NoOfCoursesTaken = 0 }, new StudentTerm { StudentTermId = 13, DegreePlanId = 7254, Term = 3, TermAbbr = "F19", TermName = "Fall2019", NoOfCoursesTaken = 3 }, new StudentTerm { StudentTermId = 14, DegreePlanId = 7254, Term = 4, TermAbbr = "S20", TermName = "Spring2020", NoOfCoursesTaken = 3 }, new StudentTerm { StudentTermId = 15, DegreePlanId = 7254, Term = 5, TermAbbr = "Su20 ", TermName = "Summer2020", NoOfCoursesTaken = 3 }, }; foreach (StudentTerm e in studentterms) { context.StudentTerms.Add(e); } context.SaveChanges(); } }