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