public void All_WhenStudentDataIsValid()
{
var student1 = new Student()
{
FirstName = "Andrew",
LastName = "Fuller",
Age = 29,
Grade = 4,
SchoolId = 1
};
var student2 = new Student()
{
FirstName = "Robert",
LastName = "King",
Age = 20,
Grade = 1,
SchoolId = 1
};
int oldStudentsCount = this.dbContext.Set<Student>().Count();
this.repository.Add(student1);
this.repository.Add(student2);
var studentsFound = this.repository.All();
Assert.AreEqual(oldStudentsCount + 2, studentsFound.Count());
Assert.IsTrue(studentsFound.Any(s => s.Id == student1.Id));
Assert.IsTrue(studentsFound.Any(s => s.Id == student2.Id));
}
public void FindStudentsByPredicateWhenExist_ShouldFindStudents()
{
var student1 = new Student()
{
FirstName = "Pesho",
LastName = "Peshev",
Age = 21
};
var student2 = new Student()
{
FirstName = "Tosho",
LastName = "Toshev",
Age = 22
};
var student3 = new Student()
{
FirstName = "Gosho",
LastName = "Goshev",
Age = 23
};
var createdStudent1 = this.studentsRepository.Add(student1);
var createdStudent2 = this.studentsRepository.Add(student2);
var createdStudent3 = this.studentsRepository.Add(student3);
Expression<Func<Student, int, bool>> predicate = (s, i) => s.Age == 23;
var foundStudent = this.studentsRepository.Find(predicate);
Assert.IsNotNull(foundStudent);
}
public HttpResponseMessage PostStudent(Student student)
{
var context = new Context();
context.Students.Add(student);
context.SaveChanges();
return this.Request.CreateResponse(HttpStatusCode.Created);
}
public void Add(Student student)
{
var students = GetAll();
if (students.Count(x => x.Number == student.Number) > 0)
{
throw new Exception("Student with that number already exists");
}
students.Add(student);
string json = JsonConvert.SerializeObject(students, Formatting.Indented);
File.WriteAllText(@"Storage\students.json", json);
}
public void Update(Student student)
{
var students = GetAll();
var studentToUpdate = students.Find(x => x.Number == student.Number);
studentToUpdate.FirstName = student.FirstName;
studentToUpdate.LastName = student.LastName;
studentToUpdate.AverageGrade = student.AverageGrade;
string json = JsonConvert.SerializeObject(students, Formatting.Indented);
File.WriteAllText(@"Storage\students.json", json);
}
public void AddToDb_CheckConnection()
{
var stud = new Student()
{
FirstName = "First",
LastName = "Last",
Age = 100,
Grade = 1
};
dbContext.Set<Student>().Add(stud);
dbContext.SaveChanges();
Assert.IsTrue(stud.StudentId > 0);
}
public void AddTest_AddOneVailid()
{
var studentFirstName = "Test name";
var school = new Student()
{
FirstName = studentFirstName,
SchoolId = 1
};
var addedSchool = this.studenteRepo.Add(school);
var foundSchool = this.dbContext.Set<Student>().Find(addedSchool.Id);
Assert.IsNotNull(foundSchool);
Assert.AreEqual(studentFirstName, foundSchool.FirstName);
}
public void MyTestMethod2()
{
var stud = new Student()
{
FirstName = "Tesss Ime First",
LastName = "tessst Ime Last",
Age = 65,
Grade = 4,
SchoolId=1
};
dbContext.Set<Student>().Add(stud);
dbContext.SaveChanges();
Assert.IsTrue(stud.Id > 0);
}
public StudentsController()
{
this.Students = new List<Student>();
for (int i = 1; i < 15; i++)
{
Student student = new Student();
student.Id = i;
student.Name = "Student #" + i;
student.Age = i + rand.Next(5);
student.AvatarUrl = @"http://www.manager.bg/sites/default/files/news_photos/avatar-james-cameron-4122797pxiva.jpg";
this.Students.Add(student);
}
}
public void AddValidStudent_ShouldAddStudentToDatabase()
{
Student student = new Student()
{
FirstName = "Pesho",
LastName = "Peshev",
Age = 21
};
var createdStudent = this.studentsRepository.Add(student);
var foundStudent = this.dbContext.Set<Student>().Find(createdStudent.StudentId);
Assert.IsNotNull(foundStudent);
Assert.IsTrue(foundStudent.StudentId > 0);
Assert.AreEqual(createdStudent.FirstName, foundStudent.FirstName);
}
public void Add_WhenNameIsValid_ShouldAddStudentToDatabase()
{
var newStudent = new Student()
{
FirstName = "Ivan",
LastName = "Ivanov",
Age = 25,
Grade = 4,
SchoolId = 1
};
var createdStudent = this.repository.Add(newStudent);
var foundStudent = this.dbContext.Set<Student>().Find(createdStudent.Id);
Assert.IsNotNull(foundStudent);
Assert.AreEqual(newStudent.FirstName, foundStudent.FirstName);
}
public void Add_CheckForValidData()
{
var stud = new Student()
{
FirstName = "First",
LastName = "Last",
Age = 100,
Grade = 1
};
var createdStud = this.studentsRepository.Add(stud);
Assert.AreEqual(stud.FirstName, createdStud.FirstName);
Assert.AreEqual(stud.LastName, createdStud.LastName);
Assert.AreEqual(stud.Age, createdStud.Age);
Assert.AreEqual(stud.Grade, createdStud.Grade);
// Created Student should not have assigned School
Assert.IsNull(createdStud.School);
// Created Student should not have any assigned Mark
Assert.IsTrue(createdStud.Marks.Count == 0);
}
static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsProblemContext, Configuration>());
Student student1 = new Student()
{
FirstName = "Pehso",
LastName = "Peshev",
Age = 12,
Grade = 9,
Marks = new List<Mark>()
{
new Mark()
{
Value = 5.5M,
Subject = "Maths"
},
new Mark()
{
Value = 2M,
Subject = "Literature"
},
new Mark()
{
Value = 4.6M,
Subject = "Maths"
}
},
School = new School()
{
Name = "PMG",
Location = "Kaspichan"
}
};
var context = new StudentsProblemContext();
context.Students.Add(student1);
context.SaveChanges();
}
public StudentsController()
{
this.Students = new List<Student>();
for (int i = 1; i < 15; i++)
{
Student student = new Student();
student.Id = i;
student.Name = "Student #" + i;
student.Grade = i + rand.Next(5);
List<Mark> marks = new List<Mark>();
for (int j = 0; j < 4; j++)
{
Mark mark = new Mark();
mark.Subject = "Subject #" + rand.Next(5);
mark.Score = j + rand.NextDouble();
marks.Add(mark);
}
student.Marks = marks;
this.Students.Add(student);
}
}
public void GetAll_WhenASingleCategoryInRepository_ShouldReturnSingleCategory()
{
var studentRepo = Mock.Create<IRepository<Student>>();
var schoolRepo = Mock.Create<IRepository<School>>();
var markRepo = Mock.Create<IRepository<Mark>>();
var studentToAdd = new Student()
{
FirstName = "Test category",
School = new School() { Name = "dafq" },
Marks = new List<Mark>() { markRepo.All().First() }
};
IList<Student> studentEntities = new List<Student>();
studentEntities.Add(studentToAdd);
Mock.Arrange(() => studentRepo.All()).Returns(() => studentEntities.AsQueryable());
var controller = new StudentsController(studentRepo, schoolRepo, markRepo);
var categoryModels = controller.Get();
Assert.IsTrue(categoryModels.Count() == 1);
Assert.AreEqual(studentToAdd.FirstName, categoryModels.First().FirstName);
}
public void AllTest_GetAll_WhereAllIs2()
{
int alreadyIn = this.studenteRepo.All().Count();
var studentFirstName = "Test name";
var student = new Student()
{
FirstName = studentFirstName,
SchoolId = 1
};
var secontStudent = new Student()
{
FirstName = studentFirstName,
SchoolId = 1
};
var addedStudent = this.studenteRepo.Add(student);
var secondAddedStudent = this.studenteRepo.Add(secontStudent);
var foundMarks = this.studenteRepo.All().ToList();
Assert.IsNotNull(foundMarks);
Assert.AreEqual(alreadyIn + 2, foundMarks.Count);
}
public void GetByIdExistingStudent_ShouldFindStudent()
{
var student = new Student()
{
FirstName = "Pesho",
LastName = "Peshev",
Age = 21
};
var createdStudent = this.studentsRepository.Add(student);
var foundStudent = this.studentsRepository.Get(createdStudent.StudentId);
Assert.IsNotNull(foundStudent);
Assert.IsTrue(foundStudent.StudentId > 0);
Assert.AreEqual(createdStudent.StudentId, foundStudent.StudentId);
}
public void GetAllStudentWhenDBIsNotEmpty_ShouldFindAllStudents()
{
var student1 = new Student()
{
FirstName = "Pesho",
LastName = "Peshev",
Age = 21
};
var student2 = new Student()
{
FirstName = "Tosho",
LastName = "Toshev",
Age = 22
};
var student3 = new Student()
{
FirstName = "Gosho",
LastName = "Goshev",
Age = 23
};
Student createdStudent1 = this.studentsRepository.Add(student1);
Student createdStudent2 = this.studentsRepository.Add(student2);
Student createdStudent3 = this.studentsRepository.Add(student3);
int actualStudentsCount = 3;
var allStudents = this.studentsRepository.All();
Assert.AreEqual(allStudents.Count(), actualStudentsCount);
}
public void RemoveTest_OneAddOneRemove()
{
int alreadyIn = this.studenteRepo.All().Count();
var studentFirstName = "Test name";
var mark = new Student()
{
FirstName = studentFirstName,
SchoolId = 1
};
var addedStudent = this.studenteRepo.Add(mark);
bool isDeleted = this.studenteRepo.Delete(addedStudent.Id);
Assert.IsTrue(isDeleted);
Assert.AreEqual(alreadyIn, this.studenteRepo.All().Count());
}
public Student Add(Student entity)
{
this.entitySet.Add(entity);
this.dbContext.SaveChanges();
return entity;
}
public Student Update(int id, Student entity)
{
throw new NotImplementedException();
}
public void Add_CheckForValidStudentId()
{
var stud = new Student()
{
FirstName = "First",
LastName = "Last",
Age = 100,
Grade = 1
};
var createdStud = this.studentsRepository.Add(stud);
Assert.IsTrue(createdStud.StudentId != 0);
}
public HttpResponseMessage PostStudents(StudentDetails model)
{
List<Mark> newMarks = new List<Mark>();
foreach (var mark in model.Marks)
{
var markEntity = new Mark()
{
Subject = mark.Subject,
Value = mark.Value
};
newMarks.Add(markEntity);
}
var entityToAdd = new Student()
{
FirstName = model.FirstName,
LastName = model.LastName,
Age = model.Age,
Grade = model.Grade,
SchoolId = model.SchoolId,
Marks = newMarks
};
var createdEntity = this.studentsRepository.Add(entityToAdd);
var createdModel = new StudentDetails()
{
Id = createdEntity.Id,
FirstName = createdEntity.FirstName,
LastName = createdEntity.LastName,
Grade = createdEntity.Grade,
Age = createdEntity.Age,
SchoolId = createdEntity.SchoolId
};
var response = Request.CreateResponse<StudentDetails>(HttpStatusCode.Created, createdModel);
var resourceLink = Url.Link("DefaultApi", new { id = createdModel.Id });
response.Headers.Location = new Uri(resourceLink);
return response;
}
