public void CourseControllerCanEdit()
{
DbContextOptions <EnrollmentDbContext> options =
new DbContextOptionsBuilder <EnrollmentDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
using (EnrollmentDbContext context = new EnrollmentDbContext(options))
{
Course course = new Course();
course.ClassName = ClassName.Python;
course.Instructor = "Miss Snake";
course.StartingDate = new DateTime(2012, 12, 12);
course.EndDate = new DateTime(2012, 12, 25);
CourseController cc = new CourseController(context);
var x = cc.Create(course);
Course newCourse = new Course();
course.ClassName = ClassName.Python;
course.Instructor = "Mister Boa";
course.StartingDate = new DateTime(2012, 12, 12);
course.EndDate = new DateTime(2012, 12, 25);
var y = cc.Update(newCourse);
var results = context.Course.Where(a => a.Instructor == "Miss Snake");
Assert.Equal(0, results.Count());
results = context.Course.Where(a => a.Instructor == "Mister Boa");
Assert.Equal(1, results.Count());
}
}
public void StudentControllerCanDelete()
{
DbContextOptions <EnrollmentDbContext> options =
new DbContextOptionsBuilder <EnrollmentDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
using (EnrollmentDbContext context = new EnrollmentDbContext(options))
{
Course course = new Course();
course.ID = 3;
course.ClassName = ClassName.Python;
course.Instructor = "Miss Snake";
course.StartingDate = new DateTime(2012, 12, 12);
course.EndDate = new DateTime(2012, 12, 25);
Student student = new Student();
student.Name = "Mario";
student.CourseId = 3;
student.Passing = true;
student.HoursOfSleep = 5;
CourseController cc = new CourseController(context);
var y = cc.Create(course);
StudentController sc = new StudentController(context);
var x = sc.Create(student);
var z = sc.Delete(1);
var results = context.Student.Where(a => a.Name == "Mario");
Assert.Equal(0, results.Count());
}
}
public static async Task <CourseDetailViewModel> FromIDAsync(int id, EnrollmentDbContext context)
{
CourseDetailViewModel cdvm = new CourseDetailViewModel();
cdvm.Course = await context.Course.Where(c => c.ID == id).SingleAsync();
cdvm.Students = await context.Student.Where(s => s.Course == cdvm.Course)
.Select(s => s)
.ToListAsync();
return(cdvm);
}
public async void DatabaseCanSaveAsync()
{
DbContextOptions <EnrollmentDbContext> options =
new DbContextOptionsBuilder <EnrollmentDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
using (EnrollmentDbContext context = new EnrollmentDbContext(options))
{
Course course = new Course();
course.ClassName = ClassName.Python;
course.Instructor = "Miss Snake";
course.StartingDate = new DateTime(2012, 12, 12);
course.EndDate = new DateTime(2012, 12, 25);
await context.Course.AddAsync(course);
await context.SaveChangesAsync();
var results = context.Course.Where(a => a.Instructor == "Miss Snake");
Assert.Equal(1, results.Count());
}
}
public StudentsController(EnrollmentDbContext context)
{
_context = context;
}
public HomeController(EnrollmentDbContext context)
{
_context = context;
}
public StudentDbService(EnrollmentDbContext context)
{
_context3 = context;
}
public CourseController(EnrollmentDbContext context)
{
_context = context;
}
