public void Add_ShouldAddConstruction()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
int constructionId = _rnd.Next(1, _marks.Count());
int diameterId = _rnd.Next(1, _boltDiameters.Count());
var constructionBolt = new ConstructionBolt
{
Construction = _constructions.SingleOrDefault(
v => v.Id == constructionId),
Diameter = _boltDiameters.SingleOrDefault(
v => v.Id == diameterId),
Packet = 5,
Num = 5,
NutNum = 5,
WasherNum = 5,
};
// Act
repo.Add(constructionBolt);
// Assert
Assert.NotNull(repo.GetById(constructionBolt.Id));
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetById_ShouldReturnNull_WhenWrongId()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
// Act
var constructionBolt = repo.GetById(999);
// Assert
Assert.Null(constructionBolt);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByConstructionId_ShouldReturnEmptyArray_WhenWrongConstructionId()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
// Act
var constructionBolts = repo.GetAllByConstructionId(999);
// Assert
Assert.Empty(constructionBolts);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetById_ShouldReturnConstructionBolt()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
int id = _rnd.Next(1, _constructionBolts.Count());
// Act
var constructionBolt = repo.GetById(id);
// Assert
Assert.Equal(_constructionBolts.SingleOrDefault(v => v.Id == id), constructionBolt);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByConstructionId_ShouldReturnConstructions()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
var constructionId = _rnd.Next(1, _maxConstructionId);
// Act
var constructionBolts = repo.GetAllByConstructionId(constructionId);
// Assert
Assert.Equal(_constructionBolts.Where(
v => v.Construction.Id == constructionId), constructionBolts);
context.Database.EnsureDeleted();
context.Dispose();
}
public void Delete_ShouldDeleteConstruction()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
int id = _rnd.Next(1, _constructionBolts.Count());
var constructionBolt = _constructionBolts.FirstOrDefault(
v => v.Id == id);
// Act
repo.Delete(constructionBolt);
// Assert
Assert.Null(repo.GetById(id));
context.Database.EnsureDeleted();
context.Dispose();
}
public void Update_ShouldUpdateConstruction()
{
// Arrange
var context = GetContext(true);
var repo = new SqlConstructionBoltRepo(context);
int id = _rnd.Next(1, _updateConstructionBolts.Count());
var construction = _updateConstructionBolts.FirstOrDefault(v => v.Id == id);
construction.Packet = 9;
// Act
repo.Update(construction);
// Assert
Assert.Equal(construction.Packet, repo.GetById(id).Packet);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetByUniqueKey_ShouldReturnNull_WhenWrongKey()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
var constructionId = _constructionBolts[0].Construction.Id;
var diameterId = _constructionBolts[0].Diameter.Id;
// Act
var additionalWork1 = repo.GetByUniqueKey(999, diameterId);
var additionalWork2 = repo.GetByUniqueKey(constructionId, 999);
// Assert
Assert.Null(additionalWork1);
Assert.Null(additionalWork2);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetByUniqueKey_ShouldReturnConstructionBolt()
{
// Arrange
var context = GetContext();
var repo = new SqlConstructionBoltRepo(context);
var constructionId = _constructionBolts[0].Construction.Id;
var diameterId = _constructionBolts[0].Diameter.Id;
// Act
var constructionBolt = repo.GetByUniqueKey(
constructionId, diameterId);
// Assert
Assert.Equal(_constructionBolts.SingleOrDefault(
v => v.Construction.Id == constructionId &&
v.Diameter.Id == diameterId), constructionBolt);
context.Database.EnsureDeleted();
context.Dispose();
}
