protected Team63LMSContext AddExistingCourse() { Team63LMSContext db = mockDB(); Courses c = new Courses(); c.Listing = "CS"; c.Number = 4150; c.Name = "Algorithms"; db.Courses.Add(c); db.SaveChanges(); Courses c2 = new Courses(); c2.Listing = "CS"; c2.Number = 4150; c2.Name = "Algorithms"; db.Courses.Add(c2); db.SaveChanges(); return(db); }
protected Team63LMSContext AddCourses() { Team63LMSContext db = mockDB(); Courses c = new Courses(); c.Listing = "CS"; c.Number = 4150; c.Name = "Algorithms"; db.Courses.Add(c); db.SaveChanges(); Courses c2 = new Courses(); c2.Listing = "CS"; c2.Number = 4600; c2.Name = "Computer Graphics"; db.Courses.Add(c2); db.SaveChanges(); Courses c3 = new Courses(); c3.Listing = "CS"; c3.Number = 4540; c3.Name = "Web Software Architecture"; db.Courses.Add(c3); db.SaveChanges(); return(db); }
protected Team63LMSContext AddProfessor2() { Team63LMSContext db = mockDB(); Professors p = new Professors(); p.FName = "Ron"; p.LName = "Weasley"; p.UId = uIDGen(db); p.WorksIn = "EE"; p.Dob = new DateTime(1994, 09, 22); db.Professors.Add(p); db.SaveChanges(); Professors p2 = new Professors(); p2.FName = "Kanny"; p2.LName = "Dopta"; p2.UId = uIDGen(db); p2.WorksIn = "EE"; p2.Dob = new DateTime(1992, 10, 23); db.Professors.Add(p2); db.SaveChanges(); return(db); }
protected Team63LMSContext AddProfessorCourseClass() { Team63LMSContext db = mockDB(); AdministratorController controller = new AdministratorController(); controller.UseLMSContext(db); // Create Professor to teach class Professors p = new Professors(); p.FName = "Danny"; p.LName = "Kopta"; p.UId = uIDGen(db); p.WorksIn = "CS"; db.Professors.Add(p); db.SaveChanges(); controller.CreateCourse("CS", 5530, "Database Systems"); controller.CreateClass("CS", 1, "Spring", 2019, new DateTime(2009, 05, 30, 7, 9, 16), new DateTime(2009, 05, 30, 9, 16, 25), "WEB 1250", "u0000000"); return(db); }
protected Team63LMSContext AddClasses() { Team63LMSContext db = mockDB(); AdministratorController controller = new AdministratorController(); controller.UseLMSContext(db); // Create Professor to teach class Professors p = new Professors(); p.FName = "Danny"; p.LName = "Kopta"; p.UId = uIDGen(db); p.WorksIn = "CS"; p.Dob = new DateTime(1992, 10, 23); db.Professors.Add(p); db.SaveChanges(); controller.CreateCourse("CS", 5530, "Database Systems"); var query = from pr in db.Professors select pr.UId; var query2 = from cr in db.Courses select cr.CatalogId; // Create class associated with a CS course Classes c = new Classes(); c.Loc = "WEB 1250"; c.Start = new TimeSpan(7, 9, 16); c.End = new TimeSpan(9, 16, 25); c.Semester = "Spring 2019"; c.TaughtBy = query.SingleOrDefault(); c.CategoryId = query2.SingleOrDefault(); db.Classes.Add(c); db.SaveChanges(); return(db); }
protected Team63LMSContext AddAdministrator() { Team63LMSContext db = mockDB(); Administrators a = new Administrators(); a.FName = "Magnus"; a.LName = "Carlsen"; a.UId = uIDGen(db); a.Dob = new DateTime(1997, 10, 23); db.Administrators.Add(a); db.SaveChanges(); return(db); }
protected Team63LMSContext AddProfessor() { Team63LMSContext db = mockDB(); Professors p = new Professors(); p.FName = "John"; p.LName = "Doe"; p.UId = uIDGen(db); p.WorksIn = "CS"; p.Dob = new DateTime(1997, 10, 23); db.Professors.Add(p); db.SaveChanges(); return(db); }
protected Team63LMSContext AddClasses2() { Team63LMSContext db = mockDB(); AdministratorController controller = new AdministratorController(); controller.UseLMSContext(db); // Create Professor to teach class Professors p = new Professors(); p.FName = "Danny"; p.LName = "Kopta"; p.UId = uIDGen(db); p.WorksIn = "CS"; db.Professors.Add(p); db.SaveChanges(); controller.CreateCourse("CS", 5530, "Database Systems"); return(db); }
protected Team63LMSContext AddStudentstoMultipleClasses() { Team63LMSContext db = mockDB(); AdministratorController controller = new AdministratorController(); controller.UseLMSContext(db); StudentController sController = new StudentController(); sController.UseLMSContext(db); // Create Professor to teach class Professors p = new Professors(); p.FName = "Danny"; p.LName = "Kopta"; p.UId = uIDGen(db); p.WorksIn = "CS"; db.Professors.Add(p); db.SaveChanges(); controller.CreateCourse("CS", 5530, "Database Systems"); controller.CreateCourse("CS", 4400, "Computer Systems"); controller.CreateCourse("CS", 3500, "Software Practice I"); controller.CreateClass("CS", 1, "Spring", 2019, new DateTime(2009, 05, 30, 7, 9, 16), new DateTime(2009, 05, 30, 9, 16, 25), "WEB 1250", "u0000000"); controller.CreateClass("CS", 4400, "Spring", 2019, new DateTime(2009, 05, 30, 7, 9, 16), new DateTime(2009, 05, 30, 9, 16, 25), "WEB 2000", "u0000000"); controller.CreateClass("CS", 3500, "Spring", 2019, new DateTime(2009, 05, 30, 7, 9, 16), new DateTime(2009, 05, 30, 9, 16, 25), "WEB 1999", "u0000000"); //Add student to class Students s = new Students(); s.UId = "u0000001"; s.FName = "Steen"; s.LName = "Sia"; s.Dob = new DateTime(2000, 07, 01); s.Major = "Electrical Engineering"; Students s2 = new Students(); s.UId = "u0000002"; s.FName = "Benjamin"; s.LName = "Button"; s.Dob = new DateTime(2000, 07, 01); s.Major = "Electrical Engineering"; Students s3 = new Students(); s.UId = "u0000003"; s.FName = "J"; s.LName = "Fish"; s.Dob = new DateTime(2000, 07, 01); s.Major = "Computer Science"; db.Students.Add(s); db.Students.Add(s2); db.Students.Add(s3); db.SaveChanges(); sController.Enroll("CS", 5530, "Spring", 2019, "u0000001"); sController.Enroll("CS", 5530, "Spring", 2019, "u0000002"); sController.Enroll("CS", 4400, "Spring", 2019, "u0000001"); sController.Enroll("CS", 4400, "Spring", 2019, "u0000002"); sController.Enroll("CS", 3500, "Spring", 2019, "u0000003"); sController.Enroll("CS", 3500, "Spring", 2019, "u0000001"); return(db); }