public void ShouldAddAnObjectGraph()
{
var prod = new Product
{
CurrentPrice = 12.99M,
UnitCost = 10.99M,
UnitsInStock = 5,
};
var cat = new Category {
CategoryName = "CatName"
};
ExecuteInATransaction(RunTheTest);
void RunTheTest()
{
SampleDataInitializer.ClearData(Context);
cat.Products.Add(prod);
Assert.Equal(0, cat.Id);
Assert.Equal(0, prod.CategoryId);
Assert.Equal(0, prod.Id);
Context.Categories.Add(cat);
Assert.True(cat.Id == 0);
Assert.True(prod.CategoryId == 0);
Assert.Equal(cat.Id, prod.CategoryId);
Context.SaveChanges();
Assert.Single(Context.Categories);
Assert.Single(Context.Products);
Assert.True(cat.Id > 0);
Assert.True(prod.Id > 0);
Assert.Equal(cat.Id, prod.CategoryId);
}
}
public void ShouldAddListOfNewCategoryRecords()
{
var cats = new List <Category>
{
new Category {
CategoryName = "Cat1Name"
},
new Category {
CategoryName = "Cat2Name"
},
new Category {
CategoryName = "Cat3Name"
},
};
ExecuteInATransaction(RunTheTest);
void RunTheTest()
{
SampleDataInitializer.ClearData(Context);
Context.Categories.AddRange(cats);
Context.SaveChanges();
Assert.Equal(3, Context.Categories.Count());
}
}
protected void CreateCategoryAndProducts(StoreContext context)
{
SampleDataInitializer.ClearData(context);
var prod1 = new Product
{
CurrentPrice = 12.99M,
UnitCost = 10.99M,
UnitsInStock = 5,
Details = { ModelName = "Product 1" },
};
var prod2 = new Product
{
CurrentPrice = 99.99M,
UnitCost = 89.99M,
UnitsInStock = 2,
Details = { ModelName = "Product 2" }
};
var cat = new Category {
CategoryName = "CatName"
};
cat.Products.AddRange(new List <Product> {
prod1, prod2
});
context.Categories.Add(cat);
context.SaveChanges();
}
public void ShouldClearTheData()
{
SampleDataInitializer.InitializeData(Context);
SampleDataInitializer.ClearData(Context);
var cars = Context.Cars.IgnoreQueryFilters();
Assert.Empty(cars);
}
public void ShouldClearTheData()
{
SampleDataInitializer.InitializeData(Context);
var cars = Context.Cars.IgnoreQueryFilters().ToList();
Assert.NotNull(cars);
Assert.Equal(9, cars.Count);
SampleDataInitializer.ClearData(Context);
var cars2 = Context.Cars.IgnoreQueryFilters();
Assert.NotNull(cars2);
Assert.Empty(cars2);
}
public void ShouldAddNewCategoryRecord()
{
var cat = new Category {
CategoryName = "CatName"
};
ExecuteInATransaction(RunTheTest);
void RunTheTest()
{
SampleDataInitializer.ClearData(Context);
Context.Categories.Add(cat);
Context.SaveChanges();
Assert.Single(Context.Categories.ToList());
}
}
public void ShouldGetOrderWithDetails()
{
ExecuteInATransaction(RunTheTest);
void RunTheTest()
{
ResetContext();
SampleDataInitializer.ClearData(Context);
CreateCategoryAndProducts();
var cust = new Customer()
{
EmailAddress = "*****@*****.**",
FullName = "Ful Name",
Password = "******"
};
var order = new Order
{
OrderDate = DateTime.Now,
ShipDate = DateTime.Now
};
var product = Context.Products.FirstOrDefault();
var orderDetail = new OrderDetail
{
ProductNavigation = product,
UnitCost = 12.99M,
Quantity = 1
};
order.OrderDetails.Add(orderDetail);
cust.Orders.Add(order);
ICustomerRepo custRepo = new CustomerRepo(Context);
custRepo.Add(cust);
Context.CustomerId = cust.Id;
Assert.NotNull(Context.Customers.FirstOrDefault());
Assert.NotNull(Context.Orders.FirstOrDefault());
Assert.NotNull(Context.OrderDetails.FirstOrDefault());
var orderRepo = new OrderRepo(Context, new OrderDetailRepo(Context));
var record = orderRepo.GetOneWithDetails(1);
var foo = "foo";
}
}
public void ShouldSetServerSideProperties()
{
var cat = new Category {
CategoryName = "CatName"
};
ExecuteInATransaction(RunTheTest);
void RunTheTest()
{
SampleDataInitializer.ClearData(Context);
Assert.Equal(0, cat.Id);
Assert.Null(cat.TimeStamp);
Context.Categories.Add(cat);
Assert.True(cat.Id == 0);
Assert.Null(cat.TimeStamp);
Context.SaveChanges();
Assert.Single(Context.Categories.ToList());
Assert.True(cat.Id > 0);
Assert.NotNull(cat.TimeStamp);
}
}
public void Dispose()
{
SampleDataInitializer.ClearData(_db);
_db.Dispose();
}
protected void CleanDatabase()
{
SampleDataInitializer.ClearData(Db);
}
private void CleanDatabase()
{
SampleDataInitializer.ClearData(_db);
}
public override void Dispose()
{
SampleDataInitializer.ClearData(Context);
_repo.Dispose();
}
public CategoryRepoTests()
{
_repo = new CategoryRepo(Context);
SampleDataInitializer.ClearData(Context);
}
public void Dispose()
{
SampleDataInitializer.ClearData(_repo.Context);
_repo.Dispose();
}
public CustomerRepoGetTests()
{
_repo = new CustomerRepo();
SampleDataInitializer.ClearData(_repo.Context);
SampleDataInitializer.InitializeData(_repo.Context);
}
