public List <SellerProductResponse> AllProductList(AllProductRequest allProduct)
{
using (DataAccess dataAccess = new DataAccess())
{
var list = from product in dataAccess.Products
join category in dataAccess.Categories on product.CategoryID equals category.CategoryID
join unit in dataAccess.Unit on product.UnitID equals unit.UnitID
join seller in dataAccess.Sellers on product.SellerID equals seller.SellerID
join city in dataAccess.Cities on seller.CityID equals city.CityID
join stockStatus in dataAccess.StockStatus on product.StockID equals stockStatus.StockID
where (product.SellerID == allProduct.SellerID && product.StatusID == true)
orderby product.StockID descending
select(new SellerProductResponse
{
ProductID = product.ProductID,
CategoryName = category.CategoryName,
ProductCode = product.ProductCode,
ProductName = product.ProductName,
Volume = product.Volume,
UnitName = unit.UnitName,
StockNumber = product.StockNumber,
Price = product.Price,
Photo = product.Photo,
StockStatus = stockStatus.StockStatu
});
return(list.ToList());
}
}
public List <SellerProductResponse> AllProductList(AllProductRequest allProduct)
{
return(productService.AllProductList(allProduct));
}
