public async System.Threading.Tasks.Task SuppliersDeleteItemAsync() { //Arrange //init var controller = new NorthwindWeb.Controllers.SuppliersController(); var db = new NorthwindDatabase(); //create Suppliers var Suppliers = new Suppliers() { CompanyName = "TestSuppliersCreate", ContactName = "contact", }; db.Entry(Suppliers).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); //detach Suppliers from db db.Entry(Suppliers).State = System.Data.Entity.EntityState.Detached; db.SaveChanges(); //Act //run controller action await controller.DeleteConfirmed(Suppliers.SupplierID); controller.Dispose(); //Assert //this will throw a InvalidOperationException var actualSuppliers = db.Suppliers.Where(x => x.SupplierID == Suppliers.SupplierID).First(); }
public async Task TerritoryCreate() { //Arrange Region regionTest = new Region() { RegionID = 100, RegionDescription = "test" }; Territories territoryTest = new Territories() { TerritoryID = "102", TerritoryDescription = "Acasa", Region = regionTest }; //Act var expected = db.Territories.Count() + 1; await _territoriesControllerTest.Create(territoryTest, regionTest.RegionID); var actual = db.Territories.Count(); var territory = db.Territories.Where(t => t.TerritoryID == territoryTest.TerritoryID && t.TerritoryDescription == territoryTest.TerritoryDescription); //Assert Assert.AreEqual(expected, actual); var regions = db.Regions.Where(t => t.RegionDescription.Contains(regionTest.RegionDescription)); db.Regions.RemoveRange(regions); var territories = db.Territories.Where(t => t.TerritoryDescription.Contains("Acasa")); db.Territories.RemoveRange(territories); db.SaveChanges(); }
public async Task OrderDetailReturnsDetails() { //Arrage Orders OrderTest = new Orders() { OrderID = 22, CustomerID = "ALFKI", EmployeeID = 3 }; Order_Details detailsTest = new Order_Details() { ProductID = 20, UnitPrice = 23, Quantity = 12, Discount = 1, Order = OrderTest }; await _detailsControllerUnderTest.Create(detailsTest, OrderTest.OrderID); //Act var result = await _detailsControllerUnderTest.Details(OrderTest.OrderID, detailsTest.ProductID) as ViewResult; //Assert Assert.IsNotNull(result); var details = db.Order_Details.Where(o => o.OrderID == detailsTest.OrderID && o.ProductID == detailsTest.ProductID && o.UnitPrice == detailsTest.UnitPrice && o.Quantity == detailsTest.Quantity && o.Discount == detailsTest.Discount); var orders = db.Orders.Find(OrderTest.OrderID); foreach (var orderdet in details) { db.Order_Details.Remove(orderdet); } db.Orders.Remove(orders); db.SaveChanges(); }
public async System.Threading.Tasks.Task RegionEditEdits() { //Arrange Region regionTest = new Region() { RegionID = 100, RegionDescription = "Aici" }; await _regionsControllerTest.Create(regionTest); db.Entry(regionTest).State = System.Data.Entity.EntityState.Added; var expectedRegion = db.Regions.Find(regionTest.RegionID); db.Dispose(); regionTest.RegionDescription = "Acolo"; db = new NorthwindDatabase(); //Act await _regionsControllerTest.Edit(regionTest); db.Entry(regionTest).State = System.Data.Entity.EntityState.Modified; var actualRegion = db.Regions.Find(regionTest.RegionID); //Assert Assert.AreEqual(expectedRegion, actualRegion); var region = db.Regions.Where(r => (r.RegionDescription == "Aici") || (r.RegionDescription == "Acolo")); db.Regions.RemoveRange(region); db.SaveChanges(); }
public async Task ShipperEditEdits() { //Arrange Shippers shipperTest = new Shippers() { CompanyName = "Express", Phone = "0240-111-111" }; await _shippersControllerTest.Create(shipperTest); db.Entry(shipperTest).State = System.Data.Entity.EntityState.Added; var expectedShipper = db.Shippers.Find(shipperTest.ShipperID); db.Dispose(); shipperTest.CompanyName = "Nero Express"; shipperTest.Phone = "0240-222-222"; db = new NorthwindDatabase(); //Act await _shippersControllerTest.Edit(shipperTest); db.Entry(shipperTest).State = System.Data.Entity.EntityState.Modified; var actualShipper = db.Shippers.Find(shipperTest.ShipperID); //Assert Assert.AreEqual(expectedShipper, actualShipper); var shipper = db.Shippers.Where(s => (s.CompanyName == "Express" && s.Phone == "0240-111-111") || (s.CompanyName == "Nero Express" && s.Phone == "0240-222-222")); db.Shippers.RemoveRange(shipper); db.SaveChanges(); }
public ActionResult Index([Bind("ID,LastName,FirstName,Email,Comment")] Persons person) {//create person from Form if (!ModelState.IsValid) { if (String.IsNullOrEmpty(person.FirstName)) { ModelState.AddModelError("", "Introduceti-va numele"); } if (String.IsNullOrEmpty(person.Email)) { ModelState.AddModelError("", "Email-ul nu a fost introdus corect"); } if (String.IsNullOrEmpty(person.Comment)) { ModelState.AddModelError("", "Va rugam sa va spuneti parerea"); } return(View(person)); } person.ID = db.Persons.Count() + 1; db.Persons.Add(person); try { db.SaveChanges(); return(RedirectToAction("Index", new { status = "Mesajul dumneavoastra a fost trimis cu succes. Va multumim!" })); } catch { return(RedirectToAction("Index", new { status = "Mesajul dumneavoastra nu a putut fi trimis momentan. Va rugam incercati mai tarziu!" })); } }
public async Task CategoryEditEdits() { //Arrange Categories categoriesTest = new Categories() { CategoryName = "foto" }; await _categoriesControllerTest.Create(categoriesTest); db.Entry(categoriesTest).State = System.Data.Entity.EntityState.Added; var expectedCategory = db.Categories.Find(categoriesTest.CategoryID); db.Dispose(); categoriesTest.CategoryName = "video"; db = new NorthwindDatabase(); //Act await _categoriesControllerTest.Edit(categoriesTest); db.Entry(categoriesTest).State = System.Data.Entity.EntityState.Modified; var actualCategory = db.Categories.Find(categoriesTest.CategoryID); //Assert Assert.AreEqual(expectedCategory, actualCategory); var category = db.Categories.Where(c => (c.CategoryName == "video") || (c.CategoryName == "foto")); db.Categories.RemoveRange(category); db.SaveChanges(); }
public async Task OrdersReturnsEditEdits() { //Arrange Orders orderTest = new Orders() { OrderID = 222, EmployeeID = 3 }; await _ordersControllerUnderTest.Create(orderTest); db.Entry(orderTest).State = System.Data.Entity.EntityState.Added; var expectedOrder = db.Orders.Find(orderTest.OrderID); db.Dispose(); orderTest.EmployeeID = 4; db = new NorthwindDatabase(); //Act await _ordersControllerUnderTest.Edit(orderTest); db.Entry(orderTest).State = System.Data.Entity.EntityState.Modified; var actualOrder = db.Orders.Find(orderTest.OrderID); //Assert Assert.AreEqual(expectedOrder, actualOrder); var orders = db.Orders.Where(o => o.OrderID == orderTest.OrderID && o.EmployeeID == orderTest.EmployeeID); db.Orders.RemoveRange(orders); db.SaveChanges(); }
public async Task CustomersReturnsEditEdits() { //Arrange var expectedCustomer = new Customers() { CustomerID = "ZZZZZ", CompanyName = "test" }; db.Customers.Add(expectedCustomer); db.SaveChanges(); db.Entry(expectedCustomer).State = System.Data.Entity.EntityState.Added; db.Dispose(); expectedCustomer.CompanyName = "test2"; db = new NorthwindDatabase(); //Act await _customersControllerUnderTest.Edit(expectedCustomer); db.Entry(expectedCustomer).State = System.Data.Entity.EntityState.Modified; var actualCustomer = db.Customers.Find(expectedCustomer.CustomerID); //Assert Assert.AreEqual(expectedCustomer.CustomerID, actualCustomer.CustomerID); var customerss = db.Customers.Where(c => c.CompanyName == expectedCustomer.CompanyName || c.CompanyName == actualCustomer.CompanyName); db.Customers.RemoveRange(customerss); db.SaveChanges(); }
private void DeleteTestFromDb() { var employees = _db.Employees.Where(e => e.LastName.Contains("test")); _db.Employees.RemoveRange(employees); _db.SaveChanges(); }
public async System.Threading.Tasks.Task ProductCreateItemAsync() { //Arrange var controller = new ProductController(); var db = new NorthwindDatabase(); int productCountBefore = db.Products.Count(); var product = new Products() { CategoryID = 4, ProductName = "TestProductCreate", Discontinued = false, QuantityPerUnit = "1", UnitPrice = 1, UnitsInStock = 1, ReorderLevel = 0, SupplierID = 1, UnitsOnOrder = 0 }; //Act await controller.Create(product, null); //Assert Assert.AreEqual(productCountBefore + 1, db.Products.Count()); db.Entry(db.Products.Where(x => x.ProductName == product.ProductName).First()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); controller.Dispose(); db.Dispose(); }
public void ContactCreateItem() { //Arrange var controller = new NorthwindWeb.Controllers.ContactController(); var db = new NorthwindDatabase(); NorthwindWeb.Models.Persons person = new NorthwindWeb.Models.Persons() { ID = db.Persons.Count() + 1, FirstName = "test1223", LastName = "123331111", Email = "*****@*****.**", Comment = "Buna!" }; //Act var result = controller.Index(person); //Assert Assert.IsNotNull(result); db.Entry(person).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); db.Dispose(); }
public async Task RegionReturnsDetails() { //Arrage Region regionTest = new Region() { RegionID = 100, RegionDescription = "Acasa" }; //Act var result = await _regionsControllerTest.Details(regionTest.RegionID); //Assert Assert.IsNotNull(result); var region = db.Regions.Where(r => r.RegionDescription == regionTest.RegionDescription); db.Regions.RemoveRange(region); db.SaveChanges(); }
public async Task CategoryCreate() { //Arrange Categories CategoriesTest = new Categories() { CategoryID = 14, CategoryName = "foto" }; //Act var expected = db.Categories.Count() + 1; await _categoriesControllerTest.Create(CategoriesTest); var actual = db.Categories.Count(); var category = db.Categories.Where(c => c.CategoryName == CategoriesTest.CategoryName); //Assert Assert.AreEqual(expected, actual); db.Categories.RemoveRange(category); db.SaveChanges(); }
public async Task OrdersReturnsDetails() { //Arrage Orders orderTest = new Orders() { OrderID = 222, EmployeeID = 3 }; await _ordersControllerUnderTest.Create(orderTest); //Act var result = await _ordersControllerUnderTest.Details(orderTest.OrderID) as ViewResult; //Assert Assert.IsNotNull(result); var orders = db.Orders.Where(o => o.OrderID == orderTest.OrderID && o.EmployeeID == orderTest.EmployeeID); db.Orders.RemoveRange(orders); db.SaveChanges(); }
public async Task ShipperCreate() { //Arrange Shippers shipperTest = new Shippers() { ShipperID = 4, CompanyName = "Nero", Phone = "0240-555-555" }; //Act var expected = db.Shippers.Count() + 1; await _shippersControllerTest.Create(shipperTest); var actual = db.Shippers.Count(); var shipper = db.Shippers.Where(s => s.CompanyName == shipperTest.CompanyName && s.Phone == shipperTest.Phone); //Assert Assert.AreEqual(expected, actual); db.Shippers.RemoveRange(shipper); db.SaveChanges(); }
public string Create(int id, int quantity) { if (!(db.Products.Where(x => x.ProductID == id).Any()) || db.Products.Where(x => x.ProductID == id).First().Discontinued) { return("Error"); } try { if (!(db.ShopCart.Any(x => x.ProductID == id && x.UserName == User.Identity.Name))) { ShopCarts cart = new ShopCarts() { UserName = User.Identity.Name, ProductID = id, Quantity = quantity, Products = db.Products.Find(id) }; db.ShopCart.Add(cart); db.SaveChanges(); } else { Update(id, quantity); } return("{}"); } catch (Exception e) { //logger.Error(e.ToString()); return("Error"); } }
public async System.Threading.Tasks.Task SuppliersEditItemAsync() { //Arrange //init var controller = new NorthwindWeb.Controllers.SuppliersController(); var db = new NorthwindDatabase(); //create Suppliers var Suppliers = new Suppliers() { CompanyName = "TestSuppliersCreate", ContactName = "contact", }; db.Entry(Suppliers).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); //detach Suppliers from db db.Entry(Suppliers).State = System.Data.Entity.EntityState.Detached; db.SaveChanges(); //edit name of Suppliers string name = Suppliers.CompanyName; string nameExpected = "test1223"; Suppliers.CompanyName = nameExpected; //Act //run controller action await controller.Edit(Suppliers); controller.Dispose(); string actual = db.Suppliers.Where(x => x.SupplierID == Suppliers.SupplierID).First().CompanyName; //Assert //check and delete Suppliers Assert.AreEqual(nameExpected, actual); Suppliers = db.Suppliers.Where(x => x.SupplierID == Suppliers.SupplierID).First(); Suppliers.CompanyName = name; db.Entry(Suppliers).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); db.Dispose(); }
public async System.Threading.Tasks.Task ProductEditItemAsync() { //Arrange //init var controller = new ProductController(); var db = new NorthwindDatabase(); //create product var product = new Products() { ProductName = "test", CategoryID = 1, SupplierID = 1 }; db.Entry(product).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); //detach product from db db.Entry(product).State = System.Data.Entity.EntityState.Detached; db.SaveChanges(); //edit name of product string name = product.ProductName; string nameExpected = "test12232"; product.ProductName = nameExpected; //Act //run controller action await controller.Edit(product, null); controller.Dispose(); string actual = db.Products.Where(x => x.ProductID == product.ProductID).First().ProductName; //Assert //check and delete product Assert.AreEqual(nameExpected, actual); product = db.Products.Where(x => x.ProductID == product.ProductID).First(); product.ProductName = name; db.Entry(product).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); db.Dispose(); }
public async Task CustomersReturnsDetails() { //Arrage DashbordCustomer customers = new DashbordCustomer() { CompanyName = "test" }; await _customersControllerUnderTest.Create(customers); var customer = db.Customers.Where(c => c.CompanyName == customers.CompanyName).FirstOrDefault(); //Act var result = await _customersControllerUnderTest.Details(customer.CustomerID) as ViewResult; //Assert Assert.IsNotNull(result); var customerss = db.Customers.Where(c => c.CustomerID == customer.CustomerID && c.CompanyName == customers.CompanyName); db.Customers.RemoveRange(customerss); db.SaveChanges(); }
public async Task OrderDetailReturnsEditEdits() { //Arrange Orders OrderTest = new Orders() { OrderID = 22, CustomerID = "ALFKI", EmployeeID = 3 }; Order_Details detailsTest = new Order_Details() { ProductID = 20, UnitPrice = 23, Quantity = 12, Discount = 1, Order = OrderTest }; await _detailsControllerUnderTest.Create(detailsTest, OrderTest.OrderID); db.Entry(detailsTest).State = System.Data.Entity.EntityState.Added; var expectedDetails = db.Order_Details.Find(detailsTest.OrderID, detailsTest.ProductID); db.Dispose(); detailsTest.UnitPrice = 43; detailsTest.Quantity = 22; db = new NorthwindDatabase(); //Act await _detailsControllerUnderTest.Edit(detailsTest); db.Entry(detailsTest).State = System.Data.Entity.EntityState.Modified; var actualDetails = db.Order_Details.Find(detailsTest.OrderID, detailsTest.ProductID); //Assert Assert.AreEqual(expectedDetails, actualDetails); var details = db.Order_Details.Where(o => o.OrderID == detailsTest.OrderID && o.ProductID == detailsTest.ProductID && o.UnitPrice == detailsTest.UnitPrice && o.Quantity == detailsTest.Quantity && o.Discount == detailsTest.Discount); var orders = db.Orders.Find(OrderTest.OrderID); foreach (var orderdet in details) { db.Order_Details.Remove(orderdet); } db.Orders.Remove(orders); db.SaveChanges(); }
public async System.Threading.Tasks.Task SuppliersCreateItemAsync() { //Arrange var controller = new NorthwindWeb.Controllers.SuppliersController(); var db = new NorthwindDatabase(); int SuppliersCountBefore = db.Suppliers.Count(); var Suppliers = new Suppliers() { CompanyName = "TestSuppliersCreate", ContactName = "contact", }; //Act await controller.Create(Suppliers); //Assert Assert.AreEqual(SuppliersCountBefore + 1, db.Suppliers.Count()); db.Entry(Suppliers).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); controller.Dispose(); db.Dispose(); }
public async Task TerritoryEditEdits() { //Arrange Region regionTest = new Region() { RegionID = 100, RegionDescription = "test" }; Territories territoryTest = new Territories() { TerritoryID = "102", TerritoryDescription = "Aici", Region = regionTest }; await _territoriesControllerTest.Create(territoryTest, regionTest.RegionID); db.Entry(territoryTest).State = System.Data.Entity.EntityState.Added; var expectedTerritory = db.Territories.Find(territoryTest.TerritoryID); db.Dispose(); territoryTest.TerritoryDescription = "Acolo"; db = new NorthwindDatabase(); //Act await _territoriesControllerTest.Edit(territoryTest); db.Entry(territoryTest).State = System.Data.Entity.EntityState.Modified; var actualTerritory = db.Territories.Find(territoryTest.TerritoryID); //Assert Assert.AreEqual(expectedTerritory, actualTerritory); var territory = db.Territories.Where(t => (t.TerritoryDescription == "Aici") || (t.TerritoryDescription == "Acolo")); db.Territories.RemoveRange(territory); var regions = db.Regions.Where(t => t.RegionDescription.Contains(regionTest.RegionDescription)); db.Regions.RemoveRange(regions); db.SaveChanges(); }
public async System.Threading.Tasks.Task ProductDeleteItemAsync() { //Arrange var controller = new ProductController(); var db = new NorthwindDatabase(); //create product var product = new Products() { ProductName = "test", CategoryID = 1, SupplierID = 1 }; db.Entry(product).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); //Act try { //run controller action await controller.DeleteConfirmed(product.ProductID); controller.Dispose(); } catch (Exception ex) { //image not found if (!(ex is NullReferenceException)) { throw; } } //Assert //this will throw a InvalidOperationException if (db.Products.Any(x => x.ProductID == product.ProductID)) { Assert.Fail(); } }