public void DBAddAStore()
{
// setup
var optionsBuilder = new DbContextOptionsBuilder <Project0databaseContext>();
optionsBuilder.UseSqlServer(GetConnectionString());
var option = optionsBuilder.Options;
CStore newStore = new CStore("Mountain View 1", "6026626662");
using (var context1 = new Project0databaseContext(option))
{
// using different context
IStoreRepository repo = new StoreRepository(option);
// action
repo.AddOneStore(newStore);
}
// asert
using var context2 = new Project0databaseContext(option);
var dbStore = context2.Stores.First(x => x.Storeloc == "Mountain View 1");
Assert.Equal(newStore.Storephone, dbStore.Storephone);
Assert.Empty(dbStore.Storecustomers);
}
public void DBGetAProductByNameAndCategory()
{
var optionsBuilder = new DbContextOptionsBuilder <Project0databaseContext>();
optionsBuilder.UseSqlServer(GetConnectionString());
var option = optionsBuilder.Options;
string name = "Duck";
string category = "Meat";
double price = 10.0;
using (var context1 = new Project0databaseContext(option))
{
IStoreRepository repo = new StoreRepository(option);
// action
CProduct p = repo.GetAProductByNameAndCategory(name, category);
}
// assert
using var context2 = new Project0databaseContext(option);
var dbProduct = context2.Products.Find("Product101");
Assert.Equal(price, dbProduct.Price);
}
public void DBAddOneProduct()
{
var optionsBuilder = new DbContextOptionsBuilder <Project0databaseContext>();
optionsBuilder.UseSqlServer(GetConnectionString());
var option = optionsBuilder.Options;
CProduct newProduct = new CProduct("Product101", "Duck", "Meat", 10.0);
using (var context1 = new Project0databaseContext(option))
{
IStoreRepository repo = new StoreRepository(option);
// action
repo.AddOneProduct(newProduct);
}
// assert
using var context2 = new Project0databaseContext(option);
var dbProduct = context2.Products.Find("Product101");
Assert.Equal(newProduct.Name, dbProduct.Name);
Assert.Equal(newProduct.Category, dbProduct.Category);
Assert.Equal(newProduct.Price, dbProduct.Price);
}
