public void GetProductByBarcode()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
Model.Product result = _repo.GetProduct("j-g-t-s-01");
Assert.NotNull(result);
Assert.Equal(1, result.Id);
}
}
public void GetLocationByName()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
Model.Location result = _repo.GetLocation("WA-Seattle");
Assert.NotNull(result);
Assert.Equal(1, result.Id);
}
}
public void GetAllBranchLocations()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
List <Model.Location> result = _repo.GetAllLocations();
Assert.NotNull(result);
Assert.Equal(1, result.Count);
}
}
public void GetCustomerByNameShouldReturnCorrespondingCustomer()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
var result = _repo.GetCustomer("2063317069");
Assert.NotNull(result);
Assert.Equal("Fang", result.LasttName);
}
}
public void GetAllInventories()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
Model.Location location = _repo.GetLocation("WA-Seattle");
HashSet <Model.Item> result = _repo.GetAllInventories(location);
Assert.NotNull(result);
Assert.Equal(1, result.Count);
}
}
public void UpdateInventoryByProductId()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
Model.Product product = _repo.GetProductById(1);
_repo.UpdateInventory(product, 10);
var result = _repo.GetInventory(product);
Assert.Equal("j-g-t-s-01", product.Barcode);
Assert.Equal(10, result.Quantity);
}
}
public void AddProduct()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
_repo.AddProduct(
new Model.Product("BBT", 3.00m, "BBT01")
);
}
using (var assertContext = new Entity.StoreAppDBContext(options))
{
//IRepository _repo = new RepoDB(assertContext);
var result = assertContext.Products.FirstOrDefault(c => c.Id == 3);
Assert.NotNull(result);
Assert.Equal("BBT", result.Name);
}
}
public void AddCustomerShoudAddCustomer()
{
using (var context = new Entity.StoreAppDBContext(options))
{
IRepository _repo = new RepoDB(context);
_repo.AddCustomer(
new Model.Customer("Jia", "W", "Fang", "2063317069")
);
}
using (var assertContext = new Entity.StoreAppDBContext(options))
{
//IRepository _repo = new RepoDB(assertContext);
var result = assertContext.Customers.FirstOrDefault(c => c.Id == 2);
Assert.NotNull(result);
Assert.Equal("Jia", result.FirstName);
}
}
public StoreRepoDB(Entity.StoreAppDBContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public RepoDB(Entity.StoreAppDBContext context)
{
this._context = context ?? throw new System.ArgumentNullException(nameof(context));
}
public void Seed()
{
using (var context = new Entity.StoreAppDBContext(options))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Customers.AddRange
(
new Entity.Customer
{
Id = 1,
LastName = "Yang",
MiddleName = "",
FirstName = "Jessie",
PhoneNumber = "2067798888"
},
new Entity.Customer
{
Id = 2,
LastName = "Fang",
MiddleName = "W",
FirstName = "Jia",
PhoneNumber = "2063317069"
}
);
context.Products.AddRange(
new Entity.Product
{
Id = 1,
Name = "Jasmine Green Tea w/ Salted Cheese",
Price = 4.50m,
Barcode = "j-g-t-s-01"
},
new Entity.Product
{
Id = 2,
Name = "Classic Milk Tea",
Price = 3.99m,
Barcode = "c-m-t-01"
}
);
context.Locations.AddRange(
new Entity.Location
{
Id = 1,
Name = "WA-Seattle",
Address = "2245 8th Ave., R1-1A Seattle WA 98121"
}
);
context.Inventories.AddRange(
new Entity.Inventory
{
Id = 1,
LocationId = 1,
ProductId = 1,
Quantity = 2
}
);
context.SaveChanges();
}
}