public void Create_ValidObject_ObjectInserted() { // Arrange var newItem = new WebApplication1.Models.EGD() { ConfigurationStreak = 10, PaddingBottom = 11, PaddingLeft = 12, PaddingRight = 13, PaddingTop = 14, PhotoStreak = 15 }; // Act var result = _controller.Create(newItem); var createdItem = _controller.GetById(result); // Cleanup if (result != -1) { _controller.Delete(result); } // Assert Assert.IsType <WebApplication1.Models.EGD>(createdItem); Assert.Equal(result, createdItem.Id); Assert.Equal(newItem.ConfigurationStreak, createdItem.ConfigurationStreak); Assert.Equal(newItem.PaddingBottom, createdItem.PaddingBottom); Assert.Equal(newItem.PaddingLeft, createdItem.PaddingLeft); Assert.Equal(newItem.PaddingRight, createdItem.PaddingRight); Assert.Equal(newItem.PaddingTop, createdItem.PaddingTop); Assert.Equal(newItem.PhotoStreak, createdItem.PhotoStreak); }
public bool UpdateEGD(WebApplication1.Models.EGD ourEgd) { using (IDbConnection conn = Connection) { conn.Open(); int rowsAffected = conn.Execute(@"UPDATE [EGD] SET [PaddingTop] = @PaddingTop ,[PaddingBottom] = @PaddingBottom," + " [PaddingLeft] = @PaddingLeft,[PaddingRight]=@PaddingRight,[PhotoStreak]=@PhotoStreak," + "[ConfigurationStreak]=@ConfigurationStreak WHERE Id = " + ourEgd.Id, ourEgd); if (rowsAffected > 0) { return(true); } return(false); } }
public int InsertEGD(WebApplication1.Models.EGD ourEgd) { using (IDbConnection conn = Connection) { conn.Open(); string sql = @"INSERT INTO EGD([PaddingTop],[PaddingBottom],[PaddingLeft],[PaddingRight],[PhotoStreak],[ConfigurationStreak]) values (@PaddingTop, @PaddingBottom, @PaddingLeft, @PaddingRight, @PhotoStreak, @ConfigurationStreak); SELECT CAST(SCOPE_IDENTITY() as int)"; var id = conn.Query <int>(sql, new { ourEgd.PaddingTop, ourEgd.PaddingBottom, ourEgd.PaddingLeft, ourEgd.PaddingRight, ourEgd.PhotoStreak, ourEgd.ConfigurationStreak }).Single(); if (id > 0) { return(id); } return(-1); } }
public void UpdateEGD_InvalidObject_ReturnsFalse() { // Arrange var newInvalidItem = new WebApplication1.Models.EGD() { Id = 3008 }; // Simulating wrong object supply. _controller.ModelState.AddModelError("PhotoStreak", "Not an integer"); // Act var result = _controller.UpdateEGD(newInvalidItem); // Assert Assert.False(result); }
public void Create_InvalidObject_ReturnsMinus1() { // Arrange var newInvalidItem = new WebApplication1.Models.EGD(); // Simulating wrong object supply. _controller.ModelState.AddModelError("PhotoStreak", "Not an integer"); // Act var result = _controller.Create(newInvalidItem); // Cleanup if (result != -1) { _controller.Delete(result); } // Assert Assert.Equal(-1, result); }
public void UpdateEGD_ValidExistingObject_ReturnsTrue() { // Arrange var newValidItem = new WebApplication1.Models.EGD() { Id = 3008, ConfigurationStreak = 10, PaddingBottom = 11, PaddingLeft = 12, PaddingRight = 13, PaddingTop = 14, PhotoStreak = 15 }; // Act var result = _controller.UpdateEGD(newValidItem); // Assert Assert.True(result); }
public void Delete_Existing_ReturnsTrue() { // Arrange var newValidItem = new WebApplication1.Models.EGD() { ConfigurationStreak = 10, PaddingBottom = 11, PaddingLeft = 12, PaddingRight = 13, PaddingTop = 14, PhotoStreak = 15 }; var id = _controller.Create(newValidItem); // Act var result = _controller.Delete(id); // Assert Assert.True(result); }
public bool UpdateEGD([FromBody] WebApplication1.Models.EGD ourEgd) { return(_EGDRepo.UpdateEGD(ourEgd)); }
public int Create([FromBody] WebApplication1.Models.EGD ourEGD) { return(_EGDRepo.InsertEGD(ourEGD)); }