public void Update_ShouldUpdateMarkGeneralDataPoint()
{
// Arrange
var markGeneralDataPoints = new List <MarkGeneralDataPoint> {
};
foreach (var gdp in TestData.markGeneralDataPoints)
{
markGeneralDataPoints.Add(new MarkGeneralDataPoint
{
Id = gdp.Id,
Mark = gdp.Mark,
Section = gdp.Section,
Text = gdp.Text,
OrderNum = gdp.OrderNum,
});
}
var context = GetContext(markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
int id = _rnd.Next(1, markGeneralDataPoints.Count());
var markGeneralDataPoint = markGeneralDataPoints.FirstOrDefault(
v => v.Id == id);
markGeneralDataPoint.Text = "NewUpdate";
// Act
repo.Update(markGeneralDataPoint);
// Assert
Assert.Equal(markGeneralDataPoint.Text, repo.GetById(id).Text);
context.Database.EnsureDeleted();
context.Dispose();
}
public void Add_ShouldAddMarkGeneralDataPoint()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
int markId = _rnd.Next(1, TestData.marks.Count());
int sectionId = _rnd.Next(1, TestData.generalDataSections.Count());
var markGeneralDataPoint = new MarkGeneralDataPoint
{
Mark = TestData.marks.SingleOrDefault(v => v.Id == markId),
Section = TestData.generalDataSections.SingleOrDefault(
v => v.Id == sectionId),
Text = "NewCreate",
OrderNum = 3,
};
// Act
repo.Add(markGeneralDataPoint);
// Assert
Assert.NotNull(repo.GetById(markGeneralDataPoint.Id));
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetByUniqueKey_ShouldReturnNull()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
var markId = TestData.marks[0].Id;
var sectionId = TestData.generalDataSections[0].Id;
var text = TestData.markGeneralDataPoints[0].Text;
// Act
var markGeneralDataPoint1 = repo.GetByUniqueKey(
999, sectionId, text);
var markGeneralDataPoint2 = repo.GetByUniqueKey(
markId, 999, text);
var markGeneralDataPoint3 = repo.GetByUniqueKey(
markId, sectionId, "NotFound");
// Assert
Assert.Null(markGeneralDataPoint1);
Assert.Null(markGeneralDataPoint2);
Assert.Null(markGeneralDataPoint3);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetById_ShouldReturnNull_WhenWrongId()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
// Act
var markGeneralDataPoint = repo.GetById(999);
// Assert
Assert.Null(markGeneralDataPoint);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByMarkId_ShouldReturnEmptyArray_WhenWrongMarkOrSectionId()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
// Act
var markGeneralDataPoints = repo.GetAllByMarkId(999);
// Assert
Assert.Empty(markGeneralDataPoints);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetById_ShouldReturnMarkGeneralDataPoint()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
int id = _rnd.Next(1, TestData.markGeneralDataPoints.Count());
// Act
var markGeneralDataPoint = repo.GetById(id);
// Assert
Assert.Equal(TestData.markGeneralDataPoints.SingleOrDefault(v => v.Id == id),
markGeneralDataPoint);
context.Database.EnsureDeleted();
context.Dispose();
}
public void Delete_ShouldDeleteMarkGeneralDataPoint()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
int id = _rnd.Next(1, TestData.markGeneralDataPoints.Count());
var markGeneralDataPoint = TestData.markGeneralDataPoints.FirstOrDefault(
v => v.Id == id);
// Act
repo.Delete(markGeneralDataPoint);
// Assert
Assert.Null(repo.GetById(id));
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByMarkAndSectionId_ShouldReturnMarkGeneralDataPoints()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
var markId = _rnd.Next(1, _maxMarkId);
var sectionId = _rnd.Next(1, _maxSectionId);
// Act
var markGeneralDataPoints = repo.GetAllByMarkAndSectionId(markId, sectionId);
// Assert
Assert.Equal(TestData.markGeneralDataPoints.Where(
v => v.Mark.Id == markId && v.Section.Id == sectionId),
markGeneralDataPoints);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetByUniqueKey_ShouldReturnMarkGeneralDataPoint()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
int id = _rnd.Next(1, TestData.markGeneralDataPoints.Count());
var foundmarkGeneralDataPoint = TestData.markGeneralDataPoints.FirstOrDefault(
v => v.Id == id);
var markId = foundmarkGeneralDataPoint.Mark.Id;
var sectionId = foundmarkGeneralDataPoint.Section.Id;
var text = foundmarkGeneralDataPoint.Text;
// Act
var markGeneralDataPoint = repo.GetByUniqueKey(
markId, sectionId, text);
// Assert
Assert.Equal(id, markGeneralDataPoint.Id);
context.Database.EnsureDeleted();
context.Dispose();
}
public void GetAllByMarkAndSectionId_ShouldReturnEmptyArray_WhenWrongMarkOrSectionId()
{
// Arrange
var context = GetContext(TestData.markGeneralDataPoints);
var repo = new SqlMarkGeneralDataPointRepo(context);
var markId = _rnd.Next(1, _maxMarkId);
var wrongMarkId = 999;
var sectionId = _rnd.Next(1, _maxSectionId);
var wrongSectionId = 999;
// Act
var markGeneralDataPoints1 = repo.GetAllByMarkAndSectionId(
wrongMarkId, sectionId);
var markGeneralDataPoints2 = repo.GetAllByMarkAndSectionId(
markId, wrongSectionId);
// Assert
Assert.Empty(markGeneralDataPoints1);
Assert.Empty(markGeneralDataPoints2);
context.Database.EnsureDeleted();
context.Dispose();
}
