public void Add(StockLevelModel stockLevel)
{
NHibernateUnitOfWork unitOfWork = (NHibernateUnitOfWork)UnitOfWork.Start();
IRepository <StockLevelModel, int> stockLevelRepository = new NHibernateRepository <StockLevelModel, int>(unitOfWork);
stockLevelRepository.Add(stockLevel);
unitOfWork.SaveChanges();
unitOfWork.Dispose();
}
public void GetNumberOfProductInCategory()
{
RequestModel model = new RequestModel
{
Id = 1
};
StockLevelModel stock = set.StockLevel.Report(model);
Assert.AreEqual(stock.Sales.Count, 2);
}
public void GetStockInfoCategory_id_1()
{
RequestModel model = new RequestModel
{
Id = 1
};
StockLevelModel stock = set.StockLevel.Report(model);
Assert.AreEqual(stock.Sales[0].ProductInput, 4);
Assert.AreEqual(stock.Sales[0].ProductOutput, 2);
Assert.AreEqual(stock.Sales[1].ProductInput, 3);
Assert.AreEqual(stock.Sales[1].ProductOutput, 1);
}
public StockLevelModel Report(RequestModel request)
{
Category category = UnitOfWork.Categories.Get(request.Id);
StockLevelModel result = new StockLevelModel()
{
CategoryId = request.Id,
CategoryName = category.Name
};
result.Sales = UnitOfWork.Products.Get().Where(x => x.Category.Id == category.Id).ToList()
.Select(x => Factory.Create(x.Id, x.Name, x.Unit, x.Stock)).ToList();
return(result);
}
// Products By Category (parameter id is category id)
public StockLevelModel Report(int id)
{
var Category = _unitOfWork.Categories.Get(id);
if (Category == null)
{
throw new Exception("Category not found");
}
StockLevelModel result = new StockLevelModel(id, Category.Name);
result.Products = _unitOfWork.Products.Get().Where(x => x.Category.Id == id).ToList()
.Select(x => _factory.Create(x.Id, x.Name, x.Stock)).ToList();
return(result);
}
public StockLevelModel Report(int id)
{
StockLevelModel result = new StockLevelModel();
Category category = UnitOfWork.Categories.Get(id);
if (category == null)
{
result.Category = "Category does not exists!";
}
else
{
result.Category = category.Name;
result.Products = category.Products.OrderBy(x => x.Name).Select(x => Factory.Create(x)).ToList();
}
return(result);
}
public void CreateDatabaseSchemaTest()
{
ProductModel product = new ProductModel();
StockLevelModel stockLevel1 = new StockLevelModel();
stockLevel1.Amount = 10;
stockLevel1.Products.Add(product);
product.ProductName = "可口可乐";
product.UnitName = "瓶子";
product.StockLevels.Add(stockLevel1);
productService.Add(product);
stockLevelService.Add(stockLevel1);
WarehouseModel warehouse = new WarehouseModel();
warehouse.Address = "chengdu shi";
warehouse.StockLevels.Add(stockLevel1);
stockLevel1.Warehouses.Add(warehouse);
warehouseService.Add(warehouse);
IList <string> productNames = productService.GetAllProductNames();
Console.WriteLine(productNames);
DistributorModel distributor = new DistributorModel();
distributor.Name = "黄凯";
distributor.Address = "贵州";
distributorService.Add(distributor);
IList <string> distributorNames = distributorService.GetAllDistributorNames();
Console.WriteLine(distributorNames);
}
public void InitReport()
{
result = report.Report(categoryId);
}
