private static CommonController MakeController(Team41LMSContext db)
{
CommonController controller = new CommonController();
controller.UseLMSContext(db);
return(controller);
}
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);
}
private static ProfessorController MakeController(Team41LMSContext db)
{
ProfessorController controller = new ProfessorController();
controller.UseLMSContext(db);
return(controller);
}
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);
}
private static AccountController MakeController(Team41LMSContext db)
{
AccountController controller = new AccountController(null, null, null, null);
controller.UseLMSContext(db);
return(controller);
}
public static StudentController MakeController(Team41LMSContext db)
{
var controller = new StudentController();
controller.UseLMSContext(db);
return(controller);
}
private static AdministratorController MakeController(Team41LMSContext db)
{
var controller = new AdministratorController();
controller.UseLMSContext(db);
return(controller);
}
public void AssertGradeEquals(string uid, string grade, Team41LMSContext db)
{
var studentController = StudentControllerTests.MakeController(db);
var gradeJsonResult = studentController.GetMyClasses(uid) as JsonResult;
var onlyClass = Utils.JsonResultValueAtIndex(gradeJsonResult, 0);
var letterGrade = Utils.GetValue <string>(onlyClass, "grade");
Assert.Equal(grade, letterGrade);
}
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();
}
/*
* WARNING: This is the quick and easy way to make the controller
* use a different LibraryContext - good enough for our purposes.
* The "right" way is through Dependency Injection via the constructor
* (look this up if interested).
*/
public void UseLMSContext(Team41LMSContext ctx)
{
db = ctx;
}
public CommonController()
{
db = new Team41LMSContext();
}
public static void AddOneProfessor(Team41LMSContext db)
{
var controller = MakeController(db);
controller.CreateNewUser("Brian", "Landes", new DateTime(), "CS", "Professor");
}
