public int AddProduct(Product info) { using (var context = new NWContext()) { context.Products.Add(info); context.SaveChanges(); return info.ProductID; } }
public void DeleteProduct(Product info) { using (var context = new NWContext()) { var found = context.Products.Find(info.ProductID); if (found != null) { context.Products.Remove(found); context.SaveChanges(); } } }
public void Should_Delete_Products() { //Arrange var sut = new NorthwindManager(); var actual = new Product() { ProductName = "Product to delete" }; actual.ProductID = sut.AddProduct(actual); //Act sut.DeleteProduct(actual); //Assert Product p = sut.GetProduct(actual.ProductID); Assert.Null(p); }
public void Should_Add_Product() { //Arrange var sut = new NorthwindManager(); var product = new Product() { ProductName = "MSP Basic Product", Discontinued = false }; //Act var productID = sut.AddProduct(product); //Assert Assert.True(productID > 0); Product actual = sut.GetProduct(productID); Assert.Equal(productID, actual.ProductID); }
public void Should_Add_Product() { //Arrange var sut = new NorthwindManager(); //sut is short for 'Scenario Under Test' var expected = new Product() { ProductName = "Double Double", UnitsInStock = 777 }; //Act var actualId = sut.AddProduct(expected); //Assert Assert.True(actualId > 0); Product actual = sut.GetProduct(actualId); Assert.Equal(expected.ProductName, actual.ProductName); Assert.Equal(expected.UnitsInStock, actual.UnitsInStock); Assert.Equal(actualId, actual.ProductID); }
public void Should_Update_Products(Product existing) { //Arrange existing.ProductName = "TIN'S OLD PRODUCT"; var sut = new NorthwindManager(); //Act sut.UpdateProduct(existing); //Assert var actual = sut.GetProduct(existing.ProductID); Assert.NotNull(actual); Assert.Equal(existing.ProductName, actual.ProductName); }
public void UpdateProduct(Product info) { //NOTE: See question and commentary on // http://stackoverflow.com/questions/15336248/entity-framework-5-updating-a-record using (var context = new NWContext()) { context.Products.Attach(info); context.Entry(info).State = EntityState.Modified; context.SaveChanges(); } }
public void Should_Delete_Product() { //Arrange var sut = new NorthwindManager(); //sut is short for 'Scenario Under Test' var expected = new Product() { ProductName = "Double Double", UnitsInStock = 777 }; expected.ProductID = sut.AddProduct(expected); //Act sut.DeleteProduct(expected); //Assert Shipper actual = sut.GetShipper(expected.ProductID); Assert.Null(actual); }
public void Should_Update_Product(Product existing) { //Arrange existing.UnitsInStock = 777; var sut = new NorthwindManager(); //sut is short for 'Scenario Under Test' existing.UnitsInStock = 999; //Act sut.UpdateProduct(existing); //Assert var actual = sut.GetProduct(existing.ProductID); Assert.NotNull(actual); Assert.Equal(existing.ProductName, actual.ProductName); Assert.Equal(existing.UnitsInStock, actual.UnitsInStock); }
public void UpdateProduct(Product info) { using (var context = new NWContext()) { context.Products.Attach(info); context.Entry(info).State = EntityState.Modified; context.SaveChanges(); } }