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 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 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(); }