public void Update_ShouldUpdateGeneralDataPoint() { // Arrange var generalDataPoints = new List <GeneralDataPoint> { }; foreach (var gdp in TestData.generalDataPoints) { generalDataPoints.Add(new GeneralDataPoint { Id = gdp.Id, User = gdp.User, Section = gdp.Section, Text = gdp.Text, OrderNum = gdp.OrderNum, }); } var context = GetContext(generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); int id = _rnd.Next(1, generalDataPoints.Count()); var generalDataPoint = generalDataPoints.FirstOrDefault(v => v.Id == id); generalDataPoint.Text = "NewUpdate"; // Act repo.Update(generalDataPoint); // Assert Assert.Equal(generalDataPoint.Text, repo.GetById(id).Text); context.Database.EnsureDeleted(); context.Dispose(); }
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 GetById_ShouldReturnNull_WhenWrongId() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); // Act var generalDataPoint = repo.GetById(999); // Assert Assert.Null(generalDataPoint); context.Database.EnsureDeleted(); context.Dispose(); }
public void GetById_ShouldReturnGeneralDataPoint() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); int id = _rnd.Next(1, TestData.generalDataPoints.Count()); // Act var generalDataPoint = repo.GetById(id); // Assert Assert.Equal(TestData.generalDataPoints.SingleOrDefault(v => v.Id == id), generalDataPoint); context.Database.EnsureDeleted(); context.Dispose(); }
public void Delete_ShouldDeleteGeneralDataPoint() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); int id = _rnd.Next(1, TestData.generalDataPoints.Count()); var generalDataPoint = TestData.generalDataPoints.FirstOrDefault(v => v.Id == id); // Act repo.Delete(generalDataPoint); // Assert Assert.Null(repo.GetById(id)); context.Database.EnsureDeleted(); context.Dispose(); }
public void GetAllByUserAndSectionId_ShouldReturnGeneralDataPoints() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); var userId = _rnd.Next(1, _maxUserId); var sectionId = _rnd.Next(1, _maxSectionId); // Act var generalDataPoints = repo.GetAllByUserAndSectionId(userId, sectionId); // Assert Assert.Equal(TestData.generalDataPoints.Where( v => v.User.Id == userId && v.Section.Id == sectionId), generalDataPoints); context.Database.EnsureDeleted(); context.Dispose(); }
public void GetByUniqueKey_ShouldReturnGeneralDataPoint() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); int id = _rnd.Next(1, TestData.generalDataPoints.Count()); var foundGeneralDataPoint = TestData.generalDataPoints.FirstOrDefault(v => v.Id == id); var userId = foundGeneralDataPoint.User.Id; var sectionId = foundGeneralDataPoint.Section.Id; var text = foundGeneralDataPoint.Text; // Act var generalDataPoint = repo.GetByUniqueKey(userId, sectionId, text); // Assert Assert.Equal(id, generalDataPoint.Id); context.Database.EnsureDeleted(); context.Dispose(); }
public void GetAllByUserAndSectionId_ShouldReturnEmptyArray_WhenWrongUserOrSectionId() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); var userId = _rnd.Next(1, _maxUserId); var wrongUserId = 999; var sectionId = _rnd.Next(1, _maxSectionId); var wrongSectionId = 999; // Act var generalDataPoints1 = repo.GetAllByUserAndSectionId(wrongUserId, sectionId); var generalDataPoints2 = repo.GetAllByUserAndSectionId(userId, wrongSectionId); // Assert Assert.Empty(generalDataPoints1); Assert.Empty(generalDataPoints2); context.Database.EnsureDeleted(); context.Dispose(); }
public void GetByUniqueKey_ShouldReturnNull_WhenWrongValues() { // Arrange var context = GetContext(TestData.generalDataPoints); var repo = new SqlGeneralDataPointRepo(context); var userId = TestData.users[0].Id; var sectionId = TestData.generalDataSections[0].Id; var text = TestData.generalDataPoints[0].Text; // Act var generalDataPoint1 = repo.GetByUniqueKey(999, sectionId, text); var generalDataPoint2 = repo.GetByUniqueKey(userId, 999, text); var generalDataPoint3 = repo.GetByUniqueKey(userId, sectionId, "NotFound"); // Assert Assert.Null(generalDataPoint1); Assert.Null(generalDataPoint2); Assert.Null(generalDataPoint3); context.Database.EnsureDeleted(); context.Dispose(); }