public void GoodListItem_ReturnsExpectedCatalogId()
{
// arrange
ListItemModel listitem = MakeListItem();
string expected = "FUT";
// act
FavoritesListDetail results = listitem.ToFavoritesListDetail();
// assert
results.CatalogId
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsZeroCustomInventoryId()
{
// arrange
FavoritesListDetail detail = MakeDetail();
int expected = 0;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.CustomInventoryItemId
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsIsDeleteAsFalse()
{
// arrange
FavoritesListDetail detail = MakeDetail();
bool expected = false;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.IsDelete
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsQuantityOfZero()
{
// arrange
FavoritesListDetail detail = MakeDetail();
int expected = 0;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Quantity
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedType()
{
// arrange
FavoritesListDetail detail = MakeDetail();
ListType expected = ListType.Favorite;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Type
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedPosition()
{
// arrange
FavoritesListDetail detail = MakeDetail();
int expected = 17;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Position
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedModifiedUtc()
{
// arrange
FavoritesListDetail detail = MakeDetail();
DateTime expected = new DateTime(2017, 7, 5, 16, 42, 0, DateTimeKind.Utc);
// act
ListItemModel results = detail.ToWebModel();
// assert
results.ModifiedUtc
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedItemNumber()
{
// arrange
FavoritesListDetail detail = MakeDetail();
string expected = "123456";
// act
ListItemModel results = detail.ToWebModel();
// assert
results.ItemNumber
.Should()
.Be(expected);
}
public void NullLabel_ReturnsExpectedValue()
{
// arrange
int detailId = 4;
IFavoriteListDetailsRepository repo = MakeRepo();
// act
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results
.Label
.Should()
.BeNull();
}
public static ListItemModel ToWebModel(this FavoritesListDetail value)
{
return(new ListItemModel()
{
Active = value.Active,
ListItemId = value.Id,
Type = ListType.Favorite,
ItemNumber = value.ItemNumber,
Position = value.LineNumber,
Label = value.Label,
ModifiedUtc = value.ModifiedUtc,
CreatedUtc = value.CreatedUtc,
Each = value.Each ?? false,
CatalogId = value.CatalogId
});
}
public static FavoritesListDetail ToFavoritesListDetail(this ListItemModel model, long headerId = 0)
{
FavoritesListDetail item = new FavoritesListDetail()
{
Active = model.Active,
CatalogId = model.CatalogId,
Each = model.Each ?? false,
Id = model.ListItemId,
ItemNumber = model.ItemNumber,
LineNumber = model.Position,
Label = model.Label,
HeaderId = headerId
};
return(item);
}
public void GoodDetail_ReturnsExpectedLineNumber()
{
// arrange
int detailId = 1;
int expected = 1;
IFavoriteListDetailsRepository repo = MakeRepo();
// act
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results
.LineNumber
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedEach()
{
// arrange
int detailId = 1;
bool expected = true;
IFavoriteListDetailsRepository repo = MakeRepo();
// act
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results
.Each
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedCreatedUtc()
{
// arrange
int detailId = 1;
DateTime expected = new DateTime(2017, 6, 29, 16, 29, 0, DateTimeKind.Utc);
IFavoriteListDetailsRepository repo = MakeRepo();
// act
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results
.CreatedUtc
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedCatalogId()
{
// arrange
int detailId = 1;
string expected = "FDF";
IFavoriteListDetailsRepository repo = MakeRepo();
// act
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results
.CatalogId
.Should()
.Be(expected);
}
public void GoodDetail_SavesCorrectLineNumber()
{
// arrange
FavoritesListDetail detail = MakeDetail();
int expected = 17;
IFavoriteListDetailsRepository repo = MakeRepo();
// act
long detailId = repo.SaveFavoriteListDetail(detail);
FavoritesListDetail result = repo.GetFavoriteDetail(detailId);
// assert
result.LineNumber
.Should()
.Be(expected);
}
public void GoodDetail_SavesCorrectLabel()
{
// arrange
FavoritesListDetail detail = MakeDetail();
string expected = "Fake Label";
IFavoriteListDetailsRepository repo = MakeRepo();
// act
long detailId = repo.SaveFavoriteListDetail(detail);
FavoritesListDetail result = repo.GetFavoriteDetail(detailId);
// assert
result.Label
.Should()
.Be(expected);
}
public void GoodDetail_SavesCorrectEach()
{
// arrange
FavoritesListDetail detail = MakeDetail();
bool expected = true;
IFavoriteListDetailsRepository repo = MakeRepo();
// act
long detailId = repo.SaveFavoriteListDetail(detail);
FavoritesListDetail result = repo.GetFavoriteDetail(detailId);
// assert
result.Each
.Should()
.Be(expected);
}
public void GoodDetail_DoesNotUseSetModifiedUtc()
{
// arrange
FavoritesListDetail detail = MakeDetail();
DateTime expected = new DateTime(2017, 6, 30, 8, 48, 0, DateTimeKind.Utc);
IFavoriteListDetailsRepository repo = MakeRepo();
// act
long detailId = repo.SaveFavoriteListDetail(detail);
FavoritesListDetail result = repo.GetFavoriteDetail(detailId);
// assert
result.ModifiedUtc
.Should()
.NotBe(expected);
}
public void GoodDetail_DeletesCorrectDetail()
{
// arrange
FavoritesListDetail detail = MakeDetail();
IFavoriteListDetailsRepository repo = MakeRepo();
// act
long detailId = repo.SaveFavoriteListDetail(detail);
repo.DeleteFavoriteListDetail(detailId);
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results.Active
.Should()
.BeFalse();
}
public long SaveFavoriteListDetail(FavoritesListDetail model)
{
DynamicParameters parms = new DynamicParameters();
parms.Add(PARMNAME_ACTIVE, model.Active);
parms.Add(PARMNAME_CATALOGID, model.CatalogId);
parms.Add(PARMNAME_EACH, model.Each);
parms.Add(PARMNAME_HEADERID, model.HeaderId);
parms.Add(PARMNAME_ID, model.Id);
parms.Add(PARMNAME_ITEMNUMBER, model.ItemNumber);
parms.Add(PARMNAME_LINENUMBER, model.LineNumber);
parms.Add(PARMNAME_LABEL, model.Label);
parms.Add(PARMNAME_RETVAL, dbType: DbType.Int64, direction: ParameterDirection.Output);
ExecuteSPCommand(SPNAME_SAVE, parms);
return(parms.Get <long>(PARMNAME_RETVAL));
}
public void NullItemNumber_ShouldThrowSqlException()
{
// arrange
FavoritesListDetail detail = new FavoritesListDetail {
Active = true,
CatalogId = "FAT",
CreatedUtc = new DateTime(2017, 6, 30, 8, 47, 0, DateTimeKind.Utc),
Each = true,
HeaderId = 1,
Label = "Fake Label",
LineNumber = 17,
ModifiedUtc = new DateTime(2017, 6, 30, 8, 48, 0, DateTimeKind.Utc)
};
IFavoriteListDetailsRepository repo = MakeRepo();
// act
Action act = () => { repo.SaveFavoriteListDetail(detail); };
// assert
act.Should().Throw <SqlException>();
}
public void NullEach_ReturnsFalse()
{
// arrange
FavoritesListDetail detail = new FavoritesListDetail {
Id = 21,
CatalogId = "FUT",
HeaderId = 10,
ItemNumber = "123456",
LineNumber = 17,
CreatedUtc = new DateTime(2017, 7, 5, 16, 41, 0, DateTimeKind.Utc),
ModifiedUtc = new DateTime(2017, 7, 5, 16, 42, 0, DateTimeKind.Utc)
};
bool expected = false;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Each
.Should()
.Be(expected);
}
public void NullLabel_SavesExpectedValue()
{
// arrange
FavoritesListDetail detail = new FavoritesListDetail {
Active = true,
CatalogId = "FAT",
CreatedUtc = new DateTime(2017, 6, 30, 8, 47, 0, DateTimeKind.Utc),
Each = true,
HeaderId = 1,
ItemNumber = "123456",
LineNumber = 17,
ModifiedUtc = new DateTime(2017, 6, 30, 8, 48, 0, DateTimeKind.Utc)
};
IFavoriteListDetailsRepository repo = MakeRepo();
// act
long detailId = repo.SaveFavoriteListDetail(detail);
FavoritesListDetail results = repo.GetFavoriteDetail(detailId);
// assert
results.Label
.Should()
.BeNull();
}
