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)); }