public void Add_ShouldAddGeneralDataPoint()
{
// Arrange
var context = GetContext(TestData.generalDataPoints);
var repo = new SqlGeneralDataPointRepo(context);
int userId = _rnd.Next(1, TestData.users.Count());
int sectionId = _rnd.Next(1, TestData.generalDataSections.Count());
var generalDataPoint = new GeneralDataPoint
{
User = TestData.users.SingleOrDefault(v => v.Id == userId),
Section = TestData.generalDataSections.SingleOrDefault(v => v.Id == sectionId),
Text = "NewCreate",
OrderNum = 3,
};
// Act
repo.Add(generalDataPoint);
// Assert
Assert.NotNull(repo.GetById(generalDataPoint.Id));
context.Database.EnsureDeleted();
context.Dispose();
}
public void Create_ShouldFailWithConflict_WhenConflictValues()
{
// Arrange
int conflictuserId = _generalDataPoints[0].User.Id;
int conflictSectionId = _generalDataPoints[0].Section.Id;
var newGeneralDataPoint = new GeneralDataPoint
{
Text = _generalDataPoints[0].Text,
};
// Act & Assert
Assert.Throws <ConflictException>(() => _service.Create(
newGeneralDataPoint, conflictuserId, conflictSectionId));
_repository.Verify(mock => mock.Add(It.IsAny <GeneralDataPoint>()), Times.Never);
}
public void Create_ShouldFailWithNull_WhenWrongValues()
{
// Arrange
int userId = _rnd.Next(1, TestData.users.Count());
int sectionId = _rnd.Next(1, TestData.generalDataSections.Count());
var newGeneralDataPoint = new GeneralDataPoint
{
Text = "NewCreate",
};
// Act & Assert
Assert.Throws <ArgumentNullException>(() => _service.Create(null, userId, sectionId));
Assert.Throws <ArgumentNullException>(() => _service.Create(newGeneralDataPoint, userId, 999));
_repository.Verify(mock => mock.Add(It.IsAny <GeneralDataPoint>()), Times.Never);
}
public void Create(
GeneralDataPoint generalDataPoint,
int userId,
int sectionId)
{
if (generalDataPoint == null)
{
throw new ArgumentNullException(nameof(generalDataPoint));
}
var foundSection = _generalDataSectionRepo.GetById(sectionId);
if (foundSection == null)
{
throw new ArgumentNullException(nameof(foundSection));
}
var foundUser = _userRepo.GetById(userId);
if (foundUser == null)
{
throw new ArgumentNullException(nameof(foundUser));
}
var uniqueConstraintViolationCheck = _repository.GetByUniqueKey(
userId, sectionId, generalDataPoint.Text);
if (uniqueConstraintViolationCheck != null)
{
throw new ConflictException(uniqueConstraintViolationCheck.Id.ToString());
}
generalDataPoint.Section = foundSection;
generalDataPoint.User = foundUser;
var currentPoints = _repository.GetAllByUserAndSectionId(userId, sectionId);
if (currentPoints.Count() == 0)
{
generalDataPoint.OrderNum = 1;
}
else
{
generalDataPoint.OrderNum = currentPoints.Max(v => v.OrderNum) + 1;
}
_repository.Add(generalDataPoint);
}
public void Create_ShouldCreateGeneralDataPoint()
{
// Arrange
int userId = _rnd.Next(1, TestData.users.Count());
int sectionId = _rnd.Next(1, TestData.generalDataSections.Count());
var newGeneralDataPoint = new GeneralDataPoint
{
Text = "NewCreate",
};
// Act
_service.Create(newGeneralDataPoint, userId, sectionId);
// Assert
_repository.Verify(mock => mock.Add(It.IsAny <GeneralDataPoint>()), Times.Once);
Assert.NotNull(newGeneralDataPoint.User);
}
public void Delete(GeneralDataPoint generalDataPoint)
{
_context.GeneralDataPoints.Remove(generalDataPoint);
_context.SaveChanges();
}
public void Update(GeneralDataPoint generalDataPoint)
{
_context.Entry(generalDataPoint).State = EntityState.Modified;
_context.SaveChanges();
}
public void Add(GeneralDataPoint generalDataPoint)
{
_context.GeneralDataPoints.Add(generalDataPoint);
_context.SaveChanges();
}
