public async Task <IActionResult> Edit(int id, [Bind("DegreeRequirementID,StudentTermID,RequirementID")] DegreeRequirement degreeRequirement)
{
if (id != degreeRequirement.DegreeRequirementID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(degreeRequirement);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DegreeRequirementExists(degreeRequirement.DegreeRequirementID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["RequirementID"] = new SelectList(_context.Requirements, "RequirementID", "RequirementID", degreeRequirement.RequirementID);
ViewData["StudentTermID"] = new SelectList(_context.StudentTerms, "StudentTermId", "TermName", degreeRequirement.StudentTermID);
return(View(degreeRequirement));
}
public async Task <IActionResult> Edit(int id, [Bind("DegreeRequirementId,DegreeId,RequirementNumber,RequirementAbbrev,RequirementName")] DegreeRequirement degreeRequirement)
{
if (id != degreeRequirement.DegreeRequirementId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(degreeRequirement);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DegreeRequirementExists(degreeRequirement.DegreeRequirementId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DegreeId"] = new SelectList(_context.Degrees, "DegreeID", "DegreeID", degreeRequirement.DegreeId);
return(View(degreeRequirement));
}
public ScheduledCourse(Course course, Semester semester, int year, DegreeRequirement req = null)
{
Semester = semester;
Course = course;
Year = year;
Requirement = req;
}
public async Task <IActionResult> Create([Bind("DegreeRequirementId,DegreeId,RequirementNumber,RequirementAbbrev,RequirementName")] DegreeRequirement degreeRequirement)
{
if (ModelState.IsValid)
{
_context.Add(degreeRequirement);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DegreeId"] = new SelectList(_context.Degrees, "DegreeID", "DegreeID", degreeRequirement.DegreeId);
return(View(degreeRequirement));
}
public async Task <IActionResult> Create([Bind("DegreeRequirementId,DegreeId,RequirementId, Done")] DegreeRequirement degreeRequirement)
{
if (ModelState.IsValid)
{
_context.Add(degreeRequirement);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(degreeRequirement));
}
public async Task <IActionResult> Create([Bind("DegreeRequirementID,StudentTermID,RequirementID")] DegreeRequirement degreeRequirement)
{
if (ModelState.IsValid)
{
_context.Add(degreeRequirement);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["RequirementID"] = new SelectList(_context.Requirements, "RequirementID", "RequirementID", degreeRequirement.RequirementID);
ViewData["StudentTermID"] = new SelectList(_context.StudentTerms, "StudentTermId", "TermName", degreeRequirement.StudentTermID);
return(View(degreeRequirement));
}
public RequirementEntry(DataManager.Data.DegreeRequirement req)
{
InitializeComponent();
if (req != null)
{
this.req = req;
IEnumerable<Course> courseList = CourseCatalog.Instance.GetCourses(req.CourseRequirement);
this.courses.Content = CourseCatalog.FormatCourseList(courseList);
updateContent();
}
DialogManager.Instance.CurrStudent.ScheduleChanged += Student_ScheduleChanged;
DialogManager.Instance.CurrStudent.BookmarksChanged += Student_BookmarksChanged;
}
public void LoadData()
{
Debug.WriteLine("Reading list of degrees");
try
{
StreamReader deparmentsReader = new StreamReader(degreeList);
string degree;
while ((degree = deparmentsReader.ReadLine()) != null)
{
String filename = String.Format("Curricula/{0}.json", degree);
if (File.Exists(filename))
{
Debug.WriteLine(filename);
String fileContents = System.IO.File.ReadAllText(filename);
JArray json = JArray.Parse(fileContents);
foreach (JToken jsonItem in json)
{
if (jsonItem["type"].ToString().Equals("filter"))
{
IFilter<Course> filter = ParseCourseFilter(jsonItem["filter"]);
if (!orphanedFilters.ContainsKey(jsonItem.Value<String>("id")))
{
orphanedFilters.Add(jsonItem.Value<String>("id"), filter);
}
}
else
{
// likely only 1 per file
String name = jsonItem["name"].ToString();
DegreeProgram program = new DegreeProgram(name);
Degrees.Add(program);
JToken reqs = jsonItem["requirements"];
foreach (JToken jsonDegreeCategory in reqs)
{
DegreeRequirementCategory cat = new DegreeRequirementCategory(jsonDegreeCategory["name"].ToString());
JToken filters = jsonDegreeCategory["filters"];
foreach (JToken jsonCourseFilter in filters)
{
IFilter<Course> courseFilter = ParseCourseFilter(jsonCourseFilter);
if (courseFilter != null)
{
DegreeRequirement degreeReq = new DegreeRequirement();
degreeReq.Category = cat;
degreeReq.CourseRequirement = courseFilter;
if (jsonCourseFilter["id"] != null)
{
degreeReq.Name = jsonCourseFilter.Value<String>("id");
}
program.Requirements.Add(degreeReq);
}
}
}
}
}
}
}
}
catch (Exception e)
{
Debug.WriteLine("Count not read degrees.txt");
Debug.WriteLine(e.Message);
}
}
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)
{
//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)
{
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)
{
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();
}
}
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();
// 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();
}
}
