public async Task <ApiResponse> GetStockRepot(GetStockRepotRequestModel options)
{
ApiResponse response = new ApiResponse();
int _pageNo = (options.pageNo == 0) ? 1 : options.pageNo;
int _pageLimit = (options.pageSize == 0) ? int.MaxValue : options.pageSize;
var stocks = from stock in _context.Stocks
join prod in _context.Products on stock.ProductId equals prod.ProductId
join cat in _context.Categories on prod.CategoryId equals cat.CategoryId
select new
{
ProductName = prod.Name,
CategoryName = cat.Name,
CategoryCode = cat.CatCode,
ProductCode = prod.ProductCode,
CategoryId = cat.CategoryId,
AvailableQuantity = stock.AvailableQuantity,
LastUpdated = stock.LastUpdated
};
if (options.CategoryId > 0)
{
stocks = stocks.Where(x => x.CategoryId == options.CategoryId);
}
response.Data = await stocks.Skip((_pageNo - 1) *_pageLimit).Take(_pageLimit).ToListAsync();
response.Message = "Stock report get successfully";
response.Status = 1;
return(response);
}
public async Task <IActionResult> GetStockRepot([FromQuery] GetStockRepotRequestModel options)
{
var cat = await tansactionService.GetStockRepot(options);
if (cat.Status == 1)
{
return(Ok(cat));
}
else
{
return(NotFound(cat));
}
}
