public void AddNewProducts()
{
using (var db = new TestModel.TestModel())
{
// Product without new supplier and category.
var product1 = db.Products.Create();
var product1Category = "Beverages";
var product1Supplier = "Exotic Liquids";
product1.ProductName = "Milk";
AddProduct(product1, product1Category, product1Supplier, db);
// Product with new supplier and category.
var product2 = db.Products.Create();
product2.ProductName = "Chicken eggs";
var product2Category = "Animal origin";
var product2Supplier = "Test company";
AddProduct(product2, product2Category, product2Supplier, db);
var products = new List <Product> {
product1, product2
};
db.Products.AddRange(products);
db.SaveChanges();
}
}
public static void Cleanup()
{
using (var db = new TestModel.TestModel())
{
db.Products.RemoveRange(db.Products.Where(p => p.ProductName == "Milk" ||
p.ProductName == "Chicken eggs" ||
p.ProductName == "Cucumber"));
db.Categories.RemoveRange(db.Categories.Where(c => c.CategoryName == "Animal origin"));
db.Suppliers.RemoveRange(db.Suppliers.Where(s => s.CompanyName == "Test company"));
db.SaveChanges();
}
}
public void ChangeCategoryOfProduct()
{
using (var db = new TestModel.TestModel())
{
var chai = db.Products.First(p => p.Id == 1);
var seafoodCategory = db.Categories.First(c => c.Id == 8);
var beveragesCategory = db.Categories.First(c => c.Id == 1);
try
{
chai.Category = seafoodCategory;
db.SaveChanges();
Assert.AreEqual(seafoodCategory, db.Products.First(p => p.Id == 1).Category);
}
finally
{
chai.Category = beveragesCategory;
db.SaveChanges();
}
}
}
public void AddNewEmployeeWithTerritories()
{
using (var db = new TestModel.TestModel())
{
var employee = db.Employees.Create();
var territories = db.Territories;
employee.LastName = "Ivanov";
employee.FirstName = "Ivan";
employee.Territories.Add(territories.First(t => t.Id == "01581"));
employee.Territories.Add(territories.First(t => t.Id == "01730"));
employee.Territories.Add(territories.First(t => t.Id == "01833"));
db.Employees.Add(employee);
db.SaveChanges();
var newEmployee = db.Employees.First(e => e.Id == employee.Id);
Assert.AreEqual(employee, newEmployee);
}
}