public void RemovesBrandCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(brand));
dataWarehouseContext.Set <Brand>().Remove(brand);
dataWarehouseContext.SaveChanges();
Assert.IsNull(dataWarehouseContext.Set <Brand>()
.FirstOrDefault(b => b.Id == brand.Id));
transaction.Rollback();
}
}
}
public void UpdatesBrandCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(brand));
var expectedResult = brand.Name = "Toyota";
dataWarehouseContext.Entry(brand).State = EntityState.Modified;
dataWarehouseContext.SaveChanges();
Assert.AreEqual(expectedResult, dataWarehouseContext.Entry(brand).Entity.Name);
transaction.Rollback();
}
}
}
public void UpdatesModelCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
var model = new Model {
Name = "Rio", Brand = brand
};
dataWarehouseContext.Set <Model>().Add(model);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(model));
var expectedResult = model.Name = "Sportage";
dataWarehouseContext.Entry(model).State = EntityState.Modified;
dataWarehouseContext.SaveChanges();
Assert.AreEqual(expectedResult, dataWarehouseContext.Entry(model).Entity.Name);
transaction.Rollback();
}
}
}
public void CreatesNewModelCorrect()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
using (var transaction = dataWarehouseContext.Database.BeginTransaction())
{
var brand = new Brand {
Name = "KIA"
};
dataWarehouseContext.Set <Brand>().Add(brand);
dataWarehouseContext.SaveChanges();
var model = new Model {
Name = "Rio", Brand = brand
};
dataWarehouseContext.Set <Model>().Add(model);
dataWarehouseContext.SaveChanges();
Assert.IsNotNull(dataWarehouseContext.Entry(model));
transaction.Rollback();
}
}
}
public void CheckDistanceBtwMoscowAndSamara()
{
using (var dataWarehouseContext = new EFDataWarehouseContext())
{
// Arrange.
const int realDistance = 854;
var mileageService = new MileageCalculatingService();
// Act.
var calcDistance = mileageService.GetMileage("Москва", "Самара");
// Assert.
Assert.AreEqual(realDistance, calcDistance);
}
}
public void EmployeeRepositoryRemovesEmployeeCorrect()
{
// Arrange.
var dataWarehouseContext = new EFDataWarehouseContext();
EmployeeRepository employeeRepository = new EmployeeRepository(dataWarehouseContext);
// Act.
var newEmployee = employeeRepository.Find(emp => (emp.Firstname == "Егор")).FirstOrDefault();
if (newEmployee != null)
{
int id = newEmployee.Id;
employeeRepository.Delete(id);
employeeRepository.Commit();
}
newEmployee = employeeRepository.Find(emp => (emp.Firstname == "Егор")).FirstOrDefault();
// Assert.
Assert.AreEqual(null, newEmployee);
}
