public static Team41LMSContext MakeMockDatabase() { var options = new DbContextOptionsBuilder <Team41LMSContext>(); // had to run: // Install-Package Microsoft.EntityFrameworkCore.InMemory // in the Package Manager Console to get this command options.UseInMemoryDatabase(Guid.NewGuid().ToString()); // there was also something in the lecture about a service provider but he // didn't show the actual code for that Team41LMSContext db = new Team41LMSContext(options.Options); // Add a department Departments newDepartment = new Departments() { Name = "Computer Science", Subject = "CS", }; db.Departments.Add(newDepartment); db.SaveChanges(); return(db); }
public static uint AddCourseAndClass(Team41LMSContext db) { uint cid = 101; Courses newCourse = new Courses { CatalogId = "12345", Listing = "CS", Name = "Algorithms", Number = "3550" }; db.Courses.Add(newCourse); Classes newClass = new Classes { CId = cid, CatalogId = "12345", SemesterYear = 2019, SemesterSeason = "Spring", Location = "On the moon", StartTime = new TimeSpan(), EndTime = new TimeSpan() }; db.Classes.Add(newClass); db.SaveChanges(); return(cid); }
public static void Enroll(string uid, uint cid, Team41LMSContext db) { Enrolled newEnrolled = new Enrolled { UId = uid, CId = cid, Grade = "--" }; db.Enrolled.Add(newEnrolled); db.SaveChanges(); }
public static string AddOneAdmin(Team41LMSContext db) { var newUser = new Administrators { FirstName = "Brian", LastName = "Landes", UId = "u000006" }; db.Administrators.Add(newUser); db.SaveChanges(); return("u000006"); }
public static string AddOneStudent(Team41LMSContext db) { var departments = new List <Departments>(db.Departments); var newUser = new Students { FirstName = "Brian", LastName = "Landes", UId = "u000006", Major = departments[0].Name, MajorNavigation = departments[0] }; db.Students.Add(newUser); db.SaveChanges(); return("u000006"); }
public static string AddOneProfessor(Team41LMSContext db) { var departments = new List <Departments>(db.Departments); var newUser = new Professors { FirstName = "Brian", LastName = "Landes", UId = "u000006", WorksIn = departments[0].Name, WorksInNavigation = departments[0] }; db.Professors.Add(newUser); db.SaveChanges(); return("u000006"); }
private static string AddSecondStudent(Team41LMSContext db) { Students chloe = new Students { UId = "u1000001", Major = "CS", FirstName = "Chloe", LastName = "Josien", Dob = DateTime.Now, }; db.Students.Add(chloe); db.SaveChanges(); var students = new List <Students>(db.Students); Assert.Equal(2, students.Count); return(chloe.UId); }
public static string AddOneStudent(Team41LMSContext db) { Students brian = new Students { UId = "u0000001", Major = "CS", FirstName = "Brian", LastName = "Landes", Dob = DateTime.Now, }; db.Students.Add(brian); db.SaveChanges(); var students = new List <Students>(db.Students); Assert.Single(students); return(brian.UId); }
public static void AddAssignmentAndCategory(uint cid, Team41LMSContext db) { AssignmentCategories assCat = new AssignmentCategories { AcId = 1002, Name = "Quizzes", GradingWeight = 50, CId = cid }; db.AssignmentCategories.Add(assCat); Assignments newAssignment = new Assignments { AId = 999, AcId = 1002, Name = "Bonus Quiz", MaxPointValue = 102, DueDate = DateTime.Now, Content = "oanklaks fl lja", }; db.Assignments.Add(newAssignment); db.SaveChanges(); }