public async Task <IActionResult> Edit(int id, [Bind("DegreeCreditId,DegreeId,CreditId")] DegreeCredit degreeCredit)
{
if (id != degreeCredit.DegreeCreditId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(degreeCredit);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DegreeCreditExists(degreeCredit.DegreeCreditId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CreditId"] = new SelectList(_context.Credits, "CreditId", "CreditId", degreeCredit.CreditId);
ViewData["DegreeId"] = new SelectList(_context.Degrees, "DegreeId", "DegreeId", degreeCredit.DegreeId);
return(View(degreeCredit));
}
public override string ToString()
{
return(base.ToString() + ": " +
"SlotID = " + SlotID +
"StudentTermID = " + StudentTermID +
", Term = " + Term +
", DegreeCreditID = " + DegreeCreditID +
", StudentTerm = {" + StudentTerm.ToString() +
"}, DegreeCredit = {" + DegreeCredit.ToString() +
"}");
}
public async Task<IActionResult> Create([Bind("DegreeCreditId,DegreeId,CreditId")] DegreeCredit degreeCredit)
{
if (ModelState.IsValid)
{
_context.Add(degreeCredit);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
ViewData["CreditId"] = new SelectList(_context.Credits, "CreditId", "CreditId", degreeCredit.CreditId);
ViewData["DegreeId"] = new SelectList(_context.Degrees, "DegreeId", "DegreeId", degreeCredit.DegreeId);
return View(degreeCredit);
}
public static void Initialize(ApplicationDbContext context)
{
context.Database.EnsureCreated();
if (context.Degrees.Any())
{
Console.WriteLine("Degrees already exist.");
}
else
{
var degrees = new Degree[]
{
new Degree {
DegreeId = 1, DegreeAbbr = "ACS+2", DegreeName = "MS ACS+2", NumberOfTerms = 4
},
new Degree {
DegreeId = 2, DegreeAbbr = "ACS+DB", DegreeName = "MS ACS+DB", NumberOfTerms = 4
},
new Degree {
DegreeId = 3, DegreeAbbr = "ACS+NF", DegreeName = "MS ACS+NF", NumberOfTerms = 4
},
new Degree {
DegreeId = 4, DegreeAbbr = "ACS", DegreeName = "MS ACS", NumberOfTerms = 4
},
};
Console.WriteLine($"Inserted {degrees.Length} new degrees.");
foreach (Degree d in degrees)
{
context.Degrees.Add(d);
}
context.SaveChanges();
}
if (context.Credits.Any())
{
Console.WriteLine("Credits already exist.");
}
else
{
var credits = new Credit[]
{
new Credit {
CreditId = 460, DegreeId = 1, CreditAbbr = "DB", CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 356, DegreeId = 1, CreditAbbr = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 542, DegreeId = 1, CreditAbbr = "542", CreditName = "OOPS with Java", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 563, DegreeId = 1, CreditAbbr = "563", CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 560, DegreeId = 1, CreditAbbr = "560", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 664, DegreeId = 1, CreditAbbr = "664-UX", CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 618, DegreeId = 1, CreditAbbr = "618-PM", CreditName = "Project Management", IsSummer = 1, IsSpring = 0, IsFall = 0
},
new Credit {
CreditId = 555, DegreeId = 1, CreditAbbr = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 691, DegreeId = 1, CreditAbbr = "691-GDP1", CreditName = "GDP1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 692, DegreeId = 1, CreditAbbr = "692-GDP2", CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 6, DegreeId = 1, CreditAbbr = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 10, DegreeId = 1, CreditAbbr = "E1", CreditName = "Elective 1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 20, DegreeId = 1, CreditAbbr = "E2", CreditName = "Elective 2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
};
Console.WriteLine($"Inserted {credits.Length} new credits.");
foreach (Credit d in credits)
{
context.Credits.Add(d);
}
context.SaveChanges();
}
if (context.Students.Any())
{
Console.WriteLine("Students already exist.");
}
else
{
var students = new Student[]
{
new Student {
StudentId = 533725, Family = "Mamidi", Given = "Prakash", N919 = 919569651
},
new Student {
StudentId = 534049, Family = "Haritha", Given = "Atmakuri", N919 = 919569607
},
new Student {
StudentId = 533767, Family = "Badisa", Given = "SaiRam", N919 = 919565612
},
};
Console.WriteLine($"Inserted {students.Length} new students.");
foreach (Student d in students)
{
context.Students.Add(d);
}
context.SaveChanges();
}
if (context.DegreePlans.Any())
{
Console.WriteLine("Degree Plans already exist.");
}
else
{
var degreePlans = new DegreePlan[]
{
new DegreePlan {
DegreePlanId = 5431, DegreeId = 1, StudentId = 533725, DegreePlanAbbr = "Slow and easy", DegreePlanName = "Take a break in summer"
},
new DegreePlan {
DegreePlanId = 5432, DegreeId = 1, StudentId = 533725, DegreePlanAbbr = "Super Fast", DegreePlanName = "No break"
},
new DegreePlan {
DegreePlanId = 5433, DegreeId = 1, StudentId = 534049, DegreePlanAbbr = "Slow and easy", DegreePlanName = "As fast as I Can"
},
new DegreePlan {
DegreePlanId = 5434, DegreeId = 1, StudentId = 534049, DegreePlanAbbr = "Slow and easy", DegreePlanName = "Take less courses per semester"
},
new DegreePlan {
DegreePlanId = 5435, DegreeId = 1, StudentId = 533767, DegreePlanAbbr = "Super Fast", DegreePlanName = "More subjects in semesters"
},
new DegreePlan {
DegreePlanId = 5436, DegreeId = 1, StudentId = 533767, DegreePlanAbbr = "Slow and Consistent", DegreePlanName = "Take a break in summer"
},
};
Console.WriteLine($"Inserted {degreePlans.Length} new Degree Plans.");
foreach (DegreePlan d in degreePlans)
{
context.DegreePlans.Add(d);
}
context.SaveChanges();
}
if (context.Slots.Any())
{
Console.WriteLine("Slots already exist.");
}
else
{
var slots = new Slot[]
{
new Slot {
SlotId = 1, DegreePlanId = 5431, Term = 1, CreditId = 460, Status = "C"
},
new Slot {
SlotId = 2, DegreePlanId = 5431, Term = 1, CreditId = 356, Status = "C"
},
new Slot {
SlotId = 3, DegreePlanId = 5431, Term = 1, CreditId = 563, Status = "C"
},
new Slot {
SlotId = 4, DegreePlanId = 5431, Term = 1, CreditId = 542, Status = "C"
},
new Slot {
SlotId = 5, DegreePlanId = 5431, Term = 2, CreditId = 555, Status = "A"
},
new Slot {
SlotId = 6, DegreePlanId = 5431, Term = 2, CreditId = 560, Status = "A"
},
new Slot {
SlotId = 7, DegreePlanId = 5431, Term = 2, CreditId = 6, Status = "A"
},
new Slot {
SlotId = 8, DegreePlanId = 5431, Term = 3, CreditId = 10, Status = "-"
},
new Slot {
SlotId = 9, DegreePlanId = 5431, Term = 4, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 10, DegreePlanId = 5431, Term = 4, CreditId = 10, Status = "P"
},
new Slot {
SlotId = 11, DegreePlanId = 5431, Term = 5, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 12, DegreePlanId = 5431, Term = 5, CreditId = 692, Status = "P"
},
new Slot {
SlotId = 13, DegreePlanId = 5431, Term = 5, CreditId = 664, Status = "P"
},
};
Console.WriteLine($"Inserted {slots.Length} new slots.");
foreach (Slot d in slots)
{
context.Slots.Add(d);
}
context.SaveChanges();
}
if (context.DegreeCredits.Any())
{
Console.WriteLine("DegreeCredits already exist.");
}
else
{
var degreeCredits = new DegreeCredit[]
{
new DegreeCredit {
DegreeCreditId = 1, DegreeId = 1, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 2, DegreeId = 1, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 3, DegreeId = 1, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 4, DegreeId = 1, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 5, DegreeId = 1, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 6, DegreeId = 1, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 7, DegreeId = 1, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 8, DegreeId = 1, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 9, DegreeId = 1, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 10, DegreeId = 1, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 11, DegreeId = 1, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 12, DegreeId = 1, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 13, DegreeId = 1, CreditId = 20
},
};
Console.WriteLine($"Inserted {degreeCredits.Length} new degree credits.");
foreach (DegreeCredit d in degreeCredits)
{
context.DegreeCredits.Add(d);
}
context.SaveChanges();
}
if (context.StudentTerms.Any())
{
Console.WriteLine("Student Terms already exist.");
}
else
{
var studentTerms = new StudentTerm[]
{
new StudentTerm {
StudentTermId = 1, DegreePlanId = 5431, Term = 1, TermAbbr = "F18", TermName = "Fall2018"
},
new StudentTerm {
StudentTermId = 2, DegreePlanId = 5431, Term = 2, TermAbbr = "s19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermId = 3, DegreePlanId = 5431, Term = 3, TermAbbr = "Su19", TermName = "Summer2019"
},
new StudentTerm {
StudentTermId = 4, DegreePlanId = 5431, Term = 4, TermAbbr = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermId = 5, DegreePlanId = 5431, Term = 5, TermAbbr = "s20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermId = 6, DegreePlanId = 5431, Term = 1, TermAbbr = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermId = 7, DegreePlanId = 5431, Term = 2, TermAbbr = "s20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermId = 8, DegreePlanId = 5431, Term = 3, TermAbbr = "Su20", TermName = "Summer2020"
},
new StudentTerm {
StudentTermId = 9, DegreePlanId = 5431, Term = 4, TermAbbr = "F20", TermName = "Fall2020"
},
new StudentTerm {
StudentTermId = 10, DegreePlanId = 5431, Term = 5, TermAbbr = "S21", TermName = "Spring2021"
},
new StudentTerm {
StudentTermId = 11, DegreePlanId = 5431, Term = 1, TermAbbr = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermId = 12, DegreePlanId = 5431, Term = 2, TermAbbr = "Su19", TermName = "Summer2019"
},
new StudentTerm {
StudentTermId = 13, DegreePlanId = 5431, Term = 3, TermAbbr = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermId = 14, DegreePlanId = 5431, Term = 4, TermAbbr = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermId = 15, DegreePlanId = 5431, Term = 5, TermAbbr = "Su20", TermName = "Summer2020"
},
};
Console.WriteLine($"Inserted {studentTerms.Length} new student terms.");
foreach (StudentTerm d in studentTerms)
{
context.StudentTerms.Add(d);
}
context.SaveChanges();
}
}
public static void Initialize(ApplicationDbContext context)
{
if (context.Slots.Any())
{
Console.WriteLine("Slots already exist");
}
else
{
var slots = new Slot[] {
//new Slot{SlotID =1,DegreePlan =7255,Term=1,CreditID=356,Status='B'},
//new Slot{SlotID =2,DegreePlan =7255,Term=1,CreditID=542,Status='B'},
new Slot {
SlotID = 1, DegreePlanID = 7255, Term = 1, CreditID = 356, Status = B
},
new Slot {
SlotID = 2, DegreePlanID = 7255, Term = 1, CreditID = 542, Status = B
},
new Slot {
SlotID = 3, DegreePlanID = 7255, Term = 1, CreditID = 563, Status = C
},
new Slot {
SlotID = 4, DegreePlanID = 7255, Term = 2, CreditID = 560, Status = C
},
new Slot {
SlotID = 5, DegreePlanID = 7255, Term = 2, CreditID = 664, Status = B
},
new Slot {
SlotID = 6, DegreePlanID = 7255, Term = 2, CreditID = 6, Status = B
},
new Slot {
SlotID = 7, DegreePlanID = 7255, Term = 3, CreditID = 618, Status = B
},
new Slot {
SlotID = 8, DegreePlanID = 7255, Term = 3, CreditID = 691, Status = B
},
new Slot {
SlotID = 9, DegreePlanID = 7255, Term = 3, CreditID = 10, Status = B
},
new Slot {
SlotID = 10, DegreePlanID = 7255, Term = 4, CreditID = 20, Status = B
},
new Slot {
SlotID = 11, DegreePlanID = 7255, Term = 4, CreditID = 692, Status = B
},
new Slot {
SlotID = 12, DegreePlanID = 7255, Term = 4, CreditID = 555, Status = B
},
new Slot {
SlotID = 13, DegreePlanID = 7256, Term = 1, CreditID = 356, Status = B
},
new Slot {
SlotID = 14, DegreePlanID = 7256, Term = 1, CreditID = 542, Status = B
},
new Slot {
SlotID = 15, DegreePlanID = 7256, Term = 1, CreditID = 563, Status = B
},
new Slot {
SlotID = 16, DegreePlanID = 7256, Term = 2, CreditID = 560, Status = B
},
new Slot {
SlotID = 17, DegreePlanID = 7256, Term = 2, CreditID = 664, Status = B
},
new Slot {
SlotID = 18, DegreePlanID = 7256, Term = 2, CreditID = 6, Status = B
},
new Slot {
SlotID = 19, DegreePlanID = 7256, Term = 3, CreditID = 618, Status = B
},
new Slot {
SlotID = 20, DegreePlanID = 7256, Term = 3, CreditID = 691, Status = B
},
new Slot {
SlotID = 21, DegreePlanID = 7256, Term = 3, CreditID = 10, Status = B
},
new Slot {
SlotID = 22, DegreePlanID = 7256, Term = 4, CreditID = 20, Status = B
},
new Slot {
SlotID = 23, DegreePlanID = 7256, Term = 4, CreditID = 692, Status = B
},
new Slot {
SlotID = 24, DegreePlanID = 7256, Term = 4, CreditID = 555, Status = B
},
new Slot {
SlotID = 25, DegreePlanID = 7259, Term = 1, CreditID = 356, Status = B
},
new Slot {
SlotID = 26, DegreePlanID = 7259, Term = 1, CreditID = 542, Status = B
},
new Slot {
SlotID = 27, DegreePlanID = 7259, Term = 1, CreditID = 563, Status = C
},
new Slot {
SlotID = 28, DegreePlanID = 7259, Term = 2, CreditID = 560, Status = C
},
new Slot {
SlotID = 29, DegreePlanID = 7259, Term = 2, CreditID = 10, Status = A
},
new Slot {
SlotID = 30, DegreePlanID = 7259, Term = 2, CreditID = 6, Status = A
},
new Slot {
SlotID = 31, DegreePlanID = 7259, Term = 3, CreditID = 618, Status = A
},
new Slot {
SlotID = 32, DegreePlanID = 7259, Term = 4, CreditID = 691, Status = A
},
new Slot {
SlotID = 33, DegreePlanID = 7259, Term = 4, CreditID = 20, Status = A
},
new Slot {
SlotID = 34, DegreePlanID = 7259, Term = 5, CreditID = 692, Status = A
},
new Slot {
SlotID = 35, DegreePlanID = 7259, Term = 5, CreditID = 555, Status = A
},
new Slot {
SlotID = 36, DegreePlanID = 7259, Term = 5, CreditID = 664, Status = A
},
new Slot {
SlotID = 37, DegreePlanID = 7260, Term = 1, CreditID = 356, Status = A
},
new Slot {
SlotID = 38, DegreePlanID = 7260, Term = 1, CreditID = 542, Status = A
},
new Slot {
SlotID = 39, DegreePlanID = 7260, Term = 1, CreditID = 563, Status = A
},
new Slot {
SlotID = 40, DegreePlanID = 7260, Term = 2, CreditID = 560, Status = A
},
new Slot {
SlotID = 41, DegreePlanID = 7260, Term = 2, CreditID = 10, Status = A
},
new Slot {
SlotID = 42, DegreePlanID = 7260, Term = 2, CreditID = 6, Status = A
},
new Slot {
SlotID = 43, DegreePlanID = 7260, Term = 4, CreditID = 691, Status = A
},
new Slot {
SlotID = 44, DegreePlanID = 7260, Term = 4, CreditID = 20, Status = A
},
new Slot {
SlotID = 45, DegreePlanID = 7260, Term = 5, CreditID = 692, Status = A
},
new Slot {
SlotID = 46, DegreePlanID = 7260, Term = 5, CreditID = 555, Status = A
},
new Slot {
SlotID = 47, DegreePlanID = 7260, Term = 5, CreditID = 664, Status = A
},
new Slot {
SlotID = 48, DegreePlanID = 7260, Term = 3, CreditID = 618, Status = A
},
new Slot {
SlotID = 50, DegreePlanID = 7261, Term = 1, CreditID = 542, Status = B
},
new Slot {
SlotID = 51, DegreePlanID = 7261, Term = 1, CreditID = 563, Status = B
},
new Slot {
SlotID = 52, DegreePlanID = 7261, Term = 1, CreditID = 356, Status = C
},
new Slot {
SlotID = 53, DegreePlanID = 7261, Term = 1, CreditID = 560, Status = C
},
new Slot {
SlotID = 54, DegreePlanID = 7261, Term = 2, CreditID = 664, Status = B
},
new Slot {
SlotID = 55, DegreePlanID = 7261, Term = 2, CreditID = 6, Status = B
},
new Slot {
SlotID = 56, DegreePlanID = 7261, Term = 2, CreditID = 10, Status = B
},
new Slot {
SlotID = 57, DegreePlanID = 7261, Term = 3, CreditID = 20, Status = B
},
new Slot {
SlotID = 58, DegreePlanID = 7261, Term = 3, CreditID = 691, Status = B
},
new Slot {
SlotID = 59, DegreePlanID = 7261, Term = 3, CreditID = 618, Status = B
},
new Slot {
SlotID = 60, DegreePlanID = 7261, Term = 4, CreditID = 555, Status = B
},
new Slot {
SlotID = 61, DegreePlanID = 7261, Term = 4, CreditID = 692, Status = B
},
new Slot {
SlotID = 62, DegreePlanID = 7262, Term = 1, CreditID = 542, Status = B
},
new Slot {
SlotID = 63, DegreePlanID = 7262, Term = 1, CreditID = 563, Status = B
},
new Slot {
SlotID = 64, DegreePlanID = 7262, Term = 1, CreditID = 356, Status = C
},
new Slot {
SlotID = 65, DegreePlanID = 7262, Term = 1, CreditID = 560, Status = C
},
new Slot {
SlotID = 66, DegreePlanID = 7262, Term = 2, CreditID = 664, Status = B
},
new Slot {
SlotID = 67, DegreePlanID = 7262, Term = 2, CreditID = 6, Status = B
},
new Slot {
SlotID = 68, DegreePlanID = 7262, Term = 2, CreditID = 10, Status = B
},
new Slot {
SlotID = 69, DegreePlanID = 7262, Term = 3, CreditID = 20, Status = B
},
new Slot {
SlotID = 70, DegreePlanID = 7262, Term = 3, CreditID = 691, Status = B
},
new Slot {
SlotID = 71, DegreePlanID = 7262, Term = 3, CreditID = 618, Status = B
},
new Slot {
SlotID = 72, DegreePlanID = 7262, Term = 4, CreditID = 555, Status = B
},
new Slot {
SlotID = 73, DegreePlanID = 7262, Term = 4, CreditID = 692, Status = B
},
new Slot {
SlotID = 74, DegreePlanID = 7253, Term = 1, CreditID = 542, Status = C
},
new Slot {
SlotID = 75, DegreePlanID = 7253, Term = 1, CreditID = 356, Status = C
},
new Slot {
SlotID = 76, DegreePlanID = 7253, Term = 1, CreditID = 563, Status = C
},
new Slot {
SlotID = 77, DegreePlanID = 7253, Term = 2, CreditID = 560, Status = A
},
new Slot {
SlotID = 78, DegreePlanID = 7253, Term = 2, CreditID = 6, Status = A
},
new Slot {
SlotID = 79, DegreePlanID = 7253, Term = 2, CreditID = 555, Status = A
},
new Slot {
SlotID = 80, DegreePlanID = 7253, Term = 3, CreditID = 664, Status = P
},
new Slot {
SlotID = 81, DegreePlanID = 7253, Term = 3, CreditID = 691, Status = P
},
new Slot {
SlotID = 82, DegreePlanID = 7253, Term = 3, CreditID = 618, Status = P
},
new Slot {
SlotID = 83, DegreePlanID = 7253, Term = 4, CreditID = 692, Status = P
},
new Slot {
SlotID = 84, DegreePlanID = 7253, Term = 4, CreditID = 10, Status = P
},
new Slot {
SlotID = 85, DegreePlanID = 7253, Term = 4, CreditID = 20, Status = P
},
new Slot {
SlotID = 86, DegreePlanID = 7254, Term = 1, CreditID = 356, Status = C
},
new Slot {
SlotID = 87, DegreePlanID = 7254, Term = 1, CreditID = 542, Status = C
},
new Slot {
SlotID = 88, DegreePlanID = 7254, Term = 1, CreditID = 563, Status = C
},
new Slot {
SlotID = 89, DegreePlanID = 7254, Term = 2, CreditID = 560, Status = A
},
new Slot {
SlotID = 90, DegreePlanID = 7254, Term = 2, CreditID = 664, Status = A
},
new Slot {
SlotID = 91, DegreePlanID = 7254, Term = 2, CreditID = 6, Status = A
},
new Slot {
SlotID = 92, DegreePlanID = 7254, Term = 3, CreditID = 691, Status = P
},
new Slot {
SlotID = 93, DegreePlanID = 7254, Term = 3, CreditID = 10, Status = P
},
new Slot {
SlotID = 94, DegreePlanID = 7254, Term = 3, CreditID = 20, Status = P
},
new Slot {
SlotID = 95, DegreePlanID = 7254, Term = 4, CreditID = 618, Status = P
},
new Slot {
SlotID = 96, DegreePlanID = 7254, Term = 5, CreditID = 692, Status = P
},
new Slot {
SlotID = 97, DegreePlanID = 7254, Term = 5, CreditID = 555, Status = P
},
new Slot {
SlotID = 98, DegreePlanID = 7257, Term = 1, CreditID = 356, Status = A
},
new Slot {
SlotID = 99, DegreePlanID = 7257, Term = 1, CreditID = 563, Status = A
},
new Slot {
SlotID = 100, DegreePlanID = 7257, Term = 1, CreditID = 542, Status = A
},
new Slot {
SlotID = 101, DegreePlanID = 7257, Term = 1, CreditID = 560, Status = A
},
new Slot {
SlotID = 102, DegreePlanID = 7257, Term = 2, CreditID = 6, Status = A
},
new Slot {
SlotID = 103, DegreePlanID = 7257, Term = 2, CreditID = 664, Status = A
},
new Slot {
SlotID = 104, DegreePlanID = 7257, Term = 2, CreditID = 10, Status = A
},
new Slot {
SlotID = 105, DegreePlanID = 7257, Term = 3, CreditID = 618, Status = A
},
new Slot {
SlotID = 106, DegreePlanID = 7257, Term = 3, CreditID = 691, Status = A
},
new Slot {
SlotID = 107, DegreePlanID = 7257, Term = 4, CreditID = 692, Status = A
},
new Slot {
SlotID = 108, DegreePlanID = 7257, Term = 4, CreditID = 555, Status = A
},
new Slot {
SlotID = 109, DegreePlanID = 7257, Term = 4, CreditID = 20, Status = A
},
new Slot {
SlotID = 110, DegreePlanID = 7258, Term = 1, CreditID = 356, Status = A
},
new Slot {
SlotID = 111, DegreePlanID = 7258, Term = 1, CreditID = 563, Status = A
},
new Slot {
SlotID = 112, DegreePlanID = 7258, Term = 1, CreditID = 542, Status = A
},
new Slot {
SlotID = 113, DegreePlanID = 7258, Term = 1, CreditID = 560, Status = A
},
new Slot {
SlotID = 114, DegreePlanID = 7258, Term = 2, CreditID = 6, Status = A
},
new Slot {
SlotID = 115, DegreePlanID = 7258, Term = 2, CreditID = 664, Status = A
},
new Slot {
SlotID = 116, DegreePlanID = 7258, Term = 2, CreditID = 10, Status = A
},
new Slot {
SlotID = 117, DegreePlanID = 7258, Term = 3, CreditID = 691, Status = A
},
new Slot {
SlotID = 118, DegreePlanID = 7258, Term = 3, CreditID = 20, Status = A
},
new Slot {
SlotID = 119, DegreePlanID = 7258, Term = 4, CreditID = 692, Status = A
},
new Slot {
SlotID = 120, DegreePlanID = 7258, Term = 4, CreditID = 555, Status = A
},
new Slot {
SlotID = 121, DegreePlanID = 7258, Term = 5, CreditID = 618, Status = A
},
};
Console.WriteLine($"Inserted{slots.Length} new slots.");
foreach (Slot s in slots)
{
context.Slots.Add(s);
}
context.SaveChanges();
}
if (context.Students.Any())
{
Console.WriteLine("Students already exist");
}
else
{
var students = new Student[] {
new Student {
StudentID = 533491, LastName = "Pasham", FirstName = "Goutami", _919 = 919564044
},
new Student {
StudentID = 533705, LastName = "Adusumalli", FirstName = "Gangadhar", _919 = 919570593
},
new Student {
StudentID = 533988, LastName = "Singam", FirstName = "Poojitha", _919 = 919571721
},
new Student {
StudentID = 533622, LastName = "Gattu", FirstName = "Srujana", _919 = 919569251
},
new Student {
StudentID = 533727, LastName = "Poshala", FirstName = "Himabindu", _919 = 919571930
}
};
Console.WriteLine($"Inserted{students.Length} new students.");
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
}
if (context.Credits.Any())
{
Console.WriteLine("Credits already exist");
}
else
{
var credits = new Credit[] {
new Credit {
CreditID = 356, CreditAbbrev = "NF", CreditName = "Network Fundamentals", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 542, CreditAbbrev = "542", CreditName = "OOPS with JAVA", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 563, CreditAbbrev = "563", CreditName = "Web Apps", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 560, CreditAbbrev = "560-ADB", CreditName = "Advanced Databases", IsSummer = 1, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 664, CreditAbbrev = "664-UX", CreditName = "User Experience Design", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 618, CreditAbbrev = "618-PM", CreditName = "Project Management", IsSummer = 1, ISSpring = 0, IsFall = 0
},
new Credit {
CreditID = 555, CreditAbbrev = "555-NS", CreditName = "Network Security", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 691, CreditAbbrev = "691-GDP1", CreditName = "GDP1", IsSummer = 1, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 692, CreditAbbrev = "692-GDP2", CreditName = "GDP2", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 6, CreditAbbrev = "MOBILE", CreditName = "643 or 644 Mobile", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 10, CreditAbbrev = "E1", CreditName = "Elective1", IsSummer = 0, ISSpring = 1, IsFall = 1
},
new Credit {
CreditID = 20, CreditAbbrev = "E2", CreditName = "Elective2", IsSummer = 0, ISSpring = 1, IsFall = 1
}
};
Console.WriteLine($"Inserted{credits.Length} new credit.");
foreach (Credit s in credits)
{
context.Credits.Add(s);
}
context.SaveChanges();
}
if (context.Degrees.Any())
{
Console.WriteLine("Degreess already exist");
}
else
{
var degrees = new Degree[] {
new Degree {
DegreeID = 1, DegreeAbbrev = "ACS+2", DegreeName = "Ms ACS+2", NumberOFTerms = 5
},
new Degree {
DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "Ms ACS+DB", NumberOFTerms = 5
},
new Degree {
DegreeID = 3, DegreeAbbrev = "ACS+NF", DegreeName = "Ms ACS+NF", NumberOFTerms = 5
},
new Degree {
DegreeID = 4, DegreeAbbrev = "ACS", DegreeName = "Ms ACS", NumberOFTerms = 5
}
};
Console.WriteLine($"Inserted{degrees.Length} new degree.");
foreach (Degree s in degrees)
{
context.Degrees.Add(s);
}
context.SaveChanges();
}
if (context.DegreeCredits.Any())
{
Console.WriteLine("Degrees credit already exist");
}
else
{
var degreecredits = new DegreeCredit[] {
new DegreeCredit {
DegreeCreditID = 1, DegreeID = 1, CreditID = 460
},
new DegreeCredit {
DegreeCreditID = 2, DegreeID = 1, CreditID = 356
},
new DegreeCredit {
DegreeCreditID = 3, DegreeID = 1, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 4, DegreeID = 1, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 5, DegreeID = 1, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 6, DegreeID = 1, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 7, DegreeID = 1, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 8, DegreeID = 1, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 9, DegreeID = 1, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 10, DegreeID = 1, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 11, DegreeID = 1, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 12, DegreeID = 1, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 13, DegreeID = 1, CreditID = 20
},
new DegreeCredit {
DegreeCreditID = 14, DegreeID = 2, CreditID = 460
},
new DegreeCredit {
DegreeCreditID = 15, DegreeID = 2, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 16, DegreeID = 2, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 17, DegreeID = 2, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 18, DegreeID = 2, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 19, DegreeID = 2, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 20, DegreeID = 2, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 21, DegreeID = 2, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 22, DegreeID = 2, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 23, DegreeID = 2, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 24, DegreeID = 2, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 25, DegreeID = 2, CreditID = 20
},
new DegreeCredit {
DegreeCreditID = 26, DegreeID = 3, CreditID = 356
},
new DegreeCredit {
DegreeCreditID = 27, DegreeID = 3, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 28, DegreeID = 3, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 29, DegreeID = 3, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 30, DegreeID = 3, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 31, DegreeID = 3, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 32, DegreeID = 3, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 33, DegreeID = 3, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 34, DegreeID = 3, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 35, DegreeID = 3, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 36, DegreeID = 3, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 37, DegreeID = 3, CreditID = 20
},
new DegreeCredit {
DegreeCreditID = 38, DegreeID = 4, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 39, DegreeID = 4, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 40, DegreeID = 4, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 41, DegreeID = 4, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 42, DegreeID = 4, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 43, DegreeID = 4, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 44, DegreeID = 4, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 45, DegreeID = 4, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 46, DegreeID = 4, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 47, DegreeID = 4, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 48, DegreeID = 4, CreditID = 20
}
};
Console.WriteLine($"Inserted{degreecredits.Length} new degree.");
foreach (DegreeCredit s in degreecredits)
{
context.DegreeCredits.Add(s);
}
context.SaveChanges();
}
if (context.StudentTerms.Any())
{
Console.WriteLine("Degreess already exist");
}
else
{
var studentterms = new StudentTerm[] {
new StudentTerm {
StudentTermID = 1, DegreePlanId = 7255, Term = 1, TermAbbrev = "F18", TermName = "Fall2018"
},
new StudentTerm {
StudentTermID = 2, DegreePlanId = 7255, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 3, DegreePlanId = 7255, Term = 3, TermAbbrev = "Sum", TermName = "Summer2019"
},
new StudentTerm {
StudentTermID = 4, DegreePlanId = 7255, Term = 4, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 5, DegreePlanId = 7256, Term = 1, TermAbbrev = "F18", TermName = "Fall2018"
},
new StudentTerm {
StudentTermID = 6, DegreePlanId = 7256, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 7, DegreePlanId = 7256, Term = 3, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 8, DegreePlanId = 7256, Term = 4, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 9, DegreePlanId = 7261, Term = 1, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 10, DegreePlanId = 7261, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020"
},
new StudentTerm {
StudentTermID = 11, DegreePlanId = 7261, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020"
},
new StudentTerm {
StudentTermID = 12, DegreePlanId = 7261, Term = 4, TermAbbrev = "F20", TermName = "Fall2020"
},
new StudentTerm {
StudentTermID = 13, DegreePlanId = 7262, Term = 1, TermAbbrev = "F19", TermName = "FALL2019"
},
new StudentTerm {
StudentTermID = 14, DegreePlanId = 7262, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020"
},
new StudentTerm {
StudentTermID = 15, DegreePlanId = 7262, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020"
},
new StudentTerm {
StudentTermID = 16, DegreePlanId = 7262, Term = 4, TermAbbrev = "F20", TermName = "FALL2020"
},
new StudentTerm {
StudentTermID = 17, DegreePlanId = 7262, Term = 5, TermAbbrev = "S21", TermName = "SPRING2021"
},
new StudentTerm {
StudentTermID = 18, DegreePlanId = 7259, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 19, DegreePlanId = 7259, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 20, DegreePlanId = 7259, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019"
},
new StudentTerm {
StudentTermID = 21, DegreePlanId = 7259, Term = 4, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 22, DegreePlanId = 7259, Term = 5, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 23, DegreePlanId = 7260, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 24, DegreePlanId = 7260, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 25, DegreePlanId = 7260, Term = 3, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 26, DegreePlanId = 7260, Term = 4, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 27, DegreePlanId = 7260, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020"
},
new StudentTerm {
StudentTermID = 28, DegreePlanId = 7257, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 29, DegreePlanId = 7257, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 30, DegreePlanId = 7257, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019"
},
new StudentTerm {
StudentTermID = 31, DegreePlanId = 7257, Term = 4, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 32, DegreePlanId = 7258, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 33, DegreePlanId = 7258, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 34, DegreePlanId = 7258, Term = 3, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 35, DegreePlanId = 7258, Term = 4, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 36, DegreePlanId = 7258, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020"
},
new StudentTerm {
StudentTermID = 37, DegreePlanId = 7253, Term = 1, TermAbbrev = "F 2018", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermID = 38, DegreePlanId = 7253, Term = 2, TermAbbrev = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermID = 39, DegreePlanId = 7253, Term = 3, TermAbbrev = "Sum19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermID = 40, DegreePlanId = 7253, Term = 4, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 41, DegreePlanId = 7254, Term = 1, TermAbbrev = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermID = 42, DegreePlanId = 7254, Term = 2, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 43, DegreePlanId = 7254, Term = 3, TermAbbrev = "S20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermID = 44, DegreePlanId = 7254, Term = 4, TermAbbrev = "Sum20", TermName = "Summer 2020"
},
new StudentTerm {
StudentTermID = 45, DegreePlanId = 7254, Term = 5, TermAbbrev = "F20", TermName = "Fall 2020"
},
};
Console.WriteLine($"Inserted{studentterms.Length} new student terms.");
foreach (StudentTerm s in studentterms)
{
context.Degrees.Add(s);
}
context.SaveChanges();
}
if (context.DegreePlans.Any())
{
Console.WriteLine("DegreePlans already exist");
}
else
{
var degreeplans = new DegreePlan[] {
new DegreePlan {
DegreePlanID = 7253, StudentID = 533705, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7254, StudentID = 533705, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7255, StudentID = 533491, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7256, StudentID = 533491, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7257, StudentID = 533727, DegreePlanAbbrev = "SuperFast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7258, StudentID = 533727, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7259, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7260, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7261, StudentID = 533988, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7262, StudentID = 533988, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
}
};
Console.WriteLine($"Inserted{degreeplans.Length} new degree plan.");
foreach (DegreePlan s in degreeplans)
{
context.DegreePlans.Add(s);
}
context.SaveChanges();
}
}
public static void Initialize(ApplicationDbContext context)
{
context.Database.EnsureCreated();
//for Degree Requirement - MEHAR CHOUDHARY
if (context.Degrees.Any())
{
Console.WriteLine("Degrees already exists.");
}
else
{
var degrees = new Degree[]
{
new Degree {
DegreeId = 1, DegreeAbbr = "ACS+2", NumberOfTerms = 5
},
new Degree {
DegreeId = 2, DegreeAbbr = "ACS+DB", NumberOfTerms = 5
},
new Degree {
DegreeId = 3, DegreeAbbr = "ACS+NF", NumberOfTerms = 5
},
new Degree {
DegreeId = 4, DegreeAbbr = "ACS", NumberOfTerms = 5
},
};
Console.WriteLine($"Inserted {degrees.Length} new degrees.");
foreach (Degree d in degrees)
{
context.Degrees.Add(d);
}
context.SaveChanges();
}
//for Credits - Aakash
if (context.Credits.Any())
{
Console.WriteLine("Credits already exist.");
}
else
{
var credit = new Credit[]
{
new Credit {
CreditId = 460, CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 356, CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 542, CreditName = "OOPS with Java", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 563, CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 560, CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 664, CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 618, CreditName = "Project Management", IsSummer = 1, IsSpring = 0, IsFall = 0
},
new Credit {
CreditId = 555, CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 691, CreditName = "GDP1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 692, CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 6, CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 10, CreditName = "Elective 1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 20, CreditName = "Elective 2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
};
Console.WriteLine($"Inserted {credit.Length} new credits.");
foreach (Credit d in credit)
{
context.Credits.Add(d);
}
context.SaveChanges();
}
//for DegreeCredit - Mehar Choudhary
if (context.DegreeCredits.Any())
{
Console.WriteLine("DegreeCredits already exist.");
}
else
{
var degreeCredits = new DegreeCredit[]
{
new DegreeCredit {
DegreeCreditId = 1, DegreeId = 1, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 2, DegreeId = 1, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 3, DegreeId = 1, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 4, DegreeId = 1, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 5, DegreeId = 1, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 6, DegreeId = 1, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 7, DegreeId = 1, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 8, DegreeId = 1, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 9, DegreeId = 1, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 10, DegreeId = 1, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 11, DegreeId = 1, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 12, DegreeId = 1, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 13, DegreeId = 1, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 14, DegreeId = 2, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 15, DegreeId = 2, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 16, DegreeId = 2, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 17, DegreeId = 2, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 18, DegreeId = 2, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 19, DegreeId = 2, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 20, DegreeId = 2, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 21, DegreeId = 2, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 22, DegreeId = 2, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 23, DegreeId = 2, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 24, DegreeId = 2, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 25, DegreeId = 2, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 26, DegreeId = 3, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 27, DegreeId = 3, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 28, DegreeId = 3, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 29, DegreeId = 3, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 30, DegreeId = 3, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 31, DegreeId = 3, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 32, DegreeId = 3, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 33, DegreeId = 3, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 34, DegreeId = 3, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 35, DegreeId = 3, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 36, DegreeId = 3, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 37, DegreeId = 3, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 38, DegreeId = 4, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 39, DegreeId = 4, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 40, DegreeId = 4, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 41, DegreeId = 4, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 42, DegreeId = 4, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 43, DegreeId = 4, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 44, DegreeId = 4, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 45, DegreeId = 4, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 46, DegreeId = 4, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 47, DegreeId = 4, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 48, DegreeId = 4, CreditId = 20
},
};
Console.WriteLine($"Inserted {degreeCredits.Length} new degree credits.");
foreach (DegreeCredit d in degreeCredits)
{
context.DegreeCredits.Add(d);
}
context.SaveChanges();
}
//for Student Id- Dasari
if (context.Students.Any())
{
Console.WriteLine("Students already exist.");
}
else
{
var students = new Student[]
{
new Student {
StudentId = 533904, Family = "Peddi", Given = "Tarak", Snumber = "S533904", N919 = 91957050
},
new Student {
StudentId = 533976, Family = "Meenavilli", Given = "Mehar Choudhary", Snumber = "S533976", N919 = 919571539
},
new Student {
StudentId = 533489, Family = "Dasari", Given = "Venkat", Snumber = "S533489", N919 = 919568241
},
new Student {
StudentId = 533714, Family = "Valluru", Given = "Aakash", Snumber = "S533714", N919 = 919568635
},
};
Console.WriteLine($"Inserted {students.Length} new students.");
foreach (Student d in students)
{
context.Students.Add(d);
}
context.SaveChanges();
}
//for DegreePlan - Aakash
if (context.DegreePlans.Any())
{
Console.WriteLine("Degree Plans already exist.");
}
else
{
var degreePlans = new DegreePlan[]
{
new DegreePlan {
DegreePlanId = 1234, StudentId = 533904, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1
},
new DegreePlan {
DegreePlanId = 1235, StudentId = 533904, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2
},
new DegreePlan {
DegreePlanId = 1236, StudentId = 533489, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2
},
new DegreePlan {
DegreePlanId = 1237, StudentId = 533489, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1
},
new DegreePlan {
DegreePlanId = 1238, StudentId = 533976, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1
},
new DegreePlan {
DegreePlanId = 1239, StudentId = 533976, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2
},
new DegreePlan {
DegreePlanId = 1240, StudentId = 533714, DegreePlanAbbr = "Super Fast", DegreePlanName = "With Summer", DegreePlanSelected = 2
},
new DegreePlan {
DegreePlanId = 1241, StudentId = 533714, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Without Summer", DegreePlanSelected = 1
},
};
Console.WriteLine($"Inserted {degreePlans.Length} new Degree Plans.");
foreach (DegreePlan d in degreePlans)
{
context.DegreePlans.Add(d);
}
context.SaveChanges();
}
//for Slot - Raviteja
if (context.Slots.Any())
{
Console.WriteLine("Slots already exist.");
}
else
{
var slots = new Slot[]
{
new Slot {
SlotId = 1, DegreePlanId = 1235, Term = 1, CreditId = 542, Status = "C"
},
new Slot {
SlotId = 2, DegreePlanId = 1235, Term = 1, CreditId = 563, Status = "C"
},
new Slot {
SlotId = 3, DegreePlanId = 1235, Term = 1, CreditId = 560, Status = "C"
},
new Slot {
SlotId = 4, DegreePlanId = 1235, Term = 2, CreditId = 664, Status = "A"
},
new Slot {
SlotId = 5, DegreePlanId = 1235, Term = 2, CreditId = 6, Status = "A"
},
new Slot {
SlotId = 6, DegreePlanId = 1235, Term = 2, CreditId = 10, Status = "A"
},
new Slot {
SlotId = 7, DegreePlanId = 1235, Term = 3, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 8, DegreePlanId = 1235, Term = 3, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 9, DegreePlanId = 1235, Term = 4, CreditId = 692, Status = "P"
},
new Slot {
SlotId = 10, DegreePlanId = 1235, Term = 4, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 11, DegreePlanId = 1235, Term = 4, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 12, DegreePlanId = 1236, Term = 1, CreditId = 542, Status = "A"
},
new Slot {
SlotId = 13, DegreePlanId = 1236, Term = 1, CreditId = 563, Status = "A"
},
new Slot {
SlotId = 14, DegreePlanId = 1236, Term = 1, CreditId = 560, Status = "A"
},
new Slot {
SlotId = 15, DegreePlanId = 1236, Term = 2, CreditId = 664, Status = "P"
},
new Slot {
SlotId = 16, DegreePlanId = 1236, Term = 2, CreditId = 6, Status = "P"
},
new Slot {
SlotId = 17, DegreePlanId = 1236, Term = 2, CreditId = 10, Status = "P"
},
new Slot {
SlotId = 18, DegreePlanId = 1236, Term = 3, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 19, DegreePlanId = 1236, Term = 3, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 20, DegreePlanId = 1236, Term = 3, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 21, DegreePlanId = 1236, Term = 4, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 22, DegreePlanId = 1236, Term = 4, CreditId = 692, Status = "P"
},
new Slot {
SlotId = 23, DegreePlanId = 1239, Term = 1, CreditId = 542, Status = "C"
},
new Slot {
SlotId = 24, DegreePlanId = 1239, Term = 1, CreditId = 563, Status = "C"
},
new Slot {
SlotId = 25, DegreePlanId = 1239, Term = 1, CreditId = 560, Status = "C"
},
new Slot {
SlotId = 26, DegreePlanId = 1239, Term = 2, CreditId = 664, Status = "A"
},
new Slot {
SlotId = 27, DegreePlanId = 1239, Term = 2, CreditId = 6, Status = "A"
},
new Slot {
SlotId = 28, DegreePlanId = 1239, Term = 2, CreditId = 10, Status = "A"
},
new Slot {
SlotId = 29, DegreePlanId = 1239, Term = 3, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 30, DegreePlanId = 1239, Term = 4, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 31, DegreePlanId = 1239, Term = 4, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 32, DegreePlanId = 1239, Term = 5, CreditId = 692, Status = "P"
},
new Slot {
SlotId = 33, DegreePlanId = 1239, Term = 5, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 34, DegreePlanId = 1240, Term = 1, CreditId = 542, Status = "A"
},
new Slot {
SlotId = 35, DegreePlanId = 1240, Term = 1, CreditId = 563, Status = "A"
},
new Slot {
SlotId = 36, DegreePlanId = 1240, Term = 1, CreditId = 560, Status = "A"
},
new Slot {
SlotId = 37, DegreePlanId = 1240, Term = 2, CreditId = 664, Status = "P"
},
new Slot {
SlotId = 38, DegreePlanId = 1240, Term = 2, CreditId = 6, Status = "P"
},
new Slot {
SlotId = 39, DegreePlanId = 1240, Term = 2, CreditId = 10, Status = "P"
},
new Slot {
SlotId = 40, DegreePlanId = 1240, Term = 3, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 41, DegreePlanId = 1240, Term = 3, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 42, DegreePlanId = 1240, Term = 3, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 43, DegreePlanId = 1240, Term = 4, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 44, DegreePlanId = 1240, Term = 4, CreditId = 692, Status = "P"
},
};
Console.WriteLine($"Inserted {slots.Length} new slots.");
foreach (Slot d in slots)
{
context.Slots.Add(d);
}
context.SaveChanges();
}
//for StudentTerm - Raviteja
if (context.Terms.Any())
{
Console.WriteLine("Student Terms already exist.");
}
else
{
var studentTerms = new StudentTerm[]
{
new StudentTerm {
StudentTermId = 1, StudentId = 533904, Term = 1, TermAbbr = "F18", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermId = 2, StudentId = 533904, Term = 2, TermAbbr = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermId = 3, StudentId = 533904, Term = 3, TermAbbr = "Su19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermId = 4, StudentId = 533904, Term = 4, TermAbbr = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermId = 5, StudentId = 533489, Term = 3, TermAbbr = "S18", TermName = "Spring 2018"
},
new StudentTerm {
StudentTermId = 6, StudentId = 533489, Term = 4, TermAbbr = "Su18", TermName = "Summer 2018"
},
new StudentTerm {
StudentTermId = 7, StudentId = 533489, Term = 5, TermAbbr = "F18", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermId = 8, StudentId = 533489, Term = 6, TermAbbr = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermId = 9, StudentId = 533976, Term = 1, TermAbbr = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermId = 10, StudentId = 533976, Term = 2, TermAbbr = "S20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermId = 11, StudentId = 533976, Term = 3, TermAbbr = "Su20", TermName = "Summer 2020"
},
new StudentTerm {
StudentTermId = 12, StudentId = 533976, Term = 4, TermAbbr = "F20", TermName = "Fall 2020"
},
new StudentTerm {
StudentTermId = 13, StudentId = 533714, Term = 3, TermAbbr = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermId = 14, StudentId = 533714, Term = 4, TermAbbr = "Su19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermId = 15, StudentId = 533714, Term = 5, TermAbbr = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermId = 16, StudentId = 533714, Term = 6, TermAbbr = "S20", TermName = "Spring 2020"
},
};
Console.WriteLine($"Inserted {studentTerms.Length} new student terms.");
foreach (StudentTerm d in studentTerms)
{
context.Terms.Add(d);
}
context.SaveChanges();
}
}
public static void Initialize(ApplicationDbContext context)
{
// This section is for Harika: To work on Degree
if (context.Degrees.Any())
{
Console.WriteLine("Degree Already exists:");
}
else
{
var degrees = new Degree[]
{
new Degree {
DegreeID = 1, DegreeAbbrev = "ACS+2", DegreeName = "MS ACS+2", NumberOfTerms = 5
},
new Degree {
DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "MS ACS + DB", NumberOfTerms = 5
},
new Degree {
DegreeID = 3, DegreeAbbrev = "ACS+NF", DegreeName = "MS ACS + NF", NumberOfTerms = 5
},
new Degree {
DegreeID = 4, DegreeAbbrev = "ACS", DegreeName = "MS ACS", NumberOfTerms = 5
},
};
Console.WriteLine($"Inserted {degrees.Length} new degrees.");
foreach (Degree d in degrees)
{
context.Degrees.Add(d);
}
context.SaveChanges();
}
//This section ends
//This section is for Teja: To work on Credit
if (context.Credits.Any())
{
Console.WriteLine("Credit Already exists:");
}
else
{
var credits = new Credit[]
{
new Credit {
CreditID = 460, CreditAbbrev = "DB", CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 356, CreditAbbrev = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 542, CreditAbbrev = "542", CreditName = "OOP with Java", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 563, CreditAbbrev = "563", CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 560, CreditAbbrev = "560", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 664, CreditAbbrev = "664-UX", CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 618, CreditAbbrev = "618-PM", CreditName = "Project Management", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 555, CreditAbbrev = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 691, CreditAbbrev = "691-GDP1", CreditName = "GDP-1", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 692, CreditAbbrev = "692-GDP2", CreditName = "GDP-2", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 6, CreditAbbrev = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 1, CreditAbbrev = "E1", CreditName = "Elective1", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 2, CreditAbbrev = "E2", CreditName = "Elective2", IsSummer = 1, IsSpring = 1, IsFall = 1
},
};
Console.WriteLine($"Inserted {credits.Length} new credits.");
foreach (Credit d in credits)
{
context.Credits.Add(d);
}
context.SaveChanges();
}
//This is for Students
if (context.Students.Any())
{
Console.WriteLine("Student Already exists:");
}
else
{
var students = new Student[]
{
new Student {
StudentID = 533726, Family = "Narne", Given = "Sai Tejaswini", Snumber = 533726, number_919 = 919571565
},
new Student {
StudentID = 533490, Family = "Gadekari", Given = "Sonam", Snumber = 533490, number_919 = 919568899
},
new Student {
StudentID = 533711, Family = "Naidu", Given = "Harika", Snumber = 533711, number_919 = 919570594
},
};
Console.WriteLine($"Inserted {students.Length} new students.");
foreach (Student d in students)
{
context.Students.Add(d);
}
context.SaveChanges();
}
//This section ends
//This section ends: Credit
//This section is for Harika: Degree Credit
if (context.DegreeCredits.Any())
{
Console.WriteLine("Degree Credit Already exists:");
}
else
{
var degreesCredits = new DegreeCredit[]
{
new DegreeCredit {
DegreeCreditID = 1, DegreeID = 1, CreditID = 460
},
new DegreeCredit {
DegreeCreditID = 2, DegreeID = 1, CreditID = 356
},
new DegreeCredit {
DegreeCreditID = 3, DegreeID = 1, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 4, DegreeID = 1, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 5, DegreeID = 1, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 6, DegreeID = 1, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 7, DegreeID = 1, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 8, DegreeID = 1, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 9, DegreeID = 1, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 10, DegreeID = 1, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 11, DegreeID = 1, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 12, DegreeID = 1, CreditID = 1
},
new DegreeCredit {
DegreeCreditID = 13, DegreeID = 1, CreditID = 2
},
new DegreeCredit {
DegreeCreditID = 14, DegreeID = 2, CreditID = 460
},
new DegreeCredit {
DegreeCreditID = 15, DegreeID = 2, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 16, DegreeID = 2, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 17, DegreeID = 2, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 18, DegreeID = 2, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 19, DegreeID = 2, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 20, DegreeID = 2, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 21, DegreeID = 2, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 22, DegreeID = 2, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 23, DegreeID = 2, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 24, DegreeID = 2, CreditID = 1
},
new DegreeCredit {
DegreeCreditID = 25, DegreeID = 2, CreditID = 2
},
new DegreeCredit {
DegreeCreditID = 26, DegreeID = 3, CreditID = 356
},
new DegreeCredit {
DegreeCreditID = 27, DegreeID = 3, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 28, DegreeID = 3, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 29, DegreeID = 3, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 30, DegreeID = 3, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 31, DegreeID = 3, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 32, DegreeID = 3, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 33, DegreeID = 3, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 34, DegreeID = 3, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 35, DegreeID = 3, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 36, DegreeID = 3, CreditID = 1
},
new DegreeCredit {
DegreeCreditID = 37, DegreeID = 3, CreditID = 2
},
new DegreeCredit {
DegreeCreditID = 38, DegreeID = 4, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 39, DegreeID = 4, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 40, DegreeID = 4, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 41, DegreeID = 4, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 42, DegreeID = 4, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 43, DegreeID = 4, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 44, DegreeID = 4, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 45, DegreeID = 4, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 46, DegreeID = 4, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 47, DegreeID = 4, CreditID = 1
},
new DegreeCredit {
DegreeCreditID = 48, DegreeID = 4, CreditID = 2
},
};
Console.WriteLine($"Inserted {degreesCredits.Length} new degreesCredits.");
foreach (DegreeCredit d in degreesCredits)
{
context.DegreeCredits.Add(d);
}
context.SaveChanges();
}
//This section ends
//This section is for Teja: To work on Degree Plan
if (context.DegreePlans.Any())
{
Console.WriteLine("DegreePlans Already exists:");
}
else
{
var degreeplans = new DegreePlan[]
{
new DegreePlan {
DegreePlanID = 7250, StudentID = 533726, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a Summer off"
},
new DegreePlan {
DegreePlanID = 7251, StudentID = 533726, DegreePlanAbbrev = "Super Fast", DegreePlanName = "As fast as I can"
},
new DegreePlan {
DegreePlanID = 7252, StudentID = 533490, DegreePlanAbbrev = "Spring Super Slow", DegreePlanName = "As slow as it could be with a Summer off"
},
new DegreePlan {
DegreePlanID = 7253, StudentID = 533490, DegreePlanAbbrev = "Spring Super fast", DegreePlanName = "As fast as it could be"
},
new DegreePlan {
DegreePlanID = 7254, StudentID = 533711, DegreePlanAbbrev = "Early completion", DegreePlanName = "Fall 2018 fast track"
},
new DegreePlan {
DegreePlanID = 7255, StudentID = 533711, DegreePlanAbbrev = "Slow and Easy", DegreePlanName = "Take a Summer off"
},
};
Console.WriteLine($"Inserted {degreeplans.Length} new degreePlans.");
foreach (DegreePlan dp in degreeplans)
{
context.DegreePlans.Add(dp);
}
context.SaveChanges();
}
//This section ends
//This section is for Sonam: StudentTerms.cs
if (context.StudentTerms.Any())
{
Console.WriteLine("StudentTerms Already exists:");
}
else
{
var studentterms = new StudentTerm[]
{
new StudentTerm {
StudentTermID = 1, StudentID = 533726, Term = 1, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 2, StudentID = 533726, Term = 2, TermAbbrev = "S20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermID = 3, StudentID = 533726, Term = 3, TermAbbrev = "Su20", TermName = "Summer 2020"
},
new StudentTerm {
StudentTermID = 4, StudentID = 533726, Term = 4, TermAbbrev = "F20", TermName = "Fall 2020"
},
new StudentTerm {
StudentTermID = 5, StudentID = 533726, Term = 5, TermAbbrev = "S21", TermName = "Spring 2021"
},
new StudentTerm {
StudentTermID = 6, StudentID = 533490, Term = 1, TermAbbrev = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermID = 7, StudentID = 533490, Term = 2, TermAbbrev = "Su19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermID = 8, StudentID = 533490, Term = 3, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 9, StudentID = 533490, Term = 4, TermAbbrev = "S20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermID = 10, StudentID = 533490, Term = 5, TermAbbrev = "Su20", TermName = "Summer 2020"
},
new StudentTerm {
StudentTermID = 11, StudentID = 533490, Term = 6, TermAbbrev = "F20", TermName = "Fall 2020"
},
new StudentTerm {
StudentTermID = 12, StudentID = 533711, Term = 1, TermAbbrev = "F18", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermID = 13, StudentID = 533711, Term = 2, TermAbbrev = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermID = 14, StudentID = 533711, Term = 3, TermAbbrev = "Su19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermID = 15, StudentID = 533711, Term = 4, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 16, StudentID = 533711, Term = 5, TermAbbrev = "S20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermID = 17, StudentID = 533711, Term = 6, TermAbbrev = "Su19", TermName = "Summer 2020"
},
};
Console.WriteLine($"Inserted {studentterms.Length} new studentTerms.");
foreach (StudentTerm d in studentterms)
{
context.StudentTerms.Add(d);
}
context.SaveChanges();
}
//This section ends
//This section is for Sonam: Student.cs
//This section is for Sonam: Slot.cs
if (context.Slots.Any())
{
Console.WriteLine("Slots Already exists:");
}
else
{
var slots = new Slot[]
{
new Slot {
SlotID = 1, DegreePlanID = 7251, Term = 1, CreditID = 460, Status = "C"
},
new Slot {
SlotID = 2, DegreePlanID = 7251, Term = 1, CreditID = 542, Status = "C"
},
new Slot {
SlotID = 3, DegreePlanID = 7251, Term = 1, CreditID = 563, Status = "C"
},
new Slot {
SlotID = 4, DegreePlanID = 7251, Term = 2, CreditID = 560, Status = "A"
},
new Slot {
SlotID = 5, DegreePlanID = 7251, Term = 2, CreditID = 664, Status = "A"
},
new Slot {
SlotID = 6, DegreePlanID = 7251, Term = 2, CreditID = 6, Status = "A"
},
new Slot {
SlotID = 7, DegreePlanID = 7251, Term = 3, CreditID = 618, Status = "P"
},
new Slot {
SlotID = 8, DegreePlanID = 7251, Term = 3, CreditID = 691, Status = "P"
},
new Slot {
SlotID = 9, DegreePlanID = 7251, Term = 4, CreditID = 692, Status = "P"
},
new Slot {
SlotID = 10, DegreePlanID = 7251, Term = 4, CreditID = 1, Status = "P"
},
new Slot {
SlotID = 11, DegreePlanID = 7251, Term = 4, CreditID = 2, Status = "P"
},
new Slot {
SlotID = 12, DegreePlanID = 7251, Term = 5, CreditID = 555, Status = "P"
},
new Slot {
SlotID = 13, DegreePlanID = 7252, Term = 1, CreditID = 460, Status = "C"
},
new Slot {
SlotID = 14, DegreePlanID = 7252, Term = 1, CreditID = 542, Status = "C"
},
new Slot {
SlotID = 15, DegreePlanID = 7252, Term = 1, CreditID = 563, Status = "C"
},
new Slot {
SlotID = 16, DegreePlanID = 7252, Term = 3, CreditID = 560, Status = "C"
},
new Slot {
SlotID = 17, DegreePlanID = 7252, Term = 3, CreditID = 664, Status = "A"
},
new Slot {
SlotID = 18, DegreePlanID = 7252, Term = 3, CreditID = 6, Status = "A"
},
new Slot {
SlotID = 19, DegreePlanID = 7252, Term = 4, CreditID = 691, Status = "A"
},
new Slot {
SlotID = 20, DegreePlanID = 7252, Term = 4, CreditID = 618, Status = "P"
},
new Slot {
SlotID = 21, DegreePlanID = 7252, Term = 5, CreditID = 692, Status = "P"
},
new Slot {
SlotID = 22, DegreePlanID = 7252, Term = 5, CreditID = 1, Status = "P"
},
new Slot {
SlotID = 23, DegreePlanID = 7252, Term = 6, CreditID = 555, Status = "P"
},
new Slot {
SlotID = 24, DegreePlanID = 7252, Term = 6, CreditID = 2, Status = "P"
},
new Slot {
SlotID = 25, DegreePlanID = 7255, Term = 1, CreditID = 460, Status = "C"
},
new Slot {
SlotID = 26, DegreePlanID = 7255, Term = 1, CreditID = 542, Status = "C"
},
new Slot {
SlotID = 27, DegreePlanID = 7255, Term = 1, CreditID = 563, Status = "C"
},
new Slot {
SlotID = 28, DegreePlanID = 7255, Term = 2, CreditID = 6, Status = "A"
},
new Slot {
SlotID = 29, DegreePlanID = 7255, Term = 2, CreditID = 618, Status = "A"
},
new Slot {
SlotID = 30, DegreePlanID = 7255, Term = 2, CreditID = 560, Status = "A"
},
new Slot {
SlotID = 31, DegreePlanID = 7255, Term = 4, CreditID = 691, Status = "P"
},
new Slot {
SlotID = 32, DegreePlanID = 7255, Term = 4, CreditID = 1, Status = "P"
},
new Slot {
SlotID = 33, DegreePlanID = 7255, Term = 4, CreditID = 2, Status = "P"
},
new Slot {
SlotID = 34, DegreePlanID = 7255, Term = 5, CreditID = 555, Status = "P"
},
new Slot {
SlotID = 35, DegreePlanID = 7255, Term = 5, CreditID = 664, Status = "P"
},
new Slot {
SlotID = 36, DegreePlanID = 7255, Term = 6, CreditID = 692, Status = "P"
},
};
Console.WriteLine($"Inserted {slots.Length} new slots.");
foreach (Slot d in slots)
{
context.Slots.Add(d);
}
context.SaveChanges();
}
//This section ends
}
//private static object studentterms;
public static void Initialize(ApplicationDbContext context)
{
if (context.Degrees.Any())
{
Console.WriteLine("Degreess already exist");
}
else
{
var degrees = new Degree[] {
new Degree {
DegreeID = 1, DegreeAbbrev = "ACS+2", DegreeName = "MsACS+2", NumberOFTerms = 5
},
new Degree {
DegreeID = 2, DegreeAbbrev = "ACS+DB", DegreeName = "MsACS+DB", NumberOFTerms = 5
},
new Degree {
DegreeID = 3, DegreeAbbrev = "ACS+NF", DegreeName = "MsACS+NF", NumberOFTerms = 5
},
new Degree {
DegreeID = 4, DegreeAbbrev = "ACS", DegreeName = "MsACS", NumberOFTerms = 5
}
};
Console.WriteLine($"Inserted{degrees.Length} new students.");
foreach (Degree s in degrees)
{
context.Degrees.Add(s);
}
context.SaveChanges();
}
if (context.Credits.Any())
{
Console.WriteLine("Credits already exist");
}
else
{
var credits = new Credit[] {
new Credit {
CreditID = 1, CreditAbbrev = "NF", CreditName = "NetworkFundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditID = 2, CreditAbbrev = "542", CreditName = "OOPSwithJAVA", IsSummer = 0, IsSpring = 1, IsFall = 1
}
};
Console.WriteLine($"Inserted{credits.Length} new students.");
foreach (Credit s in credits)
{
context.Credits.Add(s);
}
context.SaveChanges();
}
if (context.DegreeCredit.Any())
{
Console.WriteLine("Degreess already exist");
}
else
{
var DegreeCredits = new DegreeCredit[] {
new DegreeCredit {
DegreeCreditID = 1, DegreeID = 1, CreditID = 460
},
new DegreeCredit {
DegreeCreditID = 2, DegreeID = 1, CreditID = 356
},
new DegreeCredit {
DegreeCreditID = 3, DegreeID = 1, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 4, DegreeID = 1, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 5, DegreeID = 1, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 6, DegreeID = 1, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 7, DegreeID = 1, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 8, DegreeID = 1, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 9, DegreeID = 1, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 10, DegreeID = 1, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 11, DegreeID = 1, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 12, DegreeID = 1, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 13, DegreeID = 1, CreditID = 20
},
new DegreeCredit {
DegreeCreditID = 14, DegreeID = 2, CreditID = 460
},
new DegreeCredit {
DegreeCreditID = 15, DegreeID = 2, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 16, DegreeID = 2, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 17, DegreeID = 2, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 18, DegreeID = 2, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 19, DegreeID = 2, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 20, DegreeID = 2, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 21, DegreeID = 2, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 22, DegreeID = 2, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 23, DegreeID = 2, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 24, DegreeID = 2, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 25, DegreeID = 2, CreditID = 20
},
new DegreeCredit {
DegreeCreditID = 26, DegreeID = 3, CreditID = 356
},
new DegreeCredit {
DegreeCreditID = 27, DegreeID = 3, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 28, DegreeID = 3, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 29, DegreeID = 3, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 30, DegreeID = 3, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 31, DegreeID = 3, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 32, DegreeID = 3, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 33, DegreeID = 3, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 34, DegreeID = 3, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 35, DegreeID = 3, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 36, DegreeID = 3, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 37, DegreeID = 3, CreditID = 20
},
new DegreeCredit {
DegreeCreditID = 38, DegreeID = 4, CreditID = 542
},
new DegreeCredit {
DegreeCreditID = 39, DegreeID = 4, CreditID = 563
},
new DegreeCredit {
DegreeCreditID = 40, DegreeID = 4, CreditID = 560
},
new DegreeCredit {
DegreeCreditID = 41, DegreeID = 4, CreditID = 664
},
new DegreeCredit {
DegreeCreditID = 42, DegreeID = 4, CreditID = 618
},
new DegreeCredit {
DegreeCreditID = 43, DegreeID = 4, CreditID = 555
},
new DegreeCredit {
DegreeCreditID = 44, DegreeID = 4, CreditID = 691
},
new DegreeCredit {
DegreeCreditID = 45, DegreeID = 4, CreditID = 692
},
new DegreeCredit {
DegreeCreditID = 46, DegreeID = 4, CreditID = 6
},
new DegreeCredit {
DegreeCreditID = 47, DegreeID = 4, CreditID = 10
},
new DegreeCredit {
DegreeCreditID = 48, DegreeID = 4, CreditID = 20
},
};
Console.WriteLine($"Inserted{DegreeCredits.Length} new students.");
foreach (DegreeCredit De in DegreeCredits)
{
context.DegreeCredit.Add(De);
}
context.SaveChanges();
}
if (context.Students.Any())
{
Console.WriteLine("Students already exist");
}
else
{
var students = new Student[] {
new Student {
StudentID = 1, LastName = "Singam", FirstName = "Poojitha", I919 = 919571721
},
new Student {
StudentID = 2, LastName = "Konidela", FirstName = "RamCharan", I919 = 919571722
},
};
Console.WriteLine($"Inserted{students.Length} new students.");
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
}
if (context.DegreePlans.Any())
{
Console.WriteLine("DegreePlans already exist");
}
else
{
var degreeplans = new DegreePlan[] {
new DegreePlan {
DegreePlanID = 7253, StudentID = 533705, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7254, StudentID = 533705, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7255, StudentID = 533491, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7256, StudentID = 533491, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7257, StudentID = 533727, DegreePlanAbbrev = "SuperFast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7258, StudentID = 533727, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7259, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7260, StudentID = 533622, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7261, StudentID = 533988, DegreePlanAbbrev = "Super fast", DereePlanName = "As fast as I can", DegreeID = 3
},
new DegreePlan {
DegreePlanID = 7262, StudentID = 533988, DegreePlanAbbrev = "slow And Easy", DereePlanName = "Take a summer Off", DegreeID = 3
},
};
Console.WriteLine($"Inserted{degreeplans.Length} new students.");
foreach (DegreePlan s in degreeplans)
{
context.DegreePlans.Add(s);
}
context.SaveChanges();
}
if (context.Slots.Any())
{
Console.WriteLine("Slots already exist");
}
else
{
var slots = new Slot[] {
new Slot {
SlotID = 1, DegreePlanID = 7255, Term = 1, CreditID = 356, Status = 'B'
},
new Slot {
SlotID = 2, DegreePlanID = 7255, Term = 1, CreditID = 542, Status = 'B'
}
};
Console.WriteLine($"Inserted{slots.Length} new slots.");
foreach (Slot s in slots)
{
context.Slots.Add(s);
}
context.SaveChanges();
}
if (context.StudentTerms.Any())
{
Console.WriteLine("Degreess already exist");
}
else
{
var studentterms = new StudentTerm[] {
new StudentTerm {
StudentTermID = 1, DegreePlanId = 7255, Term = 1, TermAbbrev = "F18", TermName = "Fall2018"
},
new StudentTerm {
StudentTermID = 2, DegreePlanId = 7255, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 3, DegreePlanId = 7255, Term = 3, TermAbbrev = "Sum", TermName = "Summer2019"
},
new StudentTerm {
StudentTermID = 4, DegreePlanId = 7255, Term = 4, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 5, DegreePlanId = 7256, Term = 1, TermAbbrev = "F18", TermName = "Fall2018"
},
new StudentTerm {
StudentTermID = 6, DegreePlanId = 7256, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 7, DegreePlanId = 7256, Term = 3, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 8, DegreePlanId = 7256, Term = 4, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 9, DegreePlanId = 7261, Term = 1, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 10, DegreePlanId = 7261, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020"
},
new StudentTerm {
StudentTermID = 11, DegreePlanId = 7261, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020"
},
new StudentTerm {
StudentTermID = 12, DegreePlanId = 7261, Term = 4, TermAbbrev = "F20", TermName = "Fall2020"
},
new StudentTerm {
StudentTermID = 13, DegreePlanId = 7262, Term = 1, TermAbbrev = "F19", TermName = "FALL2019"
},
new StudentTerm {
StudentTermID = 14, DegreePlanId = 7262, Term = 2, TermAbbrev = "S20", TermName = "SPRING2020"
},
new StudentTerm {
StudentTermID = 15, DegreePlanId = 7262, Term = 3, TermAbbrev = "SU20", TermName = "SUMMER2020"
},
new StudentTerm {
StudentTermID = 16, DegreePlanId = 7262, Term = 4, TermAbbrev = "F20", TermName = "FALL2020"
},
new StudentTerm {
StudentTermID = 17, DegreePlanId = 7262, Term = 5, TermAbbrev = "S21", TermName = "SPRING2021"
},
new StudentTerm {
StudentTermID = 18, DegreePlanId = 7259, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 19, DegreePlanId = 7259, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 20, DegreePlanId = 7259, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019"
},
new StudentTerm {
StudentTermID = 21, DegreePlanId = 7259, Term = 4, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 22, DegreePlanId = 7259, Term = 5, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 23, DegreePlanId = 7260, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 24, DegreePlanId = 7260, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 25, DegreePlanId = 7260, Term = 3, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 26, DegreePlanId = 7260, Term = 4, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 27, DegreePlanId = 7260, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020"
},
new StudentTerm {
StudentTermID = 28, DegreePlanId = 7257, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 29, DegreePlanId = 7257, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 30, DegreePlanId = 7257, Term = 3, TermAbbrev = "Sum19", TermName = "Summer2019"
},
new StudentTerm {
StudentTermID = 31, DegreePlanId = 7257, Term = 4, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 32, DegreePlanId = 7258, Term = 1, TermAbbrev = "F18", TermName = "FALL2018"
},
new StudentTerm {
StudentTermID = 33, DegreePlanId = 7258, Term = 2, TermAbbrev = "S19", TermName = "Spring2019"
},
new StudentTerm {
StudentTermID = 34, DegreePlanId = 7258, Term = 3, TermAbbrev = "F19", TermName = "Fall2019"
},
new StudentTerm {
StudentTermID = 35, DegreePlanId = 7258, Term = 4, TermAbbrev = "S20", TermName = "Spring2020"
},
new StudentTerm {
StudentTermID = 36, DegreePlanId = 7258, Term = 5, TermAbbrev = "Sum20", TermName = "Summer2020"
},
new StudentTerm {
StudentTermID = 37, DegreePlanId = 7253, Term = 1, TermAbbrev = "F 2018", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermID = 38, DegreePlanId = 7253, Term = 2, TermAbbrev = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermID = 39, DegreePlanId = 7253, Term = 3, TermAbbrev = "Sum19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermID = 40, DegreePlanId = 7253, Term = 4, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 41, DegreePlanId = 7254, Term = 1, TermAbbrev = "S19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermID = 42, DegreePlanId = 7254, Term = 2, TermAbbrev = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermID = 43, DegreePlanId = 7254, Term = 3, TermAbbrev = "S20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermID = 44, DegreePlanId = 7254, Term = 4, TermAbbrev = "Sum20", TermName = "Summer 2020"
},
new StudentTerm {
StudentTermID = 45, DegreePlanId = 7254, Term = 5, TermAbbrev = "F20", TermName = "Fall 2020"
},
};
Console.WriteLine($"Inserted{studentterms.Length} new students.");
foreach (StudentTerm s in studentterms)
{
context.StudentTerms.Add(s);
}
context.SaveChanges();
}
}
public static void Initialize(ApplicationDbContext context)
{
context.Database.EnsureCreated();
//for Degree - TEJA
if (context.Degrees.Any())
{
Console.WriteLine("Degrees already exist.");
}
else
{
var degrees = new Degree[]
{
new Degree {
DegreeId = 1, DegreeAbbr = "ACS+2", DegreeName = "MS ACS+2", NumberOfTerms = 4
},
new Degree {
DegreeId = 2, DegreeAbbr = "ACS+DB", DegreeName = "MS ACS+DB", NumberOfTerms = 4
},
new Degree {
DegreeId = 3, DegreeAbbr = "ACS+NF", DegreeName = "MS ACS+NF", NumberOfTerms = 4
},
new Degree {
DegreeId = 4, DegreeAbbr = "ACS", DegreeName = "MS ACS", NumberOfTerms = 4
},
};
Console.WriteLine($"Inserted {degrees.Length} new degrees.");
foreach (Degree d in degrees)
{
context.Degrees.Add(d);
}
context.SaveChanges();
}
//for Credit - Malli
if (context.Credits.Any())
{
Console.WriteLine("Credits already exist.");
return;
}
else
{
var credits = new Credit[]
{
new Credit {
CreditId = 460, CreditAbbr = "DB", CreditName = "Databases", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 356, CreditAbbr = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 542, CreditAbbr = "542", CreditName = "OOPS with Java", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 563, CreditAbbr = "563", CreditName = "Web Apps", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 560, CreditAbbr = "560", CreditName = "Advanced Databases", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 664, CreditAbbr = "664-UX", CreditName = "User Experience", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 618, CreditAbbr = "618-PM", CreditName = "Project Management", IsSummer = 1, IsSpring = 0, IsFall = 0
},
new Credit {
CreditId = 555, CreditAbbr = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 691, CreditAbbr = "691-GDP1", CreditName = "GDP1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 692, CreditAbbr = "692-GDP2", CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 6, CreditAbbr = "Mobile", CreditName = "643 or 644 Mobile", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 10, CreditAbbr = "E1", CreditName = "Elective 1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 20, CreditAbbr = "E2", CreditName = "Elective 2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
};
Console.WriteLine($"Inserted {credits.Length} new credits.");
foreach (Credit d in credits)
{
context.Credits.Add(d);
}
context.SaveChanges();
}
//DegreeRequirments
if (context.DegreeRequirements.Any())
{
Console.WriteLine("Credits already exist.");
return;
}
else
{
var degreeRequirements = new DegreeRequirement[]
{
new DegreeRequirement {
DegreeRequirementId = 1, RequirementNumber = 542, RequirementAbbr = "542", DegreeId = 4, RequirementName = "OOPS with Java"
},
new DegreeRequirement {
DegreeRequirementId = 2, RequirementNumber = 563, RequirementAbbr = "563", DegreeId = 4, RequirementName = "Web Apps"
},
new DegreeRequirement {
DegreeRequirementId = 3, RequirementNumber = 560, RequirementAbbr = "560", DegreeId = 4, RequirementName = "Advanced Databases"
},
new DegreeRequirement {
DegreeRequirementId = 4, RequirementNumber = 664, RequirementAbbr = "664-UX", DegreeId = 4, RequirementName = "User Experience"
},
new DegreeRequirement {
DegreeRequirementId = 5, RequirementNumber = 618, RequirementAbbr = "618-PM", DegreeId = 4, RequirementName = "Project Management"
},
new DegreeRequirement {
DegreeRequirementId = 6, RequirementNumber = 555, RequirementAbbr = "555-NS", DegreeId = 4, RequirementName = "Network Security"
},
new DegreeRequirement {
DegreeRequirementId = 7, RequirementNumber = 691, RequirementAbbr = "691-GDP1", DegreeId = 4, RequirementName = "GDP1"
},
new DegreeRequirement {
DegreeRequirementId = 8, RequirementNumber = 692, RequirementAbbr = "692-GDP2", DegreeId = 4, RequirementName = "GDP2"
},
new DegreeRequirement {
DegreeRequirementId = 9, RequirementNumber = 6, RequirementAbbr = "Mobile", DegreeId = 4, RequirementName = "643 or 644 Mobile"
},
new DegreeRequirement {
DegreeRequirementId = 10, RequirementNumber = 10, RequirementAbbr = "E1", DegreeId = 4, RequirementName = "Elective 1"
},
new DegreeRequirement {
DegreeRequirementId = 11, RequirementNumber = 20, RequirementAbbr = "E2", DegreeId = 4, RequirementName = "Elective 2"
},
};
Console.WriteLine($"Inserted {degreeRequirements.Length} new degree requirements.");
foreach (DegreeRequirement d in degreeRequirements)
{
context.DegreeRequirements.Add(d);
}
context.SaveChanges();
}
//for Student - Mouni
if (context.Students.Any())
{
Console.WriteLine("Students already exist.");
return;
}
else
{
var students = new Student[]
{
new Student {
StudentId = 533568, Family = "Bodepudi", Given = "Mallikarjuna", N919 = 919569870
},
new Student {
StudentId = 533708, Family = "Kancharla", Given = "Sai Krishna Teja", N919 = 919571315
},
new Student {
StudentId = 533897, Family = "Atluri", Given = "Mouni Krishna", N919 = 919571233
},
};
Console.WriteLine($"Inserted {students.Length} new students.");
foreach (Student d in students)
{
context.Students.Add(d);
}
context.SaveChanges();
}
//for DegreeCredit - Malli
if (context.DegreeCredits.Any())
{
Console.WriteLine("DegreeCredits already exist.");
return;
}
else
{
var degreeCredits = new DegreeCredit[]
{
new DegreeCredit {
DegreeCreditId = 1, DegreeId = 1, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 2, DegreeId = 1, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 3, DegreeId = 1, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 4, DegreeId = 1, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 5, DegreeId = 1, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 6, DegreeId = 1, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 7, DegreeId = 1, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 8, DegreeId = 1, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 9, DegreeId = 1, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 10, DegreeId = 1, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 11, DegreeId = 1, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 12, DegreeId = 1, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 13, DegreeId = 1, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 14, DegreeId = 2, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 15, DegreeId = 2, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 16, DegreeId = 2, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 17, DegreeId = 2, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 18, DegreeId = 2, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 19, DegreeId = 2, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 20, DegreeId = 2, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 21, DegreeId = 2, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 22, DegreeId = 2, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 23, DegreeId = 2, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 24, DegreeId = 2, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 25, DegreeId = 2, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 26, DegreeId = 3, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 27, DegreeId = 3, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 28, DegreeId = 3, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 29, DegreeId = 3, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 30, DegreeId = 3, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 31, DegreeId = 3, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 32, DegreeId = 3, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 33, DegreeId = 3, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 34, DegreeId = 3, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 35, DegreeId = 3, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 36, DegreeId = 3, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 37, DegreeId = 3, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 38, DegreeId = 4, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 39, DegreeId = 4, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 40, DegreeId = 4, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 41, DegreeId = 4, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 42, DegreeId = 4, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 43, DegreeId = 4, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 44, DegreeId = 4, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 45, DegreeId = 4, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 46, DegreeId = 4, CreditId = 6
},
new DegreeCredit {
DegreeCreditId = 47, DegreeId = 4, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 48, DegreeId = 4, CreditId = 20
},
};
Console.WriteLine($"Inserted {degreeCredits.Length} new degree credits.");
foreach (DegreeCredit d in degreeCredits)
{
context.DegreeCredits.Add(d);
}
context.SaveChanges();
}
//for DegreePlan - Mouni
if (context.DegreePlans.Any())
{
Console.WriteLine("Degree Plans already exist.");
return;
}
else
{
var degreePlans = new DegreePlan[]
{
new DegreePlan {
DegreePlanId = 1, DegreeId = 4, StudentId = 533568, DegreePlanAbbr = "Super Fast", DegreePlanName = "Cheetah", DegreePlanSelected = 5681
},
new DegreePlan {
DegreePlanId = 2, DegreeId = 4, StudentId = 533568, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Tortoise", DegreePlanSelected = 5682
},
new DegreePlan {
DegreePlanId = 3, DegreeId = 4, StudentId = 533708, DegreePlanAbbr = "Super Fast", DegreePlanName = "Cheetah", DegreePlanSelected = 7081
},
new DegreePlan {
DegreePlanId = 4, DegreeId = 4, StudentId = 533708, DegreePlanAbbr = "Slow and Easy", DegreePlanName = "Tortoise", DegreePlanSelected = 7082
},
new DegreePlan {
DegreePlanId = 5, DegreeId = 4, StudentId = 533897, DegreePlanAbbr = "Super Fast", DegreePlanName = "Cheetah", DegreePlanSelected = 8971
},
new DegreePlan {
DegreePlanId = 6, DegreeId = 4, StudentId = 533897, DegreePlanAbbr = "Summer Off", DegreePlanName = "Rabbit", DegreePlanSelected = 8973
},
};
Console.WriteLine($"Inserted {degreePlans.Length} new Degree Plans.");
foreach (DegreePlan d in degreePlans)
{
context.DegreePlans.Add(d);
}
context.SaveChanges();
}
//for Slot - TEJA
if (context.Slots.Any())
{
Console.WriteLine("Slots already exist.");
return;
}
else
{
var slots = new Slot[]
{
new Slot {
SlotId = 1, DegreePlanSelected = 5681, Term = 1, DegreeRequirementId = 1, CreditId = 542, Status = "C"
},
new Slot {
SlotId = 2, DegreePlanSelected = 5681, Term = 1, DegreeRequirementId = 2, CreditId = 563, Status = "C"
},
new Slot {
SlotId = 3, DegreePlanSelected = 5681, Term = 1, DegreeRequirementId = 3, CreditId = 560, Status = "C"
},
new Slot {
SlotId = 4, DegreePlanSelected = 5681, Term = 2, DegreeRequirementId = 4, CreditId = 664, Status = "A"
},
new Slot {
SlotId = 5, DegreePlanSelected = 5681, Term = 2, DegreeRequirementId = 5, CreditId = 6, Status = "A"
},
new Slot {
SlotId = 6, DegreePlanSelected = 5681, Term = 2, DegreeRequirementId = 6, CreditId = 10, Status = "A"
},
new Slot {
SlotId = 7, DegreePlanSelected = 5681, Term = 3, DegreeRequirementId = 7, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 8, DegreePlanSelected = 5681, Term = 3, DegreeRequirementId = 8, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 9, DegreePlanSelected = 5681, Term = 4, DegreeRequirementId = 9, CreditId = 692, Status = "P"
},
new Slot {
SlotId = 10, DegreePlanSelected = 5681, Term = 4, DegreeRequirementId = 10, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 11, DegreePlanSelected = 5681, Term = 4, DegreeRequirementId = 11, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 12, DegreePlanSelected = 7082, Term = 1, DegreeRequirementId = 1, CreditId = 542, Status = "C"
},
new Slot {
SlotId = 13, DegreePlanSelected = 7082, Term = 1, DegreeRequirementId = 2, CreditId = 563, Status = "C"
},
new Slot {
SlotId = 14, DegreePlanSelected = 7082, Term = 1, DegreeRequirementId = 3, CreditId = 560, Status = "C"
},
new Slot {
SlotId = 15, DegreePlanSelected = 7082, Term = 2, DegreeRequirementId = 4, CreditId = 664, Status = "A"
},
new Slot {
SlotId = 16, DegreePlanSelected = 7082, Term = 2, DegreeRequirementId = 5, CreditId = 6, Status = "A"
},
new Slot {
SlotId = 17, DegreePlanSelected = 7082, Term = 2, DegreeRequirementId = 6, CreditId = 10, Status = "A"
},
new Slot {
SlotId = 18, DegreePlanSelected = 7082, Term = 3, DegreeRequirementId = 7, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 19, DegreePlanSelected = 7082, Term = 4, DegreeRequirementId = 8, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 20, DegreePlanSelected = 7082, Term = 4, DegreeRequirementId = 9, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 21, DegreePlanSelected = 7082, Term = 5, DegreeRequirementId = 10, CreditId = 692, Status = "P"
},
new Slot {
SlotId = 22, DegreePlanSelected = 7082, Term = 5, DegreeRequirementId = 11, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 23, DegreePlanSelected = 8973, Term = 1, DegreeRequirementId = 1, CreditId = 542, Status = "A"
},
new Slot {
SlotId = 24, DegreePlanSelected = 8973, Term = 1, DegreeRequirementId = 2, CreditId = 563, Status = "A"
},
new Slot {
SlotId = 25, DegreePlanSelected = 8973, Term = 1, DegreeRequirementId = 3, CreditId = 560, Status = "A"
},
new Slot {
SlotId = 26, DegreePlanSelected = 8973, Term = 2, DegreeRequirementId = 4, CreditId = 664, Status = "P"
},
new Slot {
SlotId = 27, DegreePlanSelected = 8973, Term = 2, DegreeRequirementId = 5, CreditId = 6, Status = "P"
},
new Slot {
SlotId = 28, DegreePlanSelected = 8973, Term = 2, DegreeRequirementId = 6, CreditId = 10, Status = "P"
},
new Slot {
SlotId = 29, DegreePlanSelected = 8973, Term = 3, DegreeRequirementId = 7, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 30, DegreePlanSelected = 8973, Term = 3, DegreeRequirementId = 8, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 31, DegreePlanSelected = 8973, Term = 3, DegreeRequirementId = 9, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 32, DegreePlanSelected = 8973, Term = 4, DegreeRequirementId = 10, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 33, DegreePlanSelected = 8973, Term = 4, DegreeRequirementId = 11, CreditId = 692, Status = "P"
},
};
Console.WriteLine($"Inserted {slots.Length} new slots.");
foreach (Slot d in slots)
{
context.Slots.Add(d);
}
context.SaveChanges();
}
//for StudentTerm - TEJA
if (context.StudentTerms.Any())
{
Console.WriteLine("Student Terms already exist.");
return;
}
else
{
var studentTerms = new StudentTerm[]
{
new StudentTerm {
StudentTermId = 1, StudentId = 533568, Term = 1, TermAbbr = "F18", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermId = 2, StudentId = 533568, Term = 2, TermAbbr = "SP19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermId = 3, StudentId = 533568, Term = 3, TermAbbr = "SU19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermId = 4, StudentId = 533568, Term = 4, TermAbbr = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermId = 5, StudentId = 533708, Term = 1, TermAbbr = "F18", TermName = "Fall 2018"
},
new StudentTerm {
StudentTermId = 6, StudentId = 533708, Term = 2, TermAbbr = "SP19", TermName = "Spring 2019"
},
new StudentTerm {
StudentTermId = 7, StudentId = 533708, Term = 3, TermAbbr = "SU19", TermName = "Summer 2019"
},
new StudentTerm {
StudentTermId = 8, StudentId = 533708, Term = 4, TermAbbr = "F19", TermName = "Fall 2019"
},
new StudentTerm {
StudentTermId = 9, StudentId = 533708, Term = 5, TermAbbr = "SP20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermId = 10, StudentId = 533897, Term = 1, TermAbbr = "SP20", TermName = "Spring 2020"
},
new StudentTerm {
StudentTermId = 11, StudentId = 533897, Term = 2, TermAbbr = "FA20", TermName = "Fall 2020"
},
new StudentTerm {
StudentTermId = 12, StudentId = 533897, Term = 3, TermAbbr = "SP21", TermName = "Spring 2021"
},
new StudentTerm {
StudentTermId = 13, StudentId = 533897, Term = 4, TermAbbr = "SU21", TermName = "Summer 2021"
},
};
Console.WriteLine($"Inserted {studentTerms.Length} new student terms.");
foreach (StudentTerm d in studentTerms)
{
context.StudentTerms.Add(d);
}
context.SaveChanges();
}
}
public static void Initialize(ApplicationDbContext context)
{
//context.Database.EnsureCreated();
// Look for any Degrees.
if (context.Degrees.Any())
{
Console.WriteLine("Degrees already exist.");
}
else
{
var degrees = new Degree[]
{
new Degree {
DegreeId = 1, DegreeAbv = "ACS+2", DegreeName = "MS ACS +2", NumberOfTerms = 6
},
new Degree {
DegreeId = 2, DegreeAbv = "ACS+DB", DegreeName = "MS ACS+ DB", NumberOfTerms = 6
},
new Degree {
DegreeId = 3, DegreeAbv = "ACS+NF", DegreeName = "MS ACS + NF", NumberOfTerms = 6
},
new Degree {
DegreeId = 4, DegreeAbv = "ACS", DegreeName = "MS ACS", NumberOfTerms = 6
},
};
Console.WriteLine($"Inserted {degrees.Length} new degrees.");
foreach (Degree d in degrees)
{
context.Degrees.Add(d);
}
context.SaveChanges();
}
if (context.Credits.Any())
{
Console.WriteLine("Credits already exist.");
}
else
{
var credits = new Credit[]
{
new Credit {
CreditId = 460, DegreeId = 1, CreditAbv = "DB", CreditName = "Database", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 356, DegreeId = 1, CreditAbv = "NF", CreditName = "Network Fundamentals", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 542, DegreeId = 1, CreditAbv = "542", CreditName = "OOP with java", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 563, DegreeId = 1, CreditAbv = "563", CreditName = "Web apps", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 560, DegreeId = 1, CreditAbv = "560", CreditName = "Advanced Database", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 664, DegreeId = 1, CreditAbv = "664-UX", CreditName = "User Experience Design", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 618, DegreeId = 1, CreditAbv = "618-PM", CreditName = "Project management", IsSummer = 1, IsSpring = 0, IsFall = 0
},
new Credit {
CreditId = 555, DegreeId = 1, CreditAbv = "555-NS", CreditName = "Network Security", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 691, DegreeId = 1, CreditAbv = "691-GDP1", CreditName = "GDP1", IsSummer = 1, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 692, DegreeId = 1, CreditAbv = "692-GDP2", CreditName = "GDP2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 64, DegreeId = 1, CreditAbv = "Mobile", CreditName = "643 or 644 mobile", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 10, DegreeId = 1, CreditAbv = "E1", CreditName = "Elective1", IsSummer = 0, IsSpring = 1, IsFall = 1
},
new Credit {
CreditId = 20, DegreeId = 1, CreditAbv = "E2", CreditName = "Elective2", IsSummer = 0, IsSpring = 1, IsFall = 1
},
};
Console.WriteLine($"Inserted {credits.Length} new credits.");
foreach (Credit d in credits)
{
context.Credits.Add(d);
}
context.SaveChanges();
}
if (context.DegreeCredits.Any())
{
Console.WriteLine("DegreeCredits already exist.");
}
else
{
var degreecredits = new DegreeCredit[]
{
new DegreeCredit {
DegreeCreditId = 1, DegreeId = 1, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 2, DegreeId = 1, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 3, DegreeId = 1, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 4, DegreeId = 1, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 5, DegreeId = 1, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 6, DegreeId = 1, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 7, DegreeId = 1, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 8, DegreeId = 1, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 9, DegreeId = 1, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 10, DegreeId = 1, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 11, DegreeId = 1, CreditId = 64
},
new DegreeCredit {
DegreeCreditId = 12, DegreeId = 1, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 13, DegreeId = 1, CreditId = 20
},
};
Console.WriteLine($"Inserted {degreecredits.Length} new degree credits.");
foreach (DegreeCredit d in degreecredits)
{
context.DegreeCredits.Add(d);
}
context.SaveChanges();
}
if (context.Students.Any())
{
Console.WriteLine("Students already exist.");
}
else
{
var students = new Student[]
{
new Student {
StudentId = 533619, FamilyName = "Cheekoti", GivenName = "Vennela", SID = "S533619", CatPawsID = 919568817
},
new Student {
StudentId = 533907, FamilyName = "Gade", GivenName = "Susritha", SID = "S533907", CatPawsID = 919570703
},
new Student {
StudentId = 533623, FamilyName = "Gone", GivenName = "Sathwika", SID = "S533623", CatPawsID = 919568816
},
};
Console.WriteLine($"Inserted {students.Length} new students.");
foreach (Student d in students)
{
context.Students.Add(d);
}
context.SaveChanges();
}
if (context.DegreePlans.Any())
{
Console.WriteLine("DegreePlans already exist.");
}
else
{
var degreeplans = new Degreeplan[]
{
new Degreeplan {
DegreeplanId = 7251, StudentId = 533619, DegreePlanAbv = "Super Fast", DegreePlanName = "As Fast as I can", DegreeId = 1
},
new Degreeplan {
DegreeplanId = 7258, StudentId = 533619, DegreePlanAbv = "slow and Easy", DegreePlanName = "As slow as I can", DegreeId = 1
},
new Degreeplan {
DegreeplanId = 7253, StudentId = 533623, DegreePlanAbv = "Super Fast", DegreePlanName = "As Fast as I can", DegreeId = 1
},
new Degreeplan {
DegreeplanId = 7255, StudentId = 533907, DegreePlanAbv = "Slow and Easy", DegreePlanName = "As slow as I can", DegreeId = 1
},
new Degreeplan {
DegreeplanId = 7257, StudentId = 533907, DegreePlanAbv = "Super Fast", DegreePlanName = "As Fast as I can", DegreeId = 1
},
new Degreeplan {
DegreeplanId = 7254, StudentId = 533623, DegreePlanAbv = "Slow and Easy", DegreePlanName = "As slow as I can", DegreeId = 1
},
};
Console.WriteLine($"Inserted {degreeplans.Length} new students.");
foreach (Degreeplan d in degreeplans)
{
context.DegreePlans.Add(d);
}
context.SaveChanges();
}
if (context.StudentTerms.Any())
{
Console.WriteLine("StudentTerm already exist.");
}
else
{
var Studentterms = new StudentTerm[]
{
new StudentTerm {
StudentTermId = 1, Term = 1, TermAbv = "S18 ", TermName = "Spring 2018", DegreeplanId = 7258
},
new StudentTerm {
StudentTermId = 2, Term = 2, TermAbv = "Su18", TermName = "Summer 2018", DegreeplanId = 7258
},
new StudentTerm {
StudentTermId = 3, Term = 3, TermAbv = "F18", TermName = "Fall 2018", DegreeplanId = 7258
},
new StudentTerm {
StudentTermId = 4, Term = 4, TermAbv = "S19", TermName = "Spring 2019", DegreeplanId = 7258
},
new StudentTerm {
StudentTermId = 5, Term = 5, TermAbv = "Su19", TermName = "Summer 2019", DegreeplanId = 7258
},
new StudentTerm {
StudentTermId = 6, Term = 6, TermAbv = "F19", TermName = "Fall 2019", DegreeplanId = 7258
},
new StudentTerm {
StudentTermId = 7, Term = 1, TermAbv = "F19", TermName = "Fall 2019", DegreeplanId = 7255
},
new StudentTerm {
StudentTermId = 8, Term = 2, TermAbv = "S20", TermName = "Spring 2020", DegreeplanId = 7255
},
new StudentTerm {
StudentTermId = 9, Term = 3, TermAbv = "Su20", TermName = "Summer 2020", DegreeplanId = 7255
},
new StudentTerm {
StudentTermId = 10, Term = 4, TermAbv = "F20", TermName = "Fall 2020", DegreeplanId = 7255
},
new StudentTerm {
StudentTermId = 11, Term = 5, TermAbv = "S21", TermName = "Spring 2021", DegreeplanId = 7255
},
new StudentTerm {
StudentTermId = 12, Term = 1, TermAbv = "F18", TermName = "Fall2018", DegreeplanId = 7254
},
new StudentTerm {
StudentTermId = 13, Term = 2, TermAbv = "S19", TermName = "Spring2019", DegreeplanId = 7254
},
new StudentTerm {
StudentTermId = 14, Term = 3, TermAbv = "SU19", TermName = "Summer2019", DegreeplanId = 7254
},
new StudentTerm {
StudentTermId = 15, Term = 4, TermAbv = "F20", TermName = "Fall2019", DegreeplanId = 7254
},
new StudentTerm {
StudentTermId = 16, Term = 5, TermAbv = "S20", TermName = "Spring2020", DegreeplanId = 7254
},
};
Console.WriteLine($"Inserted {Studentterms.Length} new degrees.");
foreach (StudentTerm d in Studentterms)
{
context.StudentTerms.Add(d);
}
context.SaveChanges();
}
if (context.Slots.Any())
{
Console.WriteLine("Slot already exist.");
}
else
{
var Slots = new Slot[]
{
new Slot {
SlotId = 1, DegreePlanId = 7255, Term = 1, CreditId = 356, Status = "C"
},
new Slot {
SlotId = 2, DegreePlanId = 7255, Term = 1, CreditId = 542, Status = "C"
},
new Slot {
SlotId = 3, DegreePlanId = 7255, Term = 1, CreditId = 563, Status = "C"
},
new Slot {
SlotId = 4, DegreePlanId = 7255, Term = 1, CreditId = 460, Status = "C"
},
new Slot {
SlotId = 5, DegreePlanId = 7255, Term = 2, CreditId = 560, Status = "A"
},
new Slot {
SlotId = 6, DegreePlanId = 7255, Term = 2, CreditId = 664, Status = "A"
},
new Slot {
SlotId = 7, DegreePlanId = 7255, Term = 2, CreditId = 64, Status = "A"
},
new Slot {
SlotId = 8, DegreePlanId = 7255, Term = 3, CreditId = 618, Status = "P"
},
new Slot {
SlotId = 9, DegreePlanId = 7255, Term = 3, CreditId = 691, Status = "P"
},
new Slot {
SlotId = 10, DegreePlanId = 7255, Term = 4, CreditId = 10, Status = "P"
},
new Slot {
SlotId = 11, DegreePlanId = 7255, Term = 4, CreditId = 555, Status = "P"
},
new Slot {
SlotId = 12, DegreePlanId = 7255, Term = 5, CreditId = 20, Status = "P"
},
new Slot {
SlotId = 13, DegreePlanId = 7255, Term = 5, CreditId = 692, Status = "P"
},
};
Console.WriteLine($"Inserted {Slots.Length} new degrees.");
foreach (Slot d in Slots)
{
context.Slots.Add(d);
}
context.SaveChanges();
}
}
public static void Initialize(ApplicationDbContext context)
{
if (context.Degrees.Any())
{
Console.WriteLine("Degree already exists");
}
else
{
var degrees = new Degree[]
{
new Degree {
DegreeId = 1, DegreeAbrrev = "ACS+2", DegreeName = "MS ACS+2"
},
new Degree {
DegreeId = 2, DegreeAbrrev = "ACS+DB", DegreeName = "MS ACS+DB"
},
new Degree {
DegreeId = 3, DegreeAbrrev = "ACS+NF", DegreeName = "MS ACS+NF"
},
new Degree {
DegreeId = 4, DegreeAbrrev = "ACS", DegreeName = "MS ACS"
},
};
Console.WriteLine($"Inserted {degrees.Length} new degrees.");
foreach (Degree d in degrees)
{
context.Degrees.Add(d);
}
context.SaveChanges();
}
//Credit table
if (context.Credits.Any())
{
Console.WriteLine("Credit already exists");
}
else
{
var credits = new Credit[]
{
new Credit {
CreditId = 460, CreditAbrrev = "DB", CreditName = "Databases", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 356, CreditAbrrev = "NF", CreditName = "Network Fundamentals", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 542, CreditAbrrev = "542-OOP", CreditName = "OOP with Java", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 563, CreditAbrrev = "563-Web", CreditName = "Web Apps", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 560, CreditAbrrev = "560-ADB", CreditName = "Advanced Databases", isSummer = 1, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 664, CreditAbrrev = "664-UX", CreditName = "User Experience", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 618, CreditAbrrev = "618-PM", CreditName = "Project Management", isSummer = 1, isSpring = 0, isFall = 0, DegreeId = 1
},
new Credit {
CreditId = 555, CreditAbrrev = "555-NS", CreditName = "Network Security", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 691, CreditAbrrev = "691-GDP1", CreditName = "GDP1", isSummer = 1, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 692, CreditAbrrev = "692-GDP2", CreditName = "GDP2", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 643, CreditAbrrev = "643-Android", CreditName = "Android", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 10, CreditAbrrev = "E1", CreditName = "Elective1", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 20, CreditAbrrev = "E2", CreditName = "Elective2", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
},
new Credit {
CreditId = 644, CreditAbrrev = "IOS", CreditName = "IOS", isSummer = 0, isSpring = 1, isFall = 1, DegreeId = 1
}
};
Console.WriteLine($"Inserted {credits.Length} new credits.");
foreach (Credit c in credits)
{
context.Credits.Add(c);
}
context.SaveChanges();
}
//Student table
if (context.Students.Any())
{
Console.WriteLine("Student already exists");
}
else
{
var students = new Student[]
{
new Student {
StudentId = 533569, FamilyName = "Chetty Ragava", GivenName = "Harshitha", Snumber = 533569, Num919 = 919568034
},
new Student {
StudentId = 533982, FamilyName = "Ali", GivenName = "Zaiba", Snumber = 533982, Num919 = 919569110
},
new Student {
StudentId = 533573, FamilyName = "Nuka", GivenName = "Vamshi krishna", Snumber = 533573, Num919 = 919570332
}
};
Console.WriteLine($"Inserted {students.Length} new students.");
foreach (Student st in students)
{
context.Students.Add(st);
}
context.SaveChanges();
}
//DegreeCredit table
if (context.DegreeCredits.Any())
{
Console.WriteLine("DegreeCredit already exists");
}
else
{
var degreeCredits = new DegreeCredit[]
{
new DegreeCredit {
DegreeCreditId = 1, DegreeId = 3, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 2, DegreeId = 3, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 3, DegreeId = 3, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 4, DegreeId = 3, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 5, DegreeId = 3, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 6, DegreeId = 3, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 7, DegreeId = 3, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 8, DegreeId = 3, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 9, DegreeId = 3, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 10, DegreeId = 3, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 11, DegreeId = 3, CreditId = 643
},
new DegreeCredit {
DegreeCreditId = 12, DegreeId = 3, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 13, DegreeId = 3, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 14, DegreeId = 3, CreditId = 460
},
new DegreeCredit {
DegreeCreditId = 15, DegreeId = 3, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 16, DegreeId = 3, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 17, DegreeId = 3, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 18, DegreeId = 3, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 19, DegreeId = 3, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 20, DegreeId = 3, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 21, DegreeId = 3, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 22, DegreeId = 3, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 23, DegreeId = 3, CreditId = 643
},
new DegreeCredit {
DegreeCreditId = 24, DegreeId = 3, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 25, DegreeId = 3, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 26, DegreeId = 3, CreditId = 356
},
new DegreeCredit {
DegreeCreditId = 27, DegreeId = 3, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 28, DegreeId = 3, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 29, DegreeId = 3, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 30, DegreeId = 3, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 31, DegreeId = 3, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 32, DegreeId = 3, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 33, DegreeId = 3, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 34, DegreeId = 3, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 35, DegreeId = 3, CreditId = 643
},
new DegreeCredit {
DegreeCreditId = 36, DegreeId = 3, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 37, DegreeId = 3, CreditId = 20
},
new DegreeCredit {
DegreeCreditId = 38, DegreeId = 3, CreditId = 542
},
new DegreeCredit {
DegreeCreditId = 39, DegreeId = 3, CreditId = 563
},
new DegreeCredit {
DegreeCreditId = 40, DegreeId = 3, CreditId = 560
},
new DegreeCredit {
DegreeCreditId = 41, DegreeId = 3, CreditId = 664
},
new DegreeCredit {
DegreeCreditId = 42, DegreeId = 3, CreditId = 618
},
new DegreeCredit {
DegreeCreditId = 43, DegreeId = 3, CreditId = 555
},
new DegreeCredit {
DegreeCreditId = 44, DegreeId = 3, CreditId = 691
},
new DegreeCredit {
DegreeCreditId = 45, DegreeId = 3, CreditId = 692
},
new DegreeCredit {
DegreeCreditId = 46, DegreeId = 3, CreditId = 644
},
new DegreeCredit {
DegreeCreditId = 47, DegreeId = 3, CreditId = 10
},
new DegreeCredit {
DegreeCreditId = 48, DegreeId = 3, CreditId = 20
}
};
Console.WriteLine($"Inserted {degreeCredits.Length} new degreecredit.");
foreach (DegreeCredit d in degreeCredits)
{
context.DegreeCredits.Add(d);
}
context.SaveChanges();
}
//Degreeplan table
if (context.DegreePlans.Any())
{
Console.WriteLine("DegreePlan already exists");
}
else
{
var degreeplans = new DegreePlan[]
{
new DegreePlan {
DegreePlanId = 7251, StudentId = 533569, DegreePlanAbbrev = "Super", DegreePlanName = "As", DegreeId = 3
},
new DegreePlan {
DegreePlanId = 7252, StudentId = 533569, DegreePlanAbbrev = "Slow", DegreePlanName = "Take", DegreeId = 3
},
new DegreePlan {
DegreePlanId = 7253, StudentId = 533982, DegreePlanAbbrev = "Easy", DegreePlanName = "Study", DegreeId = 3
},
new DegreePlan {
DegreePlanId = 7254, StudentId = 533982, DegreePlanAbbrev = "one", DegreePlanName = "Complete", DegreeId = 3
},
new DegreePlan {
DegreePlanId = 7255, StudentId = 533573, DegreePlanAbbrev = "slow", DegreePlanName = "Maximum", DegreeId = 3
},
new DegreePlan {
DegreePlanId = 7256, StudentId = 533573, DegreePlanAbbrev = "Default", DegreePlanName = "Default", DegreeId = 3
}
};
Console.WriteLine($"Inserted {degreeplans.Length} new degreeplans.");
foreach (DegreePlan dp in degreeplans)
{
context.DegreePlans.Add(dp);
}
context.SaveChanges();
}
//Slot table
if (context.Slots.Any())
{
Console.WriteLine("Slot already exists");
}
else
{
var slots = new Slot[]
{
new Slot {
SlotId = 1, DegreePlanId = 7251, StudentTermId = 1, CreditId = 542, Status = "C"
}
};
Console.WriteLine($"Inserted {slots.Length} new slots.");
foreach (Slot sl in slots)
{
context.Slots.Add(sl);
}
context.SaveChanges();
}
//StudentTerm Table
if (context.StudentTerms.Any())
{
Console.WriteLine("Student Term already exists");
}
else
{
var studentTerms = new StudentTerm[]
{
new StudentTerm {
StudentTermId = 1, StudentId = 533569, StudentTermNo = 1, DegreePlanId = 7251, TermAbbrev = "F18", TermName = "Fall 2018"
}
};
Console.WriteLine($"Inserted {studentTerms.Length} new studentTerms.");
foreach (StudentTerm stt in studentTerms)
{
context.StudentTerms.Add(stt);
}
context.SaveChanges();
}
}
