public void CreateWine_ShouldCreateWine_WhenGivenExistingRegionVineyardAndWineTypeAsDuplicates()
{
// __Arrange __
var model = new CreateWineRequest
{
WineName = "Sample",
Vineyard = "Mark's vineyard",
Region = "Yarra valley",
WineType = "Shiraz"
};
using var context = new DataContext(ContextOptions);
var sut = new CreateUpdateWineRepository(context);
// __ Act __
var result = sut.CreateWine(model);
// __ Assert __
result.Should().BeTrue();
var vineyard = context.Vineyards.Find(1);
var region = context.Regions.Find(1);
var wineType = context.Winetypes.Find(1);
var wine = context.Winelists.First(x => x.Winename == "Sample");
wine.Regionid.Should().Be(1);
region.Region1.Should().Be("Yarra valley");
wine.Vineyardid.Should().Be(1);
vineyard.Vineyard1.Should().Be("Mark's vineyard");
wine.Winetypeid.Should().Be(1);
wineType.Winetype1.Should().Be("Shiraz");
}
public void UpdateWine_ShouldReturnFalse_WhenGivenRequestModelInvalidId()
{
// __Arrange __
var model = new UpdateWineRequest
{
Id = 21,
WineName = "Sample",
Region = "Hunter Valley",
Locations = new List <Location>
{
new Location {
BoxNo = 2, Qty = 1
},
}
};
using var context = new DataContext(ContextOptions);
var sut = new CreateUpdateWineRepository(context);
// __ Act __
var result = sut.UpdateWine(model);
// __ Assert __
result.Should().BeFalse();
}
public void UpdateWine_ShouldUpdateWine_WhenGivenValidRequestModelWithLocations()
{
// __Arrange __
var model = new UpdateWineRequest
{
Id = 50,
WineName = "Sample",
PercentAlcohol = 14.5f,
PricePaid = 20.99m,
Notes = "These are my notes",
Vintage = 2000,
Region = "Hunter Valley",
Locations = new List <Location>
{
new Location {
BoxNo = 55, Qty = 2
},
new Location {
BoxNo = 2, Qty = 1
},
new Location {
Qty = 3
}
}
};
using var context = new DataContext(ContextOptions);
var sut = new CreateUpdateWineRepository(context);
// __ Act __
var result = sut.UpdateWine(model);
// __ Assert __
result.Should().BeTrue();
var region = context.Regions.Single(x => x.Region1 == "Hunter Valley");
var wine = context.Winelists.First(x => x.Winename == "Sample");
wine.Winename.Should().Be("Sample");
wine.Notes.Should().Be("These are my notes");
wine.Vintage.Should().Be(2000);
wine.Regionid.Should().Be(region.Id);
region.Region1.Should().Be("Hunter Valley");
var locations = context.Locations.Where(x => x.Wineid == wine.Id).ToList();
wine.Locations.Select(x => x.Id).Should().BeEquivalentTo(locations.Select(x => x.Id));
locations.Should().HaveCount(2);
locations.Should().Contain(x => x.Box == 55 && x.No == 2);
locations.Should().Contain(x => x.Box == 2 && x.No == 1);
locations.Should().NotContain(x => x.No == 3);
}
public void UpdateWine_ShouldUpdateWine_WhenGivenValidRequestModel()
{
// __Arrange __
var model = new UpdateWineRequest()
{
Id = 50,
WineName = "Sample",
PercentAlcohol = 14.5f,
PricePaid = 20.99m,
Notes = "These are my notes",
Vintage = 2000,
YearBought = 2002,
DrinkFrom = 2005,
DrinkTo = 2015,
Rating = 92,
BottleSize = 750,
Region = "Hunter Valley",
Vineyard = "Dave's place",
WineType = "Chardonnay"
};
using var context = new DataContext(ContextOptions);
var sut = new CreateUpdateWineRepository(context);
// __ Act __
var result = sut.UpdateWine(model);
// __ Assert __
result.Should().BeTrue();
var vineyard = context.Vineyards.Single(x => x.Vineyard1 == "Dave's place");
var region = context.Regions.Single(x => x.Region1 == "Hunter Valley");
var wineType = context.Winetypes.Single(x => x.Winetype1 == "Chardonnay");
var wine = context.Winelists.First(x => x.Winename == "Sample");
wine.Winename.Should().Be("Sample");
wine.Percentalcohol.Should().Be(14.5f);
wine.Pricepaid.Should().Be(20.99m);
wine.Notes.Should().Be("These are my notes");
wine.Vintage.Should().Be(2000);
wine.Yearbought.Should().Be(2002);
wine.Drinkrangefrom.Should().Be(2005);
wine.Drinkrangeto.Should().Be(2015);
wine.Rating.Should().Be(92);
wine.Bottlesize.Should().Be(750);
wine.Regionid.Should().Be(region.Id);
region.Region1.Should().Be("Hunter Valley");
wine.Vineyardid.Should().Be(vineyard.Id);
vineyard.Vineyard1.Should().Be("Dave's place");
wine.Winetypeid.Should().Be(wineType.Id);
wineType.Winetype1.Should().Be("Chardonnay");
}
