public void AddSchoolWithStudent()
{
//arrange
var student = new Student()
{
Age = 10,
FirstName = "Pesho",
LastName = "Trojkata",
Grade = 4,
};
var school = new School()
{
Location = "Меден Рудник",
Name = "Петко Росен",
Students = new HashSet<Student>() { student },
};
dbContext.Set<Student>().Add(student);
dbContext.SaveChanges();
//act
dbContext.Set<School>().Add(school);
dbContext.SaveChanges();
//assert
Assert.AreEqual(student, school.Students.ToList<Student>()[0]);
}
static void Main(string[] args)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<SchoolContext,Configuration>());
using (var context = new SchoolContext())
{
var school = new School() { Name = "Techical University Of Varna", Location = "Varna" };
context.Schools.Add(school);
context.SaveChanges();
}
}
public void UpdateSchool(School school)
{
if (this.Name != null)
{
school.Name = this.Name;
}
if (this.Location != null)
{
school.Location = this.Location;
}
}
public void TestSimpleAddViaContext()
{
var school = new School()
{
Name = "Telerik",
Location = "Mladost"
};
dbContext.Set<School>().Add(school);
dbContext.SaveChanges();
Assert.IsTrue(school.SchoolId > 0);
}
public void TestAddedSchoolDataIntegrity()
{
var school = new School()
{
Name = "Telerik",
Location = "Mladost"
};
var createdSchool = categoriesRepository.Add(school);
var foundSchool = this.dbContext.Set<School>().Find(createdSchool.SchoolId);
Assert.IsNotNull(foundSchool);
Assert.AreEqual(createdSchool.Name, foundSchool.Name);
Assert.AreEqual(createdSchool.Location, foundSchool.Location);
}
public void AddingSingleStudentEntryWithSchoolTest()
{
//arrange
const string Subject = "Math";
const decimal Value = 2.00m;
const int Age = 10;
const string FirstName = "Nikolay";
const string LastName = "Kostadinov";
const int Grade = 4;
var mark = new Mark()
{
Subject = Subject,
Value = Value
};
var school = new School()
{
Name = "Petko Rosen",
Location = "Meden Rudnik",
};
var student = new Student()
{
Age = Age,
FirstName = FirstName,
LastName = LastName,
Grade = Grade,
Marks = new List<Mark>() { mark },
School = school,
};
school.Students.Add(student);
//act
dbContext.Set<School>().Add(school);
dbContext.Set<Student>().Add(student);
dbContext.SaveChanges();
//assert
var studentMarks = student.Marks.ToList();
var actual =
student.Age == Age &&
student.Grade == Grade &&
student.FirstName == FirstName &&
student.LastName == LastName &&
student.Marks.Count == 1 &&
studentMarks[0].Subject == mark.Subject &&
studentMarks[0].Value == mark.Value;
var expected = true;
Assert.AreEqual(expected, actual);
}
public void AddingSingleStudentEntryWithSchoolThanDeleteStudentTest()
{
//arrange
const string Subject = "Math";
const decimal Value = 2.00m;
const int Age = 10;
const string FirstName = "Nikolay";
const string LastName = "Kostadinov";
const int Grade = 4;
var mark = new Mark()
{
Subject = Subject,
Value = Value
};
var school = new School()
{
Name = "Petko Rosen",
Location = "Meden Rudnik",
};
var student = new Student()
{
Age = Age,
FirstName = FirstName,
LastName = LastName,
Grade = Grade,
Marks = new List<Mark>() { mark },
School = school,
};
school.Students.Add(student);
dbContext.Set<School>().Add(school);
dbContext.Set<Student>().Add(student);
dbContext.Set<Mark>().Add(mark);
dbContext.SaveChanges();
//act
var actual = dbContext.Set<Student>().Where(x => x.StudentId == student.StudentId).FirstOrDefault();
Assert.AreEqual(student, actual);
dbContext.Set<Student>().Remove(student);
dbContext.SaveChanges();
//assert
actual = dbContext.Set<Student>().Where(x => x.StudentId == student.StudentId).FirstOrDefault();
Assert.AreEqual(null, actual);
}
public void TestSimpleAddViaRepository()
{
var school = new School()
{
Name = "Telerik",
Location = "Mladost"
};
categoriesRepository.Add(school);
Assert.IsTrue(school.SchoolId > 0);
}
// PUT api/Schools/5
public HttpResponseMessage Put(int id, School School)
{
//var SchoolEntity = db.Get(id);
this.db.Update(id, School);
return Request.CreateResponse(HttpStatusCode.OK);
}
