public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
peter = new Student { FirstName = "PeterTest", LastName = "SimonsTest", Sex = Sex.Male, Age = 25 };
sarah = new Student { FirstName = "SarahTest", LastName = "ClarksTest", Sex = Sex.Female, Age = 20 };
jessy = new Student { FirstName = "JessyTest", LastName = "AlgienTest", Sex = Sex.Female, Age = 22 };
math = new Course { CourseName = "MathematicsTest", MaxNumberOfStudents = 15 };
calculus = new Course { CourseName = "CalculusTest", MaxNumberOfStudents = 10 };
discrete = new Course { CourseName = "DiscreteTest", MaxNumberOfStudents = 2 };
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(peter);
ctx.Students.Add(sarah);
ctx.Students.Add(jessy);
ctx.SaveChanges();
math.Students.Add(peter);
math.Students.Add(jessy);
ctx.Courses.Add(math);
ctx.Courses.Add(calculus);
ctx.Courses.Add(discrete);
ctx.SaveChanges();
}
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
peter = new Student { FirstName = "PeterTest", LastName = "SimonsTest", Sex = Sex.Male, Age = 25 };
sarah = new Student { FirstName = "SarahTest", LastName = "ClarksTest", Sex = Sex.Female, Age = 20 };
jessy = new Student { FirstName = "JessyTest", LastName = "AlgienTest", Sex = Sex.Female, Age = 22 };
math = new Course { CourseName = "MathematicsTest", MaxNumberOfStudents = 15 };
calculus = new Course { CourseName = "CalculusTest", MaxNumberOfStudents = 10 };
discrete = new Course { CourseName = "DiscreteTest", MaxNumberOfStudents = 2 };
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(peter);
ctx.Students.Add(sarah);
ctx.Students.Add(jessy);
ctx.SaveChanges();
discrete.Students.Add(sarah);
calculus.Students.Add(sarah);
ctx.Courses.Add(math);
ctx.Courses.Add(calculus);
ctx.Courses.Add(discrete);
ctx.SaveChanges();
expectedCourses = new List<StudentCourse>();
foreach (var course in ctx.Courses)
{
expectedCourses.Add(new StudentCourse { CourseName = course.CourseName, AssignedStudents = course.Students.Count, Id = course.Id, IsActive = course.Students.Count < course.MaxNumberOfStudents, MaxStudents = course.MaxNumberOfStudents, IsAppliedFor = course.Students.Any(x => x.Id == sarah.Id) });
}
}
}
public void TestApplyForCourseFullCourse()
{
Assert.Throws(typeof(InvalidOperationException), delegate { stService.ApplyForCourse(peter.Id, discrete.Id); });
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(peter.Courses.Count(), ctx.Students.Find(peter.Id).Courses.Count());
}
}
public void TestDeleteNoId()
{
stService.DeleteStudent(-1);
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(initCount, ctx.Students.Count());
}
}
public void TestDeleteSuccess()
{
stService.DeleteCourse(math.Id.ToString());
using (var ctx = new StudentTrackerDbContext())
{
Assert.IsNull(ctx.Courses.Find(math.Id));
}
}
public void TestDeleteNoId()
{
stService.DeleteCourse(notExistingId);
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(initCount, ctx.Courses.Count());
}
}
public void TestDeleteSuccess()
{
stService.DeleteStudent(peter.Id);
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(initCount - 1, ctx.Students.Count());
Assert.IsNull(ctx.Students.Find(peter.Id));
}
}
public void TestUpdateCourseDublicateName()
{
bool result = stService.UpdateCourse(math.Id.ToString(), discrete.CourseName, this.capacityToUpdate);
Assert.IsFalse(result);
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreNotEqual(ctx.Courses.Single(x => x.Id == math.Id), discrete.CourseName);
}
}
public void TestSaveSuccess()
{
stService.SaveStudents(this.infos);
using(var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(infos.Count + initCount, ctx.Students.Count());
Assert.AreEqual(infos.Last().LastName, ctx.Students.OrderByDescending(x=>x.Id).First().LastName);
}
}
public void TestUpdateCourseIdDoesNotExist()
{
bool result = stService.UpdateCourse(this.notExistingId.ToString(), this.nameToUpdate, this.capacityToUpdate);
Assert.IsFalse(result);
using(var ctx = new StudentTrackerDbContext())
{
Assert.IsFalse(ctx.Courses.Any(x => x.CourseName == nameToUpdate));
}
}
public void SetNewUiColoursSuccess()
{
stService.SetUiColours(user16.Id, expectedResult.BackgroundColour, expectedResult.HeaderColour);
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(expectedResult.BackgroundColour, ctx.Users.Find(user16.Id).UiColour.BackgroundColour);
Assert.AreEqual(expectedResult.HeaderColour, ctx.Users.Find(user16.Id).UiColour.HeaderColour);
}
}
public void TestAddDublicate()
{
bool result = stService.AddCourse(entryDublicate);
Assert.IsFalse(result);
using (var ctx = new StudentTrackerDbContext())
{
Assert.AreEqual(initCount, ctx.Courses.Count());
Assert.AreNotEqual(entry.CourseName, ctx.Courses.OrderByDescending(x => x.Id).First().CourseName);
}
}
public void TestAddSuccess()
{
bool result = stService.AddCourse(this.entry);
using (var ctx = new StudentTrackerDbContext())
{
Assert.IsTrue(result);
Assert.AreEqual(initCount + 1, ctx.Courses.Count());
Assert.AreEqual(entry.CourseName, ctx.Courses.OrderByDescending(x => x.Id).First().CourseName);
}
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
initCount = ctx.Students.Count();
}
infos = new List<RawStudentInfo> { peter, jason, mary };
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(new Student { FirstName = "DoubleName", LastName = "DoubleName", Age = 20, Sex = Sex.Male });
ctx.SaveChanges();
}
}
public void CleanUp()
{
using (var ctx = new StudentTrackerDbContext())
{
foreach (var user in ctx.Users.Where(x=>x.Id==user5.Id || x.Id==user16.Id || x.Id==user22.Id))
{
ctx.Users.Remove(user);
}
ctx.SaveChanges();
}
}
public void CleanUp()
{
using (var ctx = new StudentTrackerDbContext())
{
foreach (var st in ctx.Students.Where(x => x.LastName == sarah.LastName || x.LastName == peter.LastName || x.LastName == jessy.LastName))
{
ctx.Students.Remove(st);
}
ctx.SaveChanges();
}
}
public void CleanUp()
{
using (var ctx = new StudentTrackerDbContext())
{
foreach (var cs in ctx.Courses.Where(x => x.CourseName == math.CourseName || x.CourseName == calculus.CourseName || x.CourseName == discrete.CourseName || x.CourseName == entry.CourseName))
{
ctx.Courses.Remove(cs);
}
ctx.SaveChanges();
}
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(peter);
ctx.SaveChanges();
id = ctx.Students.Single(x => x.FirstName == peter.FirstName && x.LastName == peter.LastName && x.Age == peter.Age).Id;
}
}
public void Initialize()
{
this.stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Courses.Add(math);
ctx.Courses.Add(calculus);
ctx.Courses.Add(discrete);
ctx.SaveChanges();
}
}
public void CleanUp()
{
using (var ctx = new StudentTrackerDbContext())
{
var s = ctx.Students.Where(x => x.FirstName == "DoubleName" && x.LastName == "DoubleName").ToList();
foreach (var st in ctx.Students.Where(x => x.FirstName == "DoubleName" && x.LastName == "DoubleName"))
{
ctx.Students.Remove(st);
}
ctx.SaveChanges();
}
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(peter);
ctx.Students.Add(sarah);
ctx.Students.Add(jessy);
ctx.SaveChanges();
initCount = ctx.Students.Count();
}
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(peter);
ctx.Students.Add(sarah);
ctx.Students.Add(jessy);
ctx.SaveChanges();
}
expectedFullName = string.Format("{0} {1}", peter.FirstName, peter.LastName);
expectedSex = sarah.Sex.ToString();
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
colours = new UiColour { BackgroundColour = "#123321", HeaderColour = "#abccba" };
using (var ctx = new StudentTrackerDbContext())
{
ctx.Users.Add(user5);
ctx.Users.Add(user16);
ctx.Users.Add(user22);
ctx.SaveChanges();
ctx.Users.Find(user5.Id).UiColour = colours;
ctx.SaveChanges();
}
}
public bool AddStudent(Student entry)
{
using (var ctx = new StudentTrackerDbContext())
{
if (IsDublicateName(entry.FirstName, entry.LastName, ctx.Students))
{
return false;
}
ctx.Students.Add(entry);
ctx.SaveChanges();
var student = ctx.Students.OrderByDescending(x => x.Id).First();
entry.Id = student != null ? student.Id : 0;
return true;
}
}
public bool AddCourse(Course entity)
{
using (var ctx = new StudentTrackerDbContext())
{
if (ctx.Courses.Any(x => x.CourseName.Equals(entity.CourseName, StringComparison.OrdinalIgnoreCase)))
{
return false;
}
ctx.Courses.Add(new Course { CourseName = entity.CourseName, MaxNumberOfStudents = entity.MaxNumberOfStudents });
ctx.SaveChanges();
var course = ctx.Courses.OrderByDescending(x => x.Id).First();
entity.Id = course != null ? course.Id : 0;
return true;
}
}
public void Initialize()
{
stService = new StudentTrackerService.StudentTrackerService();
expectedStudents = new List<StudentInfo>();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Students.Add(peter);
ctx.Students.Add(sarah);
ctx.Students.Add(jessy);
ctx.SaveChanges();
foreach (var student in ctx.Students)
{
expectedStudents.Add(new StudentInfo { Id = student.Id, FirstName = student.FirstName, LastName = student.LastName, Age = student.Age, Sex = student.Sex.ToString()});
}
}
}
public void Initialize()
{
this.stService = new StudentTrackerService.StudentTrackerService();
using (var ctx = new StudentTrackerDbContext())
{
ctx.Courses.Add(math);
ctx.Courses.Add(calculus);
ctx.Courses.Add(discrete);
ctx.SaveChanges();
expectedCourses = new List<CourseInfo>();
foreach (var course in ctx.Courses)
{
expectedCourses.Add(new CourseInfo { CourseName = course.CourseName, Id = course.Id, CurrentlyAssigned = course.Students.Count(), MaxAssigned = course.MaxNumberOfStudents });
}
}
}
public void CleanUp()
{
using (var ctx = new StudentTrackerDbContext())
{
foreach(var st in ctx.Students.Where(x=>x.LastName==sarah.LastName || x.LastName==peter.LastName || x.LastName==jessy.LastName))
{
ctx.Students.Remove(st);
}
foreach (var cs in ctx.Courses.Where(x => x.CourseName == math.CourseName || x.CourseName == discrete.CourseName || x.CourseName == calculus.CourseName))
{
ctx.Courses.Remove(cs);
}
ctx.SaveChanges();
}
}
public void ApplyForCourse(int studentId, int courseId)
{
using (var ctx = new StudentTrackerDbContext())
{
var student = ctx.Students.Find(studentId);
var course = ctx.Courses.Find(courseId);
if (student == null)
{
throw new InvalidOperationException("No student with specified id found.");
}
if (course == null)
{
throw new InvalidOperationException("No course with specified id found.");
}
if (course.Students.Count==course.MaxNumberOfStudents)
{
throw new InvalidOperationException("Course is full.");
}
course.Students.Add(student);
ctx.SaveChanges();
}
}
